PHP MYSQL::query Examples

Programming Language: PHP

Class/Type: MYSQL

Method/Function: query

Examples at hotexamples.com: 5

1) Example using MySQLi package:

Description: The following code snippet connects to a MySQL database using MySQLi package and executes a SELECT query to retrieve all rows from a `users` table.

$con = mysqli_connect("localhost", "username", "password", "database_name");

if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  exit();
}

$query = "SELECT * FROM users";
$result = mysqli_query($con, $query);

if (!$result) {
  die('Error: ' . mysqli_error($con));
}

while($row = mysqli_fetch_array($result)) {
  echo $row['username'] . '
';
}

mysqli_close($con);

2) Example using PDO package:

Description: The following code snippet connects to a MySQL database using PDO package and executes a INSERT query to insert a new row into a `users` table.

$dbhost = 'localhost';
$dbname = 'database_name';
$dbuser = 'username';
$dbpass = 'password';

try {
  $conn = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
  
  $stmt = $conn->prepare("INSERT INTO users (username, email, password) VALUES (:username, :email, :password)");
  
  $stmt->bindParam(':username', $username);
  $stmt->bindParam(':email', $email);
  $stmt->bindParam(':password', $password);
  
  $username = 'john';
  $email = 'john@example.com';
  $password = 'password123';
  
  $stmt->execute();
  
  echo "New record created successfully";
} catch(PDOException $e) {
  echo "Error: " . $e->getMessage();
}

$conn = null;

Both examples are using PHP to connect to a MySQL database and retrieve or insert data using different packages/libraries: MySQLi and PDO.

PHP MYSQL::query - 5 examples found. These are the top rated real world PHP examples of MYSQL::query extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

QUERY(30)

SqlSelect(19)

query(5)

SqlInsert(5)

dbResult(4)

SqlDelete(3)

SqlUpdate(3)

connect(3)

basedatos(2)

mysqlSelectQuery(2)

conecta(2)

mysqlSelect(1)

mysqlUpdateQuery(1)

BuildSQLWhereClause(1)

mysqlInsert(1)

select(1)

selectdb(1)

mysqlInsertQuery(1)

db_result(1)

mysqlDeleteQuery(1)

listtables(1)

listdbs(1)

insert(1)

delete(1)

CreateSelectSQL(1)

db_query_range(1)

SQLValue(1)

MysqlSelectDb(1)

update(1)

Example #1

Show file

File: DBProcess.php Project: esironal/crossui

 public function stimulate(&$hash)
 {
     $db = new MYSQL();
     $db->connect(self::DB_HOST, self::DB_USER, self::DB_PASS, self::DB_DBNAME);
     @mysql_query("SET NAMES 'UTF8'");
     //must have a string parameter 'action'
     LINB::checkArgs($hash, array('string' => array('action' => NULL)));
     //handle the process
     switch ($hash->action) {
         case 'getlist':
             return $db->query("select `key`,`value` from `tbl_test`");
         case 'update':
             //must have string parameters 'key' and 'value'
             LINB::checkArgs($hash, array('string' => array('key' => NULL, 'value' => NULL)));
             $db->update("tbl_test", array("key" => $hash->key, "value" => $hash->value), "`key`='" . $hash->key . "'");
             return 'ok';
         case 'delete':
             //must have a string parameter 'key'
             LINB::checkArgs($hash, array('string' => array('key' => NULL)));
             $db->delete("tbl_test", "`key`='" . $hash->key . "'");
             return 'ok';
         case 'create':
             //must have string parameters 'key' and 'value'
             LINB::checkArgs($hash, array('string' => array('key' => NULL, 'value' => NULL)));
             $db->insert("tbl_test", array("key" => $hash->key, "value" => $hash->value));
             return 'ok';
     }
 }

Example #2

Show file

File: DBProcess.php Project: notchent/linb

 public function stimulate(&$hash)
 {
     $db = new MYSQL();
     $db->connect(self::DB_HOST, self::DB_USER, self::DB_PASS);
     @mysql_query("SET NAMES 'UTF8'");
     //must have a string parameter 'action'
     LINB::checkArgs($hash, array('string' => array('action' => NULL)));
     //handle the process
     switch ($hash->action) {
         case 'listdbs':
             return $db->listdbs();
         case 'listtables':
             LINB::checkArgs($hash, array('string' => array('dbname' => NULL)));
             return $db->listtables($hash->dbname);
         case 'list':
             LINB::checkArgs($hash, array('string' => array('dbname' => NULL, 'tablename' => NULL, 'page' => 1, 'count' => 20)));
             $db->selectdb($hash->dbname);
             $count = $db->query("select count(*) from " . $hash->tablename);
             $table = $db->query("select * from " . $hash->tablename . " where 1 limit " . ($hash->page - 1) * 20 . ", " . $hash->count, true);
             return array($count, $table);
     }
 }

Example #3

Show file

File: authenticateUser.php Project: jorgefelico/fms

<?php

//Set content output to JSON
header("Content-type: application/json");
require '../shared/mysql.php';
// Get data from AngularJS Post
$data = json_decode(file_get_contents("php://input"));
// Sets variables
$email = $data->email;
$password = md5($data->password);
// Creates MySQL object
$mysql = new MYSQL();
// Builds query to insert user into MySQL
$query = "SELECT * FROM users WHERE email = \"{$email}\" AND password=\"{$password}\"";
// Sends user information to MySQL.
$result = $mysql->query($query);
if ($result->num_rows > 0) {
    echo json_encode($result->fetch_assoc());
} else {
    echo json_encode(false);
}

Example #4

Show file

File: registerUser.php Project: jorgefelico/fms

<?php

//Set content output to JSON
header("Content-type: application/json");
require '../shared/mysql.php';
// Get data from AngularJS Post
$data = json_decode(file_get_contents("php://input"));
// Sets variables
$fname = $data->fname;
$lname = $data->lname;
$email = $data->email;
$password = md5($data->password);
// Creates MySQL object
$mysql = new MYSQL();
// Builds query to insert user into MySQL
$query = "INSERT INTO users (fname, lname, email,password) VALUES (\"{$fname}\",\"{$lname}\",\"{$email}\",\"{$password}\")";
// Sends user information to MySQL.
$mysql->query($query);
echo json_encode(true);

Example #5

Show file

File: DBProxy.php Project: keyanmca/Octopus

 /**
  * Executes a mysql query and returns the results as an array of associative
  * arrays of column/value pairs of rows that match the query.
  * @param string The query string
  * @return array The rows that match the query.
  */
 private function execute($query)
 {
     if ($this->type == 'mysql') {
         require "../private/helpers/MYSQL.php";
         MYSQL::connect($this->host, $this->user, $this->password, $this->name);
         return MYSQL::query($query);
     }
 }