*/
$post = array('email_user' => '*****@*****.**', 'password' => 'test');
$db->insert('users', $post);
echo "Inseted Row ID is :: " . $db->InserId;
echo "<br>";
/*
* Select Example
*/
$db->select('users');
while ($r = $db->fetch()) {
echo $r['email_user'];
echo "<br>";
}
echo "<br>";
print_r($r);
echo "Total Rows : ", $db->NumRows();
echo "<br><br>";
/*
* Select with where
* You can use various conditions here such as like , regexp and etc...
*/
$db->select('users', '*', 'id = 1');
$r = $db->fetch();
print_r($r);
echo "<br><br>";
/*
* Order by , group by ,limit , start examples
*/
$db->order_by = 'id ASC';
$db->start = 2;
$db->limit = 4;
<h2>Reservations/Contact</h2>
<form method="POST" action="Reserva.php" enctype="multipart/form-data" class="comment-form" id="frmReserva" name="frmReserva">
<div class="wrap" id="IdReservaciones">
<div class="one_half ">
<p class="comment-form-comment">
<label for="comment">Full name/s (Separated by enter)</label> <textarea id="nombre" name="nombre" cols="45" rows="4" aria-required="true"></textarea>
</p>
<p class="comment-form-comment">
<label for="comment">Hotel</label>
<select id="hotel" name="hotel" class="ui-widget">
<?php
$SHoteles = "SELECT * FROM cs_hoteles";
$db->Query($SHoteles);
$NumHoteles = $db->NumRows();
for ($i = 0; $i < $NumHoteles; $i++) {
$row = $db->NextRow();
?>
<option value="<?php
echo $row['id_cs_hotel'];
?>
"><?php
echo $row['nombre'];
?>
</option>
<?php
}
?>
</select>
</p>
public function cargarMenu()
{
$query = "Select md.nombre, md.ruta, m.nombre as menu, m.idMenu from tblusuariopermisos as up join tblmenudetalle as md on up.idPermiso = md.idMenuDetalle join tblmenu as m on m.idMenu = md.idMenu WHERE up.idUsuario =" . $this->idUsuario . " order by m.idMenu, md.orden";
$con = new Database();
$con->Query($query);
?>
<ul>
<li class="classic">
<a href="index">
<span class="semi-bold">Inicio</span>
</a>
</li>
<?php
$idMenu = 0;
$cierre = false;
$fin = $con->NumRows();
$i = 1;
while ($fila = $con->NextRow()) {
if ($idMenu != $fila["idMenu"]) {
if ($idMenu != 0) {
?>
</ul>
</li>
<?php
$cierre = false;
}
$idMenu = $fila["idMenu"];
?>
<li class="classic">
<a href="javascript:;">
<span class="semi-bold"><?php
echo $fila["menu"];
?>
</span> <span class="arrow"></span>
</a>
<ul class="classic">
<?php
}
?>
<li>
<a href="<?php
echo $fila["ruta"];
?>
">
<?php
echo utf8_encode($fila["nombre"]);
?>
</a>
</li>
<?php
if ($fin == $i) {
?>
</ul>
</li>
<?php
}
$i++;
}
?>
</ul>
<?php
}
