PHP error in connect.php

Question

I am getting the below error. I have copy paste the code. I have very little knowledge of PHP please guide me.

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/test_bader/public_html/include/connect.php on line 66

<?php
$DBHOST = "localhost";
$DBUSER = "tese_test";
$DBPASS = "";
$DB     = "test_bader";
$default_dbname="test_bader";
*/
$DBHOST = "localhost";$
$Port= "3306";
$DBUSER = "test_test";
$DBPASS = "test@.";
$DB     = "test_bader";
$default_dbname="test_bader";


$con=mysql_connect($DBHOST,$DBUSER,$DBPASS) or die(mysql_error());
mysql_select_db($DB);

function db_connect()
{
    global $DBHOST, $DBUSER, $DBPASS, $default_dbname, $DB , $MYSQL_ERRNO, $MYSQL_ERROR;

    $link_id = mysql_connect("$DBHOST","$DBUSER","$DBPASS");
    if (!$link_id)
    {
        $MYSQL_ERRNO = 0;
        $MYSQL_ERROR = "Connection Fail to the host $DBHOST.";
    }
    else if(empty($DB ) && !mysql_select_db($default_dbname))
    {
        $MYSQL_ERRNO = mysql_errno();
        $MYSQL_ERROR = mysql_error();
        return 0;
    }
    else if(!empty($DB ) && !mysql_select_db($DB ))
    {
        $MYSQL_ERRNO = mysql_errno();
        $MYSQL_ERROR = mysql_error();
        return 0;
    }
    else return $link_id;
}




function sql_error()
{
    global $MYSQL_ERRNO, $MYSQL_ERROR;
    if(empty($MYSQL_ERROR))
    {
        $MYSQL_ERRNO = mysql_erron();
        $MYSQL_ERROR = mysql_error();
    }
    return "$MYSQL_ERRNO : $MYSQL_ERROR";
}

function q($st)
{
    $r=mysql_query($st);
    return $r;
}
function f($st)
{
    $r=mysql_fetch_array($st);
    return $r;
}

?>

we cannot see your code. Please edit your question accordingly. — shivam, Dec 09 '14 at 06:42
you first need to post your query, also post what you have tried so far. Your post is unclear, — Aditya, Dec 09 '14 at 06:42
possible duplicate of [mysql\_fetch\_array() expects parameter 1 to be resource (or mysqli\_result), boolean given](http://stackoverflow.com/questions/2973202/mysql-fetch-array-expects-parameter-1-to-be-resource-or-mysqli-result-boole) — Ben, Dec 09 '14 at 06:43
actually whatever you are passing into mysql_fetch_array() for 1 argument is a boolean you need to pass a resource not boolean value like this: $result = mysql_query("SELECT id, name FROM mytable"); $data = mysql_fetch_array($result, MYSQL_NUM); — Manoj Sharma, Dec 09 '14 at 06:43

score -1 · Answer 1 · answered Dec 09 '14 at 06:42

<?php
$DBHOST = "localhost";
$DBUSER = "tese_test";
$DBPASS = "";
$DB     = "test_bader";
$default_dbname="test_bader";
*/
$DBHOST = "localhost";$
$Port= "3306";
$DBUSER = "test_test";
$DBPASS = "test@.";
$DB     = "test_bader";
$default_dbname="test_bader";


$con=mysql_connect($DBHOST,$DBUSER,$DBPASS) or die(mysql_error());
mysql_select_db($DB);

function db_connect()
{
 global $DBHOST, $DBUSER, $DBPASS, $default_dbname, $DB , $MYSQL_ERRNO, $MYSQL_ERROR;
 
 $link_id = mysql_connect("$DBHOST","$DBUSER","$DBPASS");
 if (!$link_id)
 {
  $MYSQL_ERRNO = 0;
  $MYSQL_ERROR = "Connection Fail to the host $DBHOST.";
 }
 else if(empty($DB ) && !mysql_select_db($default_dbname))
 {
  $MYSQL_ERRNO = mysql_errno();
  $MYSQL_ERROR = mysql_error();
  return 0;
 }
 else if(!empty($DB ) && !mysql_select_db($DB ))
 {
  $MYSQL_ERRNO = mysql_errno();
  $MYSQL_ERROR = mysql_error();
  return 0;
 }
 else return $link_id;
}




function sql_error()
{
 global $MYSQL_ERRNO, $MYSQL_ERROR;
 if(empty($MYSQL_ERROR))
 {
  $MYSQL_ERRNO = mysql_erron();
  $MYSQL_ERROR = mysql_error();
 }
 return "$MYSQL_ERRNO : $MYSQL_ERROR";
}

function q($st)
{
 $r=mysql_query($st);
 return $r;
}
function f($st)
{
 $r=mysql_fetch_array($st);
 return $r;
}

?>

please delete this, as it is not an answer. I've added the code to your answer — baao, Dec 09 '14 at 06:44
baao you right as i am also not able to understand what he want explain. nothing is clear what he trying. Just delete it is confusing.... — Manoj Sharma, Dec 09 '14 at 06:47

PHP error in connect.php

1 Answers1