- Joined
- Aug 6, 2007
- Messages
- 1,767
- Reaction score
- 36
Hello,
I'v been working on a website. On the admin page you can edit the text of the site but for some reason it dosen't save when you push save could anyone help me out?
Database table main
thanks// Mokerhamer
I'v been working on a website. On the admin page you can edit the text of the site but for some reason it dosen't save when you push save could anyone help me out?
PHP:
<?php
$connect = mysql_connect ("localhost","root","secret") or die ("Kon geen verbinding met MySQL Server tot stand brengen. MySQL error: " . mysql_error());
mysql_select_db("nout",$connect) or die("Kon geen verbinding maken met database. MySQL error: " . mysql_error());
$query = "SELECT * FROM main";
$result = mysql_query($query) or die("Kon query niet uitvoeren: " . mysql_error());
if(mysql_num_rows($result) == 0)
{
echo "Niks gevonden neem a.u.b contact op met munier";
}
else
{
while($_POST = mysql_fetch_array($result))
{
echo "<INPUT type='tekst' name='tekst' value='$_POST[tekst]'></TD>";
echo "<br />";
}
}
mysql_select_db('nout', $connect) or die (mysql_error());
if (isset($_POST['submit']))
{
mysql_query("UPDATE `main` SET `tekst` = '" . $_POST['text'] . "' WHERE id = '". (int) $_POST['id']."'") or die ("Kon query niet uitvoeren: " . mysql_error());
echo 'Geupdate';
}
$result = mysql_query('SELECT * FROM `main`') or die (mysql_error());
if (mysql_num_rows($result) < 1)
die ('Geen tekst gevonden neem a.u.b contact op met munier voor hulp');
while ($row = mysql_fetch_array($result))
{
echo 'TextID ' . $row['id'] . ': ' . $row['tekst'];
}
?>
<form method="POST" action="<? echo $_SERVER['REQUEST_URI'] ?>">
<font color=red>Id Niet veranderen!</font><td> </td><td> </td>Id: <input TYPE='TEXT' NAME='id' VALUE='1'/>
<TEXTAREA ROWS='20' COLS='40' NAME='text'></TEXTAREA>
<INPUT TYPE='submit' NAME='submit' onClick='return checkForm();' />
</FORM>
Database table main
Code:
-- Tabel structuur voor tabel `main`
--
CREATE TABLE IF NOT EXISTS `main` (
`id` int(50) NOT NULL auto_increment,
`tekst` varchar(5000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Gegevens worden uitgevoerd voor tabel `main`
--
INSERT INTO `main` (`id`, `tekst`) VALUES
(1, 'helloooo');
thanks// Mokerhamer
Last edited: