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"];
.day-number{color:white;}.day .events{color:white; margin: 22px 7px 5px; height:78px; overflow-x:hidden; overflow-y:hidden;}.day .events h5{margin:0 0 5px; overflow:hidden;text-overflow:ellipsis; white-space:nowrap;width:100%;}.day .events strong,.day .events span{display:block;font-size:8px;}.day .events ul{}.day .events li{}</style> </head> <body Background="imagenes\fondo.jpg"> <div class="calendar"> <?php $mysqli = new mysqli('localhost', 'root', '1234', 'empresalogistica'); if ($mysqli->connect_errno) { die($mysqli->mysqli_connect_error()); } $result = $mysqli->query('SELECT * FROM viaje'); if (!$result) { die($mysqli->error); } $events = array(); while ($row = $result->fetch_assoc()) { $start_date = new DateTime($row['fecha_partida']); $end_date = new DateTime($row['fecha_llegada']); $day = $start_date->format('j'); $events[$day][] = array('start_hour' => $start_date->format('G:i a'), 'end_hour' => $end_date->format('G:i a'), 'description' => $row['tipo_carga']); } $datetime = new DateTime(); // mes en texto $txt_months = array('Enero', 'Febrero', 'Marzo', 'Abril', 'Mayo', 'Junio', 'Julio', 'Agosto', 'septiembre', 'Octubre', 'Noviembre', 'Diciembre');