PHP - Mysql_query Help

I am getting a "mysqli_query() expects parameter 1 to be mysqli, null given" error.

the code I am using is below but simplified. connect() does connect to the database without throwing any errors but when I get down to query() I get the above error.

public function connect() {
  mysqli_connect(self::DBHOST, self::DBUSER, self::DBPASS, self::DBNAME);
}
public function query($query) {
                 mysqli_query(self::connect(), $query);
}


below is what I am using to call the function. I am not sure if I have to pass the $link in the query function too. I have tried but it didn't seem to do any better.

$link = db::connect();

$query = "SELECT name FROM plugins";

db::query($query);


I am sure this is something simple that I have overlooked but I am new to this and still learning.

Thank you for any help you can provide.

Hi, why won't this work, there is no error messages so it gets to this point, but won't redirect???
(Obviously a lot is missed out here)

$query = mysql_query("SELECT * FROM `users` WHERE `username`='$username'");
if ($username==$dbusername&&$password==$dbpassword)
{ 
$_SESSION['user'] = $username;

while($row = mysql_fetch_array($query)){ 
$type = $row['Type'];
if ($type=="0") {
header("Location: chefpanel.php");
}else{
header("Location: restpanel.php");
}
}  

}
else
 $errors[] = 'Password Incorrect';
}
else
 $errors[] = 'Username Incorrect';

OK So I have a quick question... how would I go about making a query like:
mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password' AND key='$key' ");
You see, theres an error:
Quote

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' key='1234' LIMIT 1' at line 1


I know this is a simple issue, and I know you cant keep creating AND's inside the query, but how would I do it? I've never attempted to use more than one AND before, so its new to me even though I'm a experienced PHP Developer. Thanks in advance!

Hey guys, I've been playing around with this open source php game, I'm having problems with the registration system. For some reason the script is echoing back that there is no password in the password fields. When in fact there is:

Add_player.php:
Code: [Select]
<?php

session_start();
session_register("pid");
include("common.inc");
include("date.inc");
include("header.inc");
dbConnect();
$res = mysql_query("select id from $dbName.pdm_players where name=\"$name\"") or die(mysql_error());

if ($name == "" || $password1 == "")
{
        echo "<center><div class=\"sheader\">Oh dear me!</div>
         You have to actually enter a name and password!";
        $name = "";
        include("character_form.inc");
        echo "</center>";
        include("footer.inc");
        return 0;
}
if ($name == $password1)
{
echo "<center><div class=\"sheader\">Oh dear me!</div>
You can't make the password the same as the name.  
People will guess your password!";
include("character_form.inc");
        echo "</center>";
        include("footer.inc");
        return 0;
}
if (strlen($password1) < 6)
{
 echo "<center><div class=\"sheader\">Oh dear me!</div>
Passwords must be at least 6 characters, otherwise they are easy to guess!";
include("character_form.inc");
        echo "</center>";
        include("footer.inc");
        return 0;
}

if (mysql_fetch_row($res))
{
        echo "<center><div class=\"sheader\">Oh dear me!</div>
         Player $name already exists, try a different name.";
        $name = "";
        include("character_form.inc");
        echo "</center>";
        include("footer.inc");
        return 0;
}
if ($password1 != $password2)
{
        echo "<center><div class=\"sheader\">Oh dear me!</div>";
        echo "The two passwords didn't match - type carefully now!.";
        include("character_form.inc");
        echo "</center>";
        include("footer.inc");
        return 0;
}
echo "<div class=\"sheader\">Registration for $name successful</div>";
$cp = crypt($password1);
$dateArray = getdate(time());
$likeNowScoob = $dateArray["year"] . "-" . $dateArray["mon"] . "-" . $dateArray["mday"];
if ($character < 1 || $character > 9) { die("you are an idiot"); }
pdm_characters();
$res =  mysql_query("select type from  $dbName.pdm_characters where cid = $character")  or die(mysql_error());
$t =  mysql_fetch_row($res);
pdm_stuff();
$specRes =  mysql_query("select sid from $dbName.pdm_stuff where sid >= 28 and sid <= 33 and type like \"%$t[0]%\"") or die(mysql_error());


