[MySQL][PHP] Universal Select / Update

[xenogfx]

Want to select and update any one column and any one table? Well here is how you do it

<?php
 
/**
* @Author Deformed aka XenoGFX
* @Copyright 2012
* @Description Simple server UPDATE and SELECT query functions..
*/
 
 
// Update Query
function mSU($table,$column,$value,$condition,$limit)
{
    mysql_query("UPDATE $table SET $column = '$value' WHERE $condition LIMIT $limit;");
}
 
// Select Query
function mSS($table,$select,$condition,$limit)
{
    return mysql_query("SELECT $select FROM $table WHERE $condition LIMIT $limit;");
}
 
// Update Query
mSU("users","online","0","username = 'howdy'","1");
 
// Select Query
mSS("users","id","username LIKE '%boobface%'","5");
 
?>

 

[Markshall]

Nice code but I prefer to use classes/objects when using MySQL now.

Also, you don't need that ';' after $limit.

 

[Xenous]

Nice code but I prefer to use classes/objects when using MySQL now.

Also, you don't need that ';' after $limit.

Im pretty sure this was coded for easy implementation into classes

 

[Markshall]

Im pretty sure this was coded for easy implementation into classes

Sure it could be, so you may as well have just coded an MySQL class and release that instead.

 

[Xenous]

Sure it could be, so you may as well have just coded an MySQL class and release that instead.

But we still want people to learn don't we?

 

[xenogfx]

Nice code but I prefer to use classes/objects when using MySQL now.

Also, you don't need that ';' after $limit.

the ; makes it so if you have multiple queries running at the same time they dont fuck up.

 

[RastaLulz]

the ; makes it so if you have multiple queries running at the same time they dont fuck up.

MySQL doesn't allow multiple queries?

 

[brsy]

Looks nice, but I prefer using classes sorry. I suggest making a TUT explaining what classes are for the MySQL/MySQLi newbies.

 

[xenogfx]

mysql_query ("SELECT $select FROM $table WHERE $condition LIMIT $limit; SELECT $select FROM $table WHERE $condition LIMIT $limit;");

^ what is that rasta..

Looks nice, but I prefer using classes sorry. I suggest making a TUT explaining what classes are for the MySQL/MySQLi newbies.

We know how it can be inserted into a class >_>

class Name {
myfunction //
myfunction //
}

how hard is it..

 

[Xenous]

For those of you who wanted it in a class for mysql,

class.mysql.php :

class xSQL {
         
                # Initial Connection to MySQL will be done through global.php for dynamic reasons. #
 
    public function __construct($host, $username, $password, $db) {
     
        $xCon = mysql_connect($host, $username, $password) or die('MySQL Error - Could not connect to mysql');
        mysql_select_db($db, $xCon) or die('MySQL Error - Could not locate database');
  }
    function mSU($table,$column,$value,$condition,$limit)
  {
    mysql_query("UPDATE $table SET $column = '$value' WHERE $condition LIMIT $limit;");
  }
 
// Select Query
    function mSS($table,$select,$condition,$limit)
  {
    return mysql_query("SELECT $select FROM $table WHERE $condition LIMIT $limit;");
  }
}

global.php :

require_once "inc/class.mysql.php";
 
    # Defining the classes. #
 
$db = new xSQL('localhost', 'root', 'password', 'database');
 
    # And xeno's example # 
$db->mSU("users","online","0","username = 'howdy'","1");
 
// Select Query
$db->mSS("users","id","username LIKE '%boobface%'","5");

Done in rough so don't flame if its wrong