function getTrendingArtists() { $artist = array(); $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } $file = "http://plato.cs.virginia.edu/~ams5da/ListenUp/text/trendingArtists.txt"; $lines = file($file); foreach ($lines as $line) { $array = explode("\n", $line); array_push($artist, trim($array[0])); } $stmt = $db_connection->stmt_init(); $stmt->prepare("SELECT * FROM Artists"); $stmt->execute(); $stmt->bind_result($a_id, $a_Name, $top_songs_key, $bio); while ($stmt->fetch()) { if (in_array($a_id, $artist)) { echo '<a id="' . $top_songs_key . '" class="list-group-item"><button onclick="display(this,\'' . $a_Name . '\', \'' . $a_id . '\', \'' . $bio . '\')" id="playSong" class ="btn btn-mini"><i class="fa fa-play"></i></button>' . $a_Name . '</a>'; } } $stmt->close(); }
function bindItems($table, $name1, $name2, $id1, $id2) { $mysqli = new mysqli(DB_HOST, DB_LOGIN, DB_PASSWORD, DB_NAME); $stmt = $mysqli->stmt_init(); if ($stmt->prepare("INSERT INTO {$table} ({$name1}, {$name2}) VALUES (?,?)")) { $stmt->bind_param("ii", $id1, $id2); $stmt->execute(); $stmt->close(); $mysqli->close(); return true; } return false; }
/** * Prepares a statement or uses an instance from the cache * * @param string $strQuery * * @return mysqli_stmt */ private function getPreparedStatement($strQuery) { $strName = md5($strQuery); if (isset($this->arrStatementsCache[$strName])) { return $this->arrStatementsCache[$strName]; } $objStatement = $this->linkDB->stmt_init(); if (!$objStatement->prepare($strQuery)) { $this->strErrorMessage = $objStatement->error; return false; } $this->arrStatementsCache[$strName] = $objStatement; return $objStatement; }
function deleteSongFromPlaylist($p_id, $s_id) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } //DELETE FROM `Contains` WHERE `Contains`.`p_id` = 7 AND `Contains`.`s_id` = \'t55174310\'"? $stmt = $db_connection->stmt_init(); if ($stmt->prepare("Delete from `Contains` where p_id={$p_id} and s_id='{$s_id}'")) { $stmt->bind_param('is', $p_id, $s_id); $stmt->execute(); } }
/** * Simple function to insert data into the database in preparation * @param mysqli $db * @param $firstname * @param $lastname * @param $age * @param $createdDate * @param $balance * @throws Exception */ private function rawRowInsert(mysqli $db, $firstname, $lastname, $age, $createdDate, $balance) { if (!($statement = $db->stmt_init())) { throw new Exception('Error creating prepared statement: ' . $db->error); } if (!$statement->prepare('INSERT INTO people (firstname, lastname, age, createdDate, balance) VALUES (?, ?, ?, ?, ?)')) { throw new Exception('Error preparing insert query: ' . $statement->error); } if (!$statement->bind_param('ssisd', $firstname, $lastname, $age, $createdDate, $balance)) { throw new Exception('Error binding parameters: ' . $statement->error); } if (!$statement->execute()) { throw new Exception('Error executing parameters'); } }
function unsubscribeFromPlaylist($p_id, $username) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } //echo "Connection made!"; // "DELETE FROM `cs4750ams5da`.`Subscribes_to` WHERE `Subscribes_to`.`Username` = \'ams5da\' AND `Subscribes_to`.`p_id` = 2"? $stmt = $db_connection->stmt_init(); if ($stmt->prepare("Delete FROM Subscribes_to WHERE Username = ? and p_id = ?")) { $stmt->bind_param("si", $username, $p_id); $stmt->execute(); } }
function updatePlaylistName($p_id, $new_p_name) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } $stmt = $db_connection->stmt_init(); if ($stmt->prepare("UPDATE `Playlists` SET `p_name`= ? WHERE `p_id` = ?")) { $stmt->bind_param("si", $new_p_name, $p_id); $stmt->execute(); //echo $userID; while ($stmt->fetch()) { } } }
function getAllSongs($userID) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } //original query "select s_id, Title, a_name FROM `Songs` natural join `Performed_by` where Songs.s_id = Performed_by.s_id" $stmt = $db_connection->stmt_init(); if ($stmt->prepare("select s_id, Title, a_name FROM song_artist_album ORDER BY `song_artist_album`.`Title` ASC")) { $stmt->execute(); $stmt->bind_result($s_id, $title, $name); while ($stmt->fetch()) { echo "<li id=" . $s_id . " onclick=\"play(this.id)\"><a href=\"javascript:;\">" . $title . " - " . $name . "</a></li>"; } } }
public function insert($table, array $data) { //create prepare statement, etc. INSERT INTO `people` (`firstname`, `lastname`, `age`, `createdDate`) VALUES (?, ?, ?, ?) $keys = array_keys($data); $dbColumnName = '('; foreach ($keys as $key) { $dbColumnName .= '`' . $key . '`, '; } $dbColumnName = substr($dbColumnName, 0, -2); $dbColumnName .= ')'; $table = 'INSERT INTO `' . $table . '` ' . $dbColumnName; $numberOfValues = count($data); $values = $this->_createValues($numberOfValues); $dataType = $this->_checkTypeOfValues($data); $type = ''; //getting first letter from each of value type foreach ($dataType as $word) { $letter = substr($word, 0, 1); $type .= $letter; } $dataValues = count($data) >= 1 ? ' VALUES (' . $values . ')' : ''; $sql = $table . $dataValues; //$stmt initialization $stmt = self::$_db->stmt_init(); //prepare statement if ($sqlPrepare = $stmt->prepare($sql)) { $whereClause = $this->createParameters($data); $values = array(); $v = $whereClause->getValues(); foreach ($v as &$value) { array_push($values, &$value); } $typeList = $whereClause->getTypeList(); $functionParams = array_merge(array(&$typeList), $values); call_user_func_array(array($stmt, 'bind_param'), $functionParams); $result = $stmt->execute(); if (true === $result) { return $stmt->insert_id; } else { throw new Exception('Error: ' . $stmt->error); } $stmt->close(); } else { throw new Exception("Error: " . $stmt->error); } }
function subscribeToPlaylist($p_id, $username, $p_name) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } //echo "Connection made!"; //SELECT Title, a_name FROM `Contains`NATURAL JOIN Performed_by where Contains.s_id = Performed_by.s_id and Contains.p_id = '7' //select Subscribes_to.p_id, Subscribes_to.p_name, Username, al_art_URL from Subscribes_to Join Playlists where Subscribes_to.p_id = Playlists.p_id AND Username = '******' and Subscribes_to.p_name = 'Work out!!!!' and Subscribes_to.p_id = 5 //echo $p_name; $defaultIcon = "images/default-playlist-artwork.png"; //First check if user is already subscribed to the playlist //Then if not, get the album URL $stmt = $db_connection->stmt_init(); if ($stmt->prepare("SELECT * FROM Subscribes_to WHERE Username = ? and p_id = ? and p_name = ?")) { $stmt->bind_param("sis", $username, $p_id, $p_name); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($user, $pid, $pname); $stmt->fetch(); //echo $stmt->num_rows; if ($stmt->num_rows == 0) { $art_URL; if ($stmt->prepare("Select al_art_URL from Playlists WHERE p_id = ?")) { $stmt->bind_param("s", $p_id); $stmt->execute(); $stmt->bind_result($artURL); while ($stmt->fetch()) { $art_URL = $artURL; if (!isset($art_URL) || trim($art_URL) === '') { $art_URL = $defaultIcon; } //echo $artURL; } } if ($stmt->prepare("INSERT into Subscribes_to(Username, p_id, p_name) VALUES (?, ?, ?)")) { $stmt->bind_param("sis", $username, $p_id, $p_name); $stmt->execute(); echo "<div class=\"content-grid\" id=\"" . $p_id . "\"><a href=\"#\" onClick=\"play(" . $p_id . ", '" . addslashes($p_name) . "')\"><img src=\"" . $art_URL . "\" title=\"album-name\" /></a><h3>" . $p_name . "</h3><ul><button type=\"button\" class=\"btn btn-danger btn-sm\" onClick=\"Unsubscribe(" . $p_id . ")\">Unsubscribe</button></ul></div>"; } } } }
/** * @param DbRequestInterface $request * @return DbReponseInterface */ public function execute(MysqliDriver $driver, DbRequestInterface $request, DbResponseInterface $response) { $stmt = new PreparedStmt($driver->stmt_init()); $stmt->prepare($request->getSql()); if ($stmt->isError()) { $error = $stmt->getError(); $response->addError($error['error-text'], $error['error-nbr']); return $response; } /* normalize and bind parameters */ if ($request->isValues()) { $stmt->organizeParams($request->getValues()); if ($stmt->isError()) { $error = $stmt->getError(); $response->addError($error['error-text'], $error['error-nbr']); return $response; } } $stmt->execute(); if ($stmt->isError()) { $error = $stmt->getError(); $response->addError($error['error-text'], $error['error-nbr']); return $response; } $isOrganized = $stmt->organizeResults(); if ($stmt->isError()) { $error = $stmt->getError(); $response->addError($error['error-text'], $error['error-nbr']); return $response; } /* database executed the query successfully and * no results are needed */ if ($isOrganized && !$stmt->isResultset()) { return $response; } $stmt->storeResults(); $errorStack = $response->getErrorStack(); $data = $stmt->fetch($errorStack, $request->getCallback()); if (is_array($data)) { $response->setResultSet($data); } return $response; }
function addSongToPlaylist($songID, $songTitle, $playlistID, $playlistName, $a_Name) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5da', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } $songTitle = addslashes($songTitle); $playlistName = addslashes($playlistName); //INSERT INTO Contains (`p_id`, `s_id`, `p_name`, `Title`) VALUES (7, 't55174310', 'Fav Songs', 'Always In My Head') //echo($playlistID . " " . $playlistName . " " . $songID . " " . $songName); $stmt = $db_connection->stmt_init(); if ($stmt->prepare("Insert into `Contains` (`p_id`, `s_id`, `p_name`, `Title`) VALUES ({$playlistID}, '{$songID}', '{$playlistName}', '{$songTitle}')")) { $stmt->bind_param('isss', $songID, $songTitle, $playlistID, $playlistName); $stmt->execute(); //echo("executed"); echo "<li id=" . $songID . " class=\"list-group-item\"><button id=\"deleteSong\" onclick=\"DeleteSongFromPL(this)\" class = \"btn btn-mini\"><i class=\"fa fa-times\"></i></button> " . $songTitle . " - " . $a_Name . "</li>"; } }
function getLikedSongs($u_id) { $uName = $_SESSION['loggedin']; $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } $stmt = $db_connection->stmt_init(); if ($stmt->prepare("SELECT Title, a_name, s_id FROM `Likes` NATURAL Join `Songs` NATURAL Join `Performed_by` WHERE username = '******'")) { $stmt->bind_param("s", $uName); $stmt->execute(); $stmt->bind_result($title, $name, $s_id); while ($stmt->fetch()) { //echo($name ." ". $title . "\n"); echo '<a id="' . $s_id . '" class="list-group-item"><button onclick="play(\'' . $s_id . '\')" id="playSong" class ="btn btn-mini"><i class="fa fa-play"></i></button>' . $title . ' - ' . $name . '</a>'; } } }
function getSongsInPlaylist($p_id) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } //echo "Connection made!"; //SELECT Title, a_name FROM `Contains`NATURAL JOIN Performed_by where Contains.s_id = Performed_by.s_id and Contains.p_id = '7' $stmt = $db_connection->stmt_init(); if ($stmt->prepare("select s_id, Title, a_name FROM `Contains` natural join `Performed_by` where Contains.s_id = Performed_by.s_id and Contains.p_id = '{$p_id}'")) { $stmt->bind_param("i", $p_id); $stmt->execute(); $stmt->bind_result($s_id, $Title, $name); while ($stmt->fetch()) { echo "<li id=" . $s_id . " class=\"list-group-item\"><button id=\"deleteSong\" onClick='DeleteSongFromPL(this)' class = \"btn btn-mini\"><i class=\"fa fa-times\"></i></button> " . $Title . " - " . $name . "</li>"; } } }
function addSongToLikes($user, $songID, $songName) { //echo ("in php: " . $user . ", " . $songID . ", " . $songName); $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } $songName = addslashes($songName); $stmt = $db_connection->stmt_init(); if ($stmt->prepare("INSERT INTO `Likes`(`Username`, `s_id`, `Title`, `likes?`) VALUES (?,?,?, 1)")) { $stmt->bind_param("sss", $user, $songID, $songName); $stmt->execute(); $stmt->bind_result(); while ($stmt->fetch()) { //echo($name ." ". $title . "\n"); echo "Added " . $songName . " for " . $user; } } }
function getAllPlaylists($userID) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } $defaultIcon = "images/default-playlist-artwork.png"; $stmt = $db_connection->stmt_init(); if ($stmt->prepare("SELECT * FROM Playlists")) { $stmt->execute(); $stmt->bind_result($p1, $playlistname, $iconURL); while ($stmt->fetch()) { if (!isset($iconURL) || trim($iconURL) === '') { $iconURL = $defaultIcon; } echo "<div class=\"content-grid\" style=\"width: 10%;\"><a href=\"#\" onClick=\"play(" . $p1 . ", '" . addslashes($playlistname) . "')\"><img src=\"" . $iconURL . "\" title=\"album-name\" /></a><h3>" . $playlistname . "</h3><ul><button id=" . $p1 . " type=\"button\" class=\"btn btn-info btn-sm\" onclick=\"editPlaylist(this.id, '" . addslashes($playlistname) . "')\"><i class=\"fa fa-pencil\"></i> Edit Me</button></ul></div>"; } } }
function getSpecificSongs($query) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } $query = addslashes($query); //SELECT DISTINCT s_id, Title FROM `Songs` where UPPER(Title) like UPPER('%r%') $stmt = $db_connection->stmt_init(); if ($stmt->prepare("SELECT DISTINCT s_id, Title, a_Name FROM Performed_by where UPPER(Title) like UPPER('%{$query}%')")) { $stmt->bind_param('s', $query); $stmt->execute(); $stmt->bind_result($s_id, $Title, $a_Name); echo "<ul class=\"list-group\">"; while ($stmt->fetch()) { echo '<a id="' . $s_id . '" class="list-group-item"><button onclick="AddSongToPL(this, \'' . addslashes($Title) . '\', \'' . addslashes($a_Name) . '\')" id="addSong" class = "btn btn-mini"><i class="fa fa-plus-circle"></i><button onclick="PlaySong(this)" id="playSong" class ="btn btn-mini"><i class="fa fa-play"></i></button>' . $Title . ' - ' . $a_Name . '<button id="like" onclick="likeSong(this, \'' . addslashes($Title) . '\')" class="btn btn-mini"><i class="fa fa-thumbs-o-up"></i></button></a>'; } echo "</ul>"; } }
function getSongsInPlaylist($p_id) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } //echo "Connection made!"; //SELECT Title, a_name FROM `Contains`NATURAL JOIN Performed_by where Contains.s_id = Performed_by.s_id and Contains.p_id = '7' $stmt = $db_connection->stmt_init(); if ($stmt->prepare("select s_id, Title, a_name FROM `song_artist_album` natural join `Contains` where song_artist_album.s_id = Contains.s_id and Contains.p_id = '{$p_id}'")) { $stmt->bind_param("i", $p_id); $stmt->execute(); $stmt->bind_result($s_id, $title, $name); while ($stmt->fetch()) { //echo($name ." ". $title . "\n"); /* echo('<li id="' . $s_id. '" onclick="play(this.id)"><a href="javascript:;">' . $title . ' - ' . $name . ' ' . '</a><button id="like" class="btn btn-mini"><i class="fa fa-thumbs-o-up"></i></button></li><input type="image" src="images/likes.png" id="' . $s_id. '" onClick="likeSong(this, \'' . addslashes($title) . '\')"/>');*/ echo '<a id="' . $s_id . '" class="list-group-item"><button onclick="play(this)" id="playSong" class ="btn btn-mini"><i class="fa fa-play"></i></button>' . $title . ' - ' . $name . '<button onclick="likeSong(this, \'' . addslashes($title) . '\')" id="like" class="btn btn-mini" ><i class="fa fa-thumbs-o-up"></i></button></a>'; } } }
function addPlaylist($p_name) { $uName = $_SESSION['loggedin']; $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } $p_name = addslashes($p_name); //SELECT Title, a_name FROM `Contains`NATURAL JOIN Performed_by where Contains.s_id = Performed_by.s_id and Contains.p_id = '7' $stmt = $db_connection->stmt_init(); if ($stmt->prepare("INSERT INTO `Playlists`(`p_name`, `al_art_URL`) VALUES (?, 'images/default-playlist-artwork.png')")) { $stmt->bind_param('s', $p_name); $stmt->execute(); //$stmt->bind_result($title, $name, $s_id); } //CREATED TRIGGER FOR THESE QUERIES INSTEAD // if($stmt->prepare("SELECT `p_id` FROM `Playlists` WHERE `p_name` = ?")) { // $stmt->bind_param("s", $p_name); // $stmt->execute(); // $stmt->bind_result($p_id); // while($stmt->fetch()) { // echo("2: " . $p_name); // } // } // if($stmt->prepare("INSERT INTO `Creates`(`Username`, `p_id`, `p_name`) VALUES (?, ?, ?)")) { // $stmt->bind_param('sss', $user, $p_id, $p_name); // $user = $uName; // $stmt->execute(); // //$stmt->bind_result($title, $name, $s_id); // while($stmt->fetch()) { // echo("3: " . $p_name); // } // } if ($stmt->prepare("UPDATE `Creates` SET `Username` = ? WHERE Username = p_id")) { $stmt->bind_param('s', $uName); $stmt->execute(); $stmt->bind_result(); } }
function searchForPlaylists($query) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } $query = addslashes($query); $defaultArtURL = "images/default-playlist-artwork.png"; //SELECT DISTINCT * FROM `Playlists` where p_name LIKE '%summer%' $stmt = $db_connection->stmt_init(); if ($stmt->prepare("SELECT DISTINCT * FROM Playlists where UPPER(p_name) like UPPER('%{$query}%') LIMIT 8")) { $stmt->bind_param('s', $query); $stmt->execute(); $stmt->bind_result($p_id, $p_name, $art_URL); while ($stmt->fetch()) { if (!isset($art_URL) || trim($art_URL) === '') { $art_URL = $defaultArtURL; } echo "<div class=\"content-grid\" style=\"width: 22%\"><a href=\"#\" onClick=\"play(" . $p_id . ", '" . addslashes($p_name) . "')\"><img src=\"" . $art_URL . "\" title=\"album-name\" /></a><h3>" . $p_name . "</h3><ul><button type=\"button\" onClick=\"subscribe(" . $p_id . ", '" . addslashes($p_name) . "')\" class=\"btn btn-success btn-sm\">Subscribe!</button></ul></div>"; } } }
function getYourPlaylists($userID) { $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } //SELECT * FROM Subscribes_to JOIN Playlists WHERE Subscribes_to.p_id = Playlists.p_id AND Username = '******' $defaultIcon = "images/default-playlist-artwork.png"; $stmt = $db_connection->stmt_init(); if ($stmt->prepare("SELECT * FROM Subscribes_to JOIN Playlists WHERE Subscribes_to.p_id = Playlists.p_id AND Username = ?")) { $stmt->bind_param("s", $userID); $stmt->execute(); $stmt->bind_result($Username, $p1, $playlistname, $p2, $pl2, $iconURL); //echo $userID; while ($stmt->fetch()) { if (!isset($iconURL) || trim($iconURL) === '') { $iconURL = $defaultIcon; } echo "<div class=\"content-grid\" id=\"" . $p1 . "\"><a href=\"#\" onClick=\"play(" . $p1 . ", '" . addslashes($playlistname) . "')\"><img src=\"" . $iconURL . "\" title=\"album-name\" /></a><h3>" . $playlistname . "</h3><ul><button type=\"button\" class=\"btn btn-danger btn-sm\" onClick=\"Unsubscribe(" . $p1 . ")\">Unsubscribe</button></ul></div>"; } } }
$name = htmlspecialchars($_POST['name']); $username = htmlspecialchars($_POST['username']); $email = htmlspecialchars($_POST['email']); $pword = htmlspecialchars($_POST['password']); //==================================================================== // ESTABLISH DATABASE CONNECTION //==================================================================== $db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5da', 'music', 'cs4750ams5da'); if (mysqli_connect_errno()) { echo "Connection Error!"; return; } //========================================== // CHECK TO SEE IF USERNAME HAS BEEN TAKEN //========================================== $stmt = $db_connection->stmt_init(); if ($stmt->prepare("SELECT Username FROM Users WHERE Username = ?")) { $stmt->bind_param("s", $username); $stmt->execute(); $stmt->bind_result($uName); $stmt->fetch(); if ($uName != NULL) { //echo "<center><h3>The username you selected has already been taken!<center></h3>"; //header("Refresh:2; URL=http://plato.cs.virginia.edu/~ams5da/ListenUp/index.html"); echo '<script type="text/javascript"> alert("The username you selected has already been taken"); window.location.href = "http://plato.cs.virginia.edu/~ams5da/ListenUp/index.html";</script>'; } else { //========================================== // INSERT USER CREDENTIALS INTO DATABASE //==========================================
$frsquery->execute(); $frsquery->bind_result($frs_userid, $frs_username, $frsl_limit); $temp01 = array(); while ($frsquery->fetch()) { $temp01[] = array($frs_userid, $frs_username, $frsl_limit); } $frsquery->close(); foreach ($temp01 as $temp) { $frs_userid = $temp[0]; $frs_username = $temp[1]; $frsl_limit = $temp[2]; $time = 30 / $frsl_limit; $time = 86400 * $time; $oldtime = time() - $time; $count = 0; $frsquery2 = $rfcdb->stmt_init(); $frsquery2->prepare("SELECT count(frsc_id) FROM frs_contacts WHERE frsc_userid=? AND frsc_timestamp > ?;"); $frsquery2->bind_param("ii", $frs_userid, $oldtime); $frsquery2->execute(); $frsquery2->bind_result($count); $frsquery2->fetch(); $frsquery2->close(); if ($count > 0) { echo "Skipping {$frs_username}\n"; continue; } $rfc_pool = array(); $frsquery3 = $rfcdb->stmt_init(); $timestamp_expire = time(); $timestamp_expire = $timestamp_expire - 3600 * 24 * 25; if ($cat != 'all') {
<?php $user = $_POST["user"]; $index = $_POST["index"]; $count = 0; // Create connection $con = new mysqli("localhost", "fradmin", "people123", "friendrequest"); $stmt = $con->stmt_init(); //Searches by name then username(creates it to be unique //user, index $requesterSQL = "SELECT username, name FROM users WHERE username IN (SELECT requester AS username FROM requests WHERE requestee=?) ORDER BY name, username LIMIT ?, 21"; $stmt->prepare($requesterSQL); $stmt->bind_param('si', $user, $index); $stmt->execute(); $stmt->bind_result($username, $names); while ($stmt->fetch()) { if ($count < 20) { echo $username . "," . $names . ";"; } $count = $count + 1; } if ($count != 21) { echo "\n"; } mysqli_close($con);
function db() { $db = new mysqli('localhost', 'uwksac5_admin', 'qpfrldpqhsowntpdy', 'uwksac5_ksa_1'); if (mysqli_connect_errno()) { die('Connect failed: ' . mysqli_connect_error()); } $stmt = $db->stmt_init(); if ($stmt->prepare("SET names utf8")) { $stmt->execute(); $stmt->close(); } return $db; }
<?php $db = new mysqli($_SERVER['DB_HOST'], $_SERVER['DB_USER'], $_SERVER['DB_PASS'], $_SERVER['DB_NAME']); $request = end(explode('/', rtrim(strtolower($_SERVER[REQUEST_URI]), '/'))); $components = explode(":", $request, 2); $link = trim($components[0]); if (count($components) > 1) { $campaign = $components[1]; } else { $campaign = ""; } $query = $db->stmt_init(); $query->prepare("SELECT id, target, utm FROM links WHERE short_link like ?"); $query->bind_param('s', $link); $query->execute(); $query->store_result(); if ($query->num_rows == 0) { $target = "http://www.fi.ncsu.edu"; $id = -1; $utm = 1; } else { $query->bind_result($id, $target, $utm); $query->fetch(); } $query->close(); if ($utm == 1) { $target_array = array(); $target_query = parse_url($target, PHP_URL_QUERY); parse_str($target_query, $target_array); $target_array['utm_source'] = 'fi'; $target_array['utm_medium'] = 'filinks';
$error = '<div class="alert alert-danger" role="alert"><b>Login Error:</b> Please enter a valid username and password.</div>'; // Required Database Information $dbHost = 'localhost'; $dbUsername = '******'; $dbUserPassword = '******'; $dbName = 'gpcorser'; // Entered user information $uname = $_POST['username']; $pass = $_POST['password']; // Session Information $dataEmail = ""; $dataPerId = ""; // Create a mysqli object $mysqli = new mysqli($dbHost, $dbUsername, $dbUserPassword, $dbName); // Init statement $stmt = $mysqli->stmt_init(); // Create query $sql = "SELECT per_email, per_id FROM persons2 \r\n\t\t WHERE per_email = ? AND per_password = ?"; if ($stmt = $mysqli->prepare($sql)) { // Bind params $stmt->bind_param('ss', $uname, $pass); // Execute statement if ($stmt->execute()) { // Bind query result to variables $stmt->bind_result($dataEmail, $dataPerId); // Fetch the statement if ($stmt->fetch()) { // Set SESSION variable $_SESSION['email'] = $dataEmail; $_SESSION['per_id'] = $dataPerId; // Close statement and mysqli object
/** * Special handling for mysqli query(). * * @param string|Select $sql The SQL statement with placeholders. * @param array $bind An array of data to bind to the placeholders. * @return \mysqli_result * @throws \mysqli_sql_exception. */ public function queryBind($sql, $bind = array()) { //try {省略throw-catch-rethrow块,直接抛出\mysqli_sql_exception // connect to the database if needed if (!$this->_isConnected) { $this->_connect(); } // make sure $bind to an array; // don't use (array) typecasting because // because $bind may be a Expr object if (!is_array($bind)) { $bind = array($bind); } //将结果缓冲当中的结果集读出来 $this->flushQueue(); $stmt = parent::stmt_init(); // TODO 以后可以派生mysqli_stmt $stmt->prepare($sql); if ($stmt === false) { throw new Exception('Failed in preparing SQL: ' . $sql); } if (!empty($bind)) { $types = ''; foreach ($bind as $val) { switch (gettype($val)) { case 'string': $types .= 's'; break; case 'integer': $types .= 'i'; break; case 'double': $types .= 'd'; break; case 'boolean': case 'object': case 'array': case 'resource': case 'NULL': case "unknown type": default: $types .= 's'; } } $stmt->bind_param($types, $bind); } // 由于取消了Statement,因此将Profiler的控制代码移动到这里 // 由于所处的程序位置,省略了$qp->start(),简化了$qp->bindParams()的相关代码 if ($this->_profiler === false) { $stmt->execute(); $result = $stmt->get_result(); } else { $q = $this->_profiler->queryStart($sql); $qp = $this->_profiler->getQueryProfile($q); if ($qp->hasEnded()) { $q = $this->_profiler->queryClone($qp); $qp = $this->_profiler->getQueryProfile($q); } $qp->bindParams($bind); $stmt->execute(); $result = $stmt->get_result(); $this->_profiler->queryEnd($q); } return $result; }
/** * Prepares a prepared query. * * @param string $query The query to execute * @param array $queryComponents The components of the query to execute * @return \mysqli_stmt|object MySQLi statement / DBAL object * @internal This method may only be called by \TYPO3\CMS\Core\Database\PreparedStatement */ public function prepare_PREPAREDquery($query, array $queryComponents) { if (!$this->isConnected) { $this->connectDB(); } $stmt = $this->link->stmt_init(); $success = $stmt->prepare($query); if ($this->debugOutput) { $this->debug('stmt_execute', $query); } return $success ? $stmt : null; }
$endtime="2015-09-01 00:00:00"; */ if (!filter_var($starttime, FILTER_VALIDATE_REGEXP, array("options" => array("regexp" => "/^\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}:\\d{2}\$/s")))) { die("invalid starttime"); } if (!filter_var($endtime, FILTER_VALIDATE_REGEXP, array("options" => array("regexp" => "/^\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}:\\d{2}\$/s")))) { die("invalid endtime"); } /* 已生产 */ $query = "select count(id) as num from i_mark where created_at>='{$starttime}' and created_at<='{$endtime}';"; $produceresult = $mysqli->query($query); $produceresultarray = $produceresult->fetch_array(); $result1 = $produceresultarray['num']; /*已销售 */ $query = "select count(id) from i_mark where sold_at>=? and sold_at<=?"; $stmt2 = $mysqli->stmt_init(); $stmt2->prepare($query); $stmt2->bind_param('ss', $starttime, $endtime); $stmt2->execute(); $stmt2->bind_result($result2); $stmt2->fetch(); $stmt2->close(); /*已损坏 */ $query = "select count(id) from i_mark where damaged_at>=? and damaged_at<=? and status=3"; $stmt3 = $mysqli->stmt_init(); $stmt3->prepare($query); $stmt3->bind_param('ss', $starttime, $endtime); $stmt3->execute(); $stmt3->bind_result($result3); $stmt3->fetch(); $stmt3->close();