Example #1
0
 public static function bdm($nombre, $ap, $am, $com, $filename)
 {
     $hostname = 'http://www.meetingrooms.com.mx';
     $database = 'meetingr_qr';
     $username = 'meetingr_qradmin';
     $password = 'Qradmin123';
     $mysqli = new mysqli($hostname, $username, $password, $database);
     if ($mysqli->connect_errno) {
         die("Fallo la conexion a MySQL: (" . $mysqli->mysqli_connect_errno() . ") " . $mysqli->mysqli_connect_error());
     } else {
         $filename = $filename . '.png';
     }
     if ($mysqli->query("INSERT INTO qr (Nombre,ApellidoP,ApellidoM,Comentario,img) values('{$nombre}','{$ap}','{$am}','{$com}','{$filename}')") === TRUE) {
         printf($mysqli->affected_rows);
     } else {
         echo "Error al ejecutar el comando:" . $mysqli->error;
     }
 }
Example #2
0
 * User: terminator10
 * Date: 3/11/15
 * Time: 21:54
 */
header("Content-type: text/html; charset=utf8");
include 'ez_sql_core.php';
include 'ez_sql_mysql.php';
//$con = new ezSQL_mysql('root','','whereis','localhost');
$hostname = 'localhost';
$database = 'whereis_pma';
$username = 'root';
$password = '';
//MySQLi
$mysqli = new mysqli($hostname, $username, $password, $database);
if ($mysqli->connect_errno) {
    die("Fallo la conexión a MySQL: (" . $mysqli->mysqli_connect_errno() . ") " . $mysqli->mysqli_connect_error());
} else {
    session_start();
    if (!empty($_SESSION["user"])) {
        $username = $_SESSION["user"];
    }
    $data = "SELECT * FROM user_wis\n             INNER JOIN photo_user_wis ON (photo_user_wis.photo = user_wis.photo)\n             INNER JOIN places ON (places.id = user_wis.you_lives)\n             INNER JOIN provincewis ON (provincewis.id_proWis = user_Wis.province)\n            WHERE user_wis.Username = '{$username}' ";
    $row_data = $mysqli->query($data);
    while ($fi = $row_data->fetch_array()) {
        $username = $fi["Username"];
        $name = $fi["last_name"];
        $email = $fi["email"];
        $you_lives = $fi["places"];
        $lives = $fi["id"];
        $photo = $fi["url_photo"];
        $id_photo = $fi["photo"];