Php best tutorials

ADD REPLY FUNCTIONALITY TO OUR COMMENT SYSTEM part2

noreply@blogger.com (ebraam) — Sun, 24 Jul 2011 18:26:00 +0000

this page post.php

<?php include_once "mysql.php";

if ($_POST['wall'] == "post"){

$name = $_POST['name1'];//name1 is parameter from the jquery function

$comment = $_POST['comment1'];//comment1 is parameter from the jquery function

if ($comment=="" || $name==""){exit();}// if no name or comment exit the script

else{

//insert the name and comment into database

$sql = mysql_query("INSERT INTO comment (name,comment) VALUES('$name','$comment')")

or die (mysql_error());

$id = mysql_insert_id();//the auto incremented id of the commet.

it important to this line

// the inserted comment will renderd by the "$("#result").prepend(data).show();" from jquery

echo 'name : '.$name.'<br />comment : '.$comment.'<br />

<div id="'.$id.'" class="reply"><span>reply</span><hr>name<br />

<br />

comment<br />

<br />

<input type="submit" name="button" id="button" value="Submit"

onclick="return false" onmousedown="javascript:reply('.$id.');"/></form>

<br />' . $r . '</div> <hr>';

} } else if ($_POST['wall'] == "reply"){

$repto = $_POST['repto1'];//repto1 is parameter from the jquery function

$repname = $_POST['repname1'];//repname1 is parameter from the jquery function

$repcomment = $_POST['repcomment1'];//repcomment1 is parameter from the jquery function

if ($repcomment=="" || $repname==""){exit();}// if no $repname or $repcomment exit the script

else{

//insert the values above into database

$sql = mysql_query("INSERT INTO reply (repto,repname,repcom) VALUES($repto,'$repname','$repcomment')")

or die (mysql_error());

// the inserted reply will renderd by the "$("#"+ comid).append(data);" from jquery

echo 'name : '.$repname.'<br />comment : '.$repcomment.'<hr>';

}

} ?>

ADD REPLY FUNCTIONALITY TO OUR COMMENT SYSTEM part1

noreply@blogger.com (ebraam) — Sun, 24 Jul 2011 18:25:00 +0000

continuing from http://phpcoderboard.blogspot.com/2011/06/learn-how-to-create-comment-system-with.html
first create a table and call it "reply" with 4 fields rid, repto,
repname, repcom.
this page index.php
<?php
include_once "mysql.php";
//////render data that is already stored in the data base
$sql_comments = mysql_query("SELECT * FROM comment ORDER BY id DESC");
while($row = mysql_fetch_array($sql_comments)){
$id = $row["id"];
$name = $row["name"];
$comment = $row["comment"];

$sql_hreply = mysql_query("SELECT * FROM reply WHERE repto !='$id'" );
while($row = mysql_fetch_array($sql_hreply)){
$r = "";
}
$sql_reply = mysql_query("SELECT * FROM reply WHERE repto='$id'" );
while($row = mysql_fetch_array($sql_reply)){
$replycom = $row["repcom"];
$replyname = $row["repname"];
$r .= 'name : '.$replyname.'<br />comment : '.$replycom.'<hr>' ;

}
$commentlist .= 'name : '.$name.'<br />comment : '.$comment.'<br /> <div id="'.$id.'" class="reply"><span>reply</span><hr>name<br />
<input type="text" id="repname'.$id.'" />
<br />
comment<br />
<textarea id="repcomment'.$id.'" cols="30" rows="2"></textarea>
<br />
<input type="submit" name="button" id="button" value="Submit"
onclick="return false" onmousedown="javascript:reply('.$id.');"/></form>
<br />' . $r . '</div> <hr>';
}
//////////////the highlight is new code added to old script
?>
<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$('#loading').hide();
$('#notice').hide();
}); function wall(){
$('#loading').show();
var name = $('#name').val();///#name is the input id and will be equal the variable "name"
var comment = $('#comment').val();/////#comment is textarea id and will be equal the variable "comment"
var URL = "post.php"; /////post.php will be equal the variable "URL" $.post(URL,{wall:"post",name1:name,comment1:comment},function(data){
//parameter wall will be equal "post", name1 will be equal to the var "name" and comment1 will be equal to the var "comment"
$("#result").prepend(data);//.show() the result will be placed above the the #result div
$('#loading').hide();
var name = $('#name').val("");
var comment = $('#comment').val("");
});
} function reply(comid){
var repname = $('#repname'+comid).val();///#repname is the input id and will be equal the variable "name"
var repcomment = $('#repcomment'+comid).val();/////#repcomment is textarea id and will be equal the variable "comment"
alert(comid + "" + repname + " " + repcomment) var URL = "post.php"; /////post.php will be equal the variable "comment"
$.post(URL,{wall:"reply",repname1:repname,repcomment1:repcomment,repto1:comid},function(data){

//parameter wall will be equal "post", repname1 will be equal to the var "repname" and repcomment1 will be equal to the var "repcomment"
$("#"+ comid).append(data);//render result
//$('#loading').hide();
var repname = $('#repname'+comid).val("");
var repcomment = $('#repcomment'+comid).val("");
});
}
</script>

