PHP MySQL 'No such file or directory'

Question

Recently I've bought webhosting at names.co.uk and I'm trying to set up something simple which will display the name from a table named Team if the id = 1. This is my code

<?php 
$q = "SELECT * FROM `Team` WHERE id =1";

$result = mysql_query($q);

echo '<br />Query is send';
    echo '<br />Result is true';
    $row = mysql_fetch_array($result);
    echo '<br />tryed fetching row';
    if ($row === FALSE) {
        echo '<br />$row is not false.';
        $name = $row['name'];
        echo '<br />$name now is "' . $name . '"';
    }
    else {
        echo( mysql_error());
    }

echo $name;
    ?>

This is the output:

Query is send Result is true tryed fetching rowNo such file or directory

UPDATE:

I have changed to msqli:

$q = "SELECT * FROM `Team` WHERE id =1";

$result = mysqli_query($q);

echo '<br />Query is send';
    echo '<br />Result is true';
    $row = mysqli_fetch_array($result);
    echo '<br />tryed fetching row';
    if ($row !== FALSE) {
        echo '<br />$row is not false.';
        $name = $row['name'];
        echo '<br />$name now is "' . $name . '"';
    }
    else {
        echo( mysqli_error());
    }

echo $name;

and now I'm getting this output:

Query is send Result is true tryed fetching row $row is not false. $name now is ""

mysql_* are deprecated functions and removed in php7 - use PDO or mysqli_* to replace — treyBake, Jun 29 '17 at 11:46
your if statement should be if ($row !== FALSE) { ... } else { echo mysql_error(); } — JYoThI, Jun 29 '17 at 11:50
inside the single quotes everything consider as string . you need to escape it properly . — JYoThI, Jun 29 '17 at 12:01
You need to read the documentation on the mysqli_ API. Your updated code is missing arguments for a few of those functions. — Funk Forty Niner, Jun 29 '17 at 12:03
change this line echo '
$name now is ' . $name; and let me know the answer @JordDuineveld — JYoThI, Jun 29 '17 at 12:05
@JordDuineveld Change `$row !== FALSE` to `$row != FALSE`. `!=` compares the parameters value while `!==` compares the type of the parameters. — lkdhruw, Jun 29 '17 at 12:07
@lkdhruw I've done this but now it's not outputting anything after the "tryed fetching row" — Jord Duineveld, Jun 29 '17 at 12:15
@JordDuineveld `mysqli_query` require one more parameter as `mixed mysqli_query ( mysqli $link , string $query [, int $resultmode = MYSQLI_STORE_RESULT ] )`. see the doc http://php.net/manual/en/mysqli.query.php — lkdhruw, Jun 29 '17 at 12:26
What version of php do you have? The mysql_* method is outdated, you should use mysql instead. — Planet, Jun 29 '17 at 11:49

score 0 · Answer 1 · answered Jun 30 '17 at 02:06

You need to fist establish a connection. For example: $connection = mysqli_connect($servername, $username, $password);.

See this link on how to use MySQLi: https://www.w3schools.com/PHP/php_mysql_connect.asp (but note that w3schools is a bad resource, with outdated information and bad practices - I'm only linking to it because this tutorial is basic and clear).

Be sure to check later, if you still haven't, on how to properly sanitize your queries. See this, for example: How can I prevent SQL injection in PHP?

score -3 · Answer 2 · answered Jun 29 '17 at 11:50

-3

Use function:

$result = mysqli_query($q);

mysql_query() have been deprecated in PHP7 onwards.

answered Jun 29 '17 at 11:50

yogikrathee

29
3

removed in php7* it was deprecated ages ago – treyBake Jun 29 '17 at 11:50

PHP MySQL 'No such file or directory'

2 Answers2