VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
ADMIN SITE LOGIN PAGE
TYBCA (SEM: V)
Page 1 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL header("location:reg_disp.php"); $c=mysql_num_rows($res); if($c>0) { $_SESSION['user']=$_REQUEST['txtuname']; header("location:reg_disp.php"); } else $m="
login NOT successfully"; } ?>
LOGOUT logout.php
TYBCA (SEM: V)
Page 3 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL CHANGE PASSWORD
chpass.php 0)
TYBCA (SEM: V)
Page 4 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL { if($_REQUEST['txtnpass']==$_REQUEST['txtcpass']) { $u="update login_master set login_possword='".$_REQUEST['txtnpass']."' where login_username like '".$_SESSION['user']."'"; mysql_query($u); $m="Password changed Successfully..!!.."; //header("location:login.php"); } else { $m="
NEW PASSWORD AND CONFIRM PASSWORD DOES NOT MATCH"; } } else { $m="
INCORRECT OLD PASSWORD"; } } ?>
TYBCA (SEM: V)
Page 7 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
CONTACT US CONNECT.PHP
INSERT
contacts_insert.php
TYBCA (SEM: V)
Page 8 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL if(isset($_REQUEST['btnsubmit'])) { $q="insert into contacts_mst set first_name='".$_REQUEST['txtfname']."', last_name='".$_REQUEST['txtlname']."', email='".$_REQUEST['txtemail']."', phone='".$_REQUEST['txtphone']."', message='".$_REQUEST['txtmsg']."'"; mysql_query($q); header("location:contacts_display.php"); } ?>
TYBCA (SEM: V)
Page 10 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL DISPLAY
contacts_delete.php
$q="delete from contacts_mst where con_id=".$_GET['id']; mysql_query($q); header("location:contacts_display.php"); ?> contacts_display.php
TYBCA (SEM: V)
Page 11 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL $q="select * from contacts_mst"; if(isset($_REQUEST['btnsearch'])) { $q="select * from contacts_mst where first_name like '%".$_REQUEST['txtsearch']."%' or last_name like '%".$_REQUEST['txtsearch']."%'"; } $res=mysql_query($q); $count=mysql_num_rows($res); ?>
EDIT Formatted: Font: 12 pt, Bold, Underline, Font color: Text 1 Formatted: Font: 12 pt, Bold, Underline, Font color: Text 1
contacts_edit.php
TYBCA (SEM: V)
Page 14 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL $s="select * from contacts_mst where con_id=".$_REQUEST['id']; $res=mysql_query($s); $row=mysql_fetch_object($res);
if(isset($_REQUEST['btnsubmit'])) { $q="update contacts_mst set first_name='".$_REQUEST['txtfname']."', last_name='".$_REQUEST['txtlname']."', email='".$_REQUEST['txtemail']."', phone='".$_REQUEST['txtphone']."', message='".$_REQUEST['txtmsg']."' where con_id=".$_REQUEST['id']; mysql_query($q); header("location:contacts_display.php"); } ?>
TYBCA (SEM: V)
Page 17 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
REGISTERATION INSERT
reg_ins.php
TYBCA (SEM: V)
Page 18 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL reg_img='".$_FILES['imgsfile']['name']."'
"; mysql_query($q);
MOVE_UPLOADED_FILE($_FILES['imgsfile']['tmp_name'],"images/".$_FILES['imgsfile']['name' ]); header("location:reg_disp.php"); } ?> welcome.. UDIT
DISPLAY
reg_del.php reg_disp.php
TYBCA (SEM: V)
Page 21 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL include "scheck.php"; include "header.php"; include "connect.php"; $q="select * from reg_mst"; if(isset($_REQUEST['btnsearch'])) { $q="select * from reg_mst where reg_fname like '%".$_REQUEST['txtsearch']."%' or reg_lname like '%".$_REQUEST['txtsearch']."%' "; } $res=mysql_query($q); $count=mysql_num_rows($res); ?>
TYBCA (SEM: V)
Page 24 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL EDIT
reg_edit.php
Page 25 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL reg_mail='".$_REQUEST['txtemail']."', reg_fname='".$_REQUEST['txtfname']."', reg_lname='".$_REQUEST['txtlname']."', reg_uname='".$_REQUEST['txtuname']."', reg_password='".$_REQUEST['txtpass']."' where reg_id=".$_get['sid'];
} else { $q="update reg_mst set reg_mail='".$_REQUEST['txtemail']."', reg_fname='".$_REQUEST['txtfname']."', reg_lname='".$_REQUEST['txtlname']."', reg_uname='".$_REQUEST['txtuname']."', reg_password='".$_REQUEST['txtpass']."', reg_img='".$_FILES['imgsfile']['name']."' where reg_id=".$_get['sid'];
} mysql_query($q);
MOVE_UPLOADED_FILE($_FILES['imgsfile']['tmp_name'],"images/".$_FILES['imgsfile']['name' ]); header("location:reg_disp.php"); } ?> TYBCA (SEM: V)
Page 26 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
TYBCA (SEM: V)
Page 28 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
WEB DEVELOPMENT INSERT
web_ins.php
Page 29 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL web_coustomer='".$_REQUEST['txtpass']."', web_img='".$_FILES['imgsfile']['name']."'
"; mysql_query($q);
MOVE_UPLOADED_FILE($_FILES['imgsfile']['tmp_name'],"images/".$_FILES['imgsfile']['name' ]); header("location:web_disp.php"); } ?> welcome..
DISPLAY
web_del.php web_disp.php
TYBCA (SEM: V)
Page 32 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL //session_start(); include "scheck.php"; include "connect.php"; INCLUDE "header.php"; $q="select * from web_mst"; if(isset($_REQUEST['btnsearch'])) { $q="select * from web_mst where web_seo like '%".$_REQUEST['txtsearch']."%' or web_coustomer like '%".$_REQUEST['txtsearch']."%' "; }
$res=mysql_query($q); $count=mysql_num_rows($res);
?>
EDIT
TYBCA (SEM: V)
Page 35 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
web_edit.php
TYBCA (SEM: V)
Page 36 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL $q="update web_mst set web_seo='".$_REQUEST['txtemail']."', web_onlinestore='".$_REQUEST['txtfname']."', web_blog='".$_REQUEST['txtlname']."', web_mobilefriendly='".$_REQUEST['txtuname']."', web_coustomer='".$_REQUEST['txtpass']."' where web_id=".$_get['sid'];
} else { $q="update web_mst set web_seo='".$_REQUEST['txtemail']."', web_onlinestore='".$_REQUEST['txtfname']."', web_blog='".$_REQUEST['txtlname']."', web_mobilefriendly='".$_REQUEST['txtuname']."', web_coustomer='".$_REQUEST['txtpass']."', web_img='".$_FILES['imgsfile']['name']."' where web_id=".$_get['sid']; } mysql_query($q);
TYBCA (SEM: V)
Page 37 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
MOVE_UPLOADED_FILE($_FILES['imgsfile']['tmp_name'],"images/".$_FILES['imgsfile' ]['name']); header("location:web_disp.php"); } ?> welcome..
TYBCA (SEM: V)
Page 40 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
USER SITE DESIGN
TYBCA (SEM: V)
Page 41 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
TYBCA (SEM: V)
Page 42 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
TYBCA (SEM: V)
Page 43 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
TYBCA (SEM: V)
Page 44 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
TYBCA (SEM: V)
Page 45 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
TYBCA (SEM: V)
Page 46 of 47
VIDYABHARTI TRUST COLLEGE OF BBA & BCA. UMRAKH SUB: PHP MYSQL JOURNAL
TYBCA (SEM: V)
Page 47 of 47