Example #1
0
 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;
     }
 }
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 = '******';
$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"];
Example #3
0
		.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');