Advertisement
Guest User

PHP MySQL PDO: non-working zerofill columns

a guest
Jul 30th, 2014
813
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.04 KB | None | 0 0
  1. <?php
  2. require "Include/vars.php";
  3.  
  4. /**
  5.  * MysqlQuery Executes SQL query and returns PDO result object.
  6.  * @param $SqlQuery The SQL query to be executed.
  7.  * @return PDO result object on success, false on failure.
  8.  */
  9. function MysqlQuery($SqlQuery)
  10. {
  11.    global $MysqlPDO;
  12.    require "Include/vars.php";
  13.    
  14.    try
  15.    {
  16.       $SqlResult = $MysqlPDO->prepare($SqlQuery);
  17.       $SqlResult->execute();
  18.    }
  19.    catch(Exception $Exception)
  20.    {
  21.       $SQLError = $Exception->getMessage();
  22.       return false;
  23.    }
  24.    return $SqlResult;
  25. }
  26.  
  27. try
  28. {
  29.    $MysqlPDO = new PDO("mysql:host=localhost;dbname=$db_name",$db_username,$db_password);
  30.    $MysqlPDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  31.    $MysqlPDO->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
  32.    //$MysqlPDO->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
  33. }
  34. catch(Exception $Exception)
  35. {
  36.    $PDOError = $Exception->getMessage();
  37.    $ErrorString = "<b>A fatal MySQL error occured</b>.\n<br />Error: $PDOError";
  38.    die($ErrorString);
  39. }
  40.  
  41. $DropTableQuery = "DROP TABLE test";
  42. $DropTableResult = MysqlQuery($DropTableQuery);
  43.  
  44. $CreateTableQuery = "CREATE TABLE test (
  45.                    `Id` tinyint(4) unsigned zerofill NOT NULL,
  46.                    `UserName` varchar(4) NOT NULL,
  47.                    `TestDecimal` decimal(6,0) unsigned zerofill DEFAULT NULL,
  48.                    PRIMARY KEY (`Id`)
  49.                  ) ENGINE=InnoDB DEFAULT CHARSET=utf8";
  50. $CreateTableResult = MysqlQuery($CreateTableQuery);
  51.  
  52. $InsertQuery = "INSERT INTO test (Id,UserName,TestDecimal) VALUES(1,'alex',2)";
  53. $InsertResult = MysqlQuery($InsertQuery);
  54.  
  55. $SqlQuery = "SELECT Id,UserName,TestDecimal FROM test";
  56.  
  57.  
  58. $SqlResult = MysqlQuery($SqlQuery); //execute query using PDO
  59. echo "Result using PDO:";
  60. var_dump($SqlResult->fetch());
  61. $MysqlPDO = null; //disconnect
  62.  
  63. mysql_connect($db_server,$db_username,$db_password);
  64. mysql_select_db($db_name);
  65. $Sql_Result = mysql_query($SqlQuery);
  66. echo "Result using mysql_ functions:";
  67. var_dump(mysql_fetch_array($Sql_Result));
  68. mysql_close();
  69.  
  70. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement