RE: [PHP] mysql trouble
| From: | Bryan Lipscy | Date: | Wed, 26 Feb 2003 01:25:21 +0000 |
| Subject: | RE: [PHP] mysql trouble | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-137174@lists.php.net to get a copy of this message | ||
Create a user with appropriate privledges for the database. DO NOT use
root.
<?php
$DB_HOST = "localhost";
$DB_USER = "root"; // Do not do this. Make a different user.
$DB_PASS = "";
$DB_DB = "mydb";
// connect to the database server
$db= @mysql_pconnect ( $DB_HOST , $DB_USER , $DB_PASS );
// use the database
@mysql_select_db ( $DB_DB ) or die ( "[ERROR] ".mysql_error()
);
// process form
$sql = "INSERT INTO agenda (nombre, direccion, telefono, email)
VALUES ('".$nombre."', '".$direccion."',
'".$telefono."',
'".$email."')";
$result = mysql_query($sql);
echo "¡Gracias! Hemos recibido sus datos.\n";
/* Free resultset */
mysql_free_result($result);
/* Closing connection */
mysql_close($db);
?>
You did not mention where the $nombre, $direccion, $telefono, or $email
variables are being initialized.
To capture the values from a form use $_POST['name'] where name is the
name of the field on the form.
HTH
-----Original Message-----
From: Luis A [mailto:webmaster@iscf.esisc.colombus.cu]
Sent: Tuesday, February 25, 2003 4:21 PM
To: php-general@lists.php.net
Subject: [PHP] to paulm Re: [PHP] mysql trouble
hey i think the root does not need password to connect to mysql
or yes ????
on my server the root user does not have password
thats why i dont know why he does not update the database?
----- Original Message -----
From: "paulm" <paulm@sgi.rdscv.ro>
To: "Luis A" <webmaster@iscf.esisc.colombus.cu>
Sent: Tuesday, February 25, 2003 6:48 PM
Subject: Re: [PHP] mysql trouble
> you don't have a password for root in mysql_connect
> ----- Original Message -----
> From: "Luis A" <webmaster@iscf.esisc.colombus.cu>
> To: <php-general@lists.php.net>
> Sent: Wednesday, February 26, 2003 1:04 AM
> Subject: [PHP] mysql trouble
>
>
> hi pasl i got a troblem here
>
>
> if some one can help me ?
>
> take a look at this
> <?php
> // process form
> $link = mysql_connect("localhost", "root");
> mysql_select_db("mydb",$db); $sql = "INSERT INTO agenda (nombre,
> direccion, telefono, email) " +
> "VALUES ('$nombre', '$direccion', '$telefono',
> '$email')"; $result =
> mysql_query($sql); echo "¡Gracias! Hemos recibido sus datos.\n";
>
> ?>
>
>
>
> HE DOES NOT WORKING
>
> any subjest ?
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php