Help Me

ppatwari

Thanks for your help in advance.

I have two different files: 1. submit.php and 2. createentry.php

Submit.php contains html code and calls createentry.php on press of the button.

Here is the code of createentry.php. I want send it to table called test1 in mysql db, but it always inserts blanks rows and I have already turned on register_global in php.ini and restarted the computer.

<?php
/ mysql_connect("localhost", "parth", "patwari") or
die ("Coultn't connect to database.");
mysql_select_db("sitenoc") or
die ("Couldn't slect database.");
/

$db = mysql_connect("localhost", "parth", "patwari");
mysql_select_db("sitenoc",$db)
or die("Unable to execute query:<br>$sql<br>Error: " . mysql_error());

//if($submit = "Sign!" )
// { ($HTTP_POST_VARS["name"]);
// echo '$name1';
//echo "$f_name";
//echo $e_mail;
$query = "INSERT INTO test1
(fname,lname,email) VALUES
('$firstname', '$lastname', '$emailfield')"
;
$result = mysql_query($query)
or die("Unable to execute query:<br>$sql<br>Error: " . mysql_error());
mysql_close($db);

/$result = mysql_query($query);// or /
//die (mysql_error());
?>

<?php/
}
else
{
include ("submit.php");
}
/?>

Thanks for your help.

Parth
😕 😕 😕 😕 😕

zhabala

Which php file are you opening in browser ? If you open createentry.php then it INSERTS a blank values into DB. Show us the content of submit.php file too. There may be an error.

Zdenek

ppatwari

Thanks for your reply.

Here is Submit.php

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>

<BODY>
<form action="createentry.php" method=post>
First Name <INPUT TYPE="text" NAME=firstname>
Last Name <INPUT TYPE="text" NAME=lastname>
Email <INPUT TYPE="text" NAME=emailfield>
<INPUT TYPE="submit" name="submit" value="Sign!">
</form>
</BODY>

</HTML>

Here is createentry.php

<?php
echo "<PRE>";
print_r ($HTTP_POST_VARS);
echo "</pre>";

$db = mysql_pconnect("localhost", "parth", "patwari");
mysql_select_db("sitenoc",$db)
or die("Unable to execute query:<br>$sql<br>Error: " . mysql_error());
echo $firstname;
$query = "INSERT INTO test1 (fname, lname, email) VALUES ('$firstname', '$lastname', '$emailfield')";
echo $query;
$result = mysql_query($query)
or die("Unable to execute query:<br>$query<br>Error: " . mysql_error());
mysql_close($db);
?>

henry_gayman

1-) one or more of your field names in "insert into..." query may be misspelled.
For e.g: "Iname" or "iname"?
2-)whats your primary key? "fname"? Are u trying to insert another row with an existing "fname"?
Try checking the existence of $firstname in your table before trying to insert it into it..
4-)it may not be the problem but:
insert into table ('field1','field2','....') values ('$data1','....','..')
--->use '''' for table field names
3-)It is not a problem but i'm used to do it like:
mysql_query("insert into......") or die("blabla......");
-->directly executing the query..

sorry, here at summer work i cannot use PHP but, if i had chance i'd execute your code

zhabala

I tryied to run your posted code and it works for me.

Are you sure you have register_globals correctly on ?

Try this pice of code instead of your createentry.php

<?php
echo "<PRE>";
print_r ($HTTP_POST_VARS);
echo "</pre>";

$db = mysql_pconnect("localhost", "zhabala", "lf191174");
mysql_select_db("sitenoc",$db)
or die("Unable to execute query:<br>$sql<br>Error: " . mysql_error());
echo $firstname;
$query = "INSERT INTO test1 (fname, lname, email) VALUES

('".$HTTP_POST_VARS['firstname']."', '".$HTTP_POST_VARS['lastname']."',

'".$HTTP_POST_VARS['emailfield']."')";
echo $query;
$result = mysql_query($query)
or die("Unable to execute query:<br>$query<br>Error: " . mysql_error());
mysql_close($db);
?>

ppatwari

Your code works great, but I am still wondering why my code was not working even though register_globals was On.

Thanks anyways,

Parth

zhabala

It seems, that you do not have register_globals on.

Zdenek