Print output in php using Sql queries

Question

I am working on PHP where i want to fetch the count of a particular column 'uid' from users table. The output window is not displaying anything. following is the code. Can anybody, help me in rectifying this code.

    <?php
    $link = mysql_connect('localhost', 'username', 'password');
    if (!$link) {
        die('Could not connect: ' . mysql_error());
    }
    mysql_select_db("rth_db");
    $data = mysql_query("SELECT COUNT(uid) AS Total FROM users", $link);
    $number = mysql_fetch_array($data);
    echo $number;
    echo 'Connected successfully';
    mysql_close($link);
    ?>

Tikkes · Accepted Answer · 2013-04-04 07:54:07Z

4

you should address your data differently

echo $number["Total"];

Also, mysql is deprecated, have a look at PDO. This also is better for security and so on. You can check the PHP.NET page for more info on this

answered Apr 4, 2013 at 7:54

Tikkes

4,6874 gold badges38 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yogesh Suthar · Accepted Answer · 2013-04-04 07:55:17Z

1

change this

echo $number;

to

print_r($number);

OR

echo $number['Total'];

Because $number is array not string.

answered Apr 4, 2013 at 7:55

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

1 Comment

Yogesh Suthar Over a year ago

@Tikkes We can use in this way also...:)

user1533868 · Accepted Answer · 2013-04-04 07:56:58Z

try using this :

<?php
    $link = mysql_connect('localhost', 'username', 'password');
    if (!$link) {
        die('Could not connect: ' . mysql_error());
    }
    mysql_select_db("rth_db");
    $data = mysql_query("SELECT COUNT(uid) AS Total FROM users", $link);
    $number = mysql_fetch_array($data);
    echo $number['total'];
    echo 'Connected successfully';
    mysql_close($link);
    ?>

i have just edited one line if u notice...hope this works :)

M.I.T. · Accepted Answer · 2013-04-04 08:28:30Z

0

u can also use

var_dump($number);

answered Apr 4, 2013 at 8:28

M.I.T.

1,0422 gold badges17 silver badges34 bronze badges

Collectives™ on Stack Overflow

Print output in php using Sql queries

4 Answers 4

Comments

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Related