remote connection doubt in MySql using php

Question

0.00/5 (No votes)

See more:

php file is in my system and the database is in my server "192.168.1.25", so
i created my file name "conn.php"

PHP

<?php
$dbhost = '192.168.1.25:3306';
$dbuser = 'root';
$dbpass = '';
$database = 'sample';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
/*mysql_select_db($database, $conn);*/
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
mysql_select_db('sample', $conn);

$sql = 'select * from test';

$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_NUM))
{
    echo "EMP ID :{$row[0]}  <br> ".
         "EMP NAME : {$row[1]} <br> ".
         "EMP SALARY : {$row[2]} <br> ".
         "--------------------------------<br>";
}
mysql_free_result($retval);
echo "Fetched data successfully\n";
mysql_close($conn); 
?>


</body>
</html>
</html>

i got this error, given below

"Could not get data: No database selected"

please help me,,
thanks in advance...

Posted 5-Jul-13 22:22pm

sathish4303

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sudhakar Shinde · Answer 1 · 2013-07-05T22:35:00

Solution 1

Connect to the root user and Run a GRANT statement to grant access to your database user.

SQL

GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'localhost'
WITH GRANT OPTION;

Refer to the [LINK] for more info on grant.

Posted 5-Jul-13 22:35pm

Sudhakar Shinde

Comments

sathish4303 6-Jul-13 6:20am

how can Connect to the root user, can you give me the steps..

Prasad Khandekar 8-Jul-13 9:22am

You can connect to your database as a root user from command prompt. Go to the bin folder of the MySQL installation and run following command.

mysql -u root

if it gives error then try

mysql -u root -p

Once connected simply issue the GRANT command

GRANT ALL ON sample.* TO 'dbuser'@'localhost';

Regards,

[no name] 31-Jul-18 6:37am

You need add following code in your config file:

<?php

function getdb(){

$servername = "46.101.5.233"; // put your cloudways server IP here
$username = "qxxfumxxxbd";
$password = "xxxxbQxxmM";
$db = "qxxfumxxxbd";

try {

   $conn = mysqli_connect($servername, $username, $password, $db);

    //echo "Connected successfully";

   }

catch(exception $e)

   {

   echo "Connection failed: " . $e->getMessage();

   }

   return $conn;

}

Try remote mysql connection again with this code.

Prasad Khandekar · Answer 2 · 2013-07-08T03:16:00

Hello Satish,

Ideally your mysql_select_db function should select the database. Please check the return value of the function. Alternatively you can programmatically issue the USE command.

PHP

<?php
mysql_query("USE sample", $conn);
?>

Still another way is to rewrite your query to include the database qualifier as shown below.

PHP

$sql = 'select * from sample.test';
$retval = mysql_query( $sql, $conn );

As a not of caution, I will encourage you to switch to MYSQLi[^] or PDO_MYSQL[^] extensions. The extension you are using is deprecated as of PHP 5.5.0, and will be removed in the future.

Regards,