On Fri, May 9, 2014 at 5:37 PM, iccsi <inungh@xxxxxxxxx> wrote:
> I have following code to connect MySQL server.
> I got Connected to database message, but I got Could not run query : No
> database selected error message when run mysql_query.
> I check that the database name is correct, I use root account which should
> have the rights to do select.
> I can access my db using phpMyAdmin, so my PHP and MySQL server both
> running.
>
> It seems that it connected to MySQL, but for some reason it does not
> connect to the database.
>
> Are there any configuration need to check for the connection?
> Your help and information is great appreciated,
>
>
> $hostname = "localhost";
> $username = "MyUser";
> $password = "mypassword";
>
> try {
> $dbh = new PDO("mysql:host=localhost;dbname=mydb;charset=utf8",
> $username, $password);
> echo "Connected to database";
> }
> catch(PDOException $e)
> {
> echo $e->getMessage();
> }
>
>
> $result = mysql_query("SELECT invid, invdate, note, amount FROM
> invheader");
> if (!$result) {
> echo 'Could not run query: ' . mysql_error();
> exit;
> }
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
You are using PDO to connect and mysql_* functions to execute the queries.
That is not possible. You either stick with PDO prepared statements or use
mysql_* functions. Here is a tutorial on how you can use PDO functions:
http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers
