function getPlans($nombre_fichero)
{
include 'content.php';
$gestor = fopen($nombre_fichero, "r");
$contenido = fread($gestor, filesize($nombre_fichero));
fclose($gestor);
$array_version = json_decode($contenido, true);
$max = 6;
echo "Planes a Mostrar:";
for ($i = 1; $i < $max; $i++) {
$plan = "plan" . $i;
$url = $array_version[0][$plan];
$data = getOne($url);
$cabecera = HEAD();
$pie = FOOT();
$contenido = explode("|", $data);
if (file_exists($plan . ".html")) {
unlink($plan . ".html");
}
$fp = fopen($plan . ".html", "a+");
fwrite($fp, $cabecera);
fwrite($fp, $contenido[1]);
fwrite($fp, "\n</div></div\n");
fwrite($fp, $pie);
fclose($fp);
if ($i == 1) {
$acumulador = uneJson($i, $contenido[0]);
//echo $acumulador;
traeImg($contenido[0]);
} else {
$acumulador = uneJson($i, $contenido[0], $acumulador);
}
echo "<br><a href='" . $plan . ".html'>" . $url . "</a>";
}
if (file_exists("planes.json")) {
unlink("planes.json");
}
$fp = fopen("planes.json", "a+");
fwrite($fp, $acumulador);
fclose($fp);
echo "<br><a href='planes.json'>json</a><br>Sistema Activo.";
}
$dirawat = 0;
$dirujuk = 0;
$pulang = 0;
$meninggal = 0;
$totalrujukan = 0;
$totalnonrujukan = 0;
$totaldirawat = 0;
$totaldirujuk = 0;
$totalpulang = 0;
$totalmeninggal = 0;
while ($baris = mysql_fetch_array($hasil)) {
$rujukan = getOne("select count(rujuk_masuk.no_rawat) from reg_periksa inner join rujuk_masuk on rujuk_masuk.no_rawat=reg_periksa.no_rawat\r\n where kd_poli='{$baris['0']}' and tgl_registrasi between '{$tanggal1}' and '{$tanggal2}'");
$nonrujukan = getOne("select count(reg_periksa.no_rawat) from reg_periksa where kd_poli='{$baris['0']}' and tgl_registrasi between '{$tanggal1}' and '{$tanggal2}' \r\n and reg_periksa.no_rawat not in(select no_rawat from rujuk_masuk)");
$dirawat = getOne("select count(reg_periksa.no_rawat) from reg_periksa inner join kamar_inap on reg_periksa.no_rawat=kamar_inap.no_rawat\r\n where kd_poli='{$baris['0']}' and tgl_registrasi between '{$tanggal1}' and '{$tanggal2}' ");
$dirujuk = getOne("select count(rujuk.no_rawat) from reg_periksa inner join rujuk on rujuk.no_rawat=reg_periksa.no_rawat\r\n where kd_poli='{$baris['0']}' and tgl_registrasi between '{$tanggal1}' and '{$tanggal2}'");
$meninggal = getOne("select count(reg_periksa.no_rkm_medis) from pasien_mati inner join reg_periksa on reg_periksa.no_rkm_medis=pasien_mati.no_rkm_medis\r\n where kd_poli='{$baris['0']}' and tgl_registrasi between '{$tanggal1}' and '{$tanggal2}'");
$pulang = $rujukan + $nonrujukan - ($dirawat + $dirujuk + $meninggal);
$totalrujukan = $totalrujukan + $rujukan;
$totalnonrujukan = $totalnonrujukan + $nonrujukan;
$totaldirawat = $totaldirawat + $dirawat;
$totaldirujuk = $totaldirujuk + $dirujuk;
$totalpulang = $totalpulang + $pulang;
$totalmeninggal = $totalmeninggal + $meninggal;
echo "<tr class='isi15'>\r\n <td>{$i} </td>\r\n <td>" . $baris[1] . " </td>\r\n <td>" . $rujukan . " </td>\r\n <td>" . $nonrujukan . " </td>\r\n <td>" . $dirawat . " </td>\r\n <td>" . $dirujuk . " </td>\r\n <td>" . $pulang . " </td>\r\n <td>" . $meninggal . " </td>\r\n </tr>";
$i++;
}
echo "\r\n <tr class=isi15>\r\n <td> </td>\r\n <td>Total</td>\r\n <td>{$totalrujukan} </td>\r\n <td>{$totalnonrujukan} </td>\r\n <td>{$totaldirawat} </td>\r\n <td>{$totaldirujuk} </td>\r\n <td>{$totalpulang} </tdtd>\r\n <td>{$totalmeninggal} </tdtd>\r\n </tr> \r\n </table>";
} else {
echo "<b>Data masih kosong !</b>";
}
?>
session_start();
$param = $_REQUEST;
$VP = new M('vote_project');
$db = new DB();
$regex = new regexTool();
//print_r($VP->gets());
//根据请求进行数据操作
switch (@$param['type']) {
case 'add':
add_();
break;
case 'updateOK':
update_();
break;
case 'update':
getOne();
break;
case 'list':
list_();
break;
case 'delete':
delete_();
break;
case 'openvalid':
openvalid();
break;
case 'closevalid':
closevalid();
break;
case 'openReview':
openReview();
static function getOne($search_criteria)
{
return getOne(get_called_class(), $search_criteria);
}
function numericToString($nilai)
{
$checkSprtrThousand = explode(".", number_format($nilai, 0, chr(44), "."));
$a = count($checkSprtrThousand) - 1;
$sayValue = "";
$b = 0;
while ($a >= 0) {
$b++;
//cari satuan per separator ribuan
$chars = preg_split('//', $checkSprtrThousand[$a], -1, PREG_SPLIT_NO_EMPTY);
$x = count($chars) - 1;
$y = 0;
switch (count($chars)) {
case "1":
$getValue = getOne($chars);
break;
case "2":
$getValue = getTwo($chars);
break;
case "3":
$getValue = getThree($chars);
break;
}
if (!empty($getValue)) {
switch ($b) {
case "2":
$getValue = $getValue . " Ribu ";
if ($getValue == "Satu Ribu ") {
$getValue = "Seribu ";
}
break;
case "3":
$getValue = $getValue . " Juta ";
if ($getValue == "Satu Juta ") {
$getValue = "Sejuta ";
}
break;
case "4":
$getValue = $getValue . " Milyar ";
break;
case "5":
$getValue = $getValue . " Trilyun ";
break;
}
}
$sayValue = $getValue . $sayValue;
$a = $a - 1;
}
//endwhile($a < count($checkSprtrThousand))
return $sayValue;
}
<html>
<body>
<?php
reportsqlinjection();
$tanggal1 = $_GET['tanggal1'];
$tanggal2 = $_GET['tanggal2'];
$_sql = "select kd_poli,nm_poli from poliklinik ";
$hasil = bukaquery($_sql);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='100%' border='1' align='left' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <caption><br/><center><font color='000000' size='4' face='Arial'>Laporan Kunjuangan Rawat Jalan Per Poli<br> Periode {$tanggal1} s.d. {$tanggal2} </font></center><br/></caption>\r\n <tr class=isi15>\r\n <td width='5%' align=center>No</td>\r\n <td width='35%' align=center>Nama Poli</td>\r\n <td width='20%' align=center>Pasien Lama</td>\r\n <td width='20%' align=center>Pasien Baru</td>\r\n <td width='20%' align=center>Jumlah Pasien</td>\r\n </tr>";
$i = 1;
$lama = 0;
$baru = 0;
$total = 0;
while ($baris = mysql_fetch_array($hasil)) {
$lama = $lama + getOne("select count(no_rawat) from reg_periksa where kd_poli='{$baris['0']}' and tgl_registrasi between '{$tanggal1}' and '{$tanggal2}' and stts_daftar='Lama'");
$baru = $baru + getOne("select count(no_rawat) from reg_periksa where kd_poli='{$baris['0']}' and tgl_registrasi between '{$tanggal1}' and '{$tanggal2}' and stts_daftar='Baru'");
$total = $total + getOne("select count(no_rawat) from reg_periksa where kd_poli='{$baris['0']}' and tgl_registrasi between '{$tanggal1}' and '{$tanggal2}'");
echo "<tr class='isi15'>\r\n <td>{$i} </td>\r\n <td>" . $baris[1] . " </td>\r\n <td>" . getOne("select count(no_rawat) from reg_periksa where kd_poli='{$baris['0']}' and tgl_registrasi between '{$tanggal1}' and '{$tanggal2}' and stts_daftar='Lama'") . " </td>\r\n <td>" . getOne("select count(no_rawat) from reg_periksa where kd_poli='{$baris['0']}' and tgl_registrasi between '{$tanggal1}' and '{$tanggal2}' and stts_daftar='Baru'") . " </td>\r\n <td>" . getOne("select count(no_rawat) from reg_periksa where kd_poli='{$baris['0']}' and tgl_registrasi between '{$tanggal1}' and '{$tanggal2}'") . " </td>\r\n </tr>";
$i++;
}
echo "\r\n <tr class=isi15>\r\n <td> </td>\r\n <td>Total</td>\r\n <td>{$lama} </td>\r\n <td>{$baru} </td>\r\n <td>{$total} </td>\r\n </tr> \r\n </table>";
} else {
echo "<b>Data masih kosong !</b>";
}
?>
</body>
</html>
//==商户根据实际情况设置相应的处理流程，此处仅作举例=======
if ($notify->checkSign() == TRUE) {
if ($notify->data["return_code"] == 'SUCCESS' && $notify->data["result_code"] == 'SUCCESS') {
$orderno = $notify->data["out_trade_no"];
$weixinno = $notify->data["transaction_id"];
$trade_status = $notify->data["result_code"];
$seller_code = $notify->data["appid"];
$buyer_code = $notify->data["openid"];
$trade_type = $notify->data["trade_type"];
//查询订单信息
$sql = "select * from i_order where orderno = '" . $orderno . "'";
$res = getOne($sql);
$nums = $res['nums'];
//查询库存
$sqlap = "select * from i_activity_product where id = '" . $res['rel_id'] . "'";
$resap = getOne($sqlap);
$stock = $resap['stock'];
//查询库存
if ($res['acti_id'] == 8) {
//一呼百应活动的特殊属处理
if ($res['ispay'] == 0) {
//如果没有支付
$sql = "update i_order set ispay = 1, payment = 2, trade_no = '" . $weixinno . "', pay_at = '" . time() . "' where orderno = '" . $orderno . "'";
$query = mysql_query($sql);
if ($query) {
//减去对应的库存
$sqlap = "update i_activity_product set stock = stock-" . $res['nums'] . ", update_time = '" . time() . "' where id = '" . $res['rel_id'] . "'";
$queryap = mysql_query($sqlap);
//写入支付日志
$sqllog = "INSERT INTO i_order_log (`uid`, `product_id`, `acti_id`, `out_trade_no`, `totalpay`, `trade_no`, `trade_status`, `pay_at`,`seller_code`, `buyer_code`,`trade_type`, `payment`, `create_time`) VALUES ('" . $res['uid'] . "', '" . $res['product_id'] . "', '" . $res['acti_id'] . "', '" . $orderno . "', '" . $res['totalpay'] . "', '" . $weixinno . "', '" . $trade_status . "', '" . time() . "', '" . $seller_code . "', '" . $buyer_code . "', '" . $trade_type . "', '2', '" . time() . "')";
$querylog = mysql_query($sqllog);
function getFirstHour()
{
$criteria = array('support_contract_id' => $this->id, 'sort' => 'date ASC');
return getOne('Hour', $criteria);
}
}
}
}
echo "</table>\n </td> \n </tr>";
}
$hasil5 = bukaquery("select temp1,temp2,temp3,temp7 from temporary_bayar_ralan where temp8='Potongan' group by temp2 order by no asc");
while ($inapdrpasien = mysql_fetch_array($hasil5)) {
echo "<tr class='isi12' padding='0'>\n <td padding='0' width='30%'><font color='000000' size='2' face='Tahoma'>{$inapdrpasien['0']}</td> \n <td padding='0' width='55%' colspan='4'><font color='000000' size='2' face='Tahoma'>{$inapdrpasien['1']}</font></td> \n <td padding='0' width='1%'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='14%' align='right'><font color='000000' size='3' face='Tahoma'>{$inapdrpasien['3']}</font></td> \n </tr>";
}
$hasil6 = bukaquery("select temp1,temp2,temp3,temp7 from temporary_bayar_ralan where temp8='Tambahan' group by temp2 order by no asc");
while ($inapdrpasien = mysql_fetch_array($hasil6)) {
echo "<tr class='isi12' padding='0'>\n <td padding='0' width='30%'><font color='000000' size='2' face='Tahoma'>{$inapdrpasien['0']}</td> \n <td padding='0' width='55%' colspan='4'><font color='000000' size='2' face='Tahoma'>{$inapdrpasien['1']}</font></td> \n <td padding='0' width='1%'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='14%' align='right'><font color='000000' size='3' face='Tahoma'>{$inapdrpasien['3']}</font></td> \n </tr>";
}
$hasil7 = bukaquery("select temp1,temp2,temp3,temp7 from temporary_bayar_ralan where temp8='-' and temp7<>'' group by temp2 order by no asc");
while ($inapdrpasien = mysql_fetch_array($hasil7)) {
echo "<tr class='isi12' padding='0'>\n <td padding='0' width='30%'><font color='000000' size='2' face='Tahoma'>{$inapdrpasien['0']}</td> \n <td padding='0' width='55%' colspan='4'><font color='000000' size='2' face='Tahoma'>{$inapdrpasien['1']}</font></td> \n <td padding='0' width='1%'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='14%' align='right'><font color='000000' size='3' face='Tahoma'>{$inapdrpasien['3']}</font></td> \n </tr>";
}
$hasil8 = bukaquery("select temp1,temp2,temp3,temp7 from temporary_bayar_ralan where temp1='TOTAL BAYAR' group by temp2 order by no asc");
while ($inapdrpasien = mysql_fetch_array($hasil8)) {
echo "<tr class='isi12' padding='0'>\n <td padding='0' width='30%'><font color='000000' size='2' face='Tahoma'>{$inapdrpasien['0']}</td> \n <td padding='0' width='55%' colspan='4'><font color='000000' size='2' face='Tahoma'>" . Terbilang(str_replace(".", "", $inapdrpasien[3])) . " rupiah</font></td> \n <td padding='0' width='1%'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='14%' align='right'><font color='000000' size='4' face='Tahoma'><b>{$inapdrpasien['3']}</b></font></td> \n </tr>";
}
echo "<tr class='isi12' padding='0'>\n <td padding='0' width='30%' align=center><font color='000000' size='2' face='Tahoma'> </td> \n <td padding='0' width='55%' colspan='4' align='center'><font color='000000' size='2' face='Tahoma'> </font></td> \n <td padding='0' width='1%'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='14%' align='center'><font color='000000' size='2' face='Tahoma'>Martapura, " . date('d-m-Y') . "</font></td> \n </tr> \n <tr class='isi12' padding='0'>\n <td padding='0' width='30%' align=center><font color='000000' size='2' face='Tahoma'>Petugas</td> \n <td padding='0' width='55%' colspan='4' align='center'><font color='000000' size='2' face='Tahoma'> </font></td> \n <td padding='0' width='1%'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='14%' align='center'><font color='000000' size='2' face='Tahoma'>Penanggung Jawab Pasien</font></td> \n </tr> \n <tr class='isi12' padding='0'>\n <td padding='0' width='30%'><font color='000000' size='2' face='Tahoma'> </td> \n <td padding='0' width='55%' colspan='4'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='1%'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='14%' align='right'><font color='000000' size='2' face='Tahoma'></font></td> \n </tr> \n <tr class='isi12' padding='0'>\n <td padding='0' width='30%'><font color='000000' size='2' face='Tahoma'> </td> \n <td padding='0' width='55%' colspan='4'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='1%'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='14%' align='right'><font color='000000' size='2' face='Tahoma'></font></td> \n </tr> \n <tr class='isi12' padding='0'>\n <td padding='0' width='30%' align=center><font color='000000' size='2' face='Tahoma'>( " . getOne("select nama from petugas where nip='{$petugas}'") . " )</td> \n <td padding='0' width='55%' colspan='4' align='center'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='1%'><font color='000000' size='2' face='Tahoma'></font></td> \n <td padding='0' width='14%' align='center'><font color='000000' size='2' face='Tahoma'>(.............)</font></td> \n </tr> \n </table>";
} else {
echo "<font color='333333' size='2' face='Times New Roman'><b>Data Billing masih kosong !</b>";
}
?>
</body>
</html>
<?php
Header('Content-Type:text/html;charset=utf-8');
$str = 'Hello 你好';
$start = 0;
$res = getOne($str, $start);
var_dump($res);
function getOne($str, $start, $encoding = 'utf-8')
{
$str = mb_substr($str, $start, 1, $encoding);
return $str;
}
echo "<table width='100%' border='0' align='left' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <tr>\r\n <td colspan='6'>\r\n <table width=100% border='0'>\r\n <tr class='isi14'>\r\n <td width='17%'>\r\n <font color='000000' size='2' face='Tahoma'>Hari / Tanggal</font>\r\n </td>\r\n <td width='17%'>\r\n <font color='000000' size='2' face='Tahoma'>: " . substr($tanggal, 8, 2) . "-" . substr($tanggal, 5, 2) . "-" . substr($tanggal, 0, 4) . "</font>\r\n </td>\r\n <td width='17%'></td>\r\n <td width='17%'></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>Petugas Jaga</font></td>\r\n <td width='17%'>:</td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td width='17%'>\r\n <font color='000000' size='2' face='Tahoma'>P</font>\r\n </td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>: " . getOne("select count(no_rawat) from reg_periksa where tgl_registrasi='{$tanggal}' and jam_reg between '{$jamp1}' and '{$jamp2}'") . "</font></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>Kunjungan Lama</font></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>: " . getOne("select count(reg_periksa.no_rawat) from reg_periksa inner join pasien\r\n on reg_periksa.no_rkm_medis=pasien.no_rkm_medis where \r\n reg_periksa.tgl_registrasi='{$tanggal}' and pasien.tgl_daftar<>'{$tanggal}'") . "</font></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>P</font></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>: {$petugasp}</font></td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td width='17%'>\r\n <font color='000000' size='2' face='Tahoma'>S</font>\r\n </td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>: " . getOne("select count(no_rawat) from reg_periksa where tgl_registrasi='{$tanggal}' and jam_reg between '{$jams1}' and '{$jams2}'") . "</font></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>Kunjungan Baru</font></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>: " . getOne("select count(reg_periksa.no_rawat) from reg_periksa inner join pasien\r\n on reg_periksa.no_rkm_medis=pasien.no_rkm_medis where \r\n reg_periksa.tgl_registrasi='{$tanggal}' and pasien.tgl_daftar='{$tanggal}'") . "</font></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>S</font></td>\r\n <td width='17%'>: {$petugass}</td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td width='17%'>\r\n <font color='000000' size='2' face='Tahoma'>M</font>\r\n </td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>: " . getOne("select count(no_rawat) from reg_periksa where tgl_registrasi='{$tanggal}' and jam_reg between '{$jamm1}' and '{$jamm2}'") . "</font></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>Jumlah </font></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>: " . (getOne("select count(reg_periksa.no_rawat) from reg_periksa inner join pasien\r\n on reg_periksa.no_rkm_medis=pasien.no_rkm_medis where \r\n reg_periksa.tgl_registrasi='{$tanggal}' and pasien.tgl_daftar='{$tanggal}'") + getOne("select count(reg_periksa.no_rawat) from reg_periksa inner join pasien\r\n on reg_periksa.no_rkm_medis=pasien.no_rkm_medis where \r\n reg_periksa.tgl_registrasi='{$tanggal}' and pasien.tgl_daftar<>'{$tanggal}'")) . "</font></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>M</font></td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>: {$petugasm}</font></td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td width='17%'>\r\n <font color='000000' size='2' face='Tahoma'>Jmlh</font>\r\n </td>\r\n <td width='17%'><font color='000000' size='2' face='Tahoma'>: " . (getOne("select count(no_rawat) from reg_periksa where tgl_registrasi='{$tanggal}' and jam_reg between '{$jamp1}' and '{$jamp2}'") + getOne("select count(no_rawat) from reg_periksa where tgl_registrasi='{$tanggal}' and jam_reg between '{$jams1}' and '{$jams2}'") + getOne("select count(no_rawat) from reg_periksa where tgl_registrasi='{$tanggal}' and jam_reg between '{$jamm1}' and '{$jamm2}'")) . "</font></td>\r\n <td width='17%'></td>\r\n <td width='17%'></td>\r\n <td width='17%'></td>\r\n <td width='17%'></td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n <tr class='isi13'>\r\n <td colspan=6> </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan=6 height='310px' valign=top>\r\n <table width=100% cellpadding='0' cellspacing='0' border='1'>\r\n <tr class=isi15>\r\n <td width='5%' align=center rowspan='2'>No</td>\r\n <td width='16%' align=center colspan='2'>No.RM</td>\r\n <td width='25%' align=center rowspan='2'>Nama Pasien</td>\r\n <td width='10%' align=center colspan='2'>Umur</td>\r\n <td width='20%' align=center rowspan='2'>Alamat</td>\r\n <td width='14%' align=center rowspan='2'>Diagnosa</td>\r\n <td width='10%' align=center rowspan='2'>Dokter Jaga</td>\r\n </tr>\r\n <tr class=isi15>\r\n <td align=center>Lama</td>\r\n <td align=center>Baru</td>\r\n <td align=center>L</td>\r\n <td align=center>P</td>\r\n </tr>\r\n ";
$i = 1;
while ($barispesan = mysql_fetch_array($hasil)) {
$baru = " ";
if ($barispesan["tgl_registrasi"] == $barispesan["tgl_daftar"]) {
$baru = $barispesan["no_rkm_medis"];
}
$lama = " ";
if ($barispesan["tgl_registrasi"] != $barispesan["tgl_daftar"]) {
$lama = $barispesan["no_rkm_medis"];
}
$umurlk = " ";
$umurpr = " ";
if ($barispesan["jk"] == "L") {
$umurlk = $barispesan["umur"];
}
if ($barispesan["jk"] == "P") {
$umurpr = $barispesan["umur"];
}
echo "\r\n <tr class='isi15'>\r\n <td>{$i}</td>\r\n <td>" . $lama . " </td>\r\n <td>" . $baru . " </td>\r\n <td>" . $barispesan["nm_pasien"] . " </td>\r\n <td>" . $umurlk . " </td>\r\n <td>" . $umurpr . " </td>\r\n <td>" . $barispesan["alamat"] . " </td>\r\n <td>" . getOne("select penyakit.nm_penyakit from penyakit inner join rawat_jl_dr \r\n on rawat_jl_dr.kd_penyakit=penyakit.kd_penyakit\r\n where rawat_jl_dr.no_rawat='" . $barispesan["no_rawat"] . "' ") . " </td>\r\n <td>" . $barispesan["nm_dokter"] . " </td>\r\n </tr>";
$i++;
}
echo " \r\n </table>\r\n </td>\r\n </tr> \r\n\r\n </table>";
} else {
echo "<b>Data pesan masih kosong !</b>";
}
?>
</body>
</html>
<link href="css/default.css" rel="stylesheet" type="text/css" />
</isi>
<body>
<?php
reportsqlinjection();
$nonota = str_replace("_", " ", $_GET['nonota']);
$tanggal = $_GET['tanggal'];
$catatan = str_replace("_", " ", $_GET['catatan']);
$petugas = str_replace("_", " ", $_GET['petugas']);
$norm = str_replace("_", " ", $_GET['norm']);
$pasien = str_replace("_", " ", $_GET['pasien']);
$_sql = "SELECT no,temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8, temp9 from temporary order by no asc";
$hasil = bukaquery($_sql);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='100%' border='0' align='left' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <tr class='isi14'>\r\n <td width=50% colspan=4 align=left>\r\n <table width='100%' bgcolor='#ffffff' padding='0' align='left' border='0' class='tbl_form'>\r\n\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t<td padding='0'>\r\n\t\t\t\t\t\t\t\t\t\t<img width='50' height='50' src='images/LOGO.png'/>\r\n\t\t\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t\t\t<center>\r\n\t\t\t\t\t\t\t\t\t\t\t<font color='000000' size='2' face='Cambria'>RUMAH SAKIT AMAL SEHAT WONOGIRI</font> <br/>\r\n\t\t\t\t\t\t\t\t\t\t\t<font color='000000' size='2' face='Cambria'>\r\n\t\t\t\t\t\t\t\t\t\t\tJl.Ngerjopuro-Slogohimo, Slogohimo, Wonogiri 57694<br/>\r\n\t\t\t\t\t\t\t\t\t\t\tTelp. : 0273-5316677, 5316688, SMS AMAL SEHAT : 08132952199<br/>\r\n\t\t\t\t\t\t\t\t\t\t\tEmail : amal_sehat@telkom.net\r\n\t\t\t\t\t\t\t\t\t\t\t</font> \r\n\t\t\t\t\t\t\t\t\t</center>\r\n\t\t\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n\t\t\t\t\t <td colspan='6'><hr/>\r\n\t\t\t\t\t\t <table width=100%>\r\n\t\t\t\t\t\t\t <tr class='isi14'>\r\n\t\t\t\t\t\t\t\t<td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>No.RM</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$norm}</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>No.Nota</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$nonota}</font>\r\n\t\t\t\t\t\t\t\t</td> \r\n\t\t\t\t\t\t\t </tr> \r\n <tr class='isi14'>\r\n\t\t\t\t\t\t\t\t<td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>Nama Pasien</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$pasien}</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>Tanggal</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$tanggal}</font>\r\n\t\t\t\t\t\t\t\t</td> \r\n\t\t\t\t\t\t\t </tr> \r\n <tr class='isi14'>\r\n\t\t\t\t\t\t\t\t<td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>Alamat Pasien</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: " . getOne("select alamat from pasien where no_rkm_medis='{$norm}'") . "</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>Petugas</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$petugas}</font>\r\n\t\t\t\t\t\t\t\t</td> \r\n\t\t\t\t\t\t\t </tr> \r\n \r\n <tr class='isi14'>\r\n\t\t\t\t\t\t\t\t<td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>Catatan</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%' colspan='3'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$catatan}</font>\r\n\t\t\t\t\t\t\t\t</td> \r\n\t\t\t\t\t\t\t </tr> \r\n\t\t\t\t\t\t </table>\r\n\t\t\t\t\t </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan=4 height='100%' valign=top>\r\n <table width=100% cellpadding='0' cellspacing='0'>\r\n <tr class=isi15>\r\n <td width='5%' align=center><font color='000000' size='2' face='Cambria'>No</font></td>\r\n <td width='20%' align=center><font color='000000' size='2' face='Cambria'>Jml</font></td>\r\n <td width='55%' align=center><font color='000000' size='2' face='Cambria'>Nama Barang</font></td>\r\n <td width='20%' align=center><font color='000000' size='2' face='Cambria'>Total</font></td>\r\n </tr>";
$ttlpesan = 0;
$i = 1;
while ($barispesan = mysql_fetch_array($hasil)) {
$ttlpesan = $ttlpesan + $barispesan[9];
echo "\r\n <tr class='isi15'>\r\n <td><font color='000000' size='2' face='Cambria'>{$i}</font></td>\r\n <td><font color='000000' size='2' face='Cambria'>{$barispesan['1']} {$barispesan['5']}</font></td>\r\n <td><font color='000000' size='2' face='Cambria'>{$barispesan['3']} </font></td>\r\n <td align=right><font color='000000' size='2' face='Cambria'>" . formatDuit2($barispesan[9]) . "</font></td>\r\n </tr>";
$i++;
}
echo " <tr class='isi14'>\r\n <td colspan=2></td>\r\n <td align='right'><font color='000000' size='2' face='Cambria'>Jumlah</font></td>\r\n <td align='right'><font color='000000' size='2' face='Cambria'>" . formatDuit2($ttlpesan) . "</font></td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n </table>";
} else {
echo "<b>Data pesan masih kosong !</b>";
}
?>
</body>
</html>
<?php
header('Content-type: text/html; charset=utf-8');
error_reporting(E_ALL & ~E_NOTICE);
foreach (glob("*.mp4") as $filename) {
$q = "ffmpeg -i \"{$filename}\" -vf blackdetect=d=0:pic_th=0.70:pix_th=0.10 -an -f null - 2> log.txt";
system($q, $r);
$myfile = fopen("log.txt", "r") or die("Unable to open file!");
$read = fread($myfile, filesize("log.txt"));
fclose($myfile);
$blackStart = getArray($read, "black_start:", "black_end:");
$blackEnd = getArray($read, "black_end:", "black_duration:");
$videoDuration = trim(getOne($read, "Duration:", ","));
$siyahBolumler = array();
for ($i = 0; $i < count($blackStart) - 1; $i++) {
$siyahBolumler[$i]['baslangic'] = $blackStart[$i];
$siyahBolumler[$i]['bitis'] = $blackEnd[$i];
$siyahBolumler[$i]['sure'] = $videoDuration;
}
if (count($siyahBolumler) == 1) {
$basla = $siyahBolumler[0]['baslangic'];
$bitis = $siyahBolumler[0]['bitis'];
if ($basla == 0) {
$basla = "00:00:00";
} else {
$exp = explode('.', $basla);
$basla = "00:00:" . sprintf("%02d", $exp[0]) . "." . $exp[1];
}
if (bastami($basla)) {
$q = "ffmpeg -i \"{$filename}\" -ss 00:00:00 -t {$basla} -async 1 converted/\"{$filename}\"";
} else {
<?php
//print_r($_SESSION);exit;
if (!empty($_POST)) {
if (!empty($_POST['remeber'])) {
$remeber = $_POST['remeber'];
}
unset($_POST['remeber']);
$_POST['password'] = md5($_POST['password']);
$res = getOne('user', $_POST);
//print_R(json_encode($res));exit;
if (!empty($res)) {
$_SESSION['username'] = $res['username'];
if (!empty($remeber)) {
setcookie('username', $res['username'], time() + 3600);
}
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH'])) {
echo json_encode($res);
return false;
}
} else {
die(json_encode('用户名密码错误'));
}
}
if (!empty($_COOKIE['username']) && empty($_SESSION['username'])) {
$_SESSION['username'] = $_COOKIE['username'];
}
//$smarty->display('header.tpl');
$smarty->display('site/index.tpl');
//$smarty->display('footer.tpl');
// view(array(),'');
<?php
checkLogin();
if (!checkMode()) {
die("没有权限");
}
$id = !empty($_GET['id']) ? $_GET['id'] : die('非法id');
//调用查找一条数据库信息函数
$res = getOne('mode', 'id=' . $id);
$res['modeid'] = json_decode($res['modeid']);
if ($res['level_id'] <= $_SESSION['level_id'] && $_SESSION['level_id'] != 1) {
die("权限不足");
}
if (!empty($_POST)) {
$_POST['modeid'] = json_encode($_POST['modeid']);
$res = update("mode", $_POST, 'id=' . $id);
if ($res) {
header('Location:' . ROOT . 'index.php?c=mode&a=index&admin=1');
} else {
die("编辑失败");
}
}
view(array('res' => $res));
//include('templates/update.php');
include 'conf/conf.php';
?>
<html>
<isi>
<link href="css/default.css" rel="stylesheet" type="text/css" />
</isi>
<body>
<?php
reportsqlinjection();
$tgl1 = $_GET['tgl1'];
$tgl2 = $_GET['tgl2'];
$_sql = "select rawat_jl_dr.no_rawat,reg_periksa.no_rkm_medis,pasien.nm_pasien \r\n from rawat_jl_dr inner join reg_periksa inner join pasien\r\n on rawat_jl_dr.no_rawat=reg_periksa.no_rawat\r\n and reg_periksa.no_rkm_medis=pasien.no_rkm_medis\r\n where tgl_registrasi between '{$tgl1}' and '{$tgl2}'\r\n group by reg_periksa.no_rawat ";
$hasil = bukaquery($_sql);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='100%' border='0' align='left' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <tr class='isi13'>\r\n <td>\r\n <table width='100%' bgcolor='#ffffff' align='left' border='0' class='tbl_form' border=1>\r\n <tr>\r\n <td>\r\n <img width='80' height='70' src='images/LOGO.png'/>\r\n </td>\r\n <td>\r\n <center>\r\n <font color='333333' size='2' face='Tahoma'>RUMAH SAKIT AMAL SEHAT WONOGIRI</font><br/>\r\n <font color='333333' size='1' face='Tahoma'>\r\n Jl.Ngerjopuro-Slogohimo, Slogohimo, Wonogiri 57694<br/>\r\n Telp. : 0273-5316677, 5316688, SMS AMAL SEHAT : 08132952199<br/>\r\n Email : amal_sehat@telkom.net\r\n </font> \r\n </center>\r\n </td>\r\n <td>\r\n <center>\r\n <font color='333333' size='3' face='Tahoma'>DAFTAR BIAYA RAWAT JALAN</font>\r\n </center>\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td height='310px' valign=top>\r\n <br/>\r\n <table width=100% cellpadding='0' cellspacing='0' >\r\n <tr class=isi15>\r\n <td width='2%' align=center rowspan='2'>No</td>\r\n <td width='20%' align=center colspan='2'>PASIEN</td>\r\n <td width='58%' align=center colspan='6'>BIAYA PENGOBATAN</td>\r\n <td width='10%' align=center rowspan='2'>DOKTER</td>\r\n <td width='10%' align=center rowspan='2'>KETERANGAN</td>\r\n </tr>\r\n <tr class=isi15>\r\n <td align=center>NO.RM</td>\r\n <td align=center>NAMA PASIEN</td>\r\n <td align=center>ADMINISTRASI</td>\r\n <td align=center>JASA MEDIS</td>\r\n <td align=center>OBAT</td>\r\n <td align=center>TINDAKAN</td>\r\n <td align=center>OKSIGEN</td>\r\n <td align=center>TOTAL</td>\r\n </tr>\r\n ";
$i = 1;
while ($barispesan = mysql_fetch_array($hasil)) {
echo "<tr class=isi15>\r\n <td>{$i}</td>\r\n <td>" . $barispesan["no_rkm_medis"] . "</td>\r\n <td>" . $barispesan["nm_pasien"] . "</td>\r\n <td align='right'> " . formatDuit2(getOne("select sum(billing.totalbiaya) from billing where status='Registrasi'\r\n and no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat")) . "\r\n </td>\r\n <td align='right'> " . formatDuit2(getOne("select sum(jns_perawatan.total_byrdr) from jns_perawatan inner join rawat_inap_dr\r\n on rawat_inap_dr.kd_jenis_prw=jns_perawatan.kd_jenis_prw where\r\n no_rawat='" . $barispesan["no_rawat"] . "'")) . "\r\n </td>\r\n <td align='right'> " . formatDuit2(getOne("select sum(billing.totalbiaya) from billing where status='Obat'\r\n and no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat")) . "\r\n </td>\r\n <td align='right'> " . formatDuit2(getOne("select sum(billing.totalbiaya) from billing where status='Ralan Dokter'\r\n and no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat") + getOne("select sum(billing.totalbiaya) from billing where status='Ralan Paramedis'\r\n and no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat")) . "\r\n </td>\r\n <td> </td>\r\n <td align='right'> " . formatDuit2(getOne("select sum(billing.totalbiaya) from billing where no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat")) . "\r\n </td>\r\n <td align='left'> " . getOne("select nm_perawatan from billing where no_rawat='" . $barispesan["no_rawat"] . "' and status='Dokter' ") . "\r\n </td>\r\n <td> " . getOne("select if(sum(billing.totalbiaya)>0,'Lunas','Belum Lunas') from billing where no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat") . "</td>\r\n <tr>";
$i++;
}
echo " \r\n </table>\r\n </td>\r\n </tr> \r\n\r\n </table>";
} else {
echo "<b>Data pesan masih kosong !</b>";
}
?>
</body>
</html>
isset():判断变量是否存在或者是否设置，如果存在或设置，返回true，否则返回false
4.查找数据是否存在
5.跳转页面
*/
if (!empty($_POST['username'])) {
$username = $_POST['username'];
$password = md5($_POST['password']);
//调用getOne函数
$result = getOne('admin', "`username` = '{$username}' and `password` = '{$password}'");
if (empty($result)) {
echo '用户名或密码错误';
} else {
//1.js跳转页面，会执行两次请求，会影响用户体验
//echo '<script>alert("登陆成功");window.location.href="index.php"</script>';
//2.php方式跳转页面header()里面写绝对地址，不要写相对地址，只执行一次
$temp = getOne('mode', 'level_id=' . $result['groupid']);
$_SESSION['level_id'] = $result['groupid'];
$_SESSION['user_id'] = $result['id'];
$_SESSION['username'] = $result['username'];
$temp['modeid'] = json_decode($temp['modeid']);
$_SESSION['mode'] = $temp['modeid'];
header("Location:" . ROOT . "index.php?a=index&c=news&admin=1");
//echo '登陆成功';
}
}
include VIEW . $admin . '/' . $c . '/' . $a . '.php';
//include('templates/login.php');
/*
$res = mysql_query($sql) or die('账号密码不对');
$rows = array();
while($row = mysql_fetch_assoc($res))
$sql6 = $sql_main . " and o.country=" . $temp_arr[0] . " and g.goods_sn=29" . $sql_time;
$res6 = getOne($sql6);
if ($res6 > 0) {
$msg[$i] .= "冰淇淋" . $res6 . "。";
}
//网上总数
$sql7 = $sql_main . " and o.country=" . $temp_arr[0] . " and left(o.order_sn,2)='sh'" . $sql_time;
$res7 = getOne($sql7);
if ($res7 > 0) {
$msg[$i] .= "今天网上" . $res7 . "个。";
}
//明天蛋糕总数
$send_time1 = date("Y-m-d", strtotime("tomorrow"));
$sql_time1 = " and o.best_time like '" . $send_time1 . "%'";
$sql8 = $sql_main . " and o.country=" . $temp_arr[0] . $sql_time1;
$res8 = getOne($sql8);
if ($res8 > 0) {
$msg[$i] .= "明日" . $res8 . "个。";
$temp_count = $res8;
}
//后缀加上时间落款
//$msg[$i].=date("Y-m-d H:i:s",time()+8*3600);
//插入sendsms
$sql9 = "insert into sendsms (content,mobile,class,sendtime) values ('" . $msg[$i] . "','" . $mobile . "','每日订单','" . date("Y-m-d H:i:s", time() + 8 * 3600) . "')";
mysql_query($sql9);
//发送短信
sendsms($mobile, $msg[$i]);
}
} else {
echo date("Y-m-d H:i:s", time()) . "<br/>还没到发送时间";
}
<?php
checkLogin();
$id = !empty($_GET['id']) ? $_GET['id'] : die('非法id');
//调用查找一条数据库信息函数
$res = getOne('admin', 'id=' . $id);
$temp = $res['password'];
if ($res['groupid'] != $_SESSION['level_id']) {
die("禁止修改别人的");
}
if (!empty($_POST)) {
$pid = $_POST['id'];
if ($_POST['password'] != $temp) {
$_POST['password'] = md5($_POST['password']);
}
//调用更新函数
$res = update('admin', $_POST, 'id=' . $pid);
if (!empty($res)) {
header('Location:' . ROOT . 'index.php?c=news&a=index&admin=1');
} else {
die('修改失败');
}
}
view(array('res' => $res));
//include('templates/update.php');
<?php
reportsqlinjection();
$tanggal1 = $_GET['tanggal1'];
$tanggal2 = $_GET['tanggal2'];
$_sql = "select left(tgl_registrasi,7) from reg_periksa where tgl_registrasi between '{$tanggal1}' and '{$tanggal2}' group by left(tgl_registrasi,7) order by tgl_registrasi";
$hasil = bukaquery($_sql);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='100%' border='1' align='left' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <caption><br/><center><font color='000000' size='4' face='Arial'>Laporan Kunjuangan Bulanan<br> Periode {$tanggal1} s.d. {$tanggal2} </font></center><br/></caption>\r\n <tr class=isi15>\r\n <td width='5%' align=center>No</td>\r\n <td width='20%' align=center>Bulan</td>\r\n <td width='15%' align=center>Tahun</td>\r\n <td width='25%' align=center>Poli</td>\r\n <td width='10%' align=center>Pasien Lama</td>\r\n <td width='10%' align=center>Pasien Baru</td>\r\n <td width='15%' align=center>Jumlah Pasien</td>\r\n </tr>";
$i = 1;
$lama = 0;
$baru = 0;
$total = 0;
while ($baris = mysql_fetch_array($hasil)) {
$hasil2 = bukaquery("select kd_poli, nm_poli from poliklinik");
while ($baris2 = mysql_fetch_array($hasil2)) {
$lama = $lama + getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}' and stts_daftar='Lama'");
$baru = $baru + getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}' and stts_daftar='Baru'");
$total = $total + getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}'");
echo "<tr class='isi15'>\r\n\t\t\t\t\t\t\t\t <td>{$i} </td>\r\n\t\t\t\t\t\t\t\t <td>" . konversiBulan(substr($baris[0], 5, 2)) . " </td>\r\n\t\t\t\t\t\t\t\t <td>" . substr($baris[0], 0, 4) . " </td>\r\n\t\t\t\t\t\t\t\t <td>" . $baris2[1] . " </td>\r\n\t\t\t\t\t\t\t\t <td>" . getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}' and stts_daftar='Lama'") . " </td>\r\n\t\t\t\t\t\t\t\t <td>" . getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}' and stts_daftar='Baru'") . " </td>\r\n\t\t\t\t\t\t\t\t <td>" . getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}'") . " </td>\r\n\t\t\t\t\t\t </tr>";
$i++;
}
}
echo "\r\n <tr class=isi15>\r\n <td> </td>\r\n <td>Total</td>\r\n <td> </td>\r\n <td> </td>\r\n <td>{$lama} </td>\r\n <td>{$baru} </td>\r\n <td>{$total} </td>\r\n </tr> \r\n </table>";
} else {
echo "<b>Data masih kosong !</b>";
}
?>
</body>
</html>
<?php
checkLogin();
$id = !empty($_GET['id']) ? $_GET['id'] : die('非法id');
$detail = getOne('category', 'id=' . $id);
$arr = array();
$pra_res = $detail;
$pra_id = 1;
//随便赋不是0的值
while ($pra_id != 0) {
$pra_id = $pra_res['pid'];
$temp_id = $pra_res['id'];
$res = getList('category', 0, 100, '*', 'pid=' . $pra_id);
//当前级别的所有信息
$pra_res = getOne('category', 'id=' . $pra_id);
//父级信息
$arr[$temp_id] = $res;
}
$arr = array_reverse($arr, true);
unset($arr[$id]);
if (!empty($_POST)) {
$res = update('category', $_POST, 'id=' . $id);
if (!empty($res)) {
header('Location:' . ROOT . 'index.php?c=category&a=index&admin=1');
} else {
die('修改失败');
}
}
view(array('detail' => $detail, 'arr' => $arr));
function getFirstHour()
{
$criteria = array('estimate_id' => $this->id, 'sort' => 'date ASC');
return getOne('Hour', $criteria);
}
<?php
//test
require_once 'boot/bootstrap.php';
$p = new Project();
$s = getOne('Staff', array('First_Name' => 'Ted'));
$p->set(array('id' => 20971, 'name' => 'SimpeTest Project', 'staff_id' => $s->id, 'company_id' => 20970));
$p->save() ? print 'saved' : (print 'didn\'t save');
<?php
checkLogin();
$id = !empty($_GET['id']) ? $_GET['id'] : die('非法id');
//调用查找一条数据库信息函数
$res = getOne('news', 'id=' . $id);
if (!empty($_POST)) {
$pid = $_POST['id'];
//调用更新函数
$res = update('news', $_POST, 'id=' . $pid);
if (!empty($res)) {
header('Location:' . ROOT . 'index.php?c=news&a=index&admin=1');
} else {
die('修改失败');
}
}
view(array('res' => $res));
//include('templates/update.php');
<?php
if (isset($_GET["id"])) {
include 'managers/photos.php';
$photo = getOne($_GET['id']);
include 'views/photos.phtml';
include 'views/templates/default.phtml';
//var_dump($photo);
} else {
include 'managers/photos.php';
$parPage = 16;
$cPage = 1;
$nombrePhotos = getNombre();
$nombrePages = ceil($nombrePhotos / $parPage);
if (isset($_GET["p"]) and $_GET["p"] > 0 and $_GET["p"] <= $nombrePages) {
$cPage = $_GET["p"];
} else {
$cPage = 1;
}
$photos = getAll($parPage, $cPage);
include 'views/photos.phtml';
include 'views/templates/default.phtml';
//var_dump($photos);
}
