DB Connection
mysql_connect(‘localhost’,'root’,”);
mysql_select_db(‘dbname’);
$sql_admin=”select * from tbl_users ORDER BY users_date DESC”;
$sql_query=mysql_query($sql_admin);
$count=1;
if(mysql_num_rows($sql_query)>0)
{
while($result=mysql_fetch_array($sql_query))
{
count++;
}
}
_____________________________________________
Pagination
$sql_admin=”select * from tbl_adminusers ORDER BY admin_createdDate DESC”;
$ord = new Split($sql_admin,10,$ppage,”",”",”");
$next = $ord->next_link;
$back = $ord->back_link;
$mid = $ord->middle_link;
$paging = $back . $mid . $next ;
if($ord->totalrows > 0){
$count = $ord->minimum;
while($Ary_admin = mysql_fetch_array($ord->rows))
{
$count++;
}
}
echo $paging;
________________________________________________
Message display
if($_REQUEST['msg']==’dele’){
$msg = ‘Admin user has deleted successfully’;
}
____________________________________________________
Alert JavaScript
<script language=”JavaScript” ”text/javascript”>
function checkform (formname )
{
//username validation
if (formname.admin_username.value.length == “”) {
alert( “Please Enter the User Name” );
formname.admin_username.focus();
return false ;
}
return true ;
}
</script>
_______________________________________________________
Edit
if (isset($_POST['btn_edit'])){
$admin_username = $_POST['admin_username'];
$admin_email = $_POST['admin_email'];
$sql_edit = “UPDATE tbl_adminusers SET
admin_email = ‘”.$admin_email.”‘
WHERE admin_id = ‘”.$_REQUEST['admin_id'].”‘ “;
$qry_edit = mysql_query($sql_edit);
header(“Location:list_admin.php?msg=edit”);
}
<script ”text/javascript” src=”http://9.cdn.blog.com/wp-admin/scripts/flexdropdown/jquery.min.js”></script>
<script ”text/javascript”>
function edit(){
if(jQuery(“#admin_email”).val()==0){
jQuery(“.error_text”).html(‘Please enter email address…’);
jQuery(“#admin_email”).focus();
return false;
}else{
jQuery(“.error_text”).html(”);
}
</script>
<input ”submit” name=”btn_edit” id=”btn_edit” value=”Update” onclick=”return edit();”/>
__________________________________________________________
Insert
$sql_admin = “INSERT INTO tbl_adminusers (
admin_username,
admin_password,
admin_email,
admin_createdDate
)
VALUES (
‘”.$admin_username.”‘,
‘”.$admin_password.”‘,
‘”.$admin_email.”‘,
‘”.$admin_createdDate.”‘
)”;
$qry_admin = mysql_query($sql_admin);
header(“Location:list_admin.php?msg=insert”);
_________________________________
JOIN
$sql_merchantlist=”select tbl_mechantprimary.pri_company, from tbl_mechantprimary LEFT JOIN tbl_merchantlogin on tbl_mechantprimary.pri_logid=tbl_merchantlogin.log_id
LEFT JOIN tbl_merchantpayment on tbl_merchantlogin.log_id=tbl_merchantpayment.pay_logid”;
_______________
page1
session_start(); // this sets variables in the session
$_SESSION['logged']=’testing’;
page 2
if($_SESSION['logged']==”"){
header(“location: pleaselogin.php”);
}else{
//is session is equal to something
}
__________________
UPLOAD AND SAVE A FILE
<?php
if ((($_FILES["file"]["type"] == “image/gif”)
|| ($_FILES["file"]["type"] == “image/jpeg”)
|| ($_FILES["file"]["type"] == “image/pjpeg”))
&& ($_FILES["file"]["size"] < 20000))
{
if ($_FILES["file"]["error"] > 0)
{
echo “Return Code: ” . $_FILES["file"]["error"] . “<br />”;
}
else
{
echo “Upload: ” . $_FILES["file"]["name"] . “<br />”;
echo “Type: ” . $_FILES["file"]["type"] . “<br />”;
echo “Size: ” . ($_FILES["file"]["size"] / 1024) . ” Kb<br />”;
echo “Temp file: ” . $_FILES["file"]["tmp_name"] . “<br />”;
if (file_exists(“upload/” . $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . ” already exists. “;
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
“upload/” . $_FILES["file"]["name"]);
echo “Stored in: ” . “upload/” . $_FILES["file"]["name"];
}
}
}
else
{
echo “Invalid file”;
}
?>