Deftone Posted July 25, 2006 Share Posted July 25, 2006 Hallo,I'm new here and also in PHP world.Few daysago I go from php4 en mysql4 to php5 and mysql5 but now I can not insert info into the database.Can someone tell me where i did wrong?[code]<?phpinclude ('_mySQL.php');if ($toevoegen == "ja");if ($pwd == "$pass");if($_POST['submit']){//Toevoegen//Connect$database_server = mysql_connect("$host","$user","$pass");mysql_select_db("$database", $database_server); if ($plaats == "1"){$plaats = " 1";}else {}if ($plaats == "2"){$plaats = " 2";}else {}if ($plaats == "3"){$plaats = " 3";}else {}if ($plaats == "4"){$plaats = " 4";}else {}if ($plaats == "5"){$plaats = " 5";}else {}if ($plaats == "6"){$plaats = " 6";}else {}if ($plaats == "7"){$plaats = " 7";}else {}if ($plaats == "8"){$plaats = " 8";}else {}if ($plaats == "9"){$plaats = " 9";}else {}//Data insertmysql_query("INSERT INTO 'race' VALUES ('" . $_POST["plaats"] . "', '" . $_POST["coureur"] . "', '" . $_POST["team"] . "', '" . $_POST["tijd"] . "', '" . $_POST["finish"] . "', '" . $_POST["race"] . "', '" . $_POST["jaar"] . "')");//Geef weer dat het is geluktecho "Gegevens toegevoegd!";echo "<html><head><title>Race-uitslag toevoegen</title></head><body><font face=\"Arial\" size=\"2\"><form action=\"race.php\" enctype=multipart/form-data><input type=\"hidden\" name=\"toevoegen\" value=\"ja\">Wachtwoord:<br><input type=\"password\" size=\"30\" name=\"pwd\"><br>Circuit:<br><input type=\"text\" size=\"30\" name=\"race\" value=\"$race\"><br>Jaar:<br><input type=\"text\" size=\"30\" name=\"jaar\" value=\"$jaar\"><br>Plaats:<br><input type=\"text\" size=\"30\" name=\"plaats\"><br>Coureur:<br><input type=\"text\" size=\"30\" name=\"coureur\"><br>Team:<br><input type=\"text\" size=\"30\" name=\"team\"><br>Tijd / reden uitval:<br><input type=\"text\" size=\"30\" name=\"tijd\"><br>Gefinished: <b>ja / nee</b><br><input type=\"text\" size=\"30\" name=\"finish\" value=\"$finish\"><br><input type=\"submit\" value=\"Verzenden\"><input type=\"reset\" value=\"Invoer wissen\"></form></body></html>";}else {?>[/code]When I submit the news the info is not going to the database.When I did that in php4 and mysql4 I got no problems Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted July 25, 2006 Share Posted July 25, 2006 did you get any error?how did you upgrade?make sure the host,username, and password are correct. the way mysql stores the user passwords has changed in mysql5, so you may want to re-setup the accounts. Quote Link to comment Share on other sites More sharing options...
thepip3r Posted July 25, 2006 Share Posted July 25, 2006 what errors are you displaying in PHP.ini? is mysql reporting an error?u should always allow for error checking. in a production environment, change your error checking to something ambiguous but in testing, just report the mysql_error upon failure like so:[code]mysql_query("INSERT INTO 'race' VALUES ('" . $_POST["plaats"] . "', '" . $_POST["coureur"] . "', '" . $_POST["team"] . "', '" . $_POST["tijd"] . "', '" . $_POST["finish"] . "', '" . $_POST["race"] . "', '" . $_POST["jaar"] . "')") or die(mysql_error());[/code]there were a number of changes in mysql from 4-5 for syntax so you may be getting an error and not knowing it. Quote Link to comment Share on other sites More sharing options...
Deftone Posted July 25, 2006 Author Share Posted July 25, 2006 Hi,Thanks for your reply. I just changed the webhost. They are using php5 and mysql5I had to make some chnges on my site and the only thing that's not working is to put info into the database.I can get the info from the db on my frontpage but not into the db.I don't get eny error. When I fill my form the fields go blanc and there isno insert in to the db Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted July 25, 2006 Share Posted July 25, 2006 oh. i spot it. remove the single quotes around race... or use backticks... I wonder why it even worked in mysql4...[code]INSERT INTO race VALUES ... [/code] Quote Link to comment Share on other sites More sharing options...
Deftone Posted July 25, 2006 Author Share Posted July 25, 2006 I did what you both say but I not getting any error mysql error.The fields only goes blank and that's it.[code]mysql_query("INSERT INTO race VALUES ('" . $_POST["plaats"] . "', '" . $_POST["coureur"] . "', '" . $_POST["team"] . "', '" . $_POST["tijd"] . "', '" . $_POST["finish"] . "', '" . $_POST["race"] . "', '" . $_POST["jaar"] . "')") or die(mysql_error());[/code]When I look into the DB there is no new info :'( Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted July 25, 2006 Share Posted July 25, 2006 does your new server have register_globals turned on?? check your phpinfo. you want to turn it off.try print_r($_POST) too, see if it contains anything. Quote Link to comment Share on other sites More sharing options...
Deftone Posted July 25, 2006 Author Share Posted July 25, 2006 register_globals are off. Also magic_quotes are offregister_globals = Offregister_argc_argv = Offregister_long_arrays = Offmagic_quotes_gpc = Offenable_dl = Off Quote Link to comment Share on other sites More sharing options...
thepip3r Posted July 25, 2006 Share Posted July 25, 2006 Add the "or die(mysql_error());" statements to your mysql_connect() and mysql_select_db(). i would assume he's not even getting to the mysql_query because it should not let him even run a query where he's trying to input blank values if the $_POST superglobal is not being propgated with information. Quote Link to comment Share on other sites More sharing options...
Deftone Posted July 25, 2006 Author Share Posted July 25, 2006 Again no mysql error'sOnly fields that turns blanc by hpushing the submit button.I have to tel you that I changed the script becouse of the problem.First my script looked like that[code]<?phpinclude ('_mySQL.php');if ($toevoegen == "ja"){if ($pwd == "$pass") {//Toevoegen//Verbinding maken$database_server = mysql_connect("$host","$user","$pass");mysql_select_db("$database", $database_server); if ($plaats == "1"){$plaats = " 1";}else {}if ($plaats == "2"){$plaats = " 2";}else {}if ($plaats == "3"){$plaats = " 3";}else {}if ($plaats == "4"){$plaats = " 4";}else {}if ($plaats == "5"){$plaats = " 5";}else {}if ($plaats == "6"){$plaats = " 6";}else {}if ($plaats == "7"){$plaats = " 7";}else {}if ($plaats == "8"){$plaats = " 8";}else {}if ($plaats == "9"){$plaats = " 9";}else {}//Gegevens invoerenmysql_query("INSERT INTO race (plaats, coureur, team, tijd, finish, race, jaar) VALUES ('$plaats', '$coureur', '$team', '$tijd', '$finish', '$race', '$jaar')");//Geef weer dat het is geluktecho "Gegevens toegevoegd!";echo "<html><head><title>Race-uitslag toevoegen</title></head><body><font face=\"Arial\" size=\"2\"><form action=\"race.php\" enctype=multipart/form-data><input type=\"hidden\" name=\"toevoegen\" value=\"ja\">Wachtwoord:<br><input type=\"password\" size=\"30\" name=\"pwd\"><br>Circuit:<br><input type=\"text\" size=\"30\" name=\"race\" value=\"$race\"><br>Jaar:<br><input type=\"text\" size=\"30\" name=\"jaar\" value=\"$jaar\"><br>Plaats:<br><input type=\"text\" size=\"30\" name=\"plaats\"><br>Coureur:<br><input type=\"text\" size=\"30\" name=\"coureur\"><br>Team:<br><input type=\"text\" size=\"30\" name=\"team\"><br>Tijd / reden uitval:<br><input type=\"text\" size=\"30\" name=\"tijd\"><br>Gefinished: <b>ja / nee</b><br><input type=\"text\" size=\"30\" name=\"finish\" value=\"$finish\"><br><input type=\"submit\" value=\"Verzenden\"><input type=\"reset\" value=\"Invoer wissen\"></form></body></html>";}}else {?>[/code] Quote Link to comment Share on other sites More sharing options...
ShogunWarrior Posted July 25, 2006 Share Posted July 25, 2006 Under mysql_query put [b]echo( mysql_error() );[/b] and that should show any MySQL errors. Quote Link to comment Share on other sites More sharing options...
Deftone Posted July 25, 2006 Author Share Posted July 25, 2006 I did that but again anly empty fields.Guys once again I really apriciate your help.You are great Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted July 25, 2006 Share Posted July 25, 2006 put [b]print_r($_POST);[/b] on the first line of your script and report what you get on screen. Quote Link to comment Share on other sites More sharing options...
Deftone Posted July 25, 2006 Author Share Posted July 25, 2006 I got this:Array ( ) Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted July 25, 2006 Share Posted July 25, 2006 so it's not the database. can you post the form? Quote Link to comment Share on other sites More sharing options...
Deftone Posted July 25, 2006 Author Share Posted July 25, 2006 Here you go[code]<?phpinclude ('_mySQL.php');if ($toevoegen == "ja");if ($pwd == "$pass");if($_POST['submit']){//Toevoegen//Connect$database_server = mysql_connect("$host","$user","$pass") or die(mysql_error());mysql_select_db("$database", $database_server) or die(mysql_error());if ($plaats == "1"){$plaats = " 1";}else {}if ($plaats == "2"){$plaats = " 2";}else {}if ($plaats == "3"){$plaats = " 3";}else {}if ($plaats == "4"){$plaats = " 4";}else {}if ($plaats == "5"){$plaats = " 5";}else {}if ($plaats == "6"){$plaats = " 6";}else {}if ($plaats == "7"){$plaats = " 7";}else {}if ($plaats == "8"){$plaats = " 8";}else {}if ($plaats == "9"){$plaats = " 9";}else {}//Data insertmysql_query("INSERT INTO race VALUES ('" . $_POST["plaats"] . "', '" . $_POST["coureur"] . "', '" . $_POST["team"] . "', '" . $_POST["tijd"] . "', '" . $_POST["finish"] . "', '" . $_POST["race"] . "', '" . $_POST["jaar"] . "')");echo( mysql_error() ); //Geef weer dat het is geluktecho "Gegevens toegevoegd!";echo "<html><head><title>Race-uitslag toevoegen</title></head><body><font face=\"Arial\" size=\"2\"><form action=\"race.php\" enctype=multipart/form-data><input type=\"hidden\" name=\"toevoegen\" value=\"ja\">Wachtwoord:<br><input type=\"password\" size=\"30\" name=\"pwd\"><br>Circuit:<br><input type=\"text\" size=\"30\" name=\"race\" value=\"$race\"><br>Jaar:<br><input type=\"text\" size=\"30\" name=\"jaar\" value=\"$jaar\"><br>Plaats:<br><input type=\"text\" size=\"30\" name=\"plaats\"><br>Coureur:<br><input type=\"text\" size=\"30\" name=\"coureur\"><br>Team:<br><input type=\"text\" size=\"30\" name=\"team\"><br>Tijd / reden uitval:<br><input type=\"text\" size=\"30\" name=\"tijd\"><br>Gefinished: <b>ja / nee</b><br><input type=\"text\" size=\"30\" name=\"finish\" value=\"$finish\"><br><input type=\"post\" value=\"Verzenden\"><input type=\"reset\" value=\"Invoer wissen\"></form></body></html>";}else {?><html><head><title>Race-uitslag toevoegen</title></head><body><font face="Arial" size="2"><form action="race.php"><input type="hidden" name="toevoegen" value="ja">Wachtwoord:<br><input type="password" size="30" name="pwd"><br>Circuit:<br><input type="text" size="30" name="race"><br>Jaar:<br><input type="text" size="30" name="jaar"><br>Plaats:<br><input type="text" size="30" name="plaats"><br>Coureur:<br><input type="text" size="30" name="coureur"><br>Team:<br><input type="text" size="30" name="team"><br>Tijd / reden uitval:<br><input type="text" size="30" name="tijd"><br>Gefinished: <b>ja / nee</b><br><input type="text" size="30" name="finish"><br><input type="submit" value="Verzenden"><input type="reset" value="Invoer wissen"></form></body></html><?php}?>[/code] Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted July 25, 2006 Share Posted July 25, 2006 <form action="race.php" [b]method="post"[/b]> Quote Link to comment Share on other sites More sharing options...
Deftone Posted July 25, 2006 Author Share Posted July 25, 2006 Ok I did that but stil nothing get into the DBThe only thing i get above the page is[code]Array ( [toevoegen] => ja [pwd] => ***** [race] => Duitsland [jaar] => 2006 [plaats] => 1 [coureur] => T.Test [team] => Renault [tijd] => 1:22:22:234 [finish] => ja )[/code] Quote Link to comment Share on other sites More sharing options...
Deftone Posted July 26, 2006 Author Share Posted July 26, 2006 I don't know where to search Quote Link to comment Share on other sites More sharing options...
redarrow Posted July 26, 2006 Share Posted July 26, 2006 is this your form wheres post<form action=\"race.php\" enctype=multipart/form-data><input type=\"hidden\" name=\"toevoegen\" value=\"ja\">Wachtwoord:<br><input type=\"password\" size=\"30\" name=\"pwd\"><br>Circuit:<br><input type=\"text\" size=\"30\" name=\"race\" value=\"$race\"><br>Jaar:<br><input type=\"text\" size=\"30\" name=\"jaar\" value=\"$jaar\"><br>Plaats:<br><input type=\"text\" size=\"30\" name=\"plaats\"><br>Coureur:<br><input type=\"text\" size=\"30\" name=\"coureur\"><br>Team:<br><input type=\"text\" size=\"30\" name=\"team\"><br>Tijd / reden uitval:<br><input type=\"text\" size=\"30\" name=\"tijd\"><br>Gefinished: <b>ja / nee</b><br><input type=\"text\" size=\"30\" name=\"finish\" value=\"$finish\"><br><input type=\"submit\" value=\"Verzenden\"><input type=\"reset\" value=\"Invoer wissen\"></form> Quote Link to comment Share on other sites More sharing options...
Deftone Posted July 26, 2006 Author Share Posted July 26, 2006 Yes.I use this two[code]<html><head><title>Race-uitslag toevoegen</title></head><body><font face=\"Arial\" size=\"2\"><form action=\"race.php\" enctype=multipart/form-data><input type=\"hidden\" name=\"toevoegen\" value=\"ja\">Wachtwoord:<br><input type=\"password\" size=\"30\" name=\"pwd\"><br>Circuit:<br><input type=\"text\" size=\"30\" name=\"race\" value=\"$race\"><br>Jaar:<br><input type=\"text\" size=\"30\" name=\"jaar\" value=\"$jaar\"><br>Plaats:<br><input type=\"text\" size=\"30\" name=\"plaats\"><br>Coureur:<br><input type=\"text\" size=\"30\" name=\"coureur\"><br>Team:<br><input type=\"text\" size=\"30\" name=\"team\"><br>Tijd / reden uitval:<br><input type=\"text\" size=\"30\" name=\"tijd\"><br>Gefinished: <b>ja / nee</b><br><input type=\"text\" size=\"30\" name=\"finish\" value=\"$finish\"><br><input type=\"submit\" value=\"Verzenden\"><input type=\"reset\" value=\"Invoer wissen\"></form></body></html>";}else {?><html><head><title>Race-uitslag toevoegen</title></head><body><font face="Arial" size="2"><form action="race.php" method="post"><input type="hidden" name="toevoegen" value="ja">Wachtwoord:<br><input type="password" size="30" name="pwd"><br>Circuit:<br><input type="text" size="30" name="race"><br>Jaar:<br><input type="text" size="30" name="jaar"><br>Plaats:<br><input type="text" size="30" name="plaats"><br>Coureur:<br><input type="text" size="30" name="coureur"><br>Team:<br><input type="text" size="30" name="team"><br>Tijd / reden uitval:<br><input type="text" size="30" name="tijd"><br>Gefinished: <b>ja / nee</b><br><input type="text" size="30" name="finish"><br><input type="submit" value="Verzenden"><input type="reset" value="Invoer wissen"></form></body></html>[/code] Quote Link to comment Share on other sites More sharing options...
redarrow Posted July 26, 2006 Share Posted July 26, 2006 gotto use post ok on all forms. method=" "<form action=\"race.php\" enctype=multipart/form-data method="post">also name the submit button on all forms name=" "<input name="submit" type="submit" value="Verzenden">then where the insert is put this ok.the post submit comes from the form name submit get me!if($_POST['submit']) {}good luck. Quote Link to comment Share on other sites More sharing options...
Deftone Posted July 26, 2006 Author Share Posted July 26, 2006 Thank you thank you thank youProblem solved.You can close this topic. ;) ;) ;) ;) ;) ;) ;) ;) Quote Link to comment 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.