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:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 4:21 PM
To: [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
To: "Luis A" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