<style type="text/css">

</style>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><form>
name<br />
<input type="text" id="name" />
<br />
comment<br />
<textarea id="comment" cols="45" rows="5"></textarea> <br />
<input type="submit" name="button" id="button" value="Submit" onclick="return false" onmousedown="javascript:wall();"/>
<img src="loading.gif" alt="" width="15" height="15" id="loading" />
<br /></form>
<div id="notice">Your comment will be reviewed by the webmaster before publishing</div>
<div id="result"><?php print"$commentlist";?></div></td>
</tr>

IMPORTANT NOTICE

noreply@blogger.com (ebraam) — Fri, 24 Jun 2011 19:43:00 +0000

Hello to everyone, To those who have been following my tutorials. I have create a fan page on facebook so you guys can give a feed backs on my tutorials and say what you like and what you dont like and what kind of tutorials you want more and the kind stuff you want to learn more.
Go to http://www.facebook.com/pages/Phpcoderboard/209608885746800?sk=wall and join.

TUTORIAL COMMENT SYSTEM WITH ALLOW AND DENY PUBLISHING FUNCTIONALITY

noreply@blogger.com (ebraam) — Thu, 23 Jun 2011 22:01:00 +0000

first create table and call it "comment" with 4 fields id, name, comment and status

mysql.php 

<?php 
@mysql_connect("localhost","root","") or die ("could not connect to mysql");
@mysql_select_db("name of your database") or die ("no database");
?>
///////////page end here

index.php

<?php 
include_once "mysql.php";
//////render data that is already stored in the data base
 $sql_comments = mysql_query("SELECT * FROM comment ORDER BY id DESC");
while($row = mysql_fetch_array($sql_comments)){
 $name = $row["name"];
 $comment = $row["comment"];
 
 $commentlist .= 'name : '.$name.'<br />comment : '.$comment.'<hr>';
}
//////////////
?>

<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type="text/javascript">
$(document).ready(function(){
 $('#loading').hide();
});

function wall(){
$('#loading').show();

  var name = $('#name').val();///#name is the input id from the form and will be equal the variable "name"
  var comment = $('#comment').val();/////#comment is textarea id from the form and will be equal the variable "comment"
  var URL = "post.php"; /////post.php will be equal the variable "comment"
  
  $.post(URL,{wall:"post",name1:name,comment1:comment},function(data){//parameter wall will be equal "post", name1 will be equal to the var "name" and comment1 will be equal to the var "comment"
  if($('#name').val() != "" && $('#comment').val() != ""){//if there is a value for name and comment
  $("#notice").show();//show the div with id = notice
  $("#notice").fadeOut(4000);//fade out the div with id = notice within 4 seconds
  }
  $('#loading').hide();
  var name = $('#name').val("");
  var comment = $('#comment').val("");
  });
 }
</script>

<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><div id='form'><form>
    name<br />
      <input type="text" id="name" />
      <br />
   comment<br />
      <textarea id="comment" cols="45" rows="5"></textarea>
      <br />
      <input type="submit" name="button" id="button" value="Submit" onclick="return false" onmousedown="javascript:wall();"/><img src="loading.gif" alt="" width="15" height="15" id="loading" />
      <br /></form>
    </div>
      <div id="result"><?php print"$commentlist";?></div></td>
  </tr>
</table>

post.php 

