function insert_child()
{
$father = $_POST['father'];
$mother = $_POST['mother'];
//$pswrd=$_POST['pswrd'];
//$cnf_pswrd=$_POST['cnf_pswrd'];
//$pswrd = "ABCD";
$date = $_POST['date'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$pin = $_POST['pin'];
$contact = $_POST['contact'];
$lat = $_POST['lat'];
$lng = $_POST['lng'];
$birth_id = $_POST['birth_id'];
$hid = $_SESSION['id'] . "/" . date("Y") . "/" . $birth_id;
$con = open_connection();
$sql_query = "INSERT INTO child (dob,hid,mother,father,address,city,state,pin,lat,lng,contact) VALUES('{$date}','{$hid}', '{$mother}','{$father}','{$address}','{$city}','{$state}',{$pin},0,0,{$contact})";
if (mysqli_query($con, $sql_query)) {
$response['code'] = 1;
$response['response'] = "Data inaserted";
$response['response_data'] = $hid;
} else {
$response['code'] = 0;
$response['response'] = "Please try again later";
}
echo json_encode($response);
}
public function buscar_cursos($nomeCurso)
{
$conexao = open_connection();
$dados = array();
$Where = "";
if ($nomeCurso == " ") {
$Where = "";
} else {
$Where = " WHERE nome_curso LIKE '%{$nomeCurso}%' ";
}
$SQLBusCurso = $conexao->query("SELECT cod_curso,\n\t\t\t\t\t\t\t\t\t\t\t\t nome_curso,\n\t\t\t\t\t\t\t\t\t\t\t\t periodo \n\t\t\t\t\t\t\t\t\t\t\t FROM curso \n\t\t\t\t\t\t\t\t\t\t\t{$Where}\n\t\t\t\t\t\t\t\t\t\t\t LIMIT 7");
if ($SQLBusCurso) {
while ($RESBusCurso = $SQLBusCurso->fetch(PDO::FETCH_ASSOC)) {
if ($RESBusCurso['periodo'] == 1) {
$periodo = "Matutino";
}
if ($RESBusCurso['periodo'] == 2) {
$periodo = "Vespertino";
}
if ($RESBusCurso['periodo'] == 3) {
$periodo = "Integral";
}
$dados[] = array("value" => $RESBusCurso['cod_curso'] . "-" . $RESBusCurso['nome_curso'] . "-" . $periodo);
}
}
return $dados;
}
public function __construct()
{
$this->connect = open_connection();
$this->path = $GLOBALS['path'];
$this->url_rewrite = $GLOBALS['url_rewrite'];
$this->url_rewrite_report = $GLOBALS['url_rewrite_report'];
//echo $this->path;
}
function k_query($request)
{
global $num_queries;
global $mysql_link;
if ($mysql_link == false) {
open_connection();
}
$num_queries = $num_queries + 1;
$result = mysql_query($request, $mysql_link) or die("{$request}<br>Error in: " . mysql_error());
return $result;
}
function search($field, $value)
{
$con = open_connection();
$sql_query = "SELECT * from child where " . $field . "=" . $value;
//echo $sql_query;
if ($result = mysqli_query($con, $sql_query)) {
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
echo mysqli_num_rows($result);
//display here
} else {
echo "No results found";
}
} else {
echo mysql_error($con);
}
}
public function buscar_alunos($nomePessoa)
{
$conexao = open_connection();
$dados = array();
$Where = "";
if ($nomePessoa == " ") {
$Where = "";
} else {
$Where = " WHERE nome_aluno LIKE '%{$nomePessoa}%' ";
}
$SQLBusAluno = $conexao->query("SELECT cod_aluno,\n\t\t\t\t\t\t\t\t\t\t\t\t nome_aluno\n\t\t\t\t\t\t\t\t\t\t\t FROM aluno \n\t\t\t\t\t\t\t\t\t\t\t{$Where}\n\t\t\t\t\t\t\t\t\t\t\t LIMIT 7");
if ($SQLBusAluno) {
while ($RESBusAluno = $SQLBusAluno->fetch(PDO::FETCH_ASSOC)) {
$dados[] = array("value" => $RESBusAluno['cod_aluno'] . "-" . $RESBusAluno['nome_aluno']);
}
}
return $dados;
}
function register_hospital()
{
$name = $_POST['name'];
$pswrd = $_POST['password'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$pin = $_POST['pin'];
$contact = $_POST['contact'];
$con = open_connection();
$query = "INSERT INTO hospital (name,pswrd,address,city,state,pin,lat,lng,contact) VALUES('{$name}','{$pswrd}','{$address}','{$city}','{$state}',{$pin},0,0,{$contact})";
if (mysqli_query($con, $query)) {
$response['code'] = 1;
$response['response'] = "Data inserted.";
} else {
$response['code'] = 0;
$response['response'] = "There was some error. Please try again later";
}
echo json_encode($response);
}
<?php ob_start();?>
<html>
<?php
include "../../config/config.php";
include "$path/header.php";
include "$path/title.php";
?>
<body>
<?php
include "$path/menu.php";
$status=$_GET['status'];
$id=$_SESSION['Aset_ID'];
?>
<?php
open_connection();
if (isset($_GET['act']))
{
if ($_GET['act'] == 'Edit')
{
$queryselect = "SELECT a.*, b.* From Penilaian AS a LEFT JOIN NilaiAset AS b ON a.Penilaian_ID = b.Penilaian_ID
WHERE a.Penilaian_ID = '$_GET[id]'";
// print_r($queryselect);
$result=mysql_query($queryselect) or die(mysql_error());
if ($result){
//echo mysql_num_rows($result);
$row = mysql_fetch_object($result);
// pr($row);
function xmpp_connect($options, $access_token)
{
global $STREAM_XML, $AUTH_XML, $RESOURCE_XML, $SESSION_XML, $CLOSE_XML, $START_TLS;
$fp = open_connection($options['server']);
if (!$fp) {
return false;
}
// initiates auth process (using X-FACEBOOK_PLATFORM)
send_xml($fp, $STREAM_XML);
if (!find_xmpp($fp, 'STREAM:STREAM')) {
return false;
}
if (!find_xmpp($fp, 'MECHANISM', 'X-FACEBOOK-PLATFORM')) {
return false;
}
// starting tls - MANDATORY TO USE OAUTH TOKEN!!!!
send_xml($fp, $START_TLS);
if (!find_xmpp($fp, 'PROCEED', null, $proceed)) {
return false;
}
stream_socket_enable_crypto($fp, true, STREAM_CRYPTO_METHOD_TLS_CLIENT);
send_xml($fp, $STREAM_XML);
if (!find_xmpp($fp, 'STREAM:STREAM')) {
return false;
}
if (!find_xmpp($fp, 'MECHANISM', 'X-FACEBOOK-PLATFORM')) {
return false;
}
// gets challenge from server and decode it
send_xml($fp, $AUTH_XML);
if (!find_xmpp($fp, 'CHALLENGE', null, $challenge)) {
return false;
}
$challenge = base64_decode($challenge);
$challenge = urldecode($challenge);
parse_str($challenge, $challenge_array);
// creates the response array
$resp_array = array('method' => $challenge_array['method'], 'nonce' => $challenge_array['nonce'], 'access_token' => $access_token, 'api_key' => $options['app_id'], 'call_id' => 0, 'v' => '1.0');
// creates signature
$response = http_build_query($resp_array);
// sends the response and waits for success
$xml = '<response xmlns="urn:ietf:params:xml:ns:xmpp-sasl">' . base64_encode($response) . '</response>';
send_xml($fp, $xml);
if (!find_xmpp($fp, 'SUCCESS')) {
return false;
}
// finishes auth process
send_xml($fp, $STREAM_XML);
if (!find_xmpp($fp, 'STREAM:STREAM')) {
return false;
}
if (!find_xmpp($fp, 'STREAM:FEATURES')) {
return false;
}
send_xml($fp, $RESOURCE_XML);
if (!find_xmpp($fp, 'JID')) {
return false;
}
send_xml($fp, $SESSION_XML);
if (!find_xmpp($fp, 'SESSION')) {
return false;
}
// we made it!
send_xml($fp, $CLOSE_XML);
print "Authentication complete<br>";
fclose($fp);
return true;
}
?>
<div class="container">
<fieldset class="col-md-8 col-md-offset-2">
<legend>Cadastro de matrículas</legend>
<form action="ModelCadMatricula.php" method="get" onsubmit="return validarPreenchimentoDosCampos();">
<div class="form-group">
<label>Aluno: *</label>
<input type="text" id="nome_aluno" name="nome_aluno" class="form-control inputUnico" placeholder="Campo auto-complete">
</div>
<div class="form-group">
<label>Curso: *</label>
<select id="curso" name="curso" class="form-control inputUnico">
<option value="0">----Selecione um curso----</option>
<?php
$conexao = open_connection();
$SQLBusCurso = $conexao->query("SELECT cod_curso,\n nome_curso,\n periodo\n FROM curso");
if ($SQLBusCurso) {
while ($RESBusCurso = $SQLBusCurso->fetch(PDO::FETCH_ASSOC)) {
$cod_curso = $RESBusCurso['cod_curso'];
$nome_curso = $RESBusCurso['nome_curso'];
$periodo = $RESBusCurso['periodo'];
if ($periodo == 1) {
$periodo = "Matutino";
}
if ($periodo == 2) {
$periodo = "Vespertino";
}
if ($periodo == 3) {
$periodo = "Integral";
}
