Jump to content

Archived

This topic is now archived and is closed to further replies.

Deftone

INSERT INTO

Recommended Posts

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]

<?php
include ('_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 insert
mysql_query("INSERT INTO 'race' VALUES ('" . $_POST["plaats"] . "', '" . $_POST["coureur"] . "', '" . $_POST["team"] . "', '" . $_POST["tijd"] . "', '" . $_POST["finish"] . "', '" . $_POST["race"] . "', '" . $_POST["jaar"] . "')");
//Geef weer dat het is gelukt
echo "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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
Hi,

Thanks for your reply. I just changed the webhost. They are using php5 and mysql5
I 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

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
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  :'(

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
register_globals are off. Also magic_quotes are off

register_globals = Off
register_argc_argv = Off
register_long_arrays = Off
magic_quotes_gpc = Off
enable_dl = Off

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
Again no mysql error's
Only 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]


<?php
include ('_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 invoeren
mysql_query("INSERT INTO race (plaats, coureur, team, tijd, finish, race, jaar) VALUES ('$plaats', '$coureur', '$team', '$tijd', '$finish', '$race', '$jaar')");
//Geef weer dat het is gelukt
echo "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]

Share this post


Link to post
Share on other sites
I did that but again anly empty fields.
Guys once again I really apriciate your help.
You are great

Share this post


Link to post
Share on other sites
put [b]print_r($_POST);[/b] on the first line of your script and report what you get on screen.

Share this post


Link to post
Share on other sites
Here you go
[code]

<?php
include ('_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 insert
mysql_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 gelukt
echo "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]

Share this post


Link to post
Share on other sites
Ok I did that but stil nothing get into the DB
The 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]

Share this post


Link to post
Share on other sites



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>

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
Thank you thank you thank you
Problem solved.
You can close this topic.  ;) ;) ;) ;) ;) ;) ;) ;)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.