PageRenderTime 254ms queryFilters 1ms Sphinxql 21ms app.CodeModel.GetByIds 112ms findMatchingLines 68ms GetByIds 180ms meta 0ms repositoryFilters 11ms languageFilters 2ms sourceFilters 4ms

67,639 results for 'mysql_query' (254 ms)

Source

Language

Repository

db_MYSQL.php https://github.com/DEVVELO/TravianZ-By-Shadowss.git | PHP | 3,784 lines
24		mysql_select_db(SQL_DB, $this->connection) or die(mysql_error());
25		mysql_query("SET NAMES 'UTF8'");  //Fix utf8 phpmyadmin by gm4st3r
26	}
36		$q = "INSERT INTO " . TB_PREFIX . "users (username,password,access,email,timestamp,tribe,act,protect,lastupdate,regtime) VALUES ('$username', '$password', " . USER . ", '$email', $time, $tribe, '$act', $timep, $time, $time)";
37		if(mysql_query($q, $this->connection)) {
38			return mysql_insert_id($this->connection);
46		$q = "INSERT INTO " . TB_PREFIX . "activate (username,password,access,email,tribe,timestamp,location,act,act2) VALUES ('$username', '$password', " . USER . ", '$email', $tribe, $time, $locate, '$act', '$act2')";
47				if(mysql_query($q, $this->connection)) {
48			return mysql_insert_id($this->connection);
55		$q = "DELETE from " . TB_PREFIX . "activate where username = '$username'";
56		return mysql_query($q, $this->connection);
57	}
59		$q = "DELETE from " . TB_PREFIX . "enforcement where id = '$id'";
60		mysql_query($q, $this->connection);
61	}
firebaseclass.php https://bitbucket.org/devpronitzz/healthcase.git | PHP | 2,574 lines
59	{    
60		mysql_query("set character_set_server='utf8'");
61		mysql_query("set names 'utf8'");  
86		$sql = "INSERT INTO `doctor_signup` (`device_id`,`register_image`, `doctor_name`, `address`, `mobile_no`, `email_id`, `password`, `lat`, `log`,`col_certificate`, `union_id`, `status`, `type`, `profile_pic`, `specialization`,`payment_id`, `fee`, `chat_status`,`call_status`) VALUES ('$deviceID','$register_image1', '$doctorName', '$address', '$mobileNo', '$emailID', '$passwordD', '$latID', '$logID' ,'$file_url_name1', '$unionID1', '0', 'D','http://bytesnmaterials.com/healthcare/profile/profile.png','$specialID','0','$feeID','0','$callstatus')";
87		$result=mysql_query($sql);
88		return $result;
94	{    
95		mysql_query("set character_set_server='utf8'");
96		mysql_query("set names 'utf8'");
97		$sql = "INSERT INTO `push_notification`(`doctor_id`, `patient_id`, `name`, `message`, `token`, `case_description`,`date`, `type`, `status`) VALUES ('$doctorID', '$patientID','$name','$message','$tokenID','$caseD','$date','P','$status')";
98		$result=mysql_query($sql);
99		return $result;
102	{    
103		mysql_query("set character_set_server='utf8'");
104		mysql_query("set names 'utf8'");
mainclass.php https://bitbucket.org/devpronitzz/healthcase.git | PHP | 2,216 lines
50	{    
51		mysql_query("set character_set_server='utf8'");
52		mysql_query("set names 'utf8'");  
77		$sql = "INSERT INTO `doctor_signup` (`device_id`,`register_image`, `doctor_name`, `address`, `mobile_no`, `email_id`, `password`, `lat`, `log`,`col_certificate`, `union_id`, `status`, `type`, `profile_pic`, `specialization`,`payment_id`, `fee`, `chat_status`,`call_status`) VALUES ('$deviceID','$register_image1', '$doctorName', '$address', '$mobileNo', '$emailID', '$passwordD', '$latID', '$logID' ,'$file_url_name1', '$unionID1', '0', 'D','http://bytesnmaterials.com/healthcare/profile/profile.png','$specialID','0','$feeID','0','$callstatus')";
78		$result=mysql_query($sql);
79		return $result;
85	{    
86		mysql_query("set character_set_server='utf8'");
87		mysql_query("set names 'utf8'");
88		$sql = "INSERT INTO `push_notification`(`doctor_id`, `patient_id`, `name`, `message`, `token`, `case_description`,`date`, `type`, `status`) VALUES ('$doctorID', '$patientID','$name','$message','$tokenID','$caseD','$date','P','$status')";
89		$result=mysql_query($sql);
90		return $result;
93	{    
94		mysql_query("set character_set_server='utf8'");
95		mysql_query("set names 'utf8'");
37_train.tpl https://github.com/DEVVELO/TravianZ-By-Shadowss.git | Smarty Template | 784 lines
36
37$result = mysql_query("SELECT * FROM ".TB_PREFIX."units WHERE `vref` = ".$village->wid."");
38$units = mysql_fetch_array($result);
531        //HERO TRAINING
532		$count_hero = mysql_num_rows(mysql_query("SELECT * FROM " . TB_PREFIX . "hero WHERE `uid` = " . $session->uid . "")); 
533        if($session->tribe == 1){
535				if($session->access != BANNED){
536					mysql_query("DELETE from " . TB_PREFIX . "hero WHERE `dead` = 1 AND `uid` = '" . $session->uid . "'");
537					if($count_hero == 0){
537					if($count_hero == 0){
538					mysql_query("INSERT INTO ".TB_PREFIX."hero (`uid`, `wref`, `regeneration`, `unit`, `name`, `level`, `points`, `experience`, `dead`, `health`, `attack`, `defence`, `attackbonus`, `defencebonus`, `trainingtime`, `autoregen`, `intraining`) VALUES ('".$session->uid."', '" . $village->wid . "', '0', '1', '".addslashes($session->username)."', '0', '5', '0', '0', '100', '0', '0', '0', '0', '".round((time() + ($u1['time'] / SPEED)*3))."', '50', '1')");
539					mysql_query("UPDATE " . TB_PREFIX . "units SET `u1` = `u1` - 1 WHERE `vref` = '" . $village->wid . "'");
539					mysql_query("UPDATE " . TB_PREFIX . "units SET `u1` = `u1` - 1 WHERE `vref` = '" . $village->wid . "'");
540					mysql_query("UPDATE " . TB_PREFIX . "vdata SET `wood` = `wood` - ".$u1['wood']." WHERE `wref` = '" . $village->wid . "'");
541					mysql_query("UPDATE " . TB_PREFIX . "vdata SET `clay` = `clay` - ".$u1['clay']." WHERE `wref` = '" . $village->wid . "'");
functions.php https://github.com/Devictorinos/PHP_LEARNING.git | PHP | 1,005 lines
42
43	 $result = mysql_query($query);
44	
44	
45	mysql_query('SET NAMES "utf8" ');
46
70
71	mysql_query('SET NAMES "utf8" ');
72	//die($query);
72	//die($query);
73	$result = mysql_query($query);
74
93	//die($query);
94	$result = mysql_query($query);
95	
firebaseclass.php https://bitbucket.org/devpronitzz/healthcase.git | PHP | 2,823 lines
59	{    
60		/*mysql_query("set character_set_server='utf8'");
61		mysql_query("set names 'utf8'");  
86		/*$sql = "INSERT INTO `doctor_signup` (`device_id`,`register_image`, `doctor_name`, `address`, `mobile_no`, `email_id`, `password`, `lat`, `log`,`col_certificate`, `union_id`, `status`, `type`, `profile_pic`, `specialization`,`payment_id`, `fee`, `chat_status`,`call_status`) VALUES ('$deviceID','$register_image1', '$doctorName', '$address', '$mobileNo', '$emailID', '$passwordD', '$latID', '$logID' ,'$file_url_name1', '$unionID1', '0', 'D','http://bytesnmaterials.com/healthcare/profile/profile.png','$specialID','0','$feeID','0','$callstatus')";
87		$result=mysql_query($sql);
88		return $result;*/
121	{    
122		mysql_query("set character_set_server='utf8'");
123		mysql_query("set names 'utf8'");
124		$sql = "INSERT INTO `push_notification`(`doctor_id`, `patient_id`, `name`, `message`, `token`, `case_description`,`date`, `type`, `status`) VALUES ('$doctorID', '$patientID','$name','$message','$tokenID','$caseD','$date','P','$status')";
125		$result=mysql_query($sql);
126		return $result;
129	{    
130		mysql_query("set character_set_server='utf8'");
131		mysql_query("set names 'utf8'");
sejur.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 1,151 lines
78	)';
79	$que = mysql_query( $ins ) or die( mysql_error() );
80	$id_oferta_nou = mysql_insert_id();
83	$insE = "INSERT INTO early_booking (SELECT '" . $id_oferta_nou . "' AS id_oferta, tip, end_date, discount, early_inclus, text_early FROM early_booking WHERE id_oferta = '" . $id_oferta . "' AND tip = 'sejur') ";
84	$queE = mysql_query( $insE ) or die( mysql_error() );
85	@mysql_free_result( $queE );
88		$insE = "INSERT INTO oferta_sejur_tip (id_oferta, id_tip_oferta) VALUES ('".$id_oferta_nou."', '8') ";
89		$queE = mysql_query( $insE ) or die( mysql_error() );
90		@mysql_free_result( $queE );
92		$insE = "INSERT INTO oferta_sejur_tip (SELECT '" . $id_oferta_nou . "' AS id_oferta, id_tip_oferta FROM oferta_sejur_tip WHERE id_oferta = '" . $id_oferta . "') ";
93		$queE = mysql_query( $insE ) or die( mysql_error() );
94		@mysql_free_result( $queE );
97	$insS = "INSERT INTO oferte_servicii (SELECT '" . $id_oferta_nou . "' AS id_oferta, denumire, value, data_start, data_end, moneda, semn, tip_serv, tip_plata, obligatoriu, tip_supliment, exprimare, pasager, ordonare FROM oferte_servicii WHERE id_oferta = '" . $id_oferta . "') ";
98	$queS = mysql_query( $insS ) or die( mysql_error() );
99	@mysql_free_result( $queS );
sejur_1.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 1,084 lines
62	)';
63	$que = mysql_query( $ins ) or die( mysql_error() );
64	$id_oferta_nou = mysql_insert_id();
67	$insE = "INSERT INTO early_booking (SELECT '" . $id_oferta_nou . "' AS id_oferta, tip, end_date, discount, early_inclus, text_early FROM early_booking WHERE id_oferta = '" . $id_oferta . "' AND tip = 'sejur') ";
68	$queE = mysql_query( $insE ) or die( mysql_error() );
69	@mysql_free_result( $queE );
71	$insE = "INSERT INTO oferta_sejur_tip (SELECT '" . $id_oferta_nou . "' AS id_oferta, id_tip_oferta FROM oferta_sejur_tip WHERE id_oferta = '" . $id_oferta . "') ";
72	$queE = mysql_query( $insE ) or die( mysql_error() );
73	@mysql_free_result( $queE );
75	$insS = "INSERT INTO oferte_servicii (SELECT '" . $id_oferta_nou . "' AS id_oferta, denumire, value, data_start, data_end, moneda, semn, tip_serv, tip_plata, obligatoriu, tip_supliment, ordonare FROM oferte_servicii WHERE id_oferta = '" . $id_oferta . "') ";
76	$queS = mysql_query( $insS ) or die( mysql_error() );
77	@mysql_free_result( $queS );
80		$insPr = "INSERT INTO data_pret_oferta (SELECT '', '" . $id_oferta_nou . "' AS id_oferta, data_start, data_end, tip_camera, pret, moneda, id_hotel, of_logictour, pret_pivot, id_masa FROM data_pret_oferta WHERE id_oferta = '" . $id_oferta . "')";
81		$quePr = mysql_query( $insPr ) or die( mysql_error() );
82		@mysql_free_result( $quePr );
control.php https://bitbucket.org/miguelBarahona/lemcontrol_version_asincrona_local.git | PHP | 4,165 lines
15    $sql = "UPDATE control_riego set intentos_reset = 0 WHERE  id_nodo = $campos[1]";
16    $consulta = mysql_query($sql, $conEmp);	
17}
18$sql = "SELECT red FROM nodo WHERE id_nodo = $campos[1]";
19$resEmp2 = mysql_query($sql, $conEmp);
20$objeto = mysql_num_rows($resEmp2);
33                 $sql_lembox = "select tipo,id_sector from programacion_riego where n_orden_riego_sector = $n_orden_riego_sector";
34                $resEmp_lembox = mysql_query($sql_lembox, $conEmp);
35                if ($datatmp_lembox= mysql_fetch_array($resEmp_lembox)) {
39                         $sql_lembox2 = "select Px,id_nodo,id_sensor from sector_riego where id_sector = $id_sector_lembox";
40                        $resEmp_lembox2 = mysql_query($sql_lembox2, $conEmp);
41                        if ($datatmp_lembox2= mysql_fetch_array($resEmp_lembox2)) {
46                            $sql_lembox5 = "select direccion from nodo where id_nodo = $id_nodo_lembox";
47                            $resEmp_lembox5 = mysql_query($sql_lembox5, $conEmp);
48                            if ($datatmp_lembox5 = mysql_fetch_array($resEmp_lembox5)) {
cityapp.php https://bitbucket.org/Yatindra_Mohite/city_app_indore.git | PHP | 2,240 lines
187    $sql = "SELECT * FROM `user` WHERE `email`= '$email' AND `password`= '$password'";
188    $res = mysql_query($sql);
189    
198
199        $sql11=mysql_query("UPDATE `user` SET `device_token`='$device_token' WHERE`id`='$user_id'");
200
245    $sql = "SELECT * FROM `user` WHERE `email` = '$email' ";
246    $res = mysql_query($sql);
247    if(mysql_num_rows($res)>0)
259        $q = "INSERT INTO `user`(username,email,password,create_at,mobile,company_name,device_token) VALUES ('$username','$email','$password',CURRENT_TIMESTAMP,'$mobile','$company_name','$device_token')";
260        if(mysql_query($q))
261        {
264            $sql1 = "SELECT * FROM `user` WHERE `id`= '$id'";
265            $res1 = mysql_query($sql1);
266            while($queRow = mysql_fetch_assoc($res1))
mysql_client_test.c https://bitbucket.org/oglop/tomato-arm-kille72.git | C | 17,759 lines
42
43  rc= mysql_query(mysql, "DROP TABLE IF EXISTS t1");
44  myquery(rc);
45
46  rc= mysql_query(mysql, "CREATE TABLE t1("
47                         "id int primary key auto_increment, "
50
51  rc= mysql_query(mysql, "CREATE TABLE t1(id int, name varchar(20))");
52  myquery_r(rc);
53
54  rc= mysql_query(mysql, "INSERT INTO t1(name) VALUES('mysql')");
55  myquery(rc);
56
57  rc= mysql_query(mysql, "INSERT INTO t1(name) VALUES('monty')");
58  myquery(rc);
utilForAdmin.php https://bitbucket.org/developershad/bulker.git | PHP | 692 lines
6	$query = "SELECT * FROM admin WHERE username = '$username' AND password='$password' AND status='1' ";
7		$result = mysql_query($query, $conn);
8    	$row = mysql_num_rows($result);
23	$query	=	"select * from admin where id = '$id' ";
24	$executeQuery	=	mysql_query($query, $conn);
25	$result = fetch_results($executeQuery);
29	$query	=	"select * from admin";
30	$executeQuery	=	mysql_query($query, $conn);
31	$result = fetch_results($executeQuery);
51	$query	=	"insert into admin (username, password, name, fatherName, motherName, email, mobile, dob, sex, nationality, maritalStatus, permamentAddress, residentialAddress) values ( '$username', '$password', '$name', '$fatherName', '$motherName', '$email', '$mobile', '$dob', '$sex', '$nationality', '$maritalStatus', '$permamentAddress', '$residentialAddress'  ) ";
52	$executeQuery	=	mysql_query($query, $conn);
53	return mysql_insert_id();	
70	$query	=	"update admin set name = '$name', fatherName='$fatherName', motherName ='$motherName', dob = '$dob',email='$email', nationality = '$nationality', mobile = '$mobile', sex='$sex', password = '$password', maritalStatus = '$maritalStatus', permamentAddress = '$permamentAddress' , residentialAddress = '$residentialAddress' where id = '$id' ";
71	$executeQuery	=	mysql_query($query, $conn);
72	return mysql_affected_rows();	
mysql_client_test.c https://bitbucket.org/edrikk/freshtomato-arm-at-gui.git | C | 17,759 lines
42
43  rc= mysql_query(mysql, "DROP TABLE IF EXISTS t1");
44  myquery(rc);
45
46  rc= mysql_query(mysql, "CREATE TABLE t1("
47                         "id int primary key auto_increment, "
50
51  rc= mysql_query(mysql, "CREATE TABLE t1(id int, name varchar(20))");
52  myquery_r(rc);
53
54  rc= mysql_query(mysql, "INSERT INTO t1(name) VALUES('mysql')");
55  myquery(rc);
56
57  rc= mysql_query(mysql, "INSERT INTO t1(name) VALUES('monty')");
58  myquery(rc);
database.php https://github.com/DEVVELO/TravianZ-By-Shadowss.git | PHP | 566 lines
39		$q = "SELECT password FROM ".TB_PREFIX."users where username = '$username' and access >= ".MULTIHUNTER;
40		$result = mysql_query($q, $this->connection);
41		$dbarray = mysql_fetch_array($result);
42		if($dbarray['password'] == md5($password)) {
43			mysql_query("Insert into ".TB_PREFIX."admin_log values (0,'X','$username logged in (IP: <b>".$_SERVER['REMOTE_ADDR']."</b>)',".time().")");
44			return true;
46		else {
47			mysql_query("Insert into ".TB_PREFIX."admin_log values (0,'X','<font color=\'red\'><b>IP: ".$_SERVER['REMOTE_ADDR']." tried to log in with username <u> $username</u> but access was denied!</font></b>',".time().")");
48			return false;
73	$q = "UPDATE ".TB_PREFIX."vdata set pop = $popTot where wref = $vid";
74	mysql_query($q, $this->connection);
75  }
111        $q = "UPDATE ".TB_PREFIX."vdata set cp = $popTot where wref = $vid";
112        mysql_query($q, $this->connection);
113        }
database.php https://github.com/DEVVELO/TravianZ-By-Shadowss.git | PHP | 858 lines
37		$q = "SELECT password FROM ".TB_PREFIX."users where username = '$username' and access >= ".MULTIHUNTER;
38		$result = mysql_query($q, $this->connection);
39		$dbarray = mysql_fetch_array($result);
40		if($dbarray['password'] == md5($password)) {
41			mysql_query("Insert into ".TB_PREFIX."admin_log values (0,'X','$username logged in (IP: <b>".$_SERVER['REMOTE_ADDR']."</b>)',".time().")");
42			return true;
44		else {
45			mysql_query("Insert into ".TB_PREFIX."admin_log values (0,'X','<font color=\'red\'><b>IP: ".$_SERVER['REMOTE_ADDR']." tried to log in with username <u> $username</u> but access was denied!</font></b>',".time().")");
46			return false;
72    $q = "UPDATE ".TB_PREFIX."vdata set pop = $popTot where wref = $vid";
73    mysql_query($q, $this->connection);
74  }
87    $q = "UPDATE ".TB_PREFIX."vdata set cp = $popTot where wref = $vid";
88    mysql_query($q, $this->connection);
89    }
system_sql.php https://github.com/Devil399/aurora-online-judge.git | PHP | 116 lines
10	if(!mysql_select_db($mysql_database)){
11		mysql_query("CREATE DATABASE ".$mysql_database);
12		if(!mysql_select_db($mysql_database)){ $_SESSION["message"][] = "SQL Error : Could Not Select Database."; return; }
14	$data = mysql_list_tables($mysql_database); $table = array(); if(is_resource($data)) while($temp=mysql_fetch_row($data)) $table[] = $temp[0];
15	if(!in_array("teams",$table)){ mysql_query("CREATE TABLE teams (tid int not null primary key auto_increment,teamname tinytext,teamname2 tinytext,pass tinytext,status tinytext,score int,penalty bigint,name1 tinytext,roll1 tinytext,branch1 tinytext,email1 tinytext,phone1 tinytext,name2 tinytext,roll2 tinytext,branch2 tinytext,email2 tinytext,phone2 tinytext,name3 tinytext,roll3 tinytext,branch3 tinytext,email3 tinytext,phone3 tinytext,platform text,ip text,session tinytext,gid int not null)"); }
16	if(!in_array("problems",$table)){ mysql_query("CREATE TABLE problems (pid int not null primary key auto_increment,code tinytext,name tinytext,type tinytext,status tinytext,pgroup tinytext,statement longtext,image blob,imgext tinytext,input longtext,output longtext,timelimit int,score int,languages tinytext,options tinytext)"); }
16	if(!in_array("problems",$table)){ mysql_query("CREATE TABLE problems (pid int not null primary key auto_increment,code tinytext,name tinytext,type tinytext,status tinytext,pgroup tinytext,statement longtext,image blob,imgext tinytext,input longtext,output longtext,timelimit int,score int,languages tinytext,options tinytext)"); }
17	if(!in_array("runs",$table)){ mysql_query("CREATE TABLE runs (rid int not null primary key auto_increment,pid int,tid int,language tinytext,name tinytext,code longtext,time tinytext,result tinytext,error text,access tinytext,submittime int,output longtext)"); }
18	if(!in_array("admin",$table)){ mysql_query("CREATE TABLE admin (variable tinytext,value longtext)"); }
18	if(!in_array("admin",$table)){ mysql_query("CREATE TABLE admin (variable tinytext,value longtext)"); }
19	if(!in_array("logs",$table)){ mysql_query("CREATE TABLE logs (time int not null primary key,ip tinytext,tid int,request tinytext)"); }
20	if(!in_array("clar",$table)){ mysql_query("CREATE TABLE clar (time int not null primary key,tid int,pid int,query text,reply text,access tinytext,createtime int)"); }
20	if(!in_array("clar",$table)){ mysql_query("CREATE TABLE clar (time int not null primary key,tid int,pid int,query text,reply text,access tinytext,createtime int)"); }
21	if(!in_array("groups",$table)){ mysql_query("CREATE TABLE groups (gid int not null primary key auto_increment, groupname tinytext, statusx int)"); }
22	
imports_task.php https://bitbucket.org/phpdecode/eprotocol.git | PHP | 1,195 lines
48                    $query="select io_year from book where id=" . $book_id;
49                    @mysql_query ('set character set utf8 ');
50                    $res=mysql_query($query);
54                    $query="select count(pn) as protocol_number from book where import_id=".$book_id." and status=1 and io_year=" . $io_year . "  and pn=(select pn from book where id=" . $book_id . ")";
55                    @mysql_query ('set character set utf8 ');
56                    $res=mysql_query($query);
60                        $query="select * from book where import_id=".$book_id." and status=1 and io_year=" . $io_year . " and pn=(select pn from book where id=" . $book_id . ")";
61                        @mysql_query ('set character set utf8 ');
62                        $res=mysql_query($query);
96							$query="select * from book where status=1 and import_id=" . $import_id;
97							@mysql_query ('set character set utf8 ');
98							$res=mysql_query($query);
134							$query="select pn, io_year, io_date from book where status=0 and id=" . $book_id;
135							@mysql_query ('set character set utf8 ');
136							$res=mysql_query($query);
alertanodocontrolcaido.php https://bitbucket.org/miguelBarahona/lemcontrol_version_asincrona_local.git | PHP | 986 lines
6$sql = "select mail,id_empresa from empresa";
7$consulta = mysql_query($sql, $link);
8if ($datatmp = mysql_fetch_array($consulta)) {
16$sql = "SELECT distinct id_nodo,fecha FROM `control_riego` WHERE id_nodo in(SELECT distinct id_nodo FROM nodo WHERE tipo_nodo=2) and fecha< date_sub(now(),interval 1 hour)";
17$consulta = mysql_query($sql, $link);
18while ($datatmp = mysql_fetch_array($consulta)) {
21    $sql2="SELECT * FROM alertas_control where id_nodo='$id_nodoCordinador' and estado=0";
22	$consulta2 = mysql_query($sql2, $link);
23	if ($datatmp2 = mysql_fetch_array($consulta2)){
27		$sql3="INSERT into alertas_control(id_nodo,tipo,fecha,estado,id_empresa) VALUES ('$id_nodoCordinador','nodo','$fecha',0,$id_empresa)";
28		$consulta3=mysql_query($sql3, $link);
29		$sw =1;
32$sql4="SELECT * FROM alertas_control where estado=0 and id_nodo in (SELECT distinct id_nodo FROM nodo WHERE tipo_nodo = 2)";
33$consulta4=mysql_query($sql4, $link);
34while($datatmp4 = mysql_fetch_array($consulta4)) {
functions.php https://bitbucket.org/proactivedevelopers/doe.git | PHP | 603 lines
4{
5    $squel = mysql_query("Select * from main where school='$school' and year='$year' and sn='$sn'");
6    $sqdata = mysql_fetch_assoc($squel);
70
71    $passpercentage = mysql_result(mysql_query("select * from curriculum"), 0, 1);
72    $need = 0;
78    $fqu .= " from fmpm where year=$year;";
79    $query = mysql_query($fqu) or die(mysql_error());
80    $fqu = mysql_fetch_row($query) or die(mysql_error());
80    $fqu = mysql_fetch_row($query) or die(mysql_error());
81    $grac = mysql_query("select marks from grace where year=$year and type='$type'");
82    $gracc = mysql_fetch_row($grac);
109{
110    $sque = mysql_query("Select no From subject where year=$year");
111    $abc = mysql_fetch_row($sque);
functions.php https://bitbucket.org/proactivedevelopers/doe.git | PHP | 603 lines
4{
5    $squel = mysql_query("Select * from main where school='$school' and year='$year' and sn='$sn'");
6    $sqdata = mysql_fetch_assoc($squel);
70
71    $passpercentage = mysql_result(mysql_query("select * from curriculum"), 0, 1);
72    $need = 0;
78    $fqu .= " from fmpm where year=$year;";
79    $query = mysql_query($fqu) or die(mysql_error());
80    $fqu = mysql_fetch_row($query) or die(mysql_error());
80    $fqu = mysql_fetch_row($query) or die(mysql_error());
81    $grac = mysql_query("select marks from grace where year=$year and type='$type'");
82    $gracc = mysql_fetch_row($grac);
109{
110    $sque = mysql_query("Select no From subject where year=$year");
111    $abc = mysql_fetch_row($sque);
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21