Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require "Include/vars.php";
- /**
- * MysqlQuery Executes SQL query and returns PDO result object.
- * @param $SqlQuery The SQL query to be executed.
- * @return PDO result object on success, false on failure.
- */
- function MysqlQuery($SqlQuery)
- {
- global $MysqlPDO;
- require "Include/vars.php";
- try
- {
- $SqlResult = $MysqlPDO->prepare($SqlQuery);
- $SqlResult->execute();
- }
- catch(Exception $Exception)
- {
- $SQLError = $Exception->getMessage();
- return false;
- }
- return $SqlResult;
- }
- try
- {
- $MysqlPDO = new PDO("mysql:host=localhost;dbname=$db_name",$db_username,$db_password);
- $MysqlPDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $MysqlPDO->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
- //$MysqlPDO->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
- }
- catch(Exception $Exception)
- {
- $PDOError = $Exception->getMessage();
- $ErrorString = "<b>A fatal MySQL error occured</b>.\n<br />Error: $PDOError";
- die($ErrorString);
- }
- $DropTableQuery = "DROP TABLE test";
- $DropTableResult = MysqlQuery($DropTableQuery);
- $CreateTableQuery = "CREATE TABLE test (
- `Id` tinyint(4) unsigned zerofill NOT NULL,
- `UserName` varchar(4) NOT NULL,
- `TestDecimal` decimal(6,0) unsigned zerofill DEFAULT NULL,
- PRIMARY KEY (`Id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8";
- $CreateTableResult = MysqlQuery($CreateTableQuery);
- $InsertQuery = "INSERT INTO test (Id,UserName,TestDecimal) VALUES(1,'alex',2)";
- $InsertResult = MysqlQuery($InsertQuery);
- $SqlQuery = "SELECT Id,UserName,TestDecimal FROM test";
- $SqlResult = MysqlQuery($SqlQuery); //execute query using PDO
- echo "Result using PDO:";
- var_dump($SqlResult->fetch());
- $MysqlPDO = null; //disconnect
- mysql_connect($db_server,$db_username,$db_password);
- mysql_select_db($db_name);
- $Sql_Result = mysql_query($SqlQuery);
- echo "Result using mysql_ functions:";
- var_dump(mysql_fetch_array($Sql_Result));
- mysql_close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement