PHP school::execute_query Beispiele

Beispiel #1

Datei: evacuation.php Projekt: seans888/Bgy-Project

$page_title = 'Barangay System';
$stylesheet_link = 'style';
require 'path.php';
init_cobalt();
require 'header1.php';
require 'components/get_listview_referrer.php';
$username = $_SESSION['user'];
require_once 'subclasses/citizen.php';
$dbh_citizen1 = new citizen();
$citizen = $dbh_citizen1->execute_query("SELECT city FROM citizen WHERE username='******'")->result;
extract($citizen->fetch_assoc());
$city_citizen = $city;
require_once 'subclasses/school.php';
$dbh_school = new school();
$dbh_school->execute_query("SELECT * FROM school WHERE city = {$city_citizen} && is_evacuation = 'Yes'");
$result1 = $dbh_school->result;
?>
<main>
<div class="block-body">
<div class="fold-2">
	<h3 class="fold-2-head center-obj fold-head">Mga lugar sa Ating Barangay</h3>
	<hr class="hr"/>
<?php 
//echo $city_citizen;
while ($row1 = $result1->fetch_assoc()) {
    extract($row1);
    echo '<li>';
    echo $school_name;
    echo '</li>';
    echo '<li>';

Beispiel #2

Datei: school.php Projekt: seans888/Bgy-Project

$page_title = 'Barangay System';
$stylesheet_link = 'style';
require 'path.php';
init_cobalt();
require 'header1.php';
require 'components/get_listview_referrer.php';
$username = $_SESSION['user'];
require_once 'subclasses/citizen.php';
$dbh_citizen1 = new citizen();
$citizen = $dbh_citizen1->execute_query("SELECT city FROM citizen WHERE username='******'")->result;
extract($citizen->fetch_assoc());
$city_citizen = $city;
require_once 'subclasses/school.php';
$dbh_school = new school();
$dbh_school->execute_query("SELECT * FROM school WHERE city = {$city_citizen}");
$result1 = $dbh_school->result;
?>
<main>
<div class="block-body">
<div class="fold-2">
	<h3 class="fold-2-head center-obj fold-head">Mga lugar sa Ating Barangay</h3>
	<hr class="hr"/>
<?php 
//echo $city_citizen;
while ($row1 = $result1->fetch_assoc()) {
    extract($row1);
    echo '<li>';
    echo $school_name;
    echo '</li>';
    echo '<li>';