(/ESCb6Ѐ_p5MT&.`=%7<8Zz67QI3ۨ&fj8[I|I4 d< X;2G Up]'|2_B?tC7N[W03 ^EM](Q $o|Hbn2lB̷֜2|㩓v*G `6uZٷ t |b?u("̪Ӕ;O4TY%I̟uI Uw(|X$ȖyIeWߔg I?'h#0$zU{Co.(:Isah%G6a7#H^;#x!L>veVZXgS"xn:3ʗLC]uF]a=Lgt6nG(qK/c\W1Kb ֜)Q08bZu<['%!Z_*V9(JLP A9)&6t9 W5c2AXEn|F4AڂI?LYz|?6U4/l8:bKPSּRs.8$n[ONHeNQ G^_R{@QrlG"݀Фc'oNrJ_-2q~L{b{Rb G('ʺ r4{㌦O lZ|hΉ??ޏ@%ݬJi2(QŽT^1dm~2 5QrVu# )wYDly5 .L:ɞ!o y =cK-CnI*:> lzsЊLJ_ӛY0!0]Ngdt(jgT0ֵwWU(㬨ނ`L pzt?>"ZNcve#~-g'bJ aK'$X0pLAQ*ByiYyf9+pN.W[G2kXF&riJpxEIa1:xUb pmBO3 xV'<6Rx[4Vج9*W%aE"Y%L`&pAX f*=;?kIiUtبGd+94"BmާI *FSL-w ^Sg۸ E\k[Fga%TudTt1S I=R}9ywgrh*z[Jǰ: Faؙ-…Y2_&xg .n X$3ɸ1fex>^O!u!RJ\ҮsKJޥ,Cѵ9Pq)h)2L)-K./M4&Bb{WFJ0vY"`?wpD\\ZzzY}h-H;+Ih#ǝwqJ b,/7Pg:xUb pmBO3 xV'<6Rx[4Vج9*W%aE"Y%L`&pAX f*=;?kIiUtبGd+94"BmާI *FS Gį%˹a”8' \,r3FhO_5iTmdJ-(ٝ!Q]y@$ !Aau=ِG@'z@UOv/f)n]j_/ gY&){+Nkxx~Ӯk/_!i;K la=jn\#ˆ6u[;G|{7l$N`Fi EjUC釆ʸF4I]B W~ :`Gl!yTx}yk8TOu_OFT6cYOVG^sd_`ۗHDMY9 h ΡU/svqnFQI\1OsA=[ܰǨ?x+2`obѭd6@֋{n2>sD@NT@$KzO|SL )YI f_c<*P*MZzn(4lPQ;"S? 3T׾V7k{Pøn5p+q-d>qɆʠL'yX;Hv=%?^ <4믃X5Į?ϧ4i5ʈ%fyi$ߑ9Oq)-M" 2>՟v1h;kc5ҙCj#ű ۖ4jϙzCG\i(RБ {8p© Vܾp6h ;4E,Kbio|3Naq~f06*V1m>ɩBU)zk|Du8"gLZR(P(i7yc*4u$ÿ:^s3 'Z bo=+c7 ̽d{0ջ)\0NÑoeXC%ϒ-+.:z"7r|dpF}+$m#{yxId4_hrp\PӭqyM#N (Ƙ(HD'Ҥb0VmRfYDZAQtq y?D-jl! #@),1\1s}g/?{ꞭuK 0;K܁ s5lKx2M;c@(FLt`<;d8i֓'0C%򩏺*ЙhFC#vmd9&seQne#gr^|fړnA;hP(F.tE׌jcLdp:%~]h42ܥw+O\2/q>zF lsZyJEgO-q}"gQ<^kBclEU*hv*!^jxHPӳ$!HeP]<ޞ-0Ȯ5U4o&Ϊqaqi٨yt 咼kI_N6 ܏_Rc|u^ϡ#!/X+켵^B={8Z> Ҡ4f>鈃Yyӫ* ʣ7=_?4'Aη/mq3tegLabAddress,Contacts) values ('$detail','$cashAccount','$date_',$LabID,'$LabName','$LabAddress','$Contacts')"; } else { $query = "update lab set detail='$detail',cashAccount='$cashAccount',date_='$date_',LabName='$LabName',LabAddress='$LabAddress',Contacts='$Contacts' where LabID='$LabID'"; } //echo $query; mysqli_query($con,$query); if($_FILES["fileToUpload"]["tmp_name"]!=""){ $oldImg=getName($con,"select banner from lab where LabID='$LabID'"); if(file_exists("fpdf/".$oldImg)) unlink("fpdf/".$oldImg); $picname=$LabID."_".basename($_FILES["fileToUpload"]["name"]); $target_file = "fpdf/images/$picname"; move_uploaded_file($_FILES["fileToUpload"]["tmp_name"],$target_file); $query="update lab set banner='images/$picname' where LabID='$LabID'"; mysqli_query($con,$query); } /* $temp_name=$_FILES["fileToUpload"]["tmp_name"]; $imageFileType = pathinfo($temp_name,PATHINFO_EXTENSION); $picname=$LabID."_".basename($_FILES["fileToUpload"]["name"]); $target_file = "fpdf/images/$picname"; if(move_uploaded_file($temp_name, $target_file)){ $oldImg=getName($con,"select banner from lab where LabID='$LabID'"); if ($oldImg!="") unlink("fpdf/$oldImg"); $query="update lab set banner='images/$picname' where LabID='$LabID'"; mysqli_query($con,$query); } */ echo ""; //echo ""; } if (isset ($_GET['del'])) { //exit(); $LabID = $_GET['del']; mysqli_query($con,"delete from lab where LabID='$LabID'"); mysqli_query($con,"delete from users where LabID='$LabID'"); mysqli_query($con,"delete from accounts where LabID='$LabID'"); mysqli_query($con,"delete from item where LabID='$LabID'"); mysqli_query($con,"delete from payments where LabID='$LabID'"); mysqli_query($con,"delete from designation where LabID='$LabID'"); mysqli_query($con,"delete from purchase where LabID='$LabID'"); mysqli_query($con,"delete from purchase2 where LabID='$LabID'"); mysqli_query($con,"delete from purchaseReturn where LabID='$LabID'"); mysqli_query($con,"delete from purchaseReturn2 where LabID='$LabID'"); mysqli_query($con,"delete from sale where LabID='$LabID'"); mysqli_query($con,"delete from sale2 where LabID='$LabID'"); mysqli_query($con,"delete from saleReturn where LabID='$LabID'"); mysqli_query($con,"delete from saleReturn2 where LabID='$LabID'"); mysqli_query($con,"delete from ledger where LabID='$LabID'"); mysqli_query($con,"delete from expensesheads where LabID='$LabID'"); mysqli_query($con,"delete from expensesdaily where LabID='$LabID'"); mysqli_query($con,"delete from userlog where LabID='$LabID'"); mysqli_query($con,"delete from smslog where LabID='$LabID'"); mysqli_query($con,"delete from infolog where LabID='$LabID'"); } if (isset ($_GET['delLabData'])) { //exit(); $LabID = $_GET['delLabData']; //mysqli_query($con,"delete from lab where LabID='$LabID'"); //mysqli_query($con,"delete from users where LabID='$LabID'"); mysqli_query($con,"delete from accounts where LabID='$LabID'"); mysqli_query($con,"delete from item where LabID='$LabID'"); mysqli_query($con,"delete from payments where LabID='$LabID'"); mysqli_query($con,"delete from designation where LabID='$LabID'"); mysqli_query($con,"delete from purchase where LabID='$LabID'"); mysqli_query($con,"delete from purchase2 where LabID='$LabID'"); mysqli_query($con,"delete from purchaseReturn where LabID='$LabID'"); mysqli_query($con,"delete from purchaseReturn2 where LabID='$LabID'"); mysqli_query($con,"delete from sale where LabID='$LabID'"); mysqli_query($con,"delete from sale2 where LabID='$LabID'"); mysqli_query($con,"delete from saleReturn where LabID='$LabID'"); mysqli_query($con,"delete from saleReturn2 where LabID='$LabID'"); mysqli_query($con,"delete from ledger where LabID='$LabID'"); mysqli_query($con,"delete from expensesheads where LabID='$LabID'"); mysqli_query($con,"delete from expensesdaily where LabID='$LabID'"); mysqli_query($con,"delete from userlog where LabID='$LabID'"); mysqli_query($con,"delete from smslog where LabID='$LabID'"); mysqli_query($con,"delete from infolog where LabID='$LabID'"); mysqli_query($con,"delete from family where LabID='$LabID'"); mysqli_query($con,"delete from imeitbl where LabID='$LabID'"); } if (isset ($_GET['delDataAllOthers'])) { echo $database=basename(__DIR__); //for local User if($database=='ele1'){ //for local only exit(); } $LabID = $_GET['delDataAllOthers']; mysqli_query($con,"delete from lab where LabID!='$LabID'"); mysqli_query($con,"delete from users where LabID!='$LabID'"); mysqli_query($con,"delete from accounts where LabID!='$LabID'"); mysqli_query($con,"delete from item where LabID!='$LabID'"); mysqli_query($con,"delete from payments where LabID!='$LabID'"); mysqli_query($con,"delete from designation where LabID!='$LabID'"); mysqli_query($con,"delete from purchase where LabID!='$LabID'"); mysqli_query($con,"delete from purchase2 where LabID!='$LabID'"); mysqli_query($con,"delete from purchaseReturn where LabID!='$LabID'"); mysqli_query($con,"delete from purchaseReturn2 where LabID!='$LabID'"); mysqli_query($con,"delete from sale where LabID!='$LabID'"); mysqli_query($con,"delete from sale2 where LabID!='$LabID'"); mysqli_query($con,"delete from saleReturn where LabID!='$LabID'"); mysqli_query($con,"delete from saleReturn2 where LabID!='$LabID'"); mysqli_query($con,"delete from ledger where LabID!='$LabID'"); //mysqli_query($con,"truncate ledger where LabID!='$LabID'"); mysqli_query($con,"delete from expensesheads where LabID!='$LabID'"); mysqli_query($con,"delete from expensesdaily where LabID!='$LabID'"); mysqli_query($con,"delete from userlog where LabID!='$LabID'"); mysqli_query($con,"delete from smslog where LabID!='$LabID'"); mysqli_query($con,"delete from infolog where LabID!='$LabID'"); mysqli_query($con,"delete from family where LabID!='$LabID'"); mysqli_query($con,"delete from imeitbl where LabID!='$LabID'"); } $database=basename(__DIR__); //for local User echo "
SerialDateLabNameLabAddressContactEditDeleteLab Data"; $query = "select * from lab order by date_ desc,LabID desc"; $cnt=1; //echo $query; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $LabID = $row['LabID']; $LabName = $row['LabName']; $LabAddress = $row['LabAddress']; $Contacts = $row['Contacts']; echo "
$cnt".$row['date_']."$LabName$LabAddress$ContactsEdit"; echo "Delete"; echo "del Data"; if($database=='ele' or $database=='elei'){ //for local only echo "del All Other Data"; } //echo "del"; echo "Detail"; $cnt+=1; } ?>