Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>What operating system is the remote host running PHP using? Perhaps MySQL isn't enabled in <code>php.ini</code>. Also, please don't use <code>mysql_*</code> functions for new code. They are no longer maintained and the community has begun the <a href="http://news.php.net/php.internals/53799" rel="nofollow">deprecation process</a> (see the <a href="http://uk.php.net/manual/en/function.mysql-connect.php" rel="nofollow">red box</a>). Instead, you should learn about <a href="http://en.wikipedia.org/wiki/Prepared_statement" rel="nofollow">prepared statements</a> and use either <a href="http://php.net/pdo" rel="nofollow">PDO</a> or <a href="http://php.net/mysqli" rel="nofollow">MySQLi</a>. If you can't decide which, <a href="http://php.net/manual/en/mysqlinfo.api.choosing.php" rel="nofollow">this article</a> will help you. If you care to learn, <a href="http://www.php.net/manual/en/pdo.connections.php" rel="nofollow">this is a good PDO tutorial</a>.</p> <p>Have you tried using PDO or the MySQLi interface? If you're trying to learn PHP, you <em>should not be using the mysql_</em>* functions regardless. See if you can access the database by using a line similar to this:</p> <pre><code>$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass); </code></pre> <p>If you need more detailed documentation, this code comes directly from the <a href="http://www.php.net/manual/en/pdo.connections.php" rel="nofollow">documentation itself</a>.</p> <p>EDIT: Also, try using PDO's error checking functionality. This example creates a database connection using PDO and tries to perform a simple query. It doesn't use prepared statements or any of those features, so it's not production-ready code (i.e. *don't just throw this into your code without understanding how to improve it) and you'll need to edit it to include a <code>SELECT</code> query that's relevant to your database, but it should at least tell PDO to provide more information about the errors it encounters. </p> <pre><code>&lt;?php error_reporting(E_ALL); ini_set('display_errors', 1); $dbhost = "localhost"; $dbname = "test"; $dbuser = "root"; $dbpass = "admin"; // database connection $conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass); // query $conn-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT * FROM booksa"; $q = $conn-&gt;query($sql) or die("ERROR: " . implode(":", $conn-&gt;errorInfo())); $r = $q-&gt;fetch(PDO::FETCH_ASSOC); print_r($r); ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PORemote connection to MySQL works via command line, but fails when using php's mysql_connect from a web browser
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRicardo Altamirano
    1. USRicardo Altamirano
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PORemote connection to MySQL works via command line, but fails when using php's mysql_connect from a web browser
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks for the tip. I switched to the new code you mentioned, but that doesn't solve the problem I have. I tried this simple file : <?php $usern = "myusername"; $dbh = new PDO('mysql:host=server;dbname=test', $usern, ""); echo $usern; ?> It doesn't printout the $usern in the browser.
      singulars
      1. PO
      1. USiamauser
    2. CO@iamauser Does it show an error message? Can you post the PDO code that you used (you can post it by editing your question)?
      singulars
      1. PO
      1. USRicardo Altamirano
    3. COI am new to StackOverflow asking questions. Could you please let me know the correct formatting to write code: Here is the code I used. <?php $usern = "myusername"; $dbh = new PDO('mysql:host=server;dbname=test', $usern, ""); echo $usern; ?>
      singulars
      1. PO
      1. USiamauser
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload