Akenatehm Posted January 31, 2009 Share Posted January 31, 2009 Hey Guys, The following script displays no errors and carries on as if it was succesful but it is not inserting into the database. I have spent hours trying to figure this out. Help would be greatly appreciated. <?php $host = 'host'; $username = 'username'; $pass = 'pass'; $db = 'database'; $con = mysql_connect($host,$username,$pass); if (!con) { die('Could not Connect:' . mysql_error()); } mysql_select_db("news"); $poster = $_COOKIE['user']; $date = date("F j,Y"); $content = $_POST['entry']; if($_POST['type'] == 'mainsite'){ mysql_query("INSERT INTO mainsite (poster, date, content) VALUES($poster,$date,$content)"); header("Location: succesfulpost.php"); } elseif($_POST['type'] == 'adminsite'){ mysql_query("INSERT INTO adminsite (poster, date, content) VALUES($poster,$date,$content)"); header("Location: succesfulpost.php"); } else{ echo "You have encountered an error."; } ?> Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/ Share on other sites More sharing options...
redarrow Posted January 31, 2009 Share Posted January 31, 2009 if($_POST['type'] == 'mainsite'){ << is this from a url if so you need to use $_GET[''] or is it in a hidden form field. Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751178 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 if($_POST['type'] == 'mainsite'){ << is this from a url if so you need to use $_GET[''] or is it in a hidden form field. Sorry, should have explained it better. I have a drop down menu in a form. The two options are mainsite and adminsite. If they select mainsite, i want to add it to the mainsite table and vice versa for adminsite. Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751179 Share on other sites More sharing options...
redarrow Posted January 31, 2009 Share Posted January 31, 2009 try this please. i have not added no database protection yet but see if it works. <?php $host = 'host'; $username = 'username'; $pass = 'pass'; $db = 'database'; $con = mysql_connect($host,$username,$pass); if (!$con) { die('Could not Connect:' . mysql_error()); } $res=mysql_select_db("news",$db); $poster = $_COOKIE['user']; $date = date("F j,Y"); $content = $_POST['entry']; if($_POST['type'] == 'mainsite'){ $sql="INSERT INTO mainsite (poster, date, content) VALUES($poster,$date,$content)"; $res=mysql/-query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } if($_POST['type'] == 'adminsite'){ $sql1="INSERT INTO adminsite (poster, date, content) VALUES($poster,$date,$content)"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); }else{ echo "You have encountered an error."; } ?> Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751180 Share on other sites More sharing options...
redarrow Posted January 31, 2009 Share Posted January 31, 2009 after all that the $con got no $ ? Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751181 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 Ok. I added the $ to con. I get the following error: Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/tedolinar/public_html/adminpanel/news/addentryscript.php on line 12 Fatal error: Call to undefined function query() in /home/tedolinar/public_html/adminpanel/news/addentryscript.php on line 22 Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751182 Share on other sites More sharing options...
redarrow Posted January 31, 2009 Share Posted January 31, 2009 try this a bit upgraded edited and corrected the $sql1 should work now. <?php $host = 'host'; $username = 'username'; $pass = 'pass'; $db = 'database'; $con = mysql_connect($host,$username,$pass); if (!$con) { die('Could not Connect:' . mysql_error()); } $res=mysql_select_db("news",$db); $poster = $_COOKIE['user']; $date =mysql_real_escape_string(date("F j,Y")); $content = mysql_real_escape_string($_POST['entry']); if($_POST['type'] == 'mainsite'){ $sql="INSERT INTO mainsite (poster, date, content) VALUES($poster,$date,$content)"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } if($_POST['type'] == 'adminsite'){ $sql1="INSERT INTO adminsite (poster, date, content) VALUES($poster,$date,$content)"; $res=mysql_query($sql1)or die(mysql_error()); header("Location: succesfulpost.php"); } if(!$_POST['type'] == 'adminsite' && !$_POST['type'] == 'mainsite'){ echo "You have encountered an error, Sorry please try agin!."; } ?> Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751183 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 Ok. I tried that and i get the following errors: Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/tedolinar/public_html/adminpanel/news/addentryscript.php on line 12 No database selected Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751184 Share on other sites More sharing options...
redarrow Posted January 31, 2009 Share Posted January 31, 2009 use the database connection like this then. <?php $db=mysql_connect("localhost","username","password"); $res_db=mysql_select_db("news",$db)or die(mysql_error()); $poster = $_COOKIE['user']; $date =mysql_real_escape_string(date("F j,Y")); $content = mysql_real_escape_string($_POST['entry']); if($_POST['type'] == 'mainsite'){ $sql="INSERT INTO mainsite (poster, date, content) VALUES($poster,$date,$content)"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } if($_POST['type'] == 'adminsite'){ $sql1="INSERT INTO adminsite (poster, date, content) VALUES($poster,$date,$content)"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } if(!$_POST['type'] == 'adminsite' && !$_POST['type'] == 'mainsite'){ echo "You have encountered an error, Sorry please try agin!."; } ?> Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751187 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 Ok. Now I get a mysql error. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'January 31,2009,Cody)' at line 1 I searched through but cant seem to see whats wrong. Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751191 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 Btw. Cody is my username from the cookie. Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751192 Share on other sites More sharing options...
redarrow Posted January 31, 2009 Share Posted January 31, 2009 sorry no single ' quotes around the insert variables <?php $db=mysql_connect("localhost","username","password"); $res_db=mysql_select_db("news",$db)or die(mysql_error()); $poster = $_COOKIE['user']; $date =mysql_real_escape_string(date("F j,Y")); $content = mysql_real_escape_string($_POST['entry']); if($_POST['type'] == 'mainsite'){ $sql="INSERT INTO mainsite (poster, date, content) VALUES('$poster','$date','$content')"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } if($_POST['type'] == 'adminsite'){ $sql1="INSERT INTO adminsite (poster, date, content) VALUES('$poster','$date','$content')"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } if(!$_POST['type'] == 'adminsite' && !$_POST['type'] == 'mainsite'){ echo "You have encountered an error, Sorry please try agin!."; } ?> Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751193 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 Ok. Its inserting fine now. But some of the fields were in the wrong place so i moved it around, now only the date field is showing. Here's the code: $poster = $_COOKIE['user']; $date =mysql_real_escape_string(date("F j,Y")); $content = mysql_real_escape_string($_POST['entry']); if($_POST['type'] == 'mainsite'){ $sql="INSERT INTO mainsite (entry, poster, date) VALUES('$entry','$poster','$date')"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } if($_POST['type'] == 'adminsite'){ $sql1="INSERT INTO adminsite (entry, poster, date) VALUES('$entry','$poster','$date')"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751199 Share on other sites More sharing options...
redarrow Posted January 31, 2009 Share Posted January 31, 2009 post your database so we can look properly. Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751202 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 Ok. WEll I have id (auto incrememnt) integer entry -text poster -tinytext date- tinytext Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751207 Share on other sites More sharing options...
redarrow Posted January 31, 2009 Share Posted January 31, 2009 well if that the order try now m8 <?php $poster = $_COOKIE['user']; $date =mysql_real_escape_string(date("F j,Y")); $content = mysql_real_escape_string($_POST['entry']); if($_POST['type'] == 'mainsite'){ $sql="INSERT INTO mainsite (content, poster, date) VALUES('$entry','$poster','$date')"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } if($_POST['type'] == 'adminsite'){ $sql1="INSERT INTO adminsite (content, poster, date) VALUES('$entry','$poster','$date')"; $res=mysql_query($sql1)or die(mysql_error()); header("Location: succesfulpost.php"); } ?> Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751210 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 Ok with the following code, it puts the poster in the entry (content) field and leaves the poster field blank. <?php $poster = $_COOKIE['user']; $date =mysql_real_escape_string(date("F j,Y")); $entry = mysql_real_escape_string($_POST['entry']); if($_POST['type'] == 'mainsite'){ $sql="INSERT INTO mainsite (entry, poster, date) VALUES('$entry','$poster','$date')"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } if($_POST['type'] == 'adminsite'){ $sql1="INSERT INTO adminsite (entry, poster, date) VALUES('$entry','$poster','$date')"; $res=mysql_query($sql1)or die(mysql_error()); header("Location: succesfulpost.php"); } ?> Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751212 Share on other sites More sharing options...
redarrow Posted January 31, 2009 Share Posted January 31, 2009 try this then <?php $poster = $_COOKIE['user']; $poster=mysql_real_escape_string($_POST['poster']); $date =mysql_real_escape_string(date("F j,Y")); $entry = mysql_real_escape_string($_POST['entry']); if($_POST['type'] == 'mainsite'){ $sql="INSERT INTO mainsite (entry, poster, date) VALUES('$entry','$poster','$date')"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } if($_POST['type'] == 'adminsite'){ $sql1="INSERT INTO adminsite (entry, poster, date) VALUES('$entry','$poster','$date')"; $res=mysql_query($sql1)or die(mysql_error()); header("Location: succesfulpost.php"); } ?> Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751214 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 Omg I've been a total noob. When testing the form I was writing Cody (my name) as the message which is also the same thing that would have been coming from the COOKIE. That is why it was putting it in the wrong field (which it wasn't). Real sorry about that mate. BUT the poster is not showing up from the cookie. I just realised something else too. I was putting the cookie as $_COOKIE['user'] when it should have been the name of the cookie....Sorry. the $_COOKIE['ID_my_site']; Sorry bout that muck ups mate..and really appreciate your help! Let me check this and see if it works. Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751216 Share on other sites More sharing options...
redarrow Posted January 31, 2009 Share Posted January 31, 2009 post the corrected code then and were work on it ok m8. Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751218 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 Ok. The cookie correction didn't work. IT is still inserting to the DB with no poster <?php $poster = $_COOKIE['ID_my_site']; $poster=mysql_real_escape_string($_POST['poster']); $date =mysql_real_escape_string(date("F j,Y")); $entry = mysql_real_escape_string($_POST['entry']); if($_POST['type'] == 'mainsite'){ $sql="INSERT INTO mainsite (entry, poster, date) VALUES('$entry','$poster','$date')"; $res=mysql_query($sql)or die(mysql_error()); header("Location: succesfulpost.php"); } if($_POST['type'] == 'adminsite'){ $sql1="INSERT INTO adminsite (entry, poster, date) VALUES('$entry','$poster','$date')"; $res=mysql_query($sql1)or die(mysql_error()); header("Location: succesfulpost.php"); } ?> Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751219 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 OK I removed this line: $poster=mysql_real_escape_string($_POST['poster']); and it worked like a breeze! Thank you soo much for your help.!! Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751221 Share on other sites More sharing options...
redarrow Posted January 31, 2009 Share Posted January 31, 2009 well done kick ur self now after that small mistake lol. Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751223 Share on other sites More sharing options...
Akenatehm Posted January 31, 2009 Author Share Posted January 31, 2009 lol yeah i know..i have this other issue though that is much harder i think.. Quote Link to comment https://forums.phpfreaks.com/topic/143232-solved-not-inserting-into-database/#findComment-751224 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.