$res =  mysql_query("BEGIN")  or die(mysql_error());
$res =  mysql_query("insert into $dbName.pdm_players (name, used, dob, cpass, char_id, roundswon, evo, aWeapon, dWeapon) VALUES (\"$name\", 1, \"$likeNowScoob\",  \"$cp\",  $character, 0,0,0,0)") or die(mysql_error());
$res =  mysql_query("select id from $dbName.pdm_players where name=\"$name\" for update") or die(mysql_error());
$row = mysql_fetch_row($res);
$pid = $row[0];
$res = mysql_query("insert into $dbName.pdm_league (id, highest, days_no_1, yesterday, longPoints) VALUES ($pid, 16777215, 0, 16777215, 0)") or die(mysql_error());
$res =  mysql_query("insert into $dbName.pdm_stats (id, level, attack, defence, health, speed, exp, ko, healthpercent, fights) VALUES ($pid, 1, 100, 100, 100, 100, 0, 0, 10, 0)") or die(mysql_error());
$res =  mysql_query("insert into $dbName.pdm_clanmembers2 (id, clanTag, applyTag, utype) VALUES ($pid, NULL, NULL, '')")  or die(mysql_error());
$res =  mysql_query("insert into $dbName.pdm_money (id, bank, wallet, bankdate) VALUES ($pid, 0,0, '0000-00-00')")  or die(mysql_error());
while ($row = mysql_fetch_row($specRes))
{
$res =  mysql_query("insert into $dbName.pdm_specials (id, sid, qty, switch) values ($pid, $row[0], 0, 1)")  or die(mysql_error());
}
$res =  mysql_query("COMMIT") or die(mysql_error());


session_register("playerName");
$playerName = stripper($name);

echo "<P><diV>Welcome  $playerName, click the Fight link down the left to fight your first opponent.</div>";
include("main_screen.inc");
include("footer.inc");
?>

Character_form.inc:

Code: [Select]
<center>
<form method="post" action="add_player.php">
<P>
<table cellpadding="0" cellspacing="0"><tr><td align="center">
<?php
dbConnect();
pdm_characters();#check HEAP table exists
$res = mysql_query("select cid, name, type from $dbName.pdm_characters order by type") or die(mysql_error());
$marker = "X";
$firstOne = 1;
$cTypes["A"] = "Alien";
$cTypes["M"] = "Magic";
$cTypes["S"] = "Spirit";
while ($row = mysql_fetch_row($res))
{
        if ($marker != $row[2]) #new type (alien/magic etc)
        {
                if ($marker != "X")
                {
                        echo "</table>\n";
                }
                $cn = $cTypes[$row[2]];
                echo "\n<table cellpadding=\"0\" cellspacing=\"0\" border=1>
                <tr><td colspan=\"3\" align=\"center\"><div class=\"sheader\"> $cn characters</div></td></tr><tr bgcolor=\"#efefef\">";
                $marker = $row[2];
        }
        echo "\n<td><table><tr><td align=center>$row[1]</td></tr><tr><td align=center>
        <img alt=\"Pick me!\" src=\"images/$row[0]0.gif\"></td></tr><tr>
        <td align=center><input type=\"radio\" name=\"character\" value=\"$row[0]\"";
        if ($firstOne and $character == "")
        {
                $firstOne = 0;
                echo " CHECKED ";
        }
        if ($character == $row[0])
        {
                echo " CHECKED ";
        }
        echo "></td></tr></table></td>";
}
echo "</tr></table>
<table width=\"551\" cellpadding=0 cellspacing=0><tr><td colspan=\"3\"><div class=\"sheader\">character details</div></td></tr>
<tr><td align=\"center\">Name<br><input size=20 maxlength=20 type=text name=\"name\" value = \"$name\"></td>";
?>
<td align="center">Password<br><input type="password" name="password1"  size=20 maxlength=20></td>
<td align="center">Password again<br><input type="password" name="password2" size=20 maxlength=20></td></tr>
<tr><td colspan="3" align="center"><input type="submit" value="Register my character"></td></tr></table>
</td></tr></table>
<hr>
</form>
</centER>

