Php MySQL Forum?

Greenman · 02-20-2003, 07:59 AM

Hi,

I have got the following code to try and insert data into MySQL database but I am not having much luck.
Has anyone any ideas as to what’s I am doing wrong.
I am not getting errors when I try click enter info.

Ta,
g

<html>

<body>

<?php
$db = mysql_connect("localhost", "user", "passwd")
or die ("cant connect to the DB");
print ("connected to database successfully");

mysql_select_db("test",$db);

?><html><br><br><?php

if ($submit) {

$sql = "INSERT INTO employees (first,last,address,position)
VALUES ('$first','$last','$address','$position')";

$result = mysql_query($sql)or die(mysql_error());

echo "Thank you! Information entered.\n";

} else{

// display form

?>

<form method="post" action="<?php echo $PHP_SELF?>">

First name:<input type="Text" name="first" value="<?php echo $first ?>"><br>

Last name:<input type="Text" name="last"><br>

Address:<input type="Text" name="address"><br>

Position:<input type="Text" name="position"><br>

<input type="Submit" name="submit" value="Enter information">

</form>

<?php

} // end if

?>

</body>

</html>

rhuser · 02-20-2003, 04:42 PM

hi there

i had problems before with this, and the way i solved this was to download the rpm for the link between php and mysql. i think it is called php-mysql.
A module for PHP applications that use MySQL databases.

i was using Red hat, so i obtained php-mysql from rhn.redhat.com.
php-mysql-4.2.2-8.0.7.i386.rpm

------
The php-mysql package contains a dynamic shared object that will add
MySQL database support to PHP. MySQL is an object-relational database
management system. PHP is an HTML-embeddable scripting language. If
you need MySQL support for PHP applications, you will need to install
this package and the php or mod_php package.

Greenman · 02-21-2003, 01:34 AM

Hi rhuser,

I have seen that problems before also and have database connectivity and can call data from the MySQL DB happily
Also with some simple script I can also add to the data base
But when I try and enter data in the MySQL via a form no Cigar!!

This is an example of some code that works for me

$insert = "INSERT INTO employees (first,last)
VALUES ('Morgan','Andersson')";
mysql_query($insert) or die ("Could not add data to the table");
$result = mysql_query($sql);

Greenman · 02-26-2003, 05:58 AM

Anyone have any ideas what is wrong with this code folks?

I am trying to enter info into a MySQL DB via a Form

Hko · 02-27-2003, 11:53 AM

Your problem may be caused by having the option "register_globals = Off" in your php.ini file (somewhere in /etc/ or /etc/php /etc/php4 or so). If you set it to "On" (maybe you need to restart apache after editing php.ini), I think your script will work.

If you don't want to set "register_globals = On" (e.g. for reasons of better security), or if you can't because it's on some provider's server, add some lines to your script in order to fill the variables. Like this:

Code:

/* . . . */

$submit = $HTTP_POST_VARS['submit'];
$first = $HTTP_POST_VARS['first'];
$last = $HTTP_POST_VARS['last'];
$address = $HTTP_POST_VARS['address'];
$position = $HTTP_POST_VARS['position'];

if ($submit) {
  $sql = "INSERT INTO employees (first,last,address,position) 
	VALUES ('$first','$last','$address','$position')";

  $result = mysql_query($sql)or die(mysql_error());

/* . . . */

If you use PHP 4.1.0 or later it probably better to use $_POST instead of $HTTP_POST_VARS.

Good luck.

Greenman · 02-27-2003, 01:35 PM

Hi,

Thanks for the advice!!!!

This was the solution to my problems!!

if ($_POST["submit"]) {

Nice

G