note 104095 rejected from function.mysql-db-query by thiago
| From: | thiago@php.net | Date: | Mon, 23 May 2011 14:09:37 +0000 |
| Subject: | note 104095 rejected from function.mysql-db-query by thiago | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-179957@lists.php.net to get a copy of this message | ||
Note Submitter: nainale72 at hotmail dot com
----
/* mmm, it seems that the example don't show the function mysql_db_query, but mysql_query.
Lets see it properly done:
*/
// on this one, we connect to database and recover some rows
<?php
bd=mysql_connect("MySQL_HOST","Admin","******");
if(!$bd)
{
die("Error, connection failed");
}
else
{
$select = mysql_db_query("Hollywood","SELECT * FROM movies");
while($object=mysql_fetch_object($select))
{
echo "Id Movie: ".$object->Id.".";
echo "Title: ".$object->Title.".";
echo "Director: ".$object->Director.".";
}
}
mysql_close($bd);
?>
// on this one, we connect to database and execute a sentence (INSERT/UPDATE/DELETE)
<?php
$id = $_POST["IdMovie"];
$title = $_POST["TitleMovie"];
bd=mysql_connect("MySQL_HOST","Admin","******");
if(!$bd)
{
die("Error, connection failed.");
}
else
{
if(!mysql_db_query("Hollywood","UPDATE movies SET Title='$title' WHERE
Id='$id'"))
{
die("Error, movie not updated.");
}
}
mysql_close($bd);
?>