<?php
include_once "mysql.php";

  if ($_POST['wall'] == "post"){
  $name = $_POST['name1'];//name1 is parameter from the jquery function  
  $comment = $_POST['comment1'];//comment1 is parameter from the jquery function  
   if ($comment=="" || $name==""){exit();}// if no name or comment exit the script
   else{
   //insert the name and comment into database as pending 
  $sql = mysql_query("INSERT INTO comment (name,comment) 
     VALUES('$name','$comment','0')")
     or die (mysql_error());
     }
}
else if ($_POST['wall'] == "allow"){
   $comid = $_POST['cid'];
//set comment from pendded to published
   mysql_query("UPDATE comment SET status='1' WHERE id='$comid'") or die(mysql_error());
   echo"comment has been published.";
   }
   else if ($_POST['wall'] == "deny"){
   $comid = $_POST['cid'];
//delete comment if dennied
   mysql_query("DELETE FROM comment WHERE id='$comid'") or die(mysql_error());
   echo"comment has been deleted.";
   }
?>

admin.php
<?php 
include_once "mysql.php";
//////render data that is already stored in the data base
 $sql_comments = mysql_query("SELECT * FROM comment WHERE status='0' ORDER BY id DESC");
while($row = mysql_fetch_array($sql_comments)){
    $id = $row["id"];
 $name = $row["name"];
 $comment = $row["comment"];
 
 $commentlist .= '<div id="'.$id.'"><table width="700" border="0" cellspacing="0" cellpadding="0">//we are going to the comment id as div id
  <tr>
    <td width="536" align="left" valign="top">name : '.$name.'<br />comment : '.$comment.'</td>
    <td width="150" align="left" valign="top">
 <a id="comment'.$id.'" href="#" onclick="return false" onmousedown="javascript:allow('.$id.');">allow</a>
 <a id="comment'.$id.'" href="#" onclick="return false" onmousedown="javascript:deny('.$id.');">deny</a></td>
  </tr>
</table></div><hr>';
}
//////////////
?>
<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type="text/javascript">

  function allow(id){//if admin want to publish
  
  var URL = 'post.php';
  $.post(URL,{wall:"allow",cid:id},function(data){
  $('#'+id).html(data);
  });
  }
  function deny(id){//if admin want to delete
  
  var URL='post.php';
  $.post(URL,{wall:"deny",cid:id},function(data){
  $('#'+id).html(data);
  });
  }

</script>
<style type="text/css">
<!--
.style {
 font-size: 16px;
 font-weight: bold;
 font-family: Arial, Helvetica, sans-serif;
 color: #333333;
}
-->
</style>
<span class="style">Pending comments</span>
<hr>
<?php print"$commentlist"; ?>

TUTORIAL:CREATE A LOGIN FORM VALIDATED WITH PHP AND JQUERY

noreply@blogger.com (ebraam) — Mon, 20 Jun 2011 20:44:00 +0000

CREATE  TABLE CALLED members WITH 5 FIELDS id firstname lastname email password
INDEX.PHP

<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type="text/javascript">

function login(){
  var email = $('#email').val();//$('#email').val() is the value of the input field with id = email so we are goning to say var email will equal the value of that input
  var pass = $('#pass').val();//$('#pass').val() is the value of the input field with id = pass so we are goning to say var pass will equal the value of that input
  var URL = "parse.php";

  $.post(URL,{action:"login",logname:email,logpass:pass},function(data){
  $("#result").html(data).show();
  });
 }

</script>
<style type="text/css">
<!--
.font {
 font-family: Arial, Helvetica, sans-serif;
 font-size: 12px;
}
.result{
 font-family: Arial, Helvetica, sans-serif;
 font-size: 12px;
 font-weight: bold;
 color: #CC0000;
}
.txtstyle{
 height: 25px;
 width: 200px;
 border-top-width: 2px;
 border-right-width: 1px;
 border-bottom-width: 1px;
 border-left-width: 1px;
 border-top-style: solid;
 border-right-style: solid;
 border-bottom-style: solid;
 border-left-style: solid;
 border-top-color: #DDDDDD;
 border-right-color: #DDDDDD;
 border-bottom-color: #DDDDDD;
 border-left-color: #DDDDDD;
}
.loginbutton {
 clear: left;
}
-->
</style>

<table width="458" border="0" align="center" cellpadding="5" cellspacing="0">
  <tr>
    <td width="261" height="117" align="left" valign="bottom">log in </td>
    <td width="291" align="left" valign="bottom">sgin up</td>
  </tr>
  <tr>
    <td height="155" align="left" valign="top"><span class="font">Email</span><br />
      <input class="txtstyle" type="text" id="email" />//CREATE INPUT WITH TYPE=TEXT AND ID=EMAIL
      <br />
      <span class="font">Password</span><br />
      <input class="txtstyle" type="password" id="pass" />//CREATE INPUT WITH TYPE=PASSWORD AND ID=PASS
      <br />
      <input type="button" class="loginbutton" id="login" onclick="return false" onmousedown="javascript:login();" value="login"/>//CREATE INPUT WITH TYPE=BUTTON AND ONECE THE BUTTON IS CLICKED JAVASCRIPT:LOGIN() WILL RUN
      <br />
      <div id="result" class="result"></div></td>
    <td width="291" align="left" valign="top">SIGN UP FORM WILL BE HERE</td>
  </tr>
</table>
PARSE.PHP
<?php
include_once "mysql.php";

if($_POST['action']=="login"){

$email1 = $_POST['logname'];//$email1 = $('#email').val();
$pass = $_POST['logpass'];//$pass =  $('#pass').val();

if($email1 ==""){echo'Please enter your email'; }//if $email1 has no value show Please enter your email
else{//if $email1 has value
$sql = mysql_query("SELECT * FROM members WHERE email='$email1'");
$email_check = mysql_num_rows($sql); //check if $email1 value exist in the table
if($email_check == 1){//if exist proceed
  
while($row = mysql_fetch_array($sql)){

$password = $row["password"];//get the password

if($pass == ""){echo 'Please enter your password';}//if $pass has no value show Please enter your password

else if(md5($pass) != $password){echo 'Your password is incorrect';}//if encrypted $pass value not equal to
$password show Your password is incorrect

else{//if encrypted $pass value equal to $password the proceed

 //create sessions for the table values
$_SESSION['id']; 
$_SESSION['firstname']; 
$_SESSION['lastname'];  
$_SESSION['email']; 
echo'<script>window.location = "profile.php"</script>';
exit(); 
     }
    }
   }
   else if($email_check != 1){//if doesnt exist show Email is incorrect
   echo 'Email is incorrect';
   }
  }
}

else{echo'<script>window.location = "index.php"</script>';}

?>
PROFILE.PHP
<?php
session_start(); // Must start session first 
include_once "mysql.php";

if (isset($_SESSION['id'])) {  
$id = $_SESSION['id']; 
echo'you are logged in';
 }
else {echo 'you are not logged in';}
?>

HOW TO CREATE A PAGE MARKUP WITH CSS3 AND JQUERY

noreply@blogger.com (ebraam) — Sat, 18 Jun 2011 16:26:00 +0000

<style type="text/css">
<!--
body{
}
.menubar{
 height: 25px;
 width: 450px;
 border-top-left-radius: 10px;
 border-top-right-radius: 10px;
 background-color: #F9F9F9;
 padding: 5px;
 border-top-width: 1px;
 border-right-width: 1px;
 border-left-width: 1px;
 border-top-style: solid;
 border-right-style: solid;
 border-left-style: solid;
 border-top-color: #CCCCCC;
 border-right-color: #CCCCCC;
 border-left-color: #CCCCCC;
 border-bottom-width: 1px;
 border-bottom-style: solid;
 border-bottom-color: #CCCCCC;
 overflow: visible;
}
.button{
 border: 1px solid #CCCCCC;
 border-top-left-radius: 10px;
 border-top-right-radius: 10px;
 display: inline-block;
 font-family: Arial, Helvetica, sans-serif;
 font-size: 12px;
 color: #333333;
 margin-right: 5px;
 text-align: center;
 width: 65px;
 background-color: #E5E5E5;
 text-decoration: none;
 height: 17px;
 padding-top: 6px;
 padding-right: 5px;
 padding-bottom: 6px;
 padding-left: 5px;
}
.selbutton{
 border-top-left-radius: 10px;
 border-top-right-radius: 10px;
 display: inline-block;
 font-family: Arial, Helvetica, sans-serif;
 font-size: 12px;
 color: #333333;
 margin-right: 5px;
 text-align: center;
 width: 65px;
 background-color: #FFFFFF;
 text-decoration: none;
 height: 18px;
 padding-top: 6px;
 padding-right: 5px;
 padding-bottom: 6px;
 padding-left: 5px;
 border-top-width: 1px;
 border-right-width: 1px;
 border-left-width: 1px;
 border-top-style: solid;
 border-right-style: solid;
 border-left-style: solid;
 border-top-color: #CCCCCC;
 border-right-color: #CCCCCC;
 border-left-color: #CCCCCC;
 overflow: visible;
 visibility: visible;
}

.content{
 height: 27px;
 width: 450px;
 border-bottom-left-radius: 10px;
 border-bottom-right-radius: 10px;
 background-color: #FfFfFf;
 padding: 5px;
 border-right-width: 1px;
 border-bottom-width: 1px;
 border-left-width: 1px;
 border-right-style: solid;
 border-bottom-style: solid;
 border-left-style: solid;
 border-right-color: #CCCCCC;
 border-bottom-color: #CCCCCC;
 border-left-color: #CCCCCC;
}
-->
</style>
<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type="text/javascript">
$(document).ready(function(){
 $('#Tab2').css('display', 'none');//hide tab2 div
 $('#Tab3').css('display', 'none');//hide tab3 div
});

function tab1(){//once tab1 clicked on
 $('a').removeClass("selbutton");//remove .selbutton class from all linkes
 $('a').addClass("button");//add .button class to all linkes
 $('#b1').removeClass("button");//remove .button
 $('#b1').addClass("selbutton");//add .selbutton (this button will selected)
 $('#Tab2').css('display', 'none');//hide tab 2
 $('#Tab3').css('display', 'none');//hide tab 3
 $('#Tab1').css('display', 'inline-block');//show tab 1
 }
 function tab2(){//once tab2 clicked on
 $('a').removeClass("selbutton");//remove .selbutton class from all linkes
 $('a').addClass("button");//add .button class to all linkes
 $('#b2').removeClass("button");//remove .button
 $('#b2').addClass("selbutton");//add .selbutton (this button will selected)
 $('#Tab1').css('display', 'none');//hide tab 1
 $('#Tab3').css('display', 'none');//hide tab 3
 $('#Tab2').css('display', 'inline-block');//show tab 2
 }
 function tab3(){//once tab3 clicked on
 $('a').removeClass("selbutton");//remove .selbutton class from all linkes
 $('a').addClass("button");//add .button class to all linkes
 $('#b3').removeClass("button");//remove .button
 $('#b3').addClass("selbutton");//add .selbutton (this button will selected)
 $('#Tab1').css('display', 'none');//hide tab 1
 $('#Tab2').css('display', 'none');//hide tab 2
 $('#Tab3').css('display', 'inline-block');//show tab 2
 }
</script>

<div class="menubar"><a id="b1" href="#" class="selbutton" onclick="return false" onmousedown="javascript:tab1();">Tab1</a><a id="b2" href="#" class="button" onclick="return false" onmousedown="javascript:tab2();">Tab2</a><a id="b3" href="#" class="button" onclick="return false" onmousedown="javascript:tab3();">Tab3</a></div>
<div class="content"><div id="Tab1">tab1 is shown tabs 2 & 3 are hidden</div><div id="Tab2">tab2 is shown tabs 1 & 3 are hidden</div><div id="Tab3">tab3 is shown tabs 2 & 1 are hidden</div></div>

HOW TO GET FLASH MEDIA SERVER TO WORK WITH YOUR LOCAL SERVER

noreply@blogger.com (ebraam) — Fri, 17 Jun 2011 22:14:00 +0000

I would assume that you have already installed flash media server without apache. So what you would do is go to this folder Adobe\Flash Media Server 3\conf\_defaultRoot_ and look for the file called Adaptor.xml on line 42 you would set ctl_channel="127.0.0.1:19350" and in lines
144   <Redirect enable="false" maxbuf="16384">
145 <Host port="80">:8080</Host>
146 <Host port="443">:8443</Host>
147 </Redirect>
same with lines 182 to 185.
and then save it. after that you would go to the text file called fms in the  Adobe\Flash Media Server 3\conf\ and set the ADAPTOR.HOSTPORT = 127.0.0.1:1935 and then save the file.

now with everything done you can enjoy your flash media server

my video comment system

noreply@blogger.com (ebraam) — Fri, 17 Jun 2011 15:53:00 +0000

this is demo for my upcoming tutorials

LEARN HOW TO CREATE COMMENT SYSTEM WITH PHP AND JQUERY

noreply@blogger.com (ebraam) — Fri, 17 Jun 2011 01:21:00 +0000

first create table and call it "comment" with 3 fields id, name and comment

mysql.php 

<?php 
@mysql_connect("localhost","root","") or die ("could not connect to mysql");
@mysql_select_db("name of your database") or die ("no database");
?>
///////////page end here

index.php

<?php 
include_once "mysql.php";
//////render data that is already stored in the data base
 $sql_comments = mysql_query("SELECT * FROM comment ORDER BY id DESC");
while($row = mysql_fetch_array($sql_comments)){
 $name = $row["name"];
 $comment = $row["comment"];
 
 $commentlist .= 'name : '.$name.'<br />comment : '.$comment.'<hr>';
}
//////////////
?>

<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type="text/javascript">
$(document).ready(function(){
 $('#loading').hide();
});

function wall(){
$('#loading').show();

  var name = $('#name').val();///#name is the input id from the form and will be equal the variable "name"
  var comment = $('#comment').val();/////#comment is textarea id from the form and will be equal the variable "comment"
  var URL = "post.php"; /////post.php will be equal the variable "comment"
  
  $.post(URL,{wall:"post",name1:name,comment1:comment},function(data){//parameter wall will be equal "post", name1 will be equal to the var "name" and comment1 will be equal to the var "comment"
  $("#result").prepend(data).show();// the result will be placed above the the #result div
  $('#loading').hide();
  });
 }
</script>

<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><div id='form'><form>
    name<br />
      <input type="text" id="name" />
      <br />
   comment<br />
      <textarea id="comment" cols="45" rows="5"></textarea>
      <br />
      <input type="submit" name="button" id="button" value="Submit" onclick="return false" onmousedown="javascript:wall();"/><img src="loading.gif" alt="" width="15" height="15" id="loading" />
      <br /></form>
    </div>
      <div id="result"><?php print"$commentlist";?></div></td>
  </tr>
</table>

post.php 
<?php
include_once "mysql.php";

  if ($_POST['wall'] == "post"){
  $name = $_POST['name1'];//name1 is parameter from the jquery function  
  $comment = $_POST['comment1'];//comment1 is parameter from the jquery function  
   if ($comment=="" || $name==""){exit();}// if no name or comment exit the script
   else{
   //insert the name and comment into database 
  $sql = mysql_query("INSERT INTO comment (name,comment) 
     VALUES('$name','$comment')")
     or die (mysql_error());  
  // the inserted comment will renderd by the "$("#result").prepend(data).show();" from jquery
 echo 'name : '.$name.'<br />comment : '.$comment.'<hr>';
     }
}
?>

PAGINATION TUTORIAL USING JQUERY AND PHP

noreply@blogger.com (ebraam) — Thu, 16 Jun 2011 21:28:00 +0000


first create table and call it pagination with 3 fields  id,

name and age and enter

dummy data


mysql.php 

<?php 
@mysql_connect("localhost","root","") or die ("could not connect to mysql");
@mysql_select_db("name of your database") or die ("no database");
?>
///////////page end here

index.php

<?php
include_once "mysql.php";//include the mysql connect script

$pagen=0;

$sql_rec = mysql_query("SELECT * FROM pagination ORDER BY id DESC LIMIT $pagen,4");//<---- this statement mean that you chose the first 4 results
while($row = mysql_fetch_array($sql_rec)){//<---- this statement fetch first 4 results
 $id = $row["id"];
 $name = $row["name"];
 $age = $row["age"];
 
$namelist .= 'name : '.$name.' age : '.$age.'<br />' ;
}

$sql_list = mysql_query("SELECT * FROM pagination");
$num_rows = mysql_num_rows($sql_list);//<---- this statement to determine number of row we will paginate
$pnumber = ceil($num_rows/4);//<---- we will divide the number of rows by 4 which is the number of post we will render  
?>

<style type="text/css">
<!--
body {
}
.link {
 background-color: #FFFFFF;
 font-family: Arial, Helvetica, sans-serif;
 font-size: 12px;
 font-weight: bold;
 color: #003399;
 text-decoration: none;
 padding-right: 2px;
 padding-left: 2px;
}

-->
</style>
<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type="text/javascript">
$(document).ready(function(){
//$('#loading').hide();//<----this will hide loading gif 
$('.link').first().css('background', 'grey');//<----this will highlight the number 1
});

function pages(page){//<----this function will run we clicked on the show more link      ( page = '.$e.')

//$('#loading').show();//<----this loading gif will appear
  $('.link').css('background', 'white');  //<----this will remove the highlight
  $("#pages" + page).css('background', 'grey');//<----this will highlight number that was clicked
  var URL = "userslist.php";
  $.post(URL,{pages:"paginate",pageNumber:page},function(data){//<----will run the userslist.php
  $("#OldComment").html(data).show();//<----replace the old page with the new one
  $('#loading').hide();
  });
 }
</script>

<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><div id='OldComment'><?php print"$namelist"; ?></div>
      <div class="pagination">
        <?php
    for($i=0; $i<=($pnumber-1); $i++)//<----we run a for loop that start from 0 to $pnumber 
  {
   $e= $i*4 ;//<----this will replace $pagen in the userlist.php
   $d=$i+1; //<----this will the number the pages
   echo '<a class="link" id="pages'.$e.'" href="#" onclick="return false" onmousedown="javascript:pages('.$e.');">'.$d.'</a> ';//<----when you click on this link the javascript:pages('.$e.'); will run 
  }
?>
     //   <img src="loading.gif" alt="" width="15" height="15" id="loading" /></div></td>//<----this loading gif will appear every time 
  </tr>
</table>

/////////////////////////////page end here
userslist.php
<?php
$pagen = $_POST['pageNumber'];//<----resulted from the jquery we ran in last script 
include_once "mysql.php";
 if ($_POST['pages'] == "paginate"){
$sql_selfnews = mysql_query("SELECT * FROM pagination ORDER BY id DESC LIMIT $pagen,4");//<---- this statement will select next 4 results
while($row = mysql_fetch_array($sql_selfnews)){
 $id = $row["id"];
 $name = $row["name"];
 $age = $row["age"];
 
$namelist .= 'name : '.$name.' age : '.$age.'<br />' ;
}
}
?>
<?php print"$namelist"; ?>//<---- this statement will render next 4 results

CHECK IF USER ONLINE OR AWAY SCRIPT

noreply@blogger.com (ebraam) — Wed, 15 Jun 2011 17:58:00 +0000



this script will tell if user is online doing something on your site or if he is away. if user remained inactive for 10 seconds he will labeled away

create table in your data base called members with 4 fields 1d, email, password and activity. and enter some dummy data

mysql.php

<?php
@mysql_connect("localhost","root","") or die ("could not connect to mysql");
@mysql_select_db("name of your database") or die ("no database");
?>

index.php (will contain the login script)

<?php
if ($_POST['email']) {
//Connect to the database through our include 
include_once "mysql.php";
$email = $_POST['email'];
$password = $_POST['password'];

$sql = mysql_query("SELECT * FROM members WHERE email='$email' AND password='$password'"); 
$login_check = mysql_num_rows($sql);
if($login_check > 0){ 
while($row = mysql_fetch_array($sql)){ 

$id = $row["id"]; 
session_register('id'); 
$_SESSION['id'] = $id;

header ("Location: profile.php?id=$id");
exit();
} // close while
}
}
?>

<style type="text/css">
<!--
body {
}
-->
</style>
<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type="text/javascript">
</script>

<form action="index.php" method="post" class="body">
      <input name="email" type="text" class="textfield" id="textfield" value=""/>
      <br />
      <input name="password" type="password" class="textfield" id="textfield2" value=""/>
      <br />
      <input type="submit" name="button" id="button" value="Sign In" />
</form>
////////////////////////

profile.php

<?php

session_start(); // Must start session first thing 

if (!isset($_SESSION['id'])) { 
print 'you are not logged in';
exit(); 
} 

include_once "mysql.php";
if (isset($_SESSION['id'])) { 
$id = $_SESSION['id'];
$mid = $_GET['id'];
$time=time();//to get the timestamp
 }

mysql_query("UPDATE members SET lastactivity='$time' WHERE id='$id'");//every time this page refresh lastactivity will be updated

$sql = mysql_query("SELECT * FROM members WHERE id='$mid'"); 
while($row = mysql_fetch_array($sql)){
$id = $row["id"];
$email = $row["email"];
}
?>
  <script type="text/javascript" src="js/jquery-1.4.2.js"></script>
  <script type="text/javascript">
//load check.php in the <span id="online"></span> and refresh every 1 second
$(document).ready(function(){
   $("#online").load('check.php?id=<?php print"$id";?>');
   setInterval(function(){
  $("#online").load('check.php?id=<?php print"$id";?>');
   },1000);//
});
</script>

this is <b><?php print"$email";?></b> and he is <b><span id="online"></b></span>
////////////////////////////

check.php

<?php

session_start(); // Must start session first thing 

if (!isset($_SESSION['id'])) { 
print 'you are not logged in';
exit(); 
} 

include_once "mysql.php";
if (isset($_SESSION['id'])) { 
$id = $_SESSION['id'];
$mid = $_GET['id'];
$time=time();
 }

$sql = mysql_query("SELECT * FROM members WHERE id='$mid'"); 
while($row = mysql_fetch_array($sql)){
$id = $row["id"];
$email = $row["email"];
$lastactivity = $row["lastactivity"];

if(time() > $lastactivity+10/*10 is the number of seconds user stay online without doing activity on the page you can always change it */){$onlineStats = "away";}//if the last time you did something on your page + 10 seconds is less than the current time. your onlinestats will equal away or you can change to offline
else if(time() < $lastactivity+10){$onlineStats = "online";}//if the last time you did something on your page + 10 seconds is greater than the current time. your onlinestats will equal online
}
?>
<?php print"$onlineStats";?>

LEARN WRITE TWITTER LOAD MORE RESULT SCRIPT USING JQUERY AND PHP

noreply@blogger.com (ebraam) — Wed, 08 Jun 2011 04:32:00 +0000



first create table and call it pagination with 3 fields  id ,name and

age and enter dummy data

mysql.php 

<?php 
@mysql_connect("localhost","root","") or die ("could not connect to mysql");
@mysql_select_db("name of your database") or die ("no database");
?>
///////////page end here

index.php

<?php
include_once "mysql.php";//include the mysql connect script

$pagen=0;

$sql_rec = mysql_query("SELECT * FROM pagination ORDER BY id DESC LIMIT $pagen,4");//<---- this statement mean that you chose the first 4 results
while($row = mysql_fetch_array($sql_rec)){//<---- this statement fetch first 4 results
 $id = $row["id"];
 $name = $row["name"];
 $age = $row["age"];
 
$namelist .= 'name : '.$name.' age : '.$age.'<br />' ;
}

$sql_list = mysql_query("SELECT * FROM pagination");
$num_rows = mysql_num_rows($sql_list);//<---- this statement to determine number of row we will paginate
$pnumber = ceil($num_rows/4);//<---- we will divide the number of rows by 4 which is the number of post we will render  

?>

<style type="text/css">
<!--
body {
}
.link {
 background-color: #FFFFFF;
 font-family: Arial, Helvetica, sans-serif;
 font-size: 12px;
 font-weight: bold;
 color: #003399;
 text-decoration: none;
 padding-right: 2px;
 padding-left: 2px;
}

-->
</style>
<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type="text/javascript">
$(document).ready(function(){
//$('#loading').hide();//<----this will hide loading gif 
 $('.link').css('display', 'none');//<----this will hide .link anchor
 $('.link').first().css('display', 'none').next().css('display', 'inline-block');//<----this will show the second .link anchor 
});

function pages(page){//<----this function will run we clicked on the show more link      ( page = '.$e.')

//$('#loading').show();//<----this loading gif will appear
  //alert("page" + page);
  $("#pages" + page).css('display', 'none').next().css('display', 'inline-block');//<----hide the link that you click and show the next if existed
  var URL = "userslist.php";
  $.post(URL,{pages:"paginate",pageNumber:page},function(data){//<----will run the userslist.php
  $("#OldComment").append(data).show();//<----show the new 4 results
  $('#loading').hide();
  });
 }
</script>

<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><div id='OldComment'><?php print"$namelist"; ?></div>
      <div class="pagination">
        <?php
    for($i=0; $i<=($pnumber-1); $i++)//<----we run a for loop that start from 0 to $pnumber 
  {
   $e= $i*4 ;//<----this will replace $pagen in the userlist.php
   
   echo '<a class="link" id="pages'.$e.'" href="#" onclick="return false" onmousedown="javascript:pages('.$e.');">Show more</a> ';//<----when you click on this link the javascript:pages('.$e.'); will run 
  }
?>
     //   <img src="loading.gif" alt="" width="15" height="15" id="loading" /></div></td>//<----this loading gif will appear every time 
  </tr>
</table>
/////////////////////////////page end here
userslist.php
<?php
$pagen = $_POST['pageNumber'];//<----resulted from the jquery we ran in last script 
include_once "mysql.php";
 if ($_POST['pages'] == "paginate"){
$sql_selfnews = mysql_query("SELECT * FROM pagination ORDER BY id DESC LIMIT $pagen,4");//<---- this statement will select next 4 results
while($row = mysql_fetch_array($sql_selfnews)){
 $id = $row["id"];
 $name = $row["name"];
 $age = $row["age"];
 
$namelist .= 'name : '.$name.' age : '.$age.'<br />' ;
}
}
?>
<?php print"$namelist"; ?>//<---- this statement will render next 4 results