public function setMiembro($nombre, $apellido, $direccion, $cedula, $email, $casa, $movil, $pin, $categoria, $desc){
dbConnection(); //Funcion que conecta a la base de datos
$this->nombre = $nombre;
$this->apellido = $apellido;
$this->cedula = $cedula;
$this->email = $email;
$this->direccion = $direccion;
$this->telefonoCasa = $casa;
$this->telefonoMobil = $movil;
$this->pin = $pin;
$this->categoriaMiembro = $categoria;
$this->desc = $desc;
$query = "INSERT INTO miembro (codigo, nombre, apellido, direccion, cedula, email, telefono_casa, telefono_mobil, pin, categoria, descripcion)";
$query.= " VALUES (NULL,'$this->nombre','$this->apellido','$this->direccion','$this->cedula','$this->email','$this->telefonoCasa','$this->telefonoMobil','$this->pin','$this->categoriaMiembro','$this->desc')";
if(mysql_query($query)){
echo "<script type='text/javascript'>
alert('Datos Guardados Correctamente');
window.location.href= 'frmMiembro.php';
</script>";
};
}
static function deleteMovie($id)
{
$sql = 'DELETE FROM Movie WHERE mov_id=:id;';
$sth = dbConnection()->prepare($sql);
$sth->execute(array(':id' => $id));
$fetch = $sth->fetch();
return $fetch;
}
static function insertUser($u)
{
if ($u->firstname != '' && $u->lastname != '' && $u->login != '' && $u->password != '') {
$sql = 'INSERT INTO User(use_login,use_password,use_firstname,use_lastname) VALUES (:login,:password,:firstname,:lastname)';
$sth = dbConnection()->prepare($sql);
$sth->execute(array(':login' => $u->login, ':password' => $u->password, ':firstname' => $u->firstname, ':lastname' => $u->lastname));
$fetch = $sth->fetch();
return $fetch;
} else {
return false;
}
}
function checkuser($fuid)
{
$conn = dbConnection();
$sql = "select * from voting where fbID='{$fuid}'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
session_start();
session_unset();
return true;
}
return false;
}
function dbResultFromQuery($query)
{
$connection = dbConnection();
if (!$connection) {
die("MySQL Connection failed : " . mysqli_connect_error());
}
$result = 0;
if (!empty($query)) {
$result = mysqli_query($connection, $query) or die("<p>" . mysqli_error($connection) . "</p>");
}
mysqli_close($connection);
return $result;
}
/**
* Function that queries the database for a specific Game and
* then returns the result.
*
* @param int $title
* @return Game
*/
public function getGame($title)
{
$db = dbConnection();
//Establish database connection
//Prepare &execute the select statement to query the database.
$stmt = $db->prepare("select * from Game where gme_id = ?");
$result = $stmt->execute($title);
//Return the Game if the query is successful.
if ($result === true) {
$game = $stmt->fetch();
return new Game($game['gme_id'], $game['gme_title'], $game['gme_developer'], $game['gme_console'], $game['gme_price'], $game['gme_rating'], $game['gme_comments']);
} else {
throw new Exception("Could not find the game!");
}
}
function insertHash($user, $pass)
{
$pass = password_hash($pass, PASSWORD_DEFAULT);
$db = dbConnection();
try {
$sql = 'INSERT INTO users(username, password) VALUES(:user, :pass)';
$stmt = $db->prepare($sql);
$stmt->bindValue(':user', $user, PDO::PARAM_STR);
$stmt->bindValue(':pass', $pass, PDO::PARAM_STR);
$stmt->execute();
$stmt->closeCursor();
} catch (PDOException $exc) {
return FALSE;
}
}
function queryMysqli($query, array $params)
{
$conPDO = dbConnection();
try {
//prepare the query
$result = $conPDO->prepare($query);
//execute the query with the passed parameters
$result->execute($params);
//close the database connection
$conPDO = null;
return $result;
} catch (PDOException $e) {
trigger_error('Error: ' . $e->getMessage(), E_USER_ERROR);
}
}
function getAlldetails($id, $lat, $lng)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "SELECT * FROM `servicesubcatrelation` a,`ownerservice` b,`servicebranch` c WHERE a.sub_category_id={$id} and a.service_id=b.service_id and b.service_id=c.service_id ";
//! Executing the query
$res = mysqli_query($rConnection, $sQuery);
/*!
* Check If the Query executed properly
*/
if ($res) {
$data = array();
//! retrieve the result from the result set
while ($aRow = mysqli_fetch_assoc($res)) {
if (distance($lat, $aRow['branch_lat'], $lng, $aRow['branch_lng']) < 300) {
$data[] = $aRow;
}
}
//! Closing the connections
dbConnectionClose($rConnection);
//! Message Login
comment_message_log('Query Executed Successfully.::: ' . $sQuery);
comment_message_log('End of Function : ' . __FUNCTION__);
return $data;
} else {
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
//! Closing the connections
dbConnectionClose($rConnection);
return E00100;
}
}
function aGetAllTags()
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "SELECT * FROM `interests` ORDER BY `id` DESC;";
//! Executing the query
$rResultSet = mysqli_query($rConnection, $sQuery);
//! Closing the connections
dbConnectionClose($rConnection);
/*!
* Check If the Query executed properly
*/
if ($rResultSet != '') {
//! Message Login
comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
$aData = array();
//! retrieve the result from the result set
while ($aRow = mysqli_fetch_assoc($rResultSet)) {
$aData[] = $aRow;
}
comment_message_log('End of Function : ' . __FUNCTION__);
return $aData;
} else {
//! Message Loggin
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
return E00100;
}
}
function aGetUserbyPass($user, $pass)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "SELECT * FROM `admin` where `email` = '{$user}' AND `password` = '{$pass}';";
//! Executing the query
$rResultSet = mysqli_query($rConnection, $sQuery);
//! Closing the connections
dbConnectionClose($rConnection);
/*!
* Check If the Query executed properly
*/
if ($rResultSet != '') {
//! Message Login
comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
$aData = array();
//! retrieve the result from the result set
while ($aRow = mysqli_fetch_assoc($rResultSet)) {
$aData = $aRow;
}
comment_message_log('End of Function : ' . __FUNCTION__);
return $aData;
} else {
//! Message Loggin
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
return E00100;
}
}
function insertintoservicesused($user_id, $service_id, $single_id, $freeserivce_id, $created_at)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "INSERT INTO `services_used` (`id`,`user_id`,`service_id`, `singleent_id`,`freeservice_id` `timeStamp`) VALUES (NULL, '{$user_id}','{$service_id}','{$single_id}','{$freeservice_id}' ,'{$created_at}');";
//! Executing the query
$res = mysqli_query($rConnection, $sQuery);
/*!
* Check If the Query executed properly
*/
if ($res) {
$user_id = mysqli_insert_id($rConnection);
//! Closing the connections
dbConnectionClose($rConnection);
return $user_id;
//! Message Login
comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
comment_message_log('End of Function : ' . __FUNCTION__);
} else {
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
//! Closing the connections
dbConnectionClose($rConnection);
return E00100;
}
}
function insertintoownerapp($owner_name, $owner_email, $service_mobile_num, $password, $created_at, $isActive, $type)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "INSERT INTO `ownerapp` (`owner_id`,`owner_name`, `owner_email`, `service_mobile_number`, `password`, `timeStamp`,`isActive`,`type`) VALUES (NULL, '{$owner_name}','{$owner_email}','{$service_mobile_num}','{$password}','{$created_at}','{$isActive}','{$type}');";
//! Executing the query
$res = mysqli_query($rConnection, $sQuery);
/*!
* Check If the Query executed properly
*/
if ($res) {
$owner_id = mysqli_insert_id($rConnection);
//! Closing the connections
dbConnectionClose($rConnection);
//! Message Login
comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
comment_message_log('End of Function : ' . __FUNCTION__);
return $owner_id;
} else {
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
//! Closing the connections
dbConnectionClose($rConnection);
return E00100;
}
}
function insertintofreeservicedb($owner_id, $branch_id, $frees_name, $free_description, $counter, $created_at, $validity)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "INSERT INTO `freeservicedb` (`id`,`owner_id`, `branch_id`,`free_name` ,`free_description`,`counter`,`timestamp`,`validity`) VALUES (NULL, '{$owner_id}', '{$branch_id}','{$free_name}','{$free_description}','{$counter}', '{$created_at}','{$validity}');";
//! Executing the query
$res = mysqli_query($rConnection, $sQuery);
/*!
* Check If the Query executed properly
*/
if ($res) {
$id = mysqli_insert_id($rConnection);
//! Closing the connections
dbConnectionClose($rConnection);
return $id;
//! Message Login
comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
comment_message_log('End of Function : ' . __FUNCTION__);
} else {
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
//! Closing the connections
dbConnectionClose($rConnection);
return E00100;
}
}
function insertintosingleent($owner_id, $category_id, $ent_name, $ent_details, $ent_website, $isActive, $listingType, $ProvidesFreeSrvc, $premiumStartDate, $premiumEndDate, $amount_paid, $created_at)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "INSERT INTO `servicebranch` (`ent_id`,`owner_id`,`category_id`,`ent_name`,`ent_details`,`ent_website`,`isActive` ,`listingType` ,`ProvidesFreeSrvc` ,`premiumStartDate` ,`premiumEndDate`,`amt_paid`,`timeStamp`) VALUES (NULL, '{$owner_id}', '{$category_id}','{$ent_name} ','{$ent_details}','{$ent_website}','{$isActive}' ,'{$listingType}' ,'{$ProvidesFreeSrvc}' ,'{$premiumStartDate}' ,'{$premiumEndDate}','{$amount_paid} ','{$created_at}');";
//! Executing the query
$res = mysqli_query($rConnection, $sQuery);
/*!
* Check If the Query executed properly
*/
if ($res) {
$ent_id = mysqli_insert_id($rConnection);
//! Closing the connections
dbConnectionClose($rConnection);
return $ent_id;
//! Message Login
comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
comment_message_log('End of Function : ' . __FUNCTION__);
} else {
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
//! Closing the connections
dbConnectionClose($rConnection);
return E00100;
}
}
function insertintoservicesubcatrelation($service_id, $ent_id, $free_id, $subcategory_id)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "INSERT INTO `servicesubcatrelation` (`service_id`,`ent_id`,`free_id`,`sub_category_id`) VALUES ('{$service_id}','{$ent_id}','{$free_id}','{$subcategory_id}');";
//! Executing the query
$res = mysqli_query($rConnection, $sQuery);
/*!
* Check If the Query executed properly
*/
if ($res) {
mysqli_insert_id($rConnection);
//! Closing the connections
dbConnectionClose($rConnection);
//! Message Login
comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
comment_message_log('End of Function : ' . __FUNCTION__);
} else {
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
//! Closing the connections
dbConnectionClose($rConnection);
return E00100;
}
}
function insertintofriend($name, $data)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "INSERT INTO `friend_list` (`user_id`,`friend_name`) VALUES ('{$data}', '{$name}');";
//! Executing the query
$res = mysqli_query($rConnection, $sQuery);
/*!
* Check If the Query executed properly
*/
if ($res) {
mysqli_insert_id($rConnection);
//! Closing the connections
dbConnectionClose($rConnection);
//! Message Login
comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
comment_message_log('End of Function : ' . __FUNCTION__);
} else {
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
//! Closing the connections
dbConnectionClose($rConnection);
return E00100;
}
}
function updatefreeservice_id($freeservice_id, $rating)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "UPDATE `freeservicedb` SET `avg_rating`='{$rating}' WHERE `id`='{$freeservice_id}'";
//! Executing the query
$res = mysqli_query($rConnection, $sQuery);
/*!
* Check If the Query executed properly
*/
if ($res) {
//! Closing the connections
dbConnectionClose($rConnection);
return $rating_id;
//! Message Login
comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
comment_message_log('End of Function : ' . __FUNCTION__);
} else {
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
//! Closing the connections
dbConnectionClose($rConnection);
return E00100;
}
}
function searchinservice($string)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "SELECT `service_id`,`service_name` FROM `ownerservice` WHERE `service_name` OR `service_details` LIKE '%{$string}%'";
//! Executing the query
$rResultSet = mysqli_query($rConnection, $sQuery);
//! Closing the connections
dbConnectionClose($rConnection);
/*!
* Check If the Query executed properly
*/
if ($rResultSet != '') {
//! Message Login
comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
$aData = array();
//! retrieve the result from the result set
while ($aRow = mysqli_fetch_assoc($rResultSet)) {
$aData[] = $aRow;
}
comment_message_log('End of Function : ' . __FUNCTION__);
return $aData;
} else {
//! Message Loggin
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
return E00100;
}
}
<div id="barLibro">Prestamo</div>
<form action="insertPrestamo.php" method="post" id="frmPrestamo" name="frmPrestamo" enctype="multipart/form-data">
<table border="0" cellspacing="2" cellpadding="5">
<tr>
<td><label rel="Codigo Miembro" >Codigo Miembro:</label></td>
<td><input type="text" name="txtmiembro" id="txtmiembro" class="in" /></td>
</tr>
<tr>
<td><label rel="isbn">Isbn:</label></td>
<td><select name="txtisbn" id="txtisbn">
<?php
require_once "config/dbConnection.php";
dbConnection();
$query = "SELECT isbn FROM libro WHERE estado = 'Disponible' ";
$result = mysql_query($query);
while ($datos = mysql_fetch_array($result, MYSQL_ASSOC)) {
?>
<option value="<?php
echo $datos["isbn"];
?>
"><?php
echo $datos["isbn"];
?>
</option>
<?php
function addintofriendlist($user_id, $friend)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "INSERT INTO `friend_list` (`user_id`,`friend_name`) VALUES ('{$user_id}','{$friend_name}');";
//! Executing the query
$rResultSet = mysqli_query($rConnection, $sQuery);
//! Closing the connections
dbConnectionClose($rConnection);
/*!
* Check If the Query executed properly
*/
if ($rResultSet != '') {
//! Message Login
comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
//! retrieve the result from the result set
comment_message_log('End of Function : ' . __FUNCTION__);
return 1;
} else {
//! Message Loggin
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
return E00100;
}
}
function iUpdatesubCats($sub_category_id, $category_id, $subcategoryname, $showinapp)
{
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "UPDATE sub_category SET `category_id` = '{$category_id}' , `sub_category_name` = '{$subcategoryname}',`show_in_app` = '{$showinapp}' WHERE `sub_category_id` = '{$sub_category_id}' ";
//! Executing the query
$res = mysqli_query($rConnection, $sQuery);
/*!
* Check If the Query executed properly
*/
if ($res) {
//! Closing the connections
dbConnectionClose($rConnection);
//! Message Login
comment_message_log('Query Executed Successfully.::: id = $iId ::: ' . $sQuery);
comment_message_log('End of Function : ' . __FUNCTION__);
} else {
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
//! Closing the connections
dbConnectionClose($rConnection);
return E00100;
}
}
function sendPassword($email)
{
$conn = dbConnection();
$sql = "select Password from memberdetails where Email='{$email}'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$to = "*****@*****.**";
$subject = "This is subject";
$message = "This is simple text message.";
$header = "From:harshatjk@gmail.com \r\n";
$retval = mail($to, $subject, $message, $header);
if ($retval == true) {
} else {
echo "Message could not be sent...";
}
}
}
}
function getAllfriendservices($id)
{
//! Message Loggin
comment_message_log('Start of Function : ' . __FUNCTION__);
//! Data base connection
$rConnection = dbConnection();
/*!
* Check if the database Connection is failed
*/
if (!$rConnection) {
//! Message Loggin
comment_message_log('End of Function : ' . __FUNCTION__);
return E00010;
}
//! Query
$sQuery = "SELECT * FROM `friend_list` a,`user` b,`services_used` c WHERE a.user_id={$id} and b.full_name=a.friend_name and c.user_id=b.user_id";
//! Executing the query
$rResultSet = mysqli_query($rConnection, $sQuery);
//! Closing the connections
dbConnectionClose($rConnection);
/*!
* Check If the Query executed properly
*/
if ($rResultSet != '') {
//! Message Login
comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
$aData = array();
//! retrieve the result from the result set
while ($aRow = mysqli_fetch_assoc($rResultSet)) {
$aData[] = $aRow;
}
comment_message_log('End of Function : ' . __FUNCTION__);
return $aData;
} else {
//! Message Loggin
comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
comment_message_log('End of Function : ' . __FUNCTION__);
return E00100;
}
}
<?php /** * configuration */ //setup db connection - mysql $setup['db_ip'] = '127.0.0.1'; $setup['db_user'] = '******'; $setup['db_pass'] = '******'; $setup['db_name'] = 'database_name'; $link = dbConnection($setup['db_ip'], $setup['db_user'], $setup['db_pass'], $setup['db_name']); //configure from mail $from_mail = '*****@*****.**';
function insertReview($review)
{
$db = dbConnection();
try {
$sql = 'INSERT INTO review(comment) VALUES(:review)';
$stmt = $db->prepare($sql);
$stmt->bindValue(':review', $review, PDO::PARAM_STR);
$stmt->execute();
$lastid = $db->lastInsertId();
$stmt->closeCursor();
} catch (PDOException $e) {
echo $message = "PDO Failure";
}
if ($lastid) {
return $lastid;
} else {
return FALSE;
}
}
<?php
//categories set for updating
include_once __DIR__ . '/config.php';
require_once __DIR__ . '/functions.php';
$table = CATEGORIES;
$pdo = dbConnection();
//table categories truncate
try {
$stmt = $pdo->prepare("\n TRUNCATE `{$table}` ");
$stmt->execute([':email' => $email]);
} catch (PDOException $e) {
echo "Category truncate error: " . $e->getMessage();
die;
}
//categories set insert into the categories table
foreach ($categories as $category) {
try {
$stmt = $pdo->prepare("\n INSERT INTO `{$table}` (`category`)\n VALUES (:category)");
$stmt->execute([':category' => $category]);
} catch (PDOException $e) {
echo "Category insert error: " . $e->getMessage();
die;
}
}
echo json_encode($categories);
