function fetchdata()
{
if (connectdb()) {
$conn = connectdb();
}
echo "<html><head><script type=\"text/javascript\" src=\"script.js\"></script>\n\t\t<link href=\"editpage.css\" rel=\"stylesheet\" type=\"text/css\">\n\t\t</head>";
$data1 = mysqli_query($conn, "Select * from formdata");
echo "<h1> Subscriber details </h1>";
echo "<h2 id='message'></h2>";
echo "<table border=1 width=100>\n\t\t<tr>\n\t\t<th>Name</th>\n\t\t<th>Sex</th>\n\t\t<th>Email</th>\n\t\t<th>Country</th>\n\t\t<th>State</th>\n\t\t<th>Address</th>\n\t\t<th>Mobileno</th>\n\t\t<th>Interests</th>\n\t\t<th>Favorites</th>\n\t\t<th>EDIT</th>\n\t\t<th>Delete</th>\n\t\t</tr>";
while ($result = mysqli_fetch_array($data1)) {
echo "<tr >";
echo "<form method='post' style='width:200px'>";
echo "<td>" . "<input type='text' name='name' value='" . $result['name'] . "'></td>";
echo "<td>" . "<input type='text' name='sex' value='" . $result['sex'] . "'></td>";
echo "<td>" . "<input type='text' name='email' value='" . $result['email'] . "'></td>";
echo "<td>" . "<input type='text' name='country' value='" . $result['country'] . "'></td>";
echo "<td>" . "<input type='text' name='state' value='" . $result['state'] . "'></td>";
echo "<td>" . "<input type='text' name='address' value='" . $result['address'] . "'></td>";
echo "<td>" . "<input type='text' name='mobileno' value='" . $result['mobileno'] . "'></td>";
echo "<td>" . "<input type='text' name='interests' value='" . $result['interest'] . "'></td>";
echo "<td>" . "<input type='text' name='favorites' value='" . $result['favorites'] . "'></td>";
echo "<td>" . "<input type='button' name='edit' value='edit' onclick='modifydata(this)'>" . "</td>";
echo "<td>" . "<input type='button' name='delete' value='delete' onclick='modifydata(this)''>" . "</td>";
echo "</form>";
echo "</tr>";
}
echo "</table>";
echo "</html>";
mysqli_close($conn);
}
function searchLoaiHH($value, $type)
{
$typesearch = "";
switch ($type) {
case "ID":
$typesearch = "IDLoaiHH";
break;
case "Ten":
$typesearch = "TenLoaiHH";
break;
case "MoTa":
$typesearch = "MoTa";
break;
}
$query_str = "select * from loaihanghoa_tbl where " . $typesearch . "='" . $value . "'";
//return $query_str;
$query_ext = mysql_query($query_str, connectdb()) or die(mysql_error());
if (mysql_num_rows($query_ext) > 0) {
while ($r = mysql_fetch_array($query_ext)) {
$rs[] = $r;
}
} else {
$rs = NULL;
}
return $rs;
}
function getName()
{
connectdb();
$query = "SELECT name FROM prefs";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
return $row['name'];
}
function viewnews()
{
global $database;
if ($database == null) {
connectdb();
}
$result = mysqli_query($database, "SELECT * FROM news");
return $result;
}
function viewcandidate()
{
global $database;
if ($database == null) {
connectdb();
}
$result = mysqli_query($database, "SELECT * FROM user WHERE role='candidate'");
return $result;
}
function viewewg()
{
global $database;
if ($database == null) {
connectdb();
}
$result = mysqli_query($database, "SELECT * FROM watchdog_group");
return $result;
}
function viewannouncement()
{
global $database;
if ($database == null) {
connectdb();
}
$result = mysqli_query($database, "SELECT * FROM announcement");
return $result;
}
function viewmember($data)
{
global $database;
if ($database == null) {
connectdb();
}
$result = mysqli_query($database, "SELECT * FROM watchdog_member WHERE groupname=" . $data);
return $result;
}
function initDB()
{
global $connectedtodb, $db;
if ($this->switches['Enable_Database']['enabled'] == true) {
if (!$connectedtodb) {
connectdb(false);
}
}
}
function checkResult($question_id, $answer_opt_id)
{
$db = connectdb();
$sql = "SELECT score FROM answer_options WHERE question_id = :question_id AND answer_option_id = :answer_option_id";
$sth = $db->prepare($sql);
$sth->setFetchMode(PDO::FETCH_ASSOC);
$sth->execute(array(':answer_option_id' => $answer_opt_id, ':question_id' => $question_id));
$result = $sth->fetchAll();
return (int) $result[0]['score'];
}
function login($acc, $pw)
{
$str = "Select * from user_tbl where Username='******' and Password='******'";
//$str = "SELECT * FROM user_tbl";
$query = mysql_query($str, connectdb()) or die(mysql_error());
while ($r = mysql_fetch_array($query)) {
$rs[] = $r;
}
return $rs;
}
function cand_prof($id, $fname, $bdate, $pos, $posrun, $prov, $city)
{
global $database;
if ($database == null) {
connectdb();
}
$sql = "INSERT INTO candidate_profile(user_fk,name,birthday,province,city,current_position,position_running) VALUES ('" . $id . "','" . $fname . "','" . $bdate . "','" . $prov . "','" . $city . "','" . $pos . "','" . $posrun . "')";
var_dump($sql);
mysqli_query($database, $sql) or die("Error: " . mysqli_error($database));
// mysqli_close($database);
}
function checkExistentQ_NQ($idnhomquyen, $iddm)
{
$str = "select * from quyen_nhomquyen_tbl where IDNhomQuyen='" . $idnhomquyen . "' and IDDM='" . $iddm . "'";
$query = mysql_query($str, connectdb()) or die(mysql_error());
if (mysql_num_rows($query) > 0) {
$rs = true;
} else {
$rs = false;
}
return $rs;
}
function getAllHH()
{
$query_str = "select * from hanghoa_tbl";
$query_ext = mysql_query($query_str, connectdb()) or die(mysql_error());
if (mysql_num_rows($query_ext) > 0) {
while ($r = mysql_fetch_array($query_ext)) {
$rs[] = $r;
}
} else {
$rs = NULL;
}
return $rs;
}
function getDMCon($iddmcha)
{
$query_str = "select * from danhmuc_tbl where IDDMCha='" . $iddmcha . "'";
$query_ext = mysql_query($query_str, connectdb()) or die(mysql_error());
if (mysql_num_rows($query_ext) > 0) {
while ($r = mysql_fetch_array($query_ext)) {
$rs[] = $r;
}
} else {
$rs = NULL;
}
return $rs;
}
function getAllNhomQuyen()
{
$str = "select * from nhomquyen_tbl";
$query = mysql_query($str, connectdb()) or die(mysql_error());
if (mysql_num_rows($query) > 0) {
while ($r = mysql_fetch_array($query)) {
$rs[] = $r;
}
} else {
$rs = null;
}
return $rs;
}
function generate_tasks($verbose = true)
{
include_once 'when/When.php';
$mysqli = connectdb(true);
$mysqli2 = connectdb(true);
$mysqli3 = connectdb(true);
$start = new DateTime();
$stmt = $mysqli->prepare("Select TaskID, Title, Details, RRule, Time FROM tasks_master WHERE Active='Y'");
$stmt->execute();
$stmt->bind_result($rtaskid, $rtitle, $rdetails, $rrrule, $rtime);
while ($stmt->fetch()) {
$r = new When();
$r->recur($start)->rrule($rrrule . ";COUNT=30");
if ($verbose) {
echo $rtaskid . " " . $rtitle . " " . $rrrule . " " . $rdetails . "<br />";
}
while ($result = $r->next()) {
if (strtotime($result->format('Y-m-d')) < strtotime('+30 days')) {
$nextime = $result->format('Y-m-d') . ' ' . $rtime;
if ($verbose) {
echo $nextime . " ";
}
$checkexistingstmt = $mysqli3->query("SELECT TaskWorkingID FROM tasks_working WHERE TaskID={$rtaskid} AND Scheduled='{$nextime}'");
if ($checkexistingstmt->num_rows > 0) {
if ($verbose) {
echo " - Already exists... skipping!!<br />";
}
} else {
$statement = $mysqli2->prepare("INSERT INTO tasks_working (TaskID, Scheduled) Values (?,?)");
if (!$statement->bind_param('is', $rtaskid, $nextime)) {
if ($verbose) {
echo "Binding parameters failed: (" . $statement->errno . ") " . $statement->error;
}
}
if (!$statement->execute()) {
if ($verbose) {
echo " - Executing query failed: (" . $statement->errno . ") " . $statement->error;
}
} else {
if ($verbose) {
echo " - Sucessfully added task<br />";
}
}
}
}
}
}
$mysqli3->close();
$mysqli2->close();
$mysqli->close();
}
function loginadmin()
{
$user = $_POST['user'];
$pass = $_POST['pass'];
$conn = connectdb();
$sql = "SELECT * FROM tb_akun WHERE username='******'";
$ssql = $conn->query($sql);
$row = $ssql->fetch(PDO::FETCH_ASSOC);
if ($row['username'] == $user and $row['password'] == $pass) {
session_start();
$_SESSION['usernameadmin'] = $row['username'];
echo "<script>alertberhasillogin()</script>";
} else {
echo "<script>swal('Maaf!', 'Username dan Password Anda Salah', 'error')</script>";
}
}
function connectdb($dbname)
{
$servername = 'localhost';
$dbuser = '******';
$dbpass = '******';
$dbport = '3306';
$db = mysqli_connect($servername, $dbuser, $dbpass, '', $dbport);
if (!mysqli_select_db($db, $dbname)) {
$db = mysqli_connect($servername, $dbuser, $dbpass, '', $dbport);
$sql = "CREATE DATABASE `" . $dbname . "`;";
$result = mysqli_query($db, $sql) or trigger_error("error: " . mysqli_error($db), E_USER_ERROR);
if (!$result) {
return false;
} else {
return connectdb($dbname);
}
}
return $db;
}
function add_group($gname, $desc)
{
global $database;
if ($database == null) {
connectdb();
}
$result = mysqli_query($database, "SELECT * FROM watchdog_group WHERE name='{$gname}'");
if (mysqli_num_rows($result) > 0) {
echo "Group already exists.";
} else {
$sql = "INSERT INTO watchdog_group (name,description) VALUES ('" . $gname . "','" . $desc . "')";
if (mysqli_query($database, $sql)) {
$last_id = mysqli_insert_id($database);
echo "New record created successfully. Last inserted ID is: " . $last_id;
// mysqli_close($database);
} else {
echo "Error: " . mysqli_error($database);
}
}
}
function getTTbyLoaiTT($idloaitt)
{
switch ($idloaitt) {
case 5:
$tbl_name = "mausac_tbl";
break;
case 6:
$tbl_name = "donvitinh_tbl";
break;
}
$query_str = "select * from " . $tbl_name;
$query_exc = mysql_query($query_str, connectdb()) or die(mysql_error());
if (mysql_num_rows($query_exc) > 0) {
while ($r = mysql_fetch_array($query_exc)) {
$rs[] = $r;
}
} else {
$rs = null;
}
return $rs;
}
<?php
require 'config.php';
require 'lib.php';
connectdb();
require_login('index.php');
ComputeTimerStudent($resttime, $question, $questiontext, $md5questiontext, $infoanswer);
echo $md5questiontext;
echo '#' . $questiontext;
function GetSkymning()
{
connectdb();
$sql = "SELECT * from settings WHERE label=longitud";
$result = mysql_query($sql);
$longitud = mysql_result($result, "value");
$sql = "SELECT * from settings WHERE label=latitud";
$result = mysql_query($sql);
$latitud = mysql_result($result, "latitud");
$sql = "SELECT * from settings WHERE label=tidzon";
$result = mysql_query($sql);
$timezone = mysql_result($result, "value");
$zenith = 90 + 50 / 60;
$twilightZenith = 96;
$timezone = 1;
$time = date_sunset(time(), SUNFUNCS_RET_STRING, $latitud, $longitud, $twilightZenith, $timezone);
return $time;
}
}
function showservicemenu()
{
//alert(document.getElementById("servicesub").checked);
document.getElementById('div_servicemenu').style.display="block";
document.getElementById('div_servicesubmenu').style.display="none";
document.getElementById('txtspan').style.display="block";
// document.getElementById('div_servicesubmenu').innerHTML="";
}
</script>
<?php
$cn = connectdb();
if (isset($_GET['action']) == "add" && $_GET['type'] == "newpage") {
$sqladd = "INSERT INTO contentmanager(page_title,meta_description,meta_keywords,menu_name,page_tpl,page_type) VALUES ('" . seofilter_title(magicquotes($_POST['pagetitle'])) . "','" . seofilter_meta(magicquotes($_POST['metadesc'])) . "','" . seofilter_meta(magicquotes($_POST['metakeywords'])) . "','" . magicquotes($_POST['menuname']) . "','" . urlencode($_POST['FCKeditor1']) . "','newpage')";
$linkadd = mysql_query($sqladd, $cn) or die("Error : " . mysql_error());
echo "<script>alert('Menu Added...'); window.location='contentmanager.php';</script>";
}
if (isset($_GET['action']) == "add" && $_GET['type'] == "linkpage") {
$sqladd = "INSERT INTO contentmanager(menu_name,ex_url,page_type) VALUES ('" . magicquotes($_POST['txtexmenuname']) . "','" . magicquotes($_POST['txtexurl']) . "','linkpage')";
$linkadd = mysql_query($sqladd, $cn) or die("Error : " . mysql_error());
echo "<script>alert('Menu Added...'); window.location='contentmanager.php';</script>";
}
?>
<table align="center" >
<tr>
<?php
$bypass = true;
error_reporting(E_ALL);
ini_set('display_errors', '1');
include_once 'db_connect.php';
$mysqlim = connectdb(true);
$mysqlim2 = connectdb(true);
//Send the mail for stuff coming due that hasnt been completed yet
$mailstmt = $mysqlim->prepare("SELECT notify.NotifyID, tasks_working.Scheduled, tasks_master.Title, users.Email, CURRENT_TIMESTAMP from tasks_working LEFT JOIN tasks_master on tasks_master.TaskID=tasks_working.TaskID LEFT JOIN notify ON notify.TaskID=tasks_master.TaskID LEFT JOIN users on notify.UserID=users.UserID WHERE tasks_working.Scheduled<DATE_ADD(CURRENT_TIMESTAMP, INTERVAL 30 MINUTE) AND tasks_master.Active='Y' AND notify.LastSent<>DATE(NOW()) AND users.Active='Y' AND (tasks_working.CompletedBy='' OR tasks_working.CompletedBy IS NULL OR tasks_working.CompletedBy=0)");
$mailstmt->execute();
$mailstmt->bind_result($rmid, $rmscheduled, $rmtitle, $rmemail, $thistime);
$mailstmt2 = $mysqlim2->prepare("UPDATE notify SET LastSent = NOW() WHERE NotifyID = ?");
while ($mailstmt->fetch()) {
echo $thistime . "Mail to be sent to " . $rmemail . " for " . $rmtitle . " scheduled for " . $rmscheduled . "<br />";
$to = $rmemail;
$subject = "Task Reminder: " . $rmtitle;
$body = "Due: " . $rmscheduled . "\r\n" . "Title: " . $rmtitle;
$headers = 'From: t-sirt-alerts@telecom.co.nz' . "\r\n" . 'Reply-To: t-sirt-alerts@telecom.co.nz' . "\r\n" . 'X-Mailer: PHP/' . phpversion();
if (mail($to, $subject, $body, $headers)) {
echo "Email successfully sent!<br />";
} else {
echo "Email delivery failed -> Please check you web servers mail settings <br />";
}
if (!$mailstmt2->bind_param('i', $rmid)) {
echo "Binding parameters failed: (" . $mailstmt2->errno . ") " . $mailstmt2->error;
}
if (!$mailstmt2->execute()) {
$json[0]['Result'] = "Failed";
$json[0]['Message'] = "Failed to set notification sent NotifyID " . $rmnotify . " error message: (" . $mailstmt2->errno . ") " . $mailstmt2->error;
}
<?php
error_reporting(0);
ini_set('display_errors', '1');
include_once "db_connect.php";
$mysqli = connectdb();
//If we are getting a GET
//set as completed;
if ($_GET['type'] == "a") {
if (isset($_GET['taskid'])) {
if ($_GET['taskid'] != "") {
$statement = $mysqli->prepare("UPDATE tasks_working SET CompletedBy=? WHERE TaskWorkingID=?");
if (!$statement->bind_param('si', $_SESSION['userid'], $_GET['taskid'])) {
echo "Binding parameters failed: (" . $statement->errno . ") " . $statement->error;
}
if (!$statement->execute()) {
$json[0]['Result'] = "Failed";
$json[0]['Message'] = "Failed to updated Task " . $_GET['taskid'] . " error message: (" . $statement->errno . ") " . $statement->error;
} else {
$json[0]['Result'] = "Success";
$json[0]['Message'] = "Successfully set completed TaskID_working " . $_GET['taskid'] . " by user " . $_SESSION['userid'];
}
audit("taskworkingcomplete", $json[0]['Result'] . " " . $json[0]['Message'] . " POSTDATA:" . implode(",", $_POST) . " GETDATA:" . implode(",", $_GET), true);
header("Location: index.php?date=" . $_GET['date']);
$mysqli->close();
exit;
}
}
}
//Set as uncomplted
if ($_GET['type'] == "b") {
</button>
<a class="navbar-brand" href="index.php?page=home">   <span class="glyphicon glyphicon-home"></span> </a>
</div>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li><a href="index.php?page=data-siswa">Manage Data Siswa</a></li>
<li><a href="index.php?page=data-kelas">Manage Kelas</a></li>
<li><a href="index.php?page=data-kelas-siswa">Manage Data Kelas Siswa</a></li>
<li><a href="index.php?page=data-absensi">Manage Data Absensi</a></li>
</ul>
<form method="POST" action="">
<ul class="nav navbar-nav navbar-right">
<li><button type="submit" name="submitlogoutadmin" class="btn btn-danger btn-lg"><span class="glyphicon glyphicon-share-alt"></span>   LOGOUT</button></li>
</ul>
</form>
</div>
</div>
</nav>
<?php
//error_reporting(0);
include "fungsi/fungsi.php";
$conn = connectdb();
if (isset($_POST['submitlogoutadmin'])) {
logoutadmin();
} elseif (isset($_POST['tambahdata'])) {
tambahdataslmw();
} elseif (isset($_POST['editdata'])) {
editdataslmw($id);
}
<?php
include_once "db_connect.php";
$mysqli = connectdb();
$mysqli2 = connectdb();
?>
<!doctype html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta>
<title>Poptask</title>
<?php
include 'script_declarations.php';
?>
<link type="text/css" href="rec/lib/jquery.tools.dateinput.css" rel="stylesheet"></link>
<link type="text/css" href="rec/lib/jquery.tools.overlay.css" rel="stylesheet"></link>
<link type="text/css" href="rec/src/jquery.recurrenceinput.css" rel="stylesheet"></link>
<script type="text/javascript" src="rec/lib/jquery.tmpl-beta1.js"></script>
<script type="text/javascript" src="rec/lib/jquery.tools.dateinput-1.2.7.js"></script>
<script type="text/javascript" src="rec/lib/jquery.tools.overlay-1.2.7.js"></script>
<script type="text/javascript" src="rec/src/jquery.recurrenceinput.js"></script>
<script>
$(function() {
var selecteditems;
$('.taskrow').click(function(){
selecteditem = $(this).attr("taskid");
$('.taskrow').removeClass("selectedrow");
<?php
function Word($var)
{
$pdo = connectdb();
foreach ($var as $data) {
// Recherche de l'id du film dans theMovieDB
$id_movies_tmdb = Search_id_movie($data[FILES_TITLE]);
// Si l'id du film n'est pas trouvé dans theMovieDb alor on continue
if ($id_movies_tmdb === false) {
//log("[Not Found] Movie is not found in tmbd, ".$data["FILES_TITLE"]);
continue;
}
// on va rechercher toutes les informations dans TheMovieDb
$Full_Info = Search_info_movie($id_movies_tmdb);
if (verif_movie($Full_Info, $pdo) === false) {
// On insert les information du films (Title, Year, tagline, Description, poster)
$id_movie_db = Insert_Movie($Full_Info, $pdo);
// la boucle suivant insert si il n'existe pas dans la bdd, le genre et le lie avec l'id du film
foreach ($Full_Info["genres"] as $row) {
if (($id_genres = getidGenre(get_object_vars($row)["name"], $pdo)) === false) {
$id_genres = Insert_Genre(get_object_vars($row)["name"], $pdo);
}
insert_genres_Movie($id_genres, $id_movie_db, $pdo);
}
// meme boucle que ci-dessus mais pour les countries
foreach ($Full_Info["production_countries"] as $row) {
if (($id_countrie = getidCountries(get_object_vars($row)["name"], $pdo)) === false) {
$id_countrie = Insert_Countries(get_object_vars($row)["name"], $pdo);
}
insert_countrie_movie($id_countrie, $id_movie_db, $pdo);
}
foreach ($Full_Info["production_companies"] as $row) {
if (($id_studios = getidstudios(get_object_vars($row)["name"], $pdo)) === false) {
$id_studios = Insert_studios(get_object_vars($row)["name"], $pdo);
}
insert_studios_Movie($id_studios, $id_movie_db, $pdo);
}
// ci dessous je vais inserer les acteurs du film, mais pas tous, je prend que les 10 principaux
$id_role = getrollebyid("Acteur", $pdo);
for ($i = 0; $i < 10; $i++) {
if (($idPeople = getidPeople(get_object_vars(get_object_vars($Full_Info["casts"])["cast"][$i])["name"], $pdo)) === false) {
$idPeople = insert_people(get_object_vars(get_object_vars($Full_Info["casts"])["cast"][$i])["name"], $pdo);
}
insert_people_role_movies($idPeople, $id_role, $id_movie_db, $pdo);
}
// insert crew, director, writer and producer.
foreach (get_object_vars($Full_Info["casts"])["crew"] as $data) {
$data = get_object_vars($data);
switch ($data["job"]) {
case 'Producer':
case 'Director':
case 'Writer':
if ($id_crew = getidPeople($data["name"], $pdo) === false) {
$id_crew = insert_people($data["name"], $pdo);
}
$id_role = getrollebyid($data["job"], $pdo);
insert_people_role_movies($id_crew, $id_role, $id_movie_db, $pdo);
break;
}
}
}
// On update dans la table files le fkmovie pour correspondre à ce que jonathan à inseré
if (isset($data[FILES_ID]) && isset($id_movie_db)) {
Update_files($id_movie_db, $data[FILES_ID], $pdo);
}
//var_dump($id_movie_db);
//var_dump($Full_Info);
print_r($Full_Info);
}
return;
}
function insert($idhh, $idloaitt, $idtt, $dongia)
{
$query_str = "insert into hanghoa_thuoctinh_tbl (IDLoaiTT, IDTT, IDHH, DonGia) values ('" . $idloaitt . "', '" . $idtt . "', '" . $idhh . "', '" . $dongia . "')";
$query_exc = mysql_query($query_str, connectdb()) or die(mysql_error());
return $query_exc;
}
