resource in mysql_connect in php

Question

I am trying to connect to database through php.I did it lots of time. But I want to know how many rows exist in my table. I've tried to use php manual, however, I was confused.

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

The above code worked on :

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

But when I decided to use

$link = mysql_connect("localhost", "mysql_user", "mysql_password","database");

It occurred an error like this:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in ...

What is difference between codes? And how can I solve it? Thanks in advance

use mysqli instead of mysql, and u can not pass database in mysql_connect statement `mysql_connect("localhost", "mysql_user", "mysql_password","database");`.. — Suhel Meman, Apr 02 '13 at 06:47

score 2 · Answer 1 · answered Apr 02 '13 at 06:47

2

The 4th parameter to mysql_connect is supposed to be a boolean type indicating whether you always want a new connection (even if mysql_connect was called earlier), not a string. As a result, $link is false because mysql_connect failed.

PHP documentation on mysql_connect

answered Apr 02 '13 at 06:47

Tushar

8,019
31
38

and the 4th parameter is not supposed to be the database name – Ander2 Apr 02 '13 at 06:48

score 0 · Answer 2 · answered Apr 02 '13 at 06:48

0

selecting DB as 4th parameter in mysql_connect is wrong - the functions returns false and no mysql_num_rows() following is possible

answered Apr 02 '13 at 06:48

Ilya

169
6

score 0 · Answer 3 · answered Apr 02 '13 at 06:50

0

The mysql_connect function accept 5 arguments. In that in 4th argument this should be either true or false. But you have passed the string. This is not correct. you cann't pass the database name here.

For more tutorial see here and also this link.

answered Apr 02 '13 at 06:50

Code Lღver

15,573
16
56
75

score 0 · Answer 4 · edited Apr 02 '13 at 07:00

0

You can not select database by mysql_connect() function. This function is used to connect to the database, not to query the database. To query the database use mysql_select() instead.

edited Apr 02 '13 at 07:00

YasirA

9,531
2
40
61

answered Apr 02 '13 at 06:52

Sandeep Kapil

984
8
14

score -1 · Answer 5 · edited Nov 21 '13 at 13:44

-1

this parameters are allowed in mysql_connect

mysql_connect(server,user,pwd,newlink,clientflag)

please check http://www.w3schools.com/php/func_mysql_connect.asp

edited Nov 21 '13 at 13:44

Nunser

4,512
8
25
37

answered Nov 21 '13 at 12:56

kapil_dev

86
4

resource in mysql_connect in php

5 Answers5