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"]));

Comments

Post a Comment

Popular posts from this blog

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();
Read more

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();
Read more

laravel Query distances between two coordinates with Eloquent

$latitude = $request->latitude; $longitude = $request->longitude; $distance = 30; $users = User::whereHas('userprofile', function($q) use ($latitude, $longitude, $distance) { $q->where([ ['latitude', '!=', $latitude], ['longitude', '!=', $longitude] ]) ->whereRaw( DB::raw( "(3959 * acos( cos( radians($latitude) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians($longitude) ) + sin( radians($latitude) ) * sin( radians( latitude ) ) ) ) where('role', 2)->where('status', 1)->get();
Read more