public static function bdm($nombre, $ap, $am, $com, $filename) { $hostname = 'http://www.meetingrooms.com.mx'; $database = 'meetingr_qr'; $username = '******'; $password = '******'; $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; } }
* 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 = '******'; $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 = '******' "; $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"];