本文整理汇总了PHP中database::send_sql方法的典型用法代码示例。如果您正苦于以下问题：PHP database::send_sql方法的具体用法？PHP database::send_sql怎么用？PHP database::send_sql使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类database的用法示例。
在下文中一共展示了database::send_sql方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getAllCategoriesDetails
function getAllCategoriesDetails()
{
$db = new database();
$db->pick_db("workoutlog");
$res = $db->send_sql("SELECT table_name, column_name, data_type FROM information_schema.columns WHERE table_schema='workoutlog' and table_name LIKE 'tbl_workoutlog_category_%'");
$categories = $res->fetch_all(MYSQLI_ASSOC);
foreach ($categories as $category) {
$categoryName = substr($category['table_name'], 24);
$columnName = $category['column_name'];
$columnDataType = $category['data_type'];
if (strtolower($columnName) != strtolower($categoryName . "Id") && strtolower($columnName) != strtolower("ExerciseId")) {
$allCategoriesDetails[$categoryName][$columnName] = $columnDataType;
}
}
return json_encode($allCategoriesDetails);
}示例2: database
</form>
</div>
</div>
<div class="container">
<fieldset>
<legend>Content</legend>
<?php
//change to your path
include "./include/DB.php";
$LIMITATION = 10;
$db = new database();
$db->connect();
$query_question = "SELECT user.Name,questions.Title,questions.time,questions.QID\n FROM `user` \n INNER JOIN `questions`\n ON user.UID=questions.UID\n";
if (!($res_question = $db->send_sql($query_question))) {
$db->disconnect();
echo "Get Questions failed!<br>\n";
return -1;
}
$num = mysqli_num_rows($res_question);
$i = 0;
while ($i < $num) {
$content = $res_question->fetch_assoc();
$content_question[$i][0] = $content['Name'];
$content_question[$i][1] = $content['Title'];
$content_question[$i][2] = $content['time'];
$content_question[$i][3] = $content['QID'];
$i++;
}
$i = 0;示例3: implode
}
return implode($pass);
//turn the array into a string
}
$db = new database();
$db->setup(DB_USER, DB_PASS, DB_HOST, DB_NAME);
if ($_POST["proftype"] == "advisor") {
ini_set('SMTP', 'localhost');
ini_set('sendmail_from', 'kjp396@gmail.com');
$header = 'From: webmaster@example.com' . "\r\n" . 'Reply-To: webmaster@example.com' . "\r\n" . 'X-Mailer: PHP/' . phpversion();
$rpass = randomPassword();
echo "Advisor has been created and password is ";
echo $rpass;
//mail($profmail,"password for subject waiver account",$rpass,$header);
$createinstructor = "INSERT INTO instructor (i_id, i_name,ph_no,i_email,advisor_bool,admin_bool,department) VALUES ('" . $profid . "', '" . $profname . "', '" . $profphone . "', '" . $profmail . "', '1', '0','" . $profdept . "')";
$db->send_sql($createinstructor);
$hpassword = md5($rpass);
//Hashing the password
$createlogin = "INSERT INTO login(id,password)VALUES('" . $profid . "','" . $hpassword . "')";
$db->send_sql($createlogin);
} elseif ($_POST["proftype"] == "admin") {
$createinstructor = "INSERT INTO instructor (i_id, i_name,ph_no,i_email,advisor_bool,admin_bool,department) VALUES ('" . $profid . "', '" . $profname . "', '" . $profphone . "', '" . $profmail . "', '0', '1','" . $profdept . "')";
$db->send_sql($createinstructor);
$rpass = randomPassword();
echo "Admin has been created and password is ";
echo $rpass;
$hpassword = md5($rpass);
//Hashing the password
$createlogin = "INSERT INTO login(id,password)VALUES('" . $profid . "','" . $hpassword . "')";
$db->send_sql($createlogin);
} else {示例4: database
header('Content-Type: application/json');
$db = new database();
$results = array();
if (isset($_POST['post']) && isset($_POST['for_name']) && $_POST['post'] != '') {
if (isset($_POST['showName'])) {
$showName = $db->escape($_POST['showName']);
if ($showName === true || $showName === 'true') {
$showName = 1;
} else {
$showName = 0;
}
} else {
$showName = 0;
}
if ($session->checkLoggedIn() === true) {
$db->send_sql("insert into ownage(u_id) values ('{$session->uid}')");
$ownage = $db->insert_id();
date_default_timezone_set('UTC');
$post = $db->escape($_POST['post']);
$for_name = $db->escape($_POST['for_name']);
$query = 'insert into posts(u_id, post, showName, ownage_id, for_name) values (\'' . $session->uid . '\', \'' . $post . '\', \'' . $showName . '\', \'' . $ownage . '\', \'' . $for_name . '\')';
$db->send_sql($query);
array_push($results, "success");
} else {
array_push($results, "Please log in");
}
} else {
if (isset($_POST['delete']) && $_POST['delete'] != '') {
$delete = $db->escape($_POST['delete']);
if ($session->isAdmin()) {
$query = 'update posts set hidden=1 where p_id=\'' . $delete . '\'';示例5: database
<?php
session_start();
include "databaseClassMySQLi.php";
//include("projconfig.php");
$db = new database();
$db->setup(DB_USER, DB_PASS, DB_HOST, DB_NAME);
if (isset($_POST['sit']) && isset($_POST['password'])) {
$sit = addslashes(strip_tags($_POST['sit']));
$password = md5($_POST['password']);
$sql = "SELECT * FROM login WHERE id='{$sit}' AND password='{$password}' ";
$res = $db->send_sql($sql);
$row = mysqli_num_rows($res);
if ($row > 0) {
$_SESSION['cwid'] = $sit;
echo 'true';
} else {
echo 'false';
}
}示例6: database
if (!isset($_POST["submit"])) {
echo 'Please use the form to enter the fields';
} else {
$courseprofname = $_POST["courseprofname"];
$db1 = new database();
$db1->setup(DB_USER, DB_PASS, DB_HOST, DB_NAME);
$courseprofid = "SELECT i_id FROM instructor WHERE i_name='" . $courseprofname . "'";
$res = $db1->send_sql($courseprofid);
$courserefid = "SELECT course_id FROM course WHERE i_id='" . $row['i_id'] . "'";
$res1 = $db1->send_sql($courserefid);
$db2 = new database();
$db2->setup(DB_USER, DB_PASS, DB_HOST, DB_NAME);
while (($fetch = mysqli_fetch_array($res1)) != NULL) {
$row = $db1->next_row();
$selfile = "SELECT subq_id FROM files WHERE course_id='" . $row1['course_id'] . "'";
$res3 = $db2->send_sql($selfile);
$row3 = $db2->next_row();
$selsubq = "SELECT s_id FROM submissionqueue WHERE subq_id='" . $row3['subq_id'] . "'";
$res4 = $db2->send_sql($selsubq);
$row4 = $db2->next_row();
$delstud = "DELETE FROM student WHERE s_id='" . $row4['s_id'] . "'";
$res5 = $db2->send_sql($delstud);
$delsubq = "DELETE FROM submissionqueue WHERE subq_id='" . $row3['subq_id'] . "'";
$res6 = $db2->send_sql($delsubq);
/*$delfile="DELETE FROM files WHERE course_id='".$row1['course_id']."'";
$res7=$db1->send_sql($delfile);
/*$delsubt="DELETE FROM submissiontype WHERE course_id='".$row1['course_id']."'";
$res8=$db1->send_sql($delsubt);*/
$delcoursename = "DELETE FROM course WHERE course_id='" . $row['i_id'] . "'";
$res9 = $db2->send_sql($delcoursename);示例7: database
<head>
<title>File upload</title>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body bgcolor="#E6E6FA">
<form id = "theForm" action = "add_file.php" method = "POST" enctype = "multipart/form-data">
<?php
include "headerStudent.php";
include "databaseClassMySQLi.php";
//include("projconfig.php");
$databaseObj = new database();
$databaseObj->setup(DB_USER, DB_PASS, DB_HOST, DB_NAME);
$courseid = addslashes(strip_tags($_POST["course"]));
$query = "SELECT * FROM submissiontype WHERE course_id='" . $courseid . "'";
$result = $databaseObj->send_sql($query);
while ($row = $databaseObj->next_row()) {
$jsonData = stripslashes($row['submission_type']);
$jsonArray = json_decode($jsonData, true);
foreach ($jsonArray as $key => $key_v) {
echo "<b>" . $key . ":</b><br>";
foreach ($key_v as $value => $element) {
echo "<label for='{$element}'>{$element}</label>";
echo "<input type='file' name='{$element}' /><br/>";
}
}
}
?>
<input type ="hidden" name = "hid" value = "<?php
if (isset($_POST['course'])) {
echo $_POST['course'];示例8: database
ob_start();
session_start();
include "databaseClassMySQLi.php";
//include("projconfig.php");
$db = new database();
$db->setup(DB_USER, DB_PASS, DB_HOST, DB_NAME);
$datab = new database();
$datab->setup(DB_USER, DB_PASS, DB_HOST, DB_NAME);
if (isset($_POST['sit']) && isset($_POST['password'])) {
$sid = addslashes(strip_tags($_POST['sit']));
$password = md5($_POST['password']);
// $password=$_POST['password'];
$sit = intval($sid);
$queryIns = "SELECT * FROM instructor WHERE i_id=" . $sit;
$query = "SELECT * FROM login WHERE id='{$sit}' AND password='{$password}' ";
$res1 = $db->send_sql($queryIns);
$row1 = mysqli_num_rows($res1);
$ans = mysqli_fetch_array($res1);
$admin_bool = $ans['admin_bool'];
$res = $datab->send_sql($query);
$row = mysqli_num_rows($res);
if ($row1 > 0) {
if ($row > 0) {
$_SESSION['admin_bool'] = $admin_bool;
$_SESSION['cwid'] = $sit;
echo 'true';
}
} else {
echo 'false';
}
}示例9: database
include "Includes/commonFuncs.php";
if (isset($_POST["exercises"]) && isset($_POST["date"]) && isset($_SESSION["username"])) {
$exercises = $_POST["exercises"];
$date = $_POST["date"];
$username = $_SESSION["username"];
$db = new database();
$db->pick_db("workoutlog");
$userId = getUserIdFromUsername($username);
if ($userId != null) {
//Add workout to tbl_workoutlog_workout, get workoutId
$stmt = $db->prepare("INSERT INTO tbl_workoutlog_workout (UserId, WorkoutDate) VALUES (?, STR_TO_DATE(?, '%Y-%m-%d'))");
$stmt->bind_param('is', $userId, $date);
$stmt->execute();
if ($stmt->affected_rows == 1) {
$stmt->free_result();
$res = $db->send_sql("SELECT LAST_INSERT_ID() AS Id");
if ($res->num_rows > 0) {
$row = $res->fetch_assoc();
$workoutId = $row['Id'];
foreach ($exercises as $exercise) {
//Add each exercise to tbl_WorkoutLog_Exercise linking to the workoutId
$stmt = $db->prepare("SELECT ExerciseNameId FROM tbl_workoutlog_exercisename WHERE ExerciseName = ?");
$stmt->bind_param('s', $exercise['name']);
$stmt->execute();
$stmt->bind_result($exerciseNameId);
$stmt->fetch();
$stmt->free_result();
if ($exerciseNameId == null) {
//New exercise name, add it to tbl_workoutlog_exercisename
$stmt = $db->prepare("INSERT INTO tbl_workoutlog_exercisename (ExerciseName, ExerciseCategory) VALUE (?, ?)");
$stmt->bind_param('ss', $exercise['name'], $exercise['category']);示例10: header
<?php
ob_start();
session_start();
if (!isset($_SESSION['username'])) {
header('Location:index.php');
}
include "./Class_Database.php";
$db = new database();
//$db->setup("kaushal", "kaushal", "localhost", "jobportaldb");
$userid = $_GET['id'];
$query = "Select * from users where id_user={$userid}";
$res = $db->send_sql($query);
if (mysql_num_rows($res) > 0) {
while ($row = mysql_fetch_array($res)) {
$to = stripslashes($row["email_user"]);
}
}
if (isset($res)) {
unset($res);
}
$username = $_SESSION['username'];
$query1 = "Select * from admin where username='{$username}' and usertype='admin'";
$res1 = $db->send_sql($query1);
if (mysql_num_rows($res1) > 0) {
while ($row = mysql_fetch_array($res1)) {
$from = stripslashes($row["email"]);
}
}
?>
<html xmlns="http://www.w3.org/1999/xhtml">示例11: database
<header> <h1> Waiver Request Form</h1><header>
<div id="form">
<form id="theForm" method="post" action="upload.php" >
<p><label>Select your major:</label>
<select name="department" required="">
<option value="" disabled selected>---Select your major-----</option>
<?php
include "databaseClassMySQLi.php";
//include ("projconfig.php");
$db = new database();
$db->setup(DB_USER, DB_PASS, DB_HOST, DB_NAME);
$res = $db->send_sql("SELECT DISTINCT department FROM course");
$db1 = new database();
$db1->setup(DB_USER, DB_PASS, DB_HOST, DB_NAME);
$res1 = $db1->send_sql("SELECT DISTINCT course_id FROM course");
while (($row = mysqli_fetch_array($res)) != NULL) {
echo "<option>" . $row['department'] . "</option>";
}
?>
</select></p><br>
<p> <label for="course">Select the course you wish to enroll:</label>
<select name="course" required="">
<option value="" disabled selected>-----Select the course you want the waiver for----</option>
<?php
while (($row = mysqli_fetch_array($res1)) != NULL) {
echo "<option>" . $row['course_id'] . "</option>";
}示例12: database
<header>
<center><h1>Remove Instructor and Remove Course Form</h1></center>
</header>
<div class="form">
<form id="deletecourse1" name="deletecourse1" action="deletecourse2.php" method="post">
<p><label>Enter the instructor you wish to remove</label></p><br>
<select name="courseprofname">
<option>---Select the name of the professor---</option>-->
<?php
include "databaseClassMySQLi.php";
$db = new database();
$db->setup(DB_USER, DB_PASS, DB_HOST, DB_NAME);
$res = $db->send_sql("SELECT * FROM instructor");
while (($row = mysqli_fetch_array($res)) != NULL) {
echo "<option>" . $row['i_name'] . "</option>";
}
?>
</select><br><br>
<input type="submit" name="submit">
</form>
</div>
</div>
</body>
</html>示例13: database
<p><label>Enter the pre-requisite course required</label></p><br>
<input type="text" name="prerequisite" pattern="^[a-zA-Z]{2,3}[0-9]{3}" title="Enter valid course ID, eg:CS123" required=""><br>
<p><label>Enter the name of the professor</label></p><br>
<select name="courseprofname" required="">
<option>---Select the name of the professor---</option>-->
<?php
include "databaseClassMySQLi.php";
//include("projconfig.php");
$db = new database();
$db1 = new database();
$db->setup(DB_USER, DB_PASS, "localhost", DB_NAME);
$db1->setup(DB_USER, DB_PASS, "localhost", DB_NAME);
$res = $db->send_sql("SELECT DISTINCT i_name FROM instructor");
$res1 = $db1->send_sql("SELECT DISTINCT department FROM course");
//$num_row= mysqli_num_rows($res);
while (($row = mysqli_fetch_array($res)) != NULL) {
//$row = $db->next_row();
echo "<option>" . $row['i_name'] . "</option>";
//$num_row=$num_row-1;
}
?>
</select>
<p><label>Enter the name of the major</label></p><br>
<select name="coursemajor" required="">
<option>---Select the name of the major---</option>
<option value="NONE">---Select your major---
<option value="BME">Biomedical Engineering示例14: addslashes
<fieldset>
<legend>Search Result</legend>
<?php
$search_word = $_POST["search_input"];
if (empty($search_word)) {
echo "None input";
} else {
$search_word2 = addslashes($search_word);
//echo $search_word2;
include "../include/DB.php";
$db = new database();
$db->connect();
$query_search_title = "SELECT user.Name,questions.Title,questions.time,questions.QID\r\n\t From `user`\r\n\t\t\t\t INNER JOIN `questions`\r\n\t\t\t\t ON user.UID=questions.UID\r\n\t\t\t\t where Title Like '%{$search_word2}%'\r\n\t";
$query_search_content = "SELECT user.Name,questions.Content,questions.time,questions.QID,questions.Title\r\n\t From `user`\r\n\t\t\t\t\t\t INNER JOIN `questions`\r\n\t\t\t\t\t\t ON user.UID=questions.UID\r\n\t\t\t\t\t\t where Content LIKE '%{$search_word2}%'\r\n\t";
if (!($res_search = $db->send_sql($query_search_title))) {
$db->disconnect();
echo "Get search result failed!<br>\n";
return -1;
}
$i = 0;
$num_title = mysqli_num_rows($res_search);
while ($i < $num_title) {
$content = $res_search->fetch_assoc();
$str = $content['Title'];
$rep = "<span style=\"background-color: #66CCFF\">" . $search_word . "</span>";
$str = preg_replace('/' . $search_word . '/i', $rep, $str);
echo "<div class=\"jumbotron\">\n";
echo "<h4><a href=\"edit_answer.php?var=" . $content['QID'] . "\" >" . $str . "</a></h4>\n";
echo "<h6>Poster:" . $content['Name'] . "</h6>\n";
echo "<h6>Time:" . $content['time'] . "</h6>\n";示例15: database
<?php
//get
//votePost.php?p_id=1&up
//votePost.php?p_id=1&down
require_once "include/databaseClassMySQLi.php";
require_once "include/session.php";
header('Content-Type: application/json');
$db = new database();
$results = array();
if (isset($_POST['p_id']) && $_POST['p_id'] != '') {
$p_id = $db->escape($_POST['p_id']);
if (isset($_POST['up'])) {
$query = 'select value from post_votes where p_id=\'' . $p_id . '\' and u_id=\'' . $session->uid . '\'';
$db->send_sql($query);
$row = $db->next_row();
if ($row === false || empty($row)) {
$query = 'insert into post_votes (p_id, u_id, value) values(\'' . $p_id . '\', \'' . $session->uid . '\', 1)';
$db->send_sql($query);
$query = 'update posts set votes = votes + 1 where p_id=' . $p_id;
$db->send_sql($query);
} else {
$query = 'update post_votes set value=1 where p_id=\'' . $p_id . '\' and u_id=\'' . $session->uid . '\'';
$db->send_sql($query);
$value = $row['value'];
if ($value == -1) {
$query = 'update posts set votes = votes + 2 where p_id=\'' . $p_id . '\'';
$db->send_sql($query);
}
}
} else {