<?php
class RequestSQL {
public $ar=array();
/////////////////////////////////return Other Name Page (Il faut inserer var $url)
public function link_pages($pdo,$url){
$dbb=$pdo->prepare('SELECT link FROM other_np WHERE link=:vurl');
$dbb->execute(array('vurl' => $url));
$res=$dbb->fetch();
if($res){return $ar="other";}
else{
$dbb=$pdo->prepare('SELECT link FROM art_np WHERE link=:vurl');
$dbb->execute(array('vurl' => $url));
$res=$dbb->fetch();
if($res){return $ar="Article";}
else{ return $ar="Error"; }
}
}
public function trends_selectAll($pdo){ $i=0;
$dbb=$pdo->query('SELECT * FROM trends LIMIT 0,5');
while($res=$dbb->fetch()) { $ar[]=$res; }
return $ar;
}
public function carrousel_selectNote($pdo){ $i=0;
$dbb=$pdo->query('SELECT * FROM art_all left join art_info
on art_all.artID=art_info.infoID
WHERE info="top"');
while($res=$dbb->fetch()) { $ar[]=$res; }
return $ar;
}
public function new_popular_selectLIMIT($pdo,$pagination){ $i=0;
if($pagination>=0){$start=$pagination*5; $end=$start+5;}else{$start=0; $end=5;}
$sql='SELECT * FROM art_all LIMIT '.$start.','.$end;
$dbb=$pdo->query($sql);
while($res=$dbb->fetch()) { $ar[]=$res; }
return $ar;
}
public function category_around_the_word($pdo,$pagination){ $i=0;
if($pagination>=0){$start=$pagination*5; $end=$start+5;}
$sql='SELECT * FROM art_all LIMIT '.$start.','.$end;
$dbb=$pdo->query($sql);
while($res=$dbb->fetch()) { $ar[]=$res; }
return $ar;
}
}
Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0