g: mysql_query(): supplied argument is not a valid MySQL-Link resource

Question

Here is my connect.php

    class DB_class {
    protected function dblogin() {
    if(!defined('DB_CONNECTED')) {

      $DB = 'mydb';
        $USER='myuser';
        $PASS='mypass';

      $HOST='localhost';
      //$link = @mysql_pconnect($HOST,$USER,$PASS) or die("DB connect error");
        $link=@mysql_connect($HOST,$USER,$PASS) or die("DB connect error");
        mysql_select_db($DB, $link);
        mysql_query("SET NAMES 'utf8'");
        return $link;
        }
    }
    function dbclose() {
        mysql_close();
    }

    function dbfree($result) {
        mysql_free_result($result);
    }
}

and here is my insert.php code

require('connect.php');
$name = $_POST['FIRSTNAME'];
$name2 = $_POST['SURNAME'];
$email = $_POST['EMAIL'];
$phone = $_POST['PHONE'];
$mailing_list = $_POST['MAILING_LIST'];
$enquiryMessage = $_POST['MESSAGE'];

$DB = new DB_class();
$link = $DB->dblogin();


$sql = "INSERT INTO user (DATE_REG, FIRSTNAME, SURNAME, NICK, EMAIL, ACCESS,user.GROUP  ,MAILING_LIST)
VALUES ('".date('Y-m-d H:i:s')."', '$name', '$name2', '$email', '$email', 0, 4, '$mailing_list')";

// $query  = mysql_query($conn, $sql, MYSQLI_USE_RESULT);

var_dump(mysql_query($sql,$link));

I'm getting error "g: mysql_query(): supplied argument is not a valid MySQL-Link resource". Thanks for help in advance.

Nineoclick · Answer 1 · 2015-09-23T08:11:58.050

First of all, you're using an extension that is deprecated from php 5.5.0.

The correct way to create a connection is by using MySQLi

An example above all:

<?php
$mysqli_port = ini_get("mysqli.default_port");
$mysqli_socket = ini_get("mysqli.default_socket");

$dbConn = new mysqli($dbHost, $dbUser, $dbPwd, $dbName, $mysqli_port, $mysqli_socket);

if(mysqli_connect_error())
{
    die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());
}

Anyway, the method dblogin you declared in your class has not to be declared as protected, because it returns a fatal error. Remove protected from within you function declaration to make it work.

g: mysql_query(): supplied argument is not a valid MySQL-Link resource

1 Answers1