PHP Engines

Split rows into multiple pages

AgManiX — Sat, 03 Dec 2011 16:06:00 GMT

Тоже где-то нашел

Code

function split_pages($current_url,$total_pages,$max_pages) {

     $pages=ceil($total_pages/$max_pages);
     For($i=1;$i<= $pages;$i++) {
         $j=($i-1);
         $start=($j*$max_pages);
         If ($pages>="2") {
             If (intval($_GET['start'])==$start) {
                 $pagenumbers[$i]="[".$i."]\n";
             } Else {
                 $pagenumbers[$i]="".$i."\n";
             }
         }
     }
     $pages="";
     If (!empty($pagenumbers)) {
         $pages=implode("",$pagenumbers);
     }
     return($pages);
}
?>

HowTo:

Code

$query=mysql_query("SELECT id FROM tbl_name");
$rows=mysql_num_rows($query);
$max_rows="10";

$pages=split_pages("/index.php?show=maps",$rows,$max_rows);

If($pages) {
     Echo("Pages: ".$pages);
}

Авторизация(класс)

AgManiX — Sat, 03 Dec 2011 16:03:53 GMT

довольно старенький скрипт, мб кому пригодится

Code

HowTo:

Code

If($_POST['login']) {
If(auth_user($_POST['username'],$_POST['password'])) {
Echo("You are now logged in. Click here to go to your page");
exit;
} Else {
Echo("Login Failed! Please try again.

");
}
}

login_form(); //display the login form
?>
/*
:- ==============
:- Put this at the top of files you want to protect.:
:- ==============
*/
If(!is_logged_in()) {
Echo("Please login first");
login_form(); //display the login form
exit;

}
// Display protected content after calling is_logged_in();

?>

VK Api class

AgManiX — Sat, 03 Dec 2011 16:01:10 GMT

Автора уже не помню.

Code

class vkapi {

         function __construct() {
                 if (!function_exists('json_decode')) {
                         $this->error(1);
                 }
         }

         private $app_id;
         private $secret;
         private $token;

         private $errors = array(
                  => "No JSON support! To use this class install JSON addon.",
                  => "Incorrect APP ID format! It must be numeric and contain at least 1 character.",
                  => "Incorrect SECRET format! It must contain at least 1 character.",
                  => "Incorrect APP ID or SECRET!",
                  => "Incorrect METHOD name, during query!",
                  => "Incorrect PARAMS array, during query!",
                  => "Authorize first!"
         );

         function auth($app_id, $secret) {

                 if (intval($app_id)>0 && strlen($secret)>0) {
                         $this->app_id = $app_id;
                         $this->secret = $secret;
                         $url = 'https://api.vkontakte.ru/oauth/access_token/?client_id='.$this->app_id.'&client_secret='.$this->secret.'&grant_type=client_credentials';
                         $ch = curl_init($url);
                         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
                         $answer = curl_exec($ch);
                         curl_close($ch);
                         $answer = json_decode($answer, true);
                         $this->token = $answer['access_token'];
                         if (strlen($this->token<1)) {
                    $this->error(4);
                         }
                 } else {
                         if (intval($app_id)<1) {
                    $this->error(2);
                         }
                         if (strlen($secret)<1) {
                    $this->error(3);
                         }
                 }

         }

         function query($method, $params) {
                 if (strlen($this->token<1)) {
                         $this->error(7);
                 }
                 $url = 'https://api.vkontakte.ru/method/';
                 if (strlen($method)>0 && count($params)>0) {
                         $url .= $method.'?';
                         while (list($key, $var) = each($params)) {
                    $url .= "$key=$var&";
                         }
                         $url .= 'access_token='.$this->token;
                         $ch = curl_init($url);
                         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
                         $answer = curl_exec($ch);
                         curl_close($ch);
                         $answer = json_decode($answer, true);
                         return $answer;
                 } else {
                         if (strlen($method)<1) {
                    $this->error(5);
                         }
                         if (count($params)<1) {
                    $this->error(6);
                         }
                 }
         }

         function rand() {
         return rand(10000,99999);
         }

         private function error($error_num) {
                 die("VK API Class error #$error_num: ".$this->errors[$error_num]);
         }

}
?>

HowTo:

Code

require_once 'vkapi.class.php';

$appid = 1234567;
$secret = 'app_secretkey';

$vk = new vkapi;
$vk->auth($appid, $secret);

$method = 'secure.setCounter';
$params = array(
'timestamp' => time(),
'random'    => $vk->rand(),
'uid'       => 1,
'counter'   => 123
);

$res=$vk->query($method, $params);
print_r($res);

?>

Simple class

AgManiX — Sat, 03 Dec 2011 15:59:27 GMT

Автор: ph4
Класс нарыл где-то на просторах Сети, вообщем-то штука удобная.

Code

/*
Initilize the class:

$sldb = new sldb;

Connect to mysql & select database:

$sl->connect("host","user","password","database");

Run a query:

$query=$sl->query("Your Query");

Get a 1 row result:

$result=$sl->result("Your Query");

Get multiple row result:

$query=$sl->query("Your Query");
while($result=$sl->fetch($query)) {
//rows
}
$sl->free($query); //will free the $query

Get rows from query:

$query=$sl->query("Your Query");
$rows=$sl->rows($query);

Get rows without query first:

$rows=$sl->getrows("Your Query");

Get last insert id:

$last_id=$sl->last_id();

Disconnect from mysql:

$sl->disconnect();
*/

class sldb {

     function connect($host,$user,$pass,$data,$persistency=False) {
         $this->host = $host;
         $this->user = $user;
         $this->pass = $pass;
         $this->data = $data;
         $this->persistency = $persistency;

         If($this->persistency) {
             $this->link=@mysql_pconnect($this->host,$this->user,$this->pass);
         } Else {
             $this->link=@mysql_connect($this->host,$this->user,$this->pass);
         }

         If(($this->link) AND ($this->data)) {
             If(@mysql_select_db($this->data,$this->link)) {
                 return True;
             }
         }
         return False;
     }

     function fetch($query="") {
         $query=@mysql_fetch_array($query);
         return($query);
     }

     function query($query="",$sup="") {
         If($sup) {
             $query=@mysql_query($query,$this->link);
         } Else {
             $query=@mysql_query($query,$this->link) or die("

".mysql_error()."

");
         }
         return($query);
     }

     function rows($query="") {
         $query=@mysql_num_rows($query);
         return($query);
     }
     function free($query="") {
         @mysql_free_result($query);
     }
     function result($query="",$sup="") {
         $query=$this->query($query,$sup);
         $result=$this->fetch($query);
         $this->free($query);
         return($result);
     }
     function getrows($querystring="") {
         $query=$this->query($querystring);
         $result=$this->rows($query);
         $this->free($query);
         return($result);
     }
     function disconnect() {
         @mysql_close($this->link);
     }
}
?>