<?php
/**
* Name:sql operation package, expandable.
* User: Zhang Yunshan
* DATE:2016/9/4
* TIME:22:02
*/
PHP File Encoding settings
Header (' content-type:text/html; Charset=utf-8 ');
Database classes
Class Sqled {
Public Function Addtabase ($sql _url, $sql _name, $sql _pss, $sql _db) {//CREATE Database
$conn = new Mysqli ($sql _url, $sql _name, $sql _PSS);
if (! $conn) {
echo "Connection failed <br>";
};
$sql = "CREATE DATABASE". $sql _db;
if ($conn->query ($sql) = = TRUE) {
return true;
}else{
echo $conn->error. " <br> ";
};
$conn-Close ();
}
Example (CREATE DATABASE) ************///addtabase ($sql _url, $sql _name, $sql _pss, $sql _db);
///*************************************************************************///
Public Function addtable ($sql _url, $sql _name, $sql _pss, $sql _db, $data) {//Create tables and fields
$conn = new Mysqli ($sql _url, $sql _name, $sql _pss, $sql _db);
detecting connections
if (! $conn) {
echo "Connection Failed";
};
$sql = "CREATE TABLE {$data [' name ']} (
ID INT (6) UNSIGNED auto_increment PRIMARY KEY,
{$data [' Data ']}
)";
/*
ID INT (6) UNSIGNED auto_increment PRIMARY KEY,
FirstName VARCHAR (+) not NULL,
LastName VARCHAR (+) not NULL,
Email VARCHAR (50),
Reg_date TIMESTAMP
*/
if ($conn->query ($sql) = = TRUE) {
return true;
}else{
echo $conn->error. " <br> ";
};
$conn-Close ();
}
Example (Create table and field) ************///addtable ($sql _url, $sql _name, $sql _pss, $sql _db,array ("name" = "Ceshi_biao", "Data" = > "
Test VARCHAR (+) not NULL
// "));
//***************************************************************************************///
Public Function Adddb ($sql _url, $sql _name, $sql _pss, $sql _db, $data) {//Add field data
$conn = new Mysqli ($sql _url, $sql _name, $sql _pss, $sql _db);
if (! $conn) {
echo "Connection Failed";
};
$sql = "INSERT into {$data [' name ']} (
{$data ["Key"]}
)
VALUES (
{$data [' value ']}
)";
if ($conn->query ($sql) = = TRUE) {
return true;
}else{
echo $conn->error;
};
$conn-Close ();
}
Example (add field data) ************///adddb ($sql _url, $sql _name, $sql _pss, $sql _db,array (
"Name" = "Ceshi_biao",
"Key" = "Zanindex",
"Value" = "0",
//));
///***********************************************************************************///
Public Function Querydb ($sql _url, $sql _name, $sql _pss, $sql _db, $data) {//Read data
Create a connection
$conn = new Mysqli ($sql _url, $sql _name, $sql _pss, $sql _db);
detecting connections
if ($conn->connect_error) {
Die ("Connection failed:". $conn->connect_error);
};
$sql = "SELECT {$data [' Data ']} from {$data [' name ']}";
$result = $conn->query ($sql);
if ($result->num_rows > 0) {
Output per row of data
$data _data = Explode (",", $data [' data ']);
$key = ' {';
$fh = ', ';
for ($i = 0; $i < count ($data _data); $i + +) {
if ($i = = count ($data _data)-1) {
$fh = ";
};
$key = $key. ' ". $data _data[$i]. ' ":" $row [\ '. $data _data[$i]. ' \ '] "'. $fh;
};
$key = $key. '} ';
$returnData = Array ();
while ($row = $result->fetch_assoc ()) {
$key 1 = Json_decode ($key, true);
foreach ($key 1 as $keyName = = $value) {
$value = "{". $value. "}";
Eval ("\ $value = \" $value \ ";");
$key 1[$keyName] = $value;
};
Array_push ($returnData, $key 1);
};
echo $returnData;//execute callback and return query result
} else {
echo "0 results";
};
return $returnData;
$conn->close ();
}
Example (data read or data query) ************///querydb ($sql _url, $sql _name, $sql _pss, $sql _db,array (
"Name" = "Ceshi_biao",
"Data" = "Id,zanindex",
// ));
//******************************************************************///
Public Function UpdateDB ($sql _url, $sql _name, $sql _pss, $sql _db, $data) {//Data update
$con =mysqli_connect ($sql _url, $sql _name, $sql _pss, $sql _db);
detecting connections
if (Mysqli_connect_errno ())
{
echo "Connection failed:". Mysqli_connect_error ();
};
$sqlUpdate _set = null;
$sqlUpdate _where = null;
Unconditional settings, all updates
$index = 0;
$fh = ",";
foreach ($data [' NewData '] as $key = + $value) {
$index + = 1;
if ($index = = count ($data [' NewData '])) {
$FH = null;
};
$sqlUpdate _set = $sqlUpdate _set. $key. " = ' ". $value." ". $FH;
};
Conditional limit S
if (count ($data ["Data"]) > 0) {
$sqlUpdate _where = "WHERE";
$FH 1 = "and";
$index 1 = 0;
foreach ($data ["Data"] as $key = + $value) {
$index 1 + = 1;
if ($index 1 = = count ($data [' data ']) {
$FH 1 = null;
};
$sqlUpdate _where = $sqlUpdate _where. " ". $key." = ' ". $value." ". $FH 1;
};
};
Conditional Limit E
Mysqli_query ($con, "UPDATE {$data [' name ']} SET". $sqlUpdate _set. $sqlUpdate _where);
Mysqli_close ($con);
return true;
}
Example (data Update) ************///updatedb ($sql _url, $sql _name, $sql _pss, $sql _db,array (
"Name" = "Ceshi_biao",
"NewData" = = Array (
"Zanindex" and "tofu is sent to bean curd",
"id" = "1",
// ),
"Data" = Array ()//condition
// ));
//*****************************************************************///
Public Function Deletedb ($sql _url, $sql _name, $sql _pss, $sql _db, $data) {//Data delete
$con =mysqli_connect ($sql _url, $sql _name, $sql _pss, $sql _db);
detecting connections
if (Mysqli_connect_errno ())
{
echo "Connection failed:". Mysqli_connect_error ();
};
$result = Mysqli_query ($con, "DELETE from {$data [' name ']} WHERE {$data [' Data ']}");
echo $result;
Mysqli_close ($con);
return true;
}
Example (data deletion) ************///deletedb ($sql _url, $sql _name, $sql _pss, $sql _db,array (
"Name" = "Ceshi_biao",
// ));
//*********************************************************************************//
Data Initial value Assignment
Public function AaB ($a, $b) {
if ($a) {
$a = $a;
}else{
$a = $b;
};
return $a;
}
//*********************************************************************************//
Database operation type
public static $sql _type = Array (
"Addtabase" = "addtabase",//CREATE Database
"AddTable" = "addtable",//Create tables and fields
"Adddb" = "adddb",//Add field data
"Querydb" = "querydb",//Read data
"UpdateDB" = "updatedb",//Data update
"Deletedb" = "deletedb"//Data deletion
);
//*********************************************************************************//
SQL Synthetic call method;
Public function fn ($sql) {
$sql [' type '] = $this->aab ($sql [' Type '],sqled:: $sql _type[' querydb ']);//default database operation set to (data query)
$sql [' url '] = $this->aab ($sql [' url '], "127.0.0.1");
$sql [' name '] = $this->aab ($sql [' name '], "root");
$sql [' pss '] = $this->aab ($sql [' PSS '], "admin");
$sql [' db '] = $this->aab ($sql [' DB '], "");
$sql [' table '] = $this->aab ($sql [' table '], "");
$sql [' array '] = $this->aab ($sql [' array '],array ());
Switch ($sql [' type ']) {
Case "addtabase";//CREATE Database
return $this->addtabase ($sql [' url '], $sql [' name '], $sql [' PSS '], $sql [' db ']);
Break
Case "addtable";//CREATE TABLE and field
return $this->addtable ($sql [' url '], $sql [' name '], $sql [' PSS '], $sql [' db '], $sql [' array ']);
Break
Case "ADDDB";//Add field data
return $this->adddb ($sql [' url '], $sql [' name '], $sql [' PSS '], $sql [' db '], $sql [' array ']);
Break
Case "querydb";//Read data
return $this->querydb ($sql [' url '], $sql [' name '], $sql [' PSS '], $sql [' db '], $sql [' array ']);
Break
Case "updatedb";//Data update
return $this->updatedb ($sql [' url '], $sql [' name '], $sql [' PSS '], $sql [' db '], $sql [' array ']);
Break
Case "deletedb";//Data deletion
return $this->deletedb ($sql [' url '], $sql [' name '], $sql [' PSS '], $sql [' db '], $sql [' array ']);
Break
}
}
Example (SQL action) *****************///
$sql = new sqled ();
$q = $sql->fn (Array (
"DB" =>sql_db,
' Type ' =>sqled:: $sql _type[' Deletedb '],
"Array" =>array (
"Name" = "User",
"Data" = "id",
"NewData" =>array (
"id" = "5",
"User" = "new-d"
// )
// )
//));
///******************************************************************************//
};
MySQL Database encapsulation