function obtenerRutAlumno($nombre_completo, $curso) { $array_nombres = explode(" ", $nombre_completo); $apellidop = array_shift($array_nombres); $apellidom = array_shift($array_nombres); $nombres = implode(" ", $array_nombres); $SQL = "CALL p_obtenerRutAlumno('{$apellidop}', '{$apellidom}', '{$nombres}', '{$curso}')"; $row = mysqliQuery($SQL); return $row['rut']; }
function calc_total_ingreso($anio, $mes = null, $dia = null) { $lastday = strftime("%d", mktime(0, 0, 0, $mes + 1, 0, $anio)); //dpr($lastday); //dpr(strftime("%d", $lastday)); $fecha_ini = $dia ? $anio . "-" . $mes . "-" . $dia : $anio . "-" . $mes . "-01"; $fecha_fin = $dia ? $anio . "-" . $mes . "-" . $dia : $anio . "-" . $mes . "-" . $lastday; $SQLi = "CALL p_ingresosPeriodo('{$fecha_ini}', '{$fecha_fin}');"; $row = mysqliQuery($SQLi); //dpr($SQLi); return $row['monto_ingreso']; }
<?php session_start(); include "main_Lib.php"; include "class/class_notas.php"; validarAcceso(); //$conn = mysqli_select_db ('dorcl_dor2009', $link); $SQL = "CALL p_obtenerRutAlumno('GODOY', 'QUIROZ', 'CAMILA CONSTANZA', '10C')"; $row = mysqliQuery($SQL, $mysqli); dpr($row); //$query2 = "SELECT @X"; //$result2 = $mysqli->query($query2); //$row2 = $result2->fetch_array(); //dpr($row2); ////Este sirve tambien para MYSQL ///* //$result = mysql_query('CALL sp_InsertarPersona(1,"Yoshiro Juan Víctor","Carbajal Cerín")'); //*/ // // ////Este sirve para SQL SERVER 2000 ///* //$result = mysql_query('exec sp_InsertarPersona(1,"Yoshiro Juan Víctor","Carbajal Cerín")'); //*/ // //if (!$result) { //die('Invalid query: ' . mysql_error()); //}
<?php require_once 'inc/db.php'; $q = "SELECT * FROM People WHERE Link <> '' ORDER BY PersonID DESC"; $data = []; if ($result = mysqliQuery($q)) { while ($row = $result->fetch_assoc()) { $data[] = $row; } } echo json_encode($data);
<?php require_once 'inc/db.php'; if (isset($_POST['submit']) && $_POST['submit'] == "adduser") { $name = $_POST['name']; $email = $_POST['email']; $link = $_POST['link']; $attending = $_POST['attending']; $a = 0; if ($attending == "Yes") { $a = 1; $q = "SELECT PersonID FROM People WHERE Attending = 1"; $result = mysqliQuery($q); if (count($result) >= 180) { echo "too many people"; die; } } $q = "INSERT INTO People (Name, Email, Link, Attending) VALUES ('{$name}', '{$email}', '{$link}', {$a})"; mysqliNonQuery($q); echo "success"; die; }
function del($id_for_del, $dbc) { $query = "DELETE FROM `adStore`\n WHERE ((`id` = '" . $id_for_del . "'));"; $result = mysqliQuery($dbc, $query); }