private function sanitize_input($astring)
 {
     $astring = trim($astring);
     $astring = stripslashes($astring);
     $astring = htmlspecialchars($astring);
     $astring = parent::getDbConnection()->real_escape_string($astring);
     return $astring;
 }
 public function multiFieldChangeToArrayAssociative($aQuery)
 {
     $tempKeys = array();
     $tempValue = array();
     $fetchFields = array();
     // run SQL query using database connection
     if ($result = parent::getDbConnection()->query($aQuery)) {
         $fetchFields = $result->fetch_fields();
         foreach ($fetchFields as $val) {
             $tempKeys[] = $val->name;
         }
         /*
         echo "<br />";
         print_r($tempKeys);
         echo "<br />Count Keys before flip: ".count($tempKeys);
         */
         // flip the values to keys
         $tempKeys = array_flip($tempKeys);
         // strip values
         $tempKeys = array_keys($tempKeys);
         // Returns true or false, true if there is a row
         // Creates a numeric array for each value that was fetched from database
         while ($row = $result->fetch_array(MYSQLI_NUM)) {
             // Iterate through array and place in temporary array.
             foreach ($row as $key => &$field) {
                 $tempValue[$key] = $field;
             }
         }
         /*
         echo "<br />";
         print_r($tempValue);
         echo "<br />Count values before flip: ".count($tempValue);
         */
         // strip keys
         $tempValue = array_values($tempValue);
         //echo count($tempValue);
         if (count($tempValue) == 0) {
             return array("REQUEST_TICKET_NUMBER" => '');
         }
         // strip keys
         $tempValue = array_values($tempValue);
         // Double the keys to make the same number of elements in each array on next combine.
         //$tempKeys = array_combine( $tempKeys, $tempKeys);
         // combine
         $tempValue = array_combine($tempKeys, $tempValue);
         /* free result set <-- memory*/
         $result->free();
         // return the array
         return $tempValue;
     } else {
         echo "No results from database, check your sql statement.";
     }
 }
Example #3
0
 public function updateFirstName($oldName, $newName)
 {
     $stmt = parent::getDbConnection()->prepare("UPDATE TB_TESTMATT SET FIRST_NAME = ? WHERE FIRST_NAME LIKE ? LIMIT 1");
     // added % to string for the wild card LIKE and sanitized the string
     $tempOne = $this->sanitizeStringForSQL('%' . $oldName . '%');
     $tempTwo = $this->sanitizeStringForSQL($newName);
     $stmt->bind_param('ss', $tempTwo, $tempOne);
     // Save to Database
     $stmt->execute();
 }
Example #4
0
 private static function setDbConnection($host, $user, $password, $database)
 {
     self::$DATABASE_CONNECTION = new mysqli($host, $user, $password, $database);
 }