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; }