Anyone able to offer up any advice or where its going wrong, If I remove the validation stuff, it still doesn't insert the user into the database.

Cheers

I'm hoping someone can help me cos my hair's going white with this one. I'm trying to put together a script that acts as web-based interface to an SQL server. There are actually two parts, admin.htm and admin.php. The first part is just a form that passes login credentials to the PHP file. That part seems to work fine, but I'll post the source anyway: -

Code: [Select]
<!DOCTYPE HTML>

<html lang="en">

<head>

<title>SQL admin login</title>

<meta charset="iso-8859-1" />

</head>

<body>

<form action="admin.php" method="post">
<label for="username">Username: -</label>
<br />
<input type="text" name="username" id="username" />
<br />
<br />
<label for="password">Password: -</label>
<br />
<input type="password" name="password" id="password" />
<br />
<br />
<label for="server">Server: -</label>
<br />
<input type="text" name="server" id="server" />
<br />
<br />
<label for="database">Database: -</label>
<br />
<input type="text" name="database" id="database" />
<br />
<br />
<input type="submit" value="Login" />
<input type="reset" value="Reset" />
</form>

</body>

</html>

Following is the content of admin.php. By this point I can see the connection in MySQL Workbench, and when I submit the query 'SELECT * FROM subscribers' it's being stored in '$_POST['query']', but 'mysql_query($_POST['query'],$_SESSION['con']);' is returning nothing. There is definitely a record in that table, and the user I'm logging on with has permission to run the 'SELECT' command against this database, so I can't figure out why mysql_query(); is returning nothing: -

Code: [Select]
<!DOCTYPE HTML>

<?php

session_start();

if(!$_SESSION['con'])
{
   if(!($_POST['username'] || $_POST['password']))
   {
      if(!($_SESSION['username'] || $_SESSION['password']))
      {
      $error="Username and password variables empty.";
      }
   }
   else
   {
      $_SESSION['username']=mysql_real_escape_string($_POST['username']);
      $_SESSION['password']=mysql_real_escape_string($_POST['password']);
      $_SESSION['server']=mysql_real_escape_string($_POST['server']);
      $_SESSION['database']=mysql_real_escape_string($_POST['database']);
      $_SESSION['con']=mysql_pconnect($_SESSION['server'],$_SESSION['username'],$_SESSION['password']);
      if(!$_SESSION['con'])
      {
         $error="Failed to connect to server.";
      }
      else
      {
         $database=mysql_select_db($_SESSION['database'],$_SESSION['con']);
         if(!$database)
         {
            $error="Failed to connect to database.";
         }
      }
   }
}

if(!$_POST['query'])
{
   $error="No query submitted.";
}
else
{
   $result=mysql_query($_POST['query'],$_SESSION['con']);
   if(!$result)
   {
      $error="Query returned nothing.";
   }
}

?>

<html lang="en">

<head>

<title>SQL admin interface</title>

<meta charset="iso-8859-1" />

</head>

<body>

<form action="admin.php" method="post">
<textarea name="query" rows="10" cols="50">SELECT * FROM subscribers</textarea>
<br />
<br />
<input type="submit" value="Submit query" />
</form>

<?php

if($error)
{
   echo $_POST['query']."<br /><br />".$result."<br /><br />".$error;
   die();
}
else
{
   while($row=mysql_fetch_assoc($result))
      {
         echo $row['name']." ".$row['email'];
         echo "<br />";
      }
}

?>

</body>

</html>

Can anyone help?

MOD EDIT: [code] . . . [/code] tags added.