Posts

Showing posts from May, 2020

PHP PDO count row

$get_audios = "SELECT user_id FROM `comp_audios` WHERE user_id = :user_id AND competition_id = :competition_id"; $get_stmt = $conn->prepare($get_audios); $get_stmt->bindValue(':user_id', $_POST["user_id"],PDO::PARAM_INT); $get_stmt->bindValue(':competition_id', $_POST["competition_id"],PDO::PARAM_INT); $get_stmt->execute(); $count= $get_stmt->rowCount();

PHP PDO insert query

$insert_query = "INSERT INTO `comp_voting`(audio_id,competition_id,user_id) VALUES(:audio_id,:competition_id,:user_id)"; $insert_stmt = $conn->prepare($insert_query); $insert_stmt->bindValue(':audio_id', htmlspecialchars(strip_tags($_POST["audio_id"])), PDO::PARAM_INT); $insert_stmt->bindValue(':competition_id', htmlspecialchars(strip_tags($_POST["competition_id"])), PDO::PARAM_INT); $insert_stmt->bindValue(':user_id', htmlspecialchars(strip_tags($_POST["user_id"])), PDO::PARAM_INT); $insert_stmt->execute();

PHP PDO count and sum value from MySQL table

$sql = 'UPDATE comp_audios SET vote = vote + 1 WHERE ( id = :id )'; $prepStatement = $conn->prepare( $sql ); $prepStatement->execute(array(':id' => $_POST["audio_id"]));