Echo a mysql column by php as an array

Question

i want to fetch a mysql table named "my_table" column named "Email" contents as an array by php , so this is my code :

<?php
    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "my_table";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $result = mysql_query("SELECT * FROM my_table");

    if ($result === FALSE) {
        die(mysql_error()); // TODO: better error handling
    }

    $data = array();
    while ($row = mysql_fetch_array($result)) {
        $data[] = $row['Email'];
    }
    echo join($data, ',');
?>

but this code returns me this error : No database selected

but i've selected my table and database ...

and i know this code have some problems as mixing mysql and mysqli content but i dont know how to fix it i just want that array echo , if this code need to be fixed just guid me , how to solve this problem ? thanks in advance Thanks to @Martin my problem has solved i just changed the code by this way :

<?php
$servername = "localhost"; $username = "root"; $password = ""; $dbname = "my_db"; 
// Create connection
 $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection 
if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error);}
$result = mysqli_query($conn, "SELECT * FROM my_table");
if($result === FALSE) { 
die(mysql_error()); // TODO: better error handling
}


$data = array();
while ($row = mysqli_fetch_array($result))
{
$data[] = $row['Email'];
}
echo join($data, ',')
?>

And also you have to pass connection string through mysqli_query. — Web Artisan, Apr 20 '16 at 10:22
i want to change this codes tu my_sql i think this is better — Sajad Asadi, Apr 20 '16 at 10:26

score -2 · Answer 1 · edited Apr 20 '16 at 10:55

-2

You are conencting to a database here called "my_table":

$dbname = "my_table";

And then, in your SQL statement, you try connecting to a table called the same:

$result = mysql_query("SELECT * FROM my_table");

Are you sure this is the correct name for your database?

On PHPMyAdmin you can click "Databases" to view the Database names and then, when clicking on the db, it will give you a list of tables:

Image file of getting database views from tables in PHPMyAdmin

edited Apr 20 '16 at 10:55

Martin

22,212
11
70
132

answered Apr 20 '16 at 10:26

joshnik

438
1
5
15

i've changed my db name but it's still returns the same error :( – Sajad Asadi Apr 20 '16 at 10:35
Can you paste the error message? – joshnik Apr 20 '16 at 10:36
No database selected – Sajad Asadi Apr 20 '16 at 10:44
Try this, obviously ensuring the correct database name is in place: connect_error) { die("Connection failed: " . $conn->connect_error); } ?> – joshnik Apr 20 '16 at 10:47
still same error ... – Sajad Asadi Apr 20 '16 at 10:53
@SajadAsadi are you using MySQLi *and* MySQL? If you connect via MySQLi this will not be available to MySQL and vice versa. – Martin Apr 20 '16 at 10:56
Instead use this: `mysqli_query($conn, "SELECT * FROM my_table");` – Martin Apr 20 '16 at 10:57
WoW Thanks so much martin thanks <3 @Martin – Sajad Asadi Apr 20 '16 at 10:59
@SajadAsadi all you need is to do this sort of update to all of your MySQL_ function references to use the newer MySQLi references, although you should be using OOP approach but that requires more in depth rewriting. Glad to help :) – Martin Apr 20 '16 at 11:02

Echo a mysql column by php as an array

1 Answers1