I have the following PHP code, instead of updating the mySQL as it should, it just clears the contents that should be updating.
+rep to all help, whether it works or not.PHP Code:<?php
include( "site_config.php" );
if( $_GET["action"] == "update_settings" )
{
$title = $_POST["title"];
$status = $_POST["status"];
$logo = $_POST["main_logo"];
$offline = $_POST["offline"];
$left = $_POST["left_logo"];
@mysql_query( "UPDATE `settings` SET `title` = '$title', `main_logo` = '$logo', `offline_text` = '$offline', `status` = '$status', `logo_left` = '$left'" );
}
else
{
$fetch = @mysql_fetch_array( mysql_query( "SELECT * FROM `settings`" ) );
$title = $fetch["title"];
$status = $fetch["statust"];
$logo = $fetch["main_logo"];
$offline = $fetch["offline_text"];
$left_logo = $fetch["logo_left"];
}
$html = <<<HTML
<form action="?action=update_settings" method="post">
<h2>site title - <span>this is the title your browser displays for your website.</span></h2><br />
<input class="textbox" name="title" type="text" value="$title"/>
<h2>site status - <span>this declares whther your site is online or offline.</span></h2><br />
<input name="status" type="radio" value="offline">Offline</input> <input name="status" type="radio" value="online">Online</input>
<h2>offline notice - <span>this is the message users see when the website is set to offline.</span></h2>
<textarea class="textarea" name="offline" type="text">$offline</textarea>
<h2>main logo - <span>this is your sites main logo.</span></h2>
<input class="textbox" name="main_logo" type="text" value="$logo"/>
<h2>semi-main logo - <span>this is your sites semi-main logo. its the bigger logo seen on the left of each page.</span></h2><br />
<input class="textbox" name="left_logo" type="text" value="$left_logo"/>
<br /><br />
<input type="submit" value="edit settings" class="submit" />
</form>
HTML;
echo( $html );
?>
Results 1 to 10 of 35
Thread: mySQL Not Updating?
-
mySQL Not Updating?
-
You're using the name attribute for your inputs. Try using the id attribute.
-
That is how you do it though, the name.
Originally Posted by Invent
-
No, that doesn't do anything.
-
I'm not sure I know what you mean but is it because your just changing it all, you're not specifying which row? Like..
UPDATE `blah` SET `blah='blah' WHERE `id`='1337'
-
That's not the problem - does anybody know? I need this asap.
-
Never use a @ in development and try and space out queries eg
$sql = "SELECT * FROM foo";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);
oh and in ur action use <?php echo $_SERVER['PHP_SELF']; ?>?action=update_settingsLast edited by Hypertext; 08-03-2008 at 05:59 PM.
How could this hapen to meeeeeeeeeeeeeee?
lol.
-
Why not use an @? That stops the output.
@imagecreatefromgif($image);
If image is not defined, it breaks and spits out everything in the world. That just shuts it up.
It doesn't matter about spacing queries out other then just being able to read them better.
The PHP_SELF thing doesn't matter one bit.
You don't need it.
@Will:
Is there a row inside of that table? If so, does it have a unique identifier (index) such as ID?
-
oh ok..
caleb if you leave action="" does it like just do php_self, always wondered that..How could this hapen to meeeeeeeeeeeeeee?lol.
-
No, I am pretty sure it doesn't.
Reply With Quote
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts