LPJ@TUMBLR

PHP Pagination (from database)

//get the pagenum from url or else = 1

$pagenum = $_GET[‘page’];

if (!(isset($pagenum))){ 

$pagenum = 1; 

} 

//query to set number of pages

$first_query = mysql_query(“SELECT * FROM content”);

$first_num = mysql_num_rows($first_query);

//rows per page

$rows_per_page = 5;

$last_page = ceil($first_num/$rows_per_page);

//always “reset” pages.

if ($pagenum < 1){ 

$pagenum = 1; 

}elseif ($pagenum > $last_page){ 

$pagenum = $last_page; 

}

//this is the limit

$max = ($pagenum - 1) * $rows_per_page .’,’ .$rows_per_page;

//final query

$query = mysql_query(“SELECT * FROM content ORDER BY id DESC LIMIT $max”);

//newer-button

if($pagenum != 1){

$newer = $pagenum-1;

echo “<a href=’”.$root.”?page=$newer’>< Newer</a>”;

}

//older-button

if($pagenum != $last_page){

$older = $pagenum+1;

echo ” <a href=’”.$root.”?page=$older’> Older ></a> “;

}

Connect to MySQL database

function connect(){

$dbHosting = “localhost”; // Host name

$dbUsername = “root”; // Mysql username

$dbPassword = “root”; // Mysql password

$dbDatabase = “lonepalmusjensen”; // Database name

mysql_connect($dbHosting,$dbUsername,$dbPassword)or die(“Could not connect..”);

mysql_select_db($dbDatabase) or die (“Could not select database..!”);

}

PHP/MySQL query SELECT

$query = mysql_query(“SELECT * FROM content WHERE id =” .$id);

$num = mysql_num_rows($query);

if ($num = 1){

$result = mysql_fetch_assoc($query);

echo $result[‘username’];

PHP/MySQL query INSERT

$query = mysql_query(“INSERT INTO table_name (title,content,picture_url,user,date) VALUES (‘$title’,’$content’,’$pic_url’,’$user’,’$date’)”) or die(“Error”);

Detect user browser

<?php

$browser_search = $_SERVER[‘HTTP_USER_AGENT’];

if (strpos($browser_search, ‘Firefox’) !== FALSE) {

$stylesheet = “ff_style.css”;

}elseif ($test = strpos($browser_search, ‘Safari’) !== FALSE){

$stylesheet = “sa_style.css”;

}elseif (strpos($browser_search, ‘MSIE’) !== FALSE){

$stylesheet = “ie_style.css”;

}

?>

<link href=”<?= $stylesheet ?>” rel=”stylesheet” type=”text/css” />

PHP Sessions

session_start();  //skrives før html-tag

$query = (“SELECT * FROM table-name WHERE username=’”.$username.”’ AND password = ‘”.password.”’”);

$_SESSION[‘user’]=mysql_fetch_assoc($query);

echo $_SESSION[‘user’][‘username’];

//logout:

session_start();

session_destroy();

.htaccess redirect

Redirecting inside your website:

Redirect /old_dir http://www.yourdomain.dk/new_dir

Example:

Redirect /gammel.html http://www.lonepalmusjensen.dk/index.html

Redirecting entire site:

Redirect / http://www.yourdomain.dk/

Example:

Redirect / http://www.lj.cphcreatives.dk/

.htaccess

Customized error message:

ErrorDocument 401 /error_pages/401.html
ErrorDocument 404 /error_pages/404.html
ErrorDocument 500 /error_pages/500.html

etc. /error_pages is the folder name. For a direct file, just:

ErrorDocument 401 /401.html