<form method=\"post\" action=\"insert.php\"> don,t wo

hisham · Jun 13, 2002

I tried the following codes to test mysql in my linux server
1- to create a MySQL database :

<?php

$result = mysql_create_db ("test_database&quot

;
if ($result == false)
echo mysql_errno() . ": " . mysql_error() . "<BR>";

?>

after running this code, the database was created successfully

2- to connect to a database and execute an SQL query. this code is to create a table that holds email information for a person:

<?php

$connection = mysql_connect ("192.168.0.2:3306", "root", "mypassword&quot

;
if ($connection == false){
echo mysql_errno().": ".mysql_error()."<BR>";
exit;
}

$query = "create table email_info " .
"(fullname varchar(255), email_address varchar(255))";
$result = mysql_db_query ("test_database", $query);

if ($result)
echo "Table 'email_info' was successfully created!";
else
echo mysql_errno().": ".mysql_error()."<BR>";

mysql_close ();

?>
after running the code, the connection and the tables was created successfully too.
3- When the following code is executed by a browser, it will show a form requesting a name and an email address. Once the submit button is clicked, the two fields will be stored into the table 'email_info', in the test_database.:
<?php

if ($submit == "click&quot

{
// The submit button was clicked!
// Get the input for fullname and email then store it in the database.
$connection = mysql_connect ("192.168.0.2:3306", "root", "mypasswrd&quot

;
if ($connection == false){
echo mysql_errno().": ".mysql_error()."<BR>";
exit;
}

$query = "insert into email_info values ('$fullname', '$email')";
$result = mysql_db_query ("test_database", $query);
if ($result){
echo "Success!";
}
else{
echo mysql_errno().": ".mysql_error()."<BR>";
}

mysql_close ();
}
else{
echo "
<html><body>

<form method=\"post\" action=\"insert.php\">

Enter your full name
<input type=\"text\" name=\"fullname\"></input><br>
Enter your email address
<input type=\"text\" name=\"email\"></input><br>

<input type=\"submit\" name=\"submit\" value=\"click\"></input>

</form>

</body></html>
";
}

?>

but the two fields data never stored into the table, just refresh the page when the submit button is clicked. User “root” has full privileges to insert, delete, etc… I tried many codes to insert data into tables but always face this same problem !!
Thanks in advance for your help.

KarveR · Jun 13, 2002

try this instead:

$query = "insert into email_info (fullname,email_address) values ('$fullname', '$email')";
***************************************
Party on, dudes!
[cannon]

hisham · Jun 14, 2002

I tried it, but don't want to insert the data !!

KarveR · Jun 14, 2002

missed this bit :
$result = mysql_db_query("test_database", $query);

Note: This function has been deprecated since PHP 4.0.6. Do not use this function. Use mysql_select_db() and mysql_query() instead.

mysql_select_db("test_database",$connection);
$result=mysql_query($query,$connection);
***************************************
Party on, dudes!
[cannon]

hisham · Jun 14, 2002

Thank you KarveR,
I tried it too but I didn’t get any error and the data didn’t insert into the table, I don't understand what happen. Can you write a simple code to insert a specific data (i.e. fullname: hisham and email_address: hisham@myserver.com) into table email_info without using form requesting a name and an email address, because I want to test if I can insert data into mysql database.
Thanks again.

DivineDragon · Jun 15, 2002

$query="INSERT INTO email_info VALUES ('$fullname', '$email')";
mysql_query($query);

I think that'll work. divine_dragon9999@yahoo.com

KarveR · Jun 16, 2002

OK heres a bit with some error checking to see if you are having errors on insert:
-----------------------------------------------------------
$connection = mysql_connect ("192.168.0.2:3306", "root", "mypassword&quot

;
$db="test_database";
// here we check what errors if any are given
$err_no=mysql_errno();
if ($err_no > 0 ){

// if errors show them
echo mysql_errno() . ": " . mysql_error() . "\n";

}
// here we select which database to use
@mysql_select_db($db,$connection) ;

$err_no=mysql_errno();

if ($err_no > 0 ){

echo " Error: " . mysql_errno() . ": " . mysql_error() . "<br>";

exit;

}

// this is your query to be called
$sql="INSERT into email_info (fullname,email_address) values ('$fullname', '$email')";

// this will echo your query to the screen to check that the variables have a value
echo "$sql<br>";

// connect to the db and run the insert
$insert=mysql_query($sql, $connection) ;

// here we check what errors if any are given
$err_no=mysql_errno();
if ($err_no > 0 ){

// if errors show them
echo mysql_errno() . ": " . mysql_error() . "\n";

}

//show number of rows affected on successful query
printf ("Records inserted: %d\n", mysql_affected_rows()); ***************************************
Party on, dudes!
[cannon]

hisham · Jun 16, 2002

Thank you ,
The code successfully inserted the data into the table, so I can be sure that the server and PHP and mysql work without errors. But I don’t understand why when I use form requesting a name and an email address, the code don’t insert the data and don’t give any error message, it only seems refresh the page!!

KarveR · Jun 16, 2002

Looking at your code I cant see where you select the database to insert the code into.

@mysql_select_db($db,$connection) ; ***************************************
Party on, dudes!
[cannon]

hisham · Jun 19, 2002

I created an html page contains the following form:

<form action="insert.php" method="post">
<input name="fullname">
<input name="email_address">
<input type="submit" value="submit">
<input type="reset" value="Clear">
</form>
the insert php:

<?php

$connection = mysql_connect ("192.168.0.2:3306", "root", "lino&quot

;
$db="test_database";
// here we check what errors if any are given
$err_no=mysql_errno();
if ($err_no > 0 ){

// if errors show them
echo mysql_errno() . ": " . mysql_error() . "\n";

}
// here we select which database to use
@mysql_select_db($db,$connection) ;

$err_no=mysql_errno();

if ($err_no > 0 ){

echo " Error: " . mysql_errno() . ": " . mysql_error() . "<br>";

exit;

}

// this is your query to be called
$query = "insert into email_info values ('$fullname', '$email')";

// connect to the db and run the insert
$insert=mysql_query($query, $connection) ;

// here we check what errors if any are given
$err_no=mysql_errno();
if ($err_no > 0 ){

// if errors show them
echo mysql_errno() . ": " . mysql_error() . "\n";

}

//show number of rows affected on successful query
printf ("Records inserted: %d\n", mysql_affected_rows());

?>

I get the following message: Records inserted: 1

But the records was blank, and not as I entered in the form.

I replaced
$query = "insert into email_info values ('$fullname', '$email')";
With:
$sql="INSERT into email_info (fullname,email_address) values ('$fullname', '$email')";
And
$insert=mysql_query($query, $connection) ;
With
$insert=mysql_query($sql, $connection) ;

But I get the same result???

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

<form method=\"post\" action=\"insert.php\"> don,t wo

hisham

IS-IT--Management

KarveR

MIS

hisham

IS-IT--Management

KarveR

MIS

hisham

IS-IT--Management

DivineDragon

Programmer

KarveR

MIS

hisham

IS-IT--Management

KarveR

MIS

hisham

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

&lt;form method=\&quot;post\&quot; action=\&quot;insert.php\&quot;&gt; don,t wo

IS-IT--Management

MIS

IS-IT--Management

MIS

IS-IT--Management

Programmer

MIS

IS-IT--Management

MIS

IS-IT--Management

Similar threads

Log in

Part and Inventory Search

Sponsor

<form method=\"post\" action=\"insert.php\"> don,t wo