PageRenderTime 151ms queryTime 44ms sortTime 9ms getByIdsTime 29ms findMatchingLines 10ms

100+ results results for 'mysql_query' (151 ms)

Not the results you expected?
show.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 161 lines
                    
19}
                    
20$req = mysql_query("SELECT * FROM `cms_album_cat` where `website` = '$website' AND  `id` = '$al'");
                    
21if (!mysql_num_rows($req)) {
                    
81    $kmess = 1;
                    
82    $start = isset($_REQUEST['page']) ? $page - 1 : (mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND  `album_id` = '$al' AND `id` > '$img'"), 0));
                    
83    // Обрабатываем ссылку для возврата
                    
88}
                    
89$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND  `album_id` = '$al'"), 0);
                    
90if ($total > $kmess)
                    
92if ($total) {
                    
93    $req = mysql_query("SELECT * FROM `cms_album_files` where `website` = '$website' AND  `user_id` = '" . $user['id'] . "' AND `album_id` = '$al' ORDER BY `id` DESC LIMIT $start, $kmess");
                    
94    $i = 0;
                    
115            // Счетчик просмотров
                    
116            if (!mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_views` where `website` = '$website' AND  `user_id` = '$user_id' AND `file_id` = '" . $res['id'] . "'"), 0)) {
                    
117                mysql_query("INSERT INTO `cms_album_views` SET `user_id` = '$user_id', `file_id` = '" . $res['id'] . "', `time` = '" . time() . "', `website` = '$website'");
                    
                
index.php https://github.com/michaelmwu/saratogahigh.com.git | PHP | 219 lines
                    
15	if(is_numeric($_GET['delete']))
                    
16		mysql_query('DELETE FROM NOTEPAGE_LIST WHERE NOTEPAGE_OWNER=' . $userid . ' AND NOTEPAGE_ID=' . $_GET['delete']) or die("Delete failed.");
                    
17	if($_POST['go'] == 'Save')
                    
23		else
                    
24			mysql_query('INSERT INTO NOTEPAGE_LIST (NOTEPAGE_OWNER, NOTEPAGE_CREATED, NOTEPAGE_MODIFIED, NOTEPAGE_VALUE, NOTEPAGE_DIGEST) VALUES (' . $userid . ', "' . date(TIME_FORMAT_SQL, CURRENT_TIME) . '", NOTEPAGE_CREATED, \'' . $_POST['entrytext'] . '\', \'' . makedigest($_POST['entrytext']) . '\')') or die("Insert failed.");
                    
25	}
                    
27	{
                    
28		mysql_query('UPDATE NOTEPAGE_LIST SET NOTEPAGE_MODIFIED="' . date(TIME_FORMAT_SQL, CURRENT_TIME) . '", NOTEPAGE_VALUE=\'' . $_POST['entrytext'] . '\', NOTEPAGE_DIGEST=\'' . makedigest($_POST['entrytext']) . '\' WHERE NOTEPAGE_OWNER=' . $userid . ' AND NOTEPAGE_ID=' . $_GET['id']) or die("Insert failed.");
                    
29	}
                    
64        
                    
65        $entries = mysql_query('SELECT NOTEPAGE_ID, NOTEPAGE_DIGEST, UNIX_TIMESTAMP(NOTEPAGE_CREATED) as TS FROM NOTEPAGE_LIST WHERE NOTEPAGE_OWNER=' . $userid . ' AND MATCH(NOTEPAGE_VALUE) AGAINST (\'' . $_GET['query'] . '\')') or die('Query failed.');
                    
66
                    
180
                    
181	$entries = mysql_query('SELECT NOTEPAGE_LIST.*, NOTEPAGE_CREATED as CR, NOTEPAGE_MODIFIED as MO FROM NOTEPAGE_LIST WHERE NOTEPAGE_OWNER=' . $userid . ' AND NOTEPAGE_ID=' . $id) or die('Query failed.');
                    
182			
                    
                
core.php https://github.com/rezamoussavi/MouRe.git | PHP | 351 lines
                    
25		if(!$osdbcon){ $_result=null; return;}
                    
26		$_result= mysql_query(parseQuery($caller,$s),$osdbcon);
                    
27	}
                    
29		global $osdbcon,$_result;
                    
30		if(!($_result= $osdbcon? mysql_query($s,$osdbcon):false)){
                    
31			osLog("os","query()","calling mysql_query() <b><font color=red>ERROR</font><br />Query:</b><br />".$s);
                    
                
delivery_list.php https://gitlab.com/Henaway/CLFC | PHP | 253 lines
                    
25    route_name ASC';
                    
26$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 769302 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
27while ( $row = mysql_fetch_array($result) )
                    
73    last_name ASC';
                    
74$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 769302 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
75$num_orders = mysql_numrows($result);
                    
188    sum_p DESC';
                    
189$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 860342 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
190while ($row = mysql_fetch_array($result))
                    
                
watch_brek_vid.php https://gitlab.com/msdusad/all_ones | PHP | 237 lines
                    
49		$sd="select bann_news from banner";
                    
50		$ab=mysql_query($sd);
                    
51		$df=mysql_fetch_array($ab);
                    
69			
                    
70			$rf=mysql_query($df);
                    
71			$row=mysql_fetch_array($rf);
                    
111			
                    
112			$rf=mysql_query($df);
                    
113			$row=mysql_fetch_array($rf);
                    
                
functions_db.php https://github.com/justinmc/turkiball.com.git | PHP | 389 lines
                    
34   
                    
35   $QUERY = mysql_query("SELECT * FROM $table WHERE Index = '$index'");
                    
36   $DATA = mysql_fetch_array($QUERY);
                    
54   
                    
55   $QUERY = mysql_query("SELECT * FROM $table WHERE `Index` = $index");
                    
56   $DATA = mysql_fetch_array($QUERY);
                    
74   
                    
75   $QUERY = mysql_query("SELECT * FROM smf_messages WHERE ID_MSG = $id");
                    
76   $DATA = mysql_fetch_array($QUERY);
                    
94   
                    
95   $QUERY = mysql_query("SELECT * FROM smf_members WHERE ID_MEMBER = $id");
                    
96   $DATA = mysql_fetch_array($QUERY);
                    
123   {
                    
124      $QUERY = mysql_query("SELECT * FROM smf_members WHERE ID_MEMBER = $count");
                    
125      $DATA = mysql_fetch_array($QUERY);
                    
                
submit_track.php http://airscore.googlecode.com/svn/trunk/ | PHP | 332 lines
                    
19$query = "select *, unix_timestamp(comDateTo) as comUnixTo  from tblCompetition where comPk=$comPk";
                    
20$result = mysql_query($query) or die('Query failed: ' . mysql_error());
                    
21$title = 'highcloud.net';
                    
123    $query = "select pilPk, pilHGFA from tblPilot where pilLastName='$name'";
                    
124    $result = mysql_query($query) or die('Query failed: ' . mysql_error());
                    
125
                    
171        $query = "select T.tasPk, T.tasTaskType, C.comType from tblTask T, tblTrack TL, tblCompetition C where C.comPk=T.comPk and T.comPk=$comid and TL.traPk=$maxPk and TL.traStart > date_sub(T.tasDate, interval C.comTimeOffset hour) and TL.traStart < date_add(T.tasDate, interval (24-C.comTimeOffset) hour)";
                    
172        $result = mysql_query($query) or die('Query failed: ' . mysql_error());
                    
173        if (mysql_num_rows($result) > 0)
                    
181    $query = "insert into tblComTaskTrack (comPk,tasPk,traPk) values ($comid,$tasPk,$maxPk)";
                    
182    $result = mysql_query($query) or die('ComTaskTrack failed: ' . mysql_error());
                    
183
                    
225    $query = "update tblTrack set traGlider='$glider', traDHV='$dhv' where traPk=$maxPk";
                    
226    $result = mysql_query($query) or die('Update tblTrack failed: ' . mysql_error());
                    
227
                    
                
events.php https://github.com/cybernet/CyBerFuN-CoDeX.git | PHP | 272 lines
                    
114$sql = "DELETE FROM `events` WHERE `id` = $id LIMIT 1;";
                    
115$res = mysql_query($sql);
                    
116if(mysql_error()!=0)
                    
150//echo "<p>$sql</p>";
                    
151$res = mysql_query($sql);
                    
152if(mysql_error()!=0)
                    
                
ebpls_abstractcoll.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 260 lines
                    
72
                    
73	$result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") 
                    
74	or die(mysql_error());
                    
75    $resulta=mysql_fetch_row($result);
                    
76$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'");
                    
77$getlgu = @mysql_fetch_row($getlgu);
                    
77$getlgu = @mysql_fetch_row($getlgu);
                    
78$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'");
                    
79$getprov = @mysql_fetch_row($getprov);
                    
112$prefset = FetchArray($dbtype,$staxfee);			
                    
113	//	$result = mysql_query("select tfodesc from ebpls_buss_tfo limit 8") 
                    
114$sassess = $prefset[staxesfees];	
                    
115
                    
116  $result = mysql_query("select a.tfoid, a.tfodesc from ebpls_buss_tfo a, rpt_temp_abs b
                    
117			where a.tfoid=b.tfoid ") ;
                    
                
edit.php https://github.com/heidymadia/sfbackup.git | PHP | 54 lines
                    
7$sql = "UPDATE `opportunities` SET  `AccountId` =  '{$_POST['AccountId']}' ,  `Amount` =  '{$_POST['Amount']}' ,  `CampaignId` =  '{$_POST['CampaignId']}' ,  `CloseDate` =  '{$_POST['CloseDate']}' ,  `CreatedById` =  '{$_POST['CreatedById']}' ,  `CreatedDate` =  '{$_POST['CreatedDate']}' ,  `CurrentGenerators__c` =  '{$_POST['CurrentGenerators__c']}' ,  `DeliveryInstallationStatus__c` =  '{$_POST['DeliveryInstallationStatus__c']}' ,  `Description` =  '{$_POST['Description']}' ,  `ExpectedRevenue` =  '{$_POST['ExpectedRevenue']}' ,  `Fiscal` =  '{$_POST['Fiscal']}' ,  `FiscalQuarter` =  '{$_POST['FiscalQuarter']}' ,  `FiscalYear` =  '{$_POST['FiscalYear']}' ,  `ForecastCategory` =  '{$_POST['ForecastCategory']}' ,  `ForecastCategoryName` =  '{$_POST['ForecastCategoryName']}' ,  `HasOpportunityLineItem` =  '{$_POST['HasOpportunityLineItem']}' ,  `IsClosed` =  '{$_POST['IsClosed']}' ,  `IsDeleted` =  '{$_POST['IsDeleted']}' ,  `IsPrivate` =  '{$_POST['IsPrivate']}' ,  `IsWon` =  '{$_POST['IsWon']}' ,  `LastActivityDate` =  '{$_POST['LastActivityDate']}' ,  `LastModifiedById` =  '{$_POST['LastModifiedById']}' ,  `LastModifiedDate` =  '{$_POST['LastModifiedDate']}' ,  `LeadSource` =  '{$_POST['LeadSource']}' ,  `MainCompetitors__c` =  '{$_POST['MainCompetitors__c']}' ,  `Name` =  '{$_POST['Name']}' ,  `NextStep` =  '{$_POST['NextStep']}' ,  `OrderNumber__c` =  '{$_POST['OrderNumber__c']}' ,  `OwnerId` =  '{$_POST['OwnerId']}' ,  `Pricebook2Id` =  '{$_POST['Pricebook2Id']}' ,  `Probability` =  '{$_POST['Probability']}' ,  `StageName` =  '{$_POST['StageName']}' ,  `SystemModstamp` =  '{$_POST['SystemModstamp']}' ,  `TotalOpportunityQuantity` =  '{$_POST['TotalOpportunityQuantity']}' ,  `TrackingNumber__c` =  '{$_POST['TrackingNumber__c']}' ,  `Type` =  '{$_POST['Type']}'   WHERE `id` = '$id' "; 
                    
8mysql_query($sql) or die(mysql_error()); 
                    
9echo (mysql_affected_rows()) ? "Edited row.<br />" : "Nothing changed. <br />"; 
                    
11} 
                    
12$row = mysql_fetch_array ( mysql_query("SELECT * FROM `opportunities` WHERE `id` = '$id' ")); 
                    
13?>
                    
                
log-2016-01-20.php https://gitlab.com/fcupen/PHP | PHP | 44 lines
                    
20ERROR - 2016-01-20 12:20:54 --> Severity: error --> Exception: Configured database connection is persistent. Aborting. /usr/home/astfou/domains/astral-foundations.com/public_html/system/libraries/Session/drivers/Session_database_driver.php 94
                    
21ERROR - 2016-01-20 12:37:40 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
22ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
22ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
23ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
24ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
                    
24ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
                    
25ERROR - 2016-01-20 12:40:19 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
26ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
26ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
27ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
28ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
                    
28ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
                    
29ERROR - 2016-01-20 12:40:55 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
30ERROR - 2016-01-20 12:40:55 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
                
edit.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 122 lines
                    
18    }
                    
19    $req = mysql_query("SELECT * FROM `lib` where `website` = '$website' AND  `id` = '" . $id . "'");
                    
20    $ms = mysql_fetch_array($req);
                    
44                }
                    
45                mysql_query("UPDATE `lib` SET
                    
46                    `name` = '" . mysql_real_escape_string(mb_substr(trim($_POST['name']), 0, 100)) . "',
                    
66                $mod = intval($_POST['mod']);
                    
67                mysql_query("UPDATE `lib` SET
                    
68                `text` = '" . $text . "',
                    
78            $text = functions::check($_POST['text']);
                    
79                mysql_query("update `lib` set text='" . $text . "' where `website` = '$website' AND  id='" . $id . "';");
                    
80                header("location: index.php?id=$ms[refid]");
                    
                
moreinfo.php https://github.com/damanlovett/SEAHO.git | PHP | 145 lines
                    
38$query_rsConference = sprintf("SELECT * FROM conference WHERE conference.deleted = 0 AND conference.conference_id = %s", GetSQLValueString($colname_rsConference, "text"));
                    
39$rsConference = mysql_query($query_rsConference, $CMS) or die(mysql_error());
                    
40$row_rsConference = mysql_fetch_assoc($rsConference);
                    
48$query_rsItems = sprintf("SELECT * FROM delegate_invoice WHERE delegate_invoice.conference_id=%s AND delegate_invoice.deleted = 0 AND delegate_invoice.type != 'registration' ORDER BY delegate_invoice.label", GetSQLValueString($colname_rsItems, "text"));
                    
49$rsItems = mysql_query($query_rsItems, $CMS) or die(mysql_error());
                    
50$row_rsItems = mysql_fetch_assoc($rsItems);
                    
58$query_rsFees = sprintf("SELECT * FROM delegate_invoice WHERE delegate_invoice.conference_id=%s AND delegate_invoice.deleted = 0 AND delegate_invoice.type = 'registration' ORDER BY delegate_invoice.amount", GetSQLValueString($colname_rsFees, "text"));
                    
59$rsFees = mysql_query($query_rsFees, $CMS) or die(mysql_error());
                    
60$row_rsFees = mysql_fetch_assoc($rsFees);
                    
                
counters.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 203 lines
                    
23
                    
24        $albumcount = mysql_result(mysql_query("SELECT COUNT(DISTINCT `user_id`) FROM `cms_album_files` WHERE `website` = '$website'"), 0);
                    
25        $photocount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `website` = '$website'"), 0);
                    
25        $photocount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `website` = '$website'"), 0);
                    
26        $newcount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND  `time` > '" . (time() - 259200) . "' AND `access` > '1'"), 0);
                    
27        return $albumcount . '&#160;/&#160;' . $photocount . ($newcount ? '&#160;/&#160;<span class="red"><a href="' . core::$system_set['homeurl'] . '/users/album.php?act=top">+' . $newcount . '</a></span>' : '');
                    
38
                    
39        $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND  `type` = 'file'"), 0);
                    
40        $new = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND  `time` > '" . (time() - 259200) . "' AND `type` = 'file'"), 0);
                    
54
                    
55        $total_thm = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND  `type` = 't'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0);
                    
56        $total_msg = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND  `type` = 'm'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0);
                    
78        if (core::$user_id) {
                    
79            $req = mysql_query("SELECT COUNT(*) FROM `forum`
                    
80                LEFT JOIN `cms_forum_rdm` ON `forum`.`id` = `cms_forum_rdm`.`topic_id` AND `cms_forum_rdm`.`user_id` = '" . core::$user_id . "'
                    
                
tracker_stats.inc.php https://github.com/harriswong/ATutor.git | PHP | 487 lines
                    
26$sql5 = "select * from ".TABLE_PREFIX."g_refs";
                    
27	$result = mysql_query($sql5, $db);
                    
28	$refs = array();
                    
46
                    
47	if(!$result8 = mysql_query($sql8, $db)){
                    
48		require(AT_INCLUDE_PATH.'footer.inc.php');
                    
67			course_id='$_SESSION[course_id]'";
                    
68	if(!$result7 = mysql_query($sql7, $db)){
                    
69		require(AT_INCLUDE_PATH.'footer.inc.php');
                    
93	$title_tools = array();
                    
94	$result9 = mysql_query($sql9, $db);
                    
95	while ($row= mysql_fetch_array($result9)) {
                    
102$sql10 = "select count(g) from ".TABLE_PREFIX."g_click_data where course_id='$_SESSION[course_id]' GROUP BY g";
                    
103$result10 = mysql_query($sql10, $db);
                    
104while($row=mysql_fetch_array($result10)){
                    
                
edit_event.php https://bitbucket.org/anneivycat/california-tour.git | PHP | 326 lines
                    
29
                    
30		$mysql_result_update = mysql_query($query_update, $mysql_link);
                    
31	}
                    
41			$query_check_cat = "SELECT category_id from CATEGORIES where category_name = '$NewCategoryName'";
                    
42			$mysql_result_cat_check = mysql_query($query_check_cat,$mysql_link);
                    
43
                    
49
                    
50				$mysql_result_cat_insert = mysql_query($query_cat_insert, $mysql_link);
                    
51				$CategoryId = $NewCategoryId;
                    
65//	print($query_get_info);
                    
66	$mysql_result_get_info = mysql_query($query_get_info, $mysql_link);
                    
67
                    
80	$query_user = "SELECT user_name from USER where user_id = '$EventUserId'";
                    
81	$mysql_result_user = mysql_query($query_user, $mysql_link);
                    
82	$row_user = mysql_fetch_array($mysql_result_user);
                    
                
listGridCMS_GROUPUSERS.php https://github.com/juddy/GIP.git | PHP | 225 lines
                    
15	$sqlUpdate = "UPDATE CMS_GROUPUSERS SET GROUP_ID = '$thisGROUP_ID' , USER_ID = '$thisUSER_ID' , GROUPUSER_FLAGS = '$thisGROUPUSER_FLAGS'  WHERE GROUP_ID = '$thisGROUP_ID'";
                    
16	$resultUpdate = MYSQL_QUERY($sqlUpdate);
                    
17	echo "<b>Record with Id ".$thisGROUP_IDFromForm." has been Updated<br></b>";
                    
28	$sqlInsert = "INSERT INTO CMS_GROUPUSERS (GROUP_ID , USER_ID , GROUPUSER_FLAGS ) VALUES ('$thisGROUP_ID' , '$thisUSER_ID' , '$thisGROUPUSER_FLAGS' )";
                    
29	$resultInsert = MYSQL_QUERY($sqlInsert);
                    
30	echo "<b>Record has been inserted in Database<br></b>";
                    
41	$sqlDelete = "DELETE FROM CMS_GROUPUSERS WHERE GROUP_ID = '$thisGROUP_ID'";
                    
42	$resultDelete = MYSQL_QUERY($sqlDelete);
                    
43
                    
81$sql = "SELECT   * FROM CMS_GROUPUSERS".$orderByQuery.$limitQuery;
                    
82$result = MYSQL_QUERY($sql);
                    
83$numberOfRows = MYSQL_NUM_ROWS($result);
                    
                
listCMS_ONLINE_RESOURCES.php https://github.com/juddy/GIP.git | PHP | 211 lines
                    
39$sql = "SELECT   * FROM CMS_ONLINE_RESOURCES".$orderByQuery.$limitQuery;
                    
40$result = MYSQL_QUERY($sql);
                    
41$numberOfRows = MYSQL_NUM_ROWS($result);
                    
                
listCMS_OFFLINE_RESOURCES.php https://github.com/juddy/GIP.git | PHP | 211 lines
                    
39$sql = "SELECT   * FROM CMS_OFFLINE_RESOURCES".$orderByQuery.$limitQuery;
                    
40$result = MYSQL_QUERY($sql);
                    
41$numberOfRows = MYSQL_NUM_ROWS($result);
                    
                
DBIMysql.class.php https://gitlab.com/qbarbosa/klindev | PHP | 468 lines
                    
188        if ($options == ($options | PMA_DatabaseInterface::QUERY_STORE)) {
                    
189            return mysql_query($query, $link);
                    
190        } elseif ($options == ($options | PMA_DatabaseInterface::QUERY_UNBUFFERED)) {
                    
192        } else {
                    
193            return mysql_query($query, $link);
                    
194        }
                    
                
customer_list.php https://gitlab.com/Henaway/CLFC | PHP | 280 lines
                    
56    AND '.NEW_TABLE_PRODUCTS.'.product_version = "'.mysql_real_escape_string ($product_version).'"';
                    
57$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 738102 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
58if ( $row = mysql_fetch_object($result) )
                    
189        AND product_version = "'.mysql_real_escape_string ($product_version).'"';
                    
190    $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 155816 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
191    $bpid= mysql_insert_id();
                    
204        AND product_version = "'.mysql_real_escape_string ($product_version).'"';
                    
205    $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 731034 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
206  }
                    
223        inventory_id = '.mysql_real_escape_string ($inventory_id);
                    
224    $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 066934 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
225  }
                    
235        AND product_version = "'.mysql_real_escape_string ($product_version).'"';
                    
236    $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 267490 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
237  }
                    
                
interface.php https://github.com/Lithixium/HawkEye.git | PHP | 244 lines
                    
35	$players = array();
                    
36	$res = mysql_query("SELECT * FROM `" . $config["dbPlayerTable"] . "`");
                    
37	if (!$res)
                    
45	$worlds = array();
                    
46	$res = mysql_query("SELECT * FROM `" . $config["dbWorldTable"] . "`");
                    
47	if (!$res)
                    
133	//Run query
                    
134	$res = mysql_query($sql);
                    
135	if (!$res)
                    
                
camaras_productor.model.php https://gitlab.com/talueses/SIPVE | PHP | 197 lines
                    
53		$link = DbLink::getLink();
                    
54		$result = mysql_query($sql, $link);
                    
55		if (!$result) {
                    
108		$str .= "\t\t\$link = DbLink::getLink();\n";
                    
109		$str .= "\t\t\$result = mysql_query(\$sql, \$link);\n";
                    
110		$str .= "\t\tif (!\$result) {\n";
                    
143		$str .= "\t\t\$link = DbLink::getLink();\n";
                    
144		$str .= "\t\t\$result = mysql_query(\$sql, \$link);\n";
                    
145		$str .= "\t\tif (!\$result) {\n";
                    
160                $str .= "\t\t\$link = DbLink::getLink();\n";
                    
161		$str .= "\t\t\$result = mysql_query(\$sql, \$link);\n";
                    
162		$str .= "\t\tif (!\$result) {\n";
                    
                
_stats_load.php https://gitlab.com/Etern4l/BitcoinDice | PHP | 238 lines
                    
17
                    
18$settings=mysql_fetch_array(mysql_query("SELECT * FROM `system` LIMIT 1"));
                    
19
                    
23  case 'my_bets':
                    
24    if (empty($_GET['_unique']) || mysql_num_rows(mysql_query("SELECT `id` FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"))==0) exit();
                    
25    $player=mysql_fetch_array(mysql_query("SELECT * FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"));
                    
26    
                    
27    $my_bets=mysql_query("SELECT * FROM `bets` WHERE `player`=$player[id] ORDER BY `time` DESC LIMIT 30");
                    
28    if (mysql_num_rows($my_bets)==0) $content.='<br><br><br><i>You haven\'t bet yet.</i>';
                    
44        
                    
45        $username=mysql_fetch_array(mysql_query("SELECT `alias` FROM `players` WHERE `id`=$my_bet[player] LIMIT 1"));
                    
46        
                    
74  case 'all_bets':
                    
75    $all_bets=mysql_query("SELECT * FROM `bets` WHERE `bet_amount`!=0 ORDER BY `time` DESC LIMIT 30");
                    
76    if (mysql_num_rows($all_bets)==0) $content.='<br><br><br><i>No one has bet yet.</i>';
                    
                
index.php https://github.com/jomartigcal/cvsea.git | PHP | 239 lines
                    
52			$query = "SELECT * FROM admins";
                    
53			$result = @mysql_query($query);
                    
54			$test = FALSE;
                    
                
mysql.dbi.lib.php https://gitlab.com/albert925/lading-ach | PHP | 450 lines
                    
171    if ($options == ($options | PMA_DBI_QUERY_STORE)) {
                    
172        $r = mysql_query($query, $link);
                    
173    } elseif ($options == ($options | PMA_DBI_QUERY_UNBUFFERED)) {
                    
175    } else {
                    
176        $r = mysql_query($query, $link);
                    
177    }
                    
                
heidelpay_response.php https://bitbucket.org/isaacoheneayisi/ecommerce.git | PHP | 190 lines
                    
48		mysql_select_db($connect->db);	
                    
49		$result = mysql_query("SELECT virtuemart_order_id FROM ".$connect->dbprefix."virtuemart_orders"." WHERE  order_number = '".mysql_real_escape_string($orderID)."';");
                    
50		$row = mysql_fetch_object($result);
                    
169					"response_ip					= \"".mysql_real_escape_string($_SERVER['REMOTE_ADDR']). "\";" ;
                    
170			$dbEerror = mysql_query($sql);
                    
171		}
                    
                
printprod_new.php https://gitlab.com/Henaway/CLFC | PHP | 201 lines
                    
34    subcategory_name ASC';
                    
35$rs = @mysql_query($sql, $connection) or die("Couldn't execute category query: ".mysql_error());
                    
36while ( $row = mysql_fetch_array($rs) )
                    
98        '.TABLE_MEMBER.'.business_name';
                    
99    $resultp = @mysql_query($sqlp, $connection) or die("Couldn't execute query 2.");
                    
100    while ( $row = mysql_fetch_array($resultp) )
                    
128            unit_price ASC';
                    
129        $result = @mysql_query($sql, $connection) or die("Couldn't execute search query: " . mysql_error());
                    
130        while ( $row = mysql_fetch_array($result) )
                    
                
ebpls_ctc_issued.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 214 lines
                    
82
                    
83        $result=@mysql_query("select lguname, lguprovince from ebpls_buss_preference")
                    
84        or die(mysql_error());
                    
85    $resulta=mysql_fetch_row($result);
                    
86$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'");
                    
87$getlgu = @mysql_fetch_row($getlgu);
                    
87$getlgu = @mysql_fetch_row($getlgu);
                    
88$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'");
                    
89$getprov = @mysql_fetch_row($getprov);
                    
115$date_to = date('Y-m-d', $xdate);
                    
116	$result1=mysql_query("select concat(ctc_first_name, ' ', ctc_middle_name, ' ', ctc_last_name) as name, ctc_code, 
                    
117    ctc_address, ctc_date_issued, ctc_tax_due, ctc_tax_interest, ctc_additional_tax1, ctc_additional_tax2, ctc_additional_tax3 from ebpls_ctc_individual where ctc_date_issued between '$date_from' and '$date_to' order by name asc") 
                    
119	$x1 = @mysql_num_rows($result1);
                    
120	$result2=mysql_query("select ctc_company, ctc_code, ctc_company_address, ctc_date_issued, ctc_tax_due, ctc_tax_interest, ctc_additional_tax1, ctc_additional_tax2 from ebpls_ctc_business where ctc_date_issued between '$date_from' and '$date_to' order by ctc_company asc") 
                    
121    or die(mysql_error());
                    
                
Abstract.php https://github.com/hettema/Stages.git | PHP | 325 lines
                    
34    /**
                    
35     * @var Mysql_Query
                    
36     */
                    
314     *
                    
315     * @return Main_Mysql_Query object 
                    
316     */
                    
319        if(!$this->_query) {
                    
320            $this->_query = new Main_Mysql_Query();
                    
321        }
                    
                
entry.php https://github.com/kenichiromiya/webwritecms.git | PHP | 253 lines
                    
13/*
                    
14		$result = mysql_query($sql,$this->db);
                    
15		$archives = array();
                    
28
                    
29//		mysql_query($query,$this->db);
                    
30	}
                    
35                $sth->execute(array($param['title'],$param['category_id'],$param['body'],$param['id']));
                    
36		//mysql_query($query,$this->db);
                    
37	}
                    
43
                    
44	//	mysql_query($query,$this->db);
                    
45	}
                    
52
                    
53		//$result = mysql_query($query,$this->db);
                    
54		//$entry=mysql_fetch_assoc($result);
                    
                
index.php https://github.com/d3c0n808/MiningFarm.git | PHP | 276 lines
                    
49								$fifteenMinutesAgo -= 60*15;
                    
50								$userHashHistoryQ = mysql_query("SELECT DISTINCT `timestamp` FROM `stats_userMHashHistory` WHERE `username` LIKE '".$getCredientials->username.".%' AND `timestamp` >= '$fifteenMinutesAgo' AND `mhashes` > 0 ORDER BY `timestamp` ASC");
                    
51								$numRows = mysql_num_rows($userHashHistoryQ);
                    
66										//Get all mhash results with this timestamp and average them up
                    
67											$getAllWorkerHash = mysql_query("SELECT `mhashes` FROM `stats_userMHashHistory` WHERE `username` LIKE '".$getCredientials->username.".%' AND `timestamp` = '".$time["timestamp"]."' AND `mhashes` > 0");
                    
68											$numWorkersThisTime = mysql_num_rows($getAllWorkerHash);
                    
74										//Get pool average results
                    
75											$getPoolAverageResult = mysql_query("SELECT `averageMhash`, `totalMhash` FROM `stats_poolMHashHistory` WHERE `timestamp` = '".$time["timestamp"]."' LIMIT 0,1");
                    
76									
                    
102									//Go through the pool history and display that
                    
103									$poolHistory = mysql_query("SELECT `averageMhash`, `totalMhash`, `timestamp` FROM `stats_poolMHashHistory` WHERE `timestamp` >= '".$fifteenMinutesAgo."' ORDER BY `timestamp` ASC");
                    
104										while($poolHash = mysql_fetch_array($poolHistory)){
                    
191										//retireve blogs
                    
192										$blogs = mysql_query("SELECT `title`, `timestamp`, `message` FROM `blogPosts` ORDER BY `timestamp` DESC");
                    
193										while($blog = mysql_fetch_array($blogs)){
                    
                
data_access.php https://github.com/jroglesby/Test-Reservation-System.git | PHP | 322 lines
                    
26		
                    
27		mysql_query("UPDATE user set password='$newpassword' where fsuid='$fsuid'");
                    
28	}
                    
39		
                    
40		$result = mysql_query("SELECT * from user WHERE fsuid='$username' AND password='$password'");
                    
41		$arr=array();
                    
104			
                    
105		$result = mysql_query($query);
                    
106		$arr=array();
                    
127		
                    
128		$result = mysql_query($query);
                    
129		$arr=array();
                    
148		
                    
149		$result = mysql_query("SELECT t2.coursenum,  t2.testname, DATE_FORMAT(t1.day, '%a, %c/%e'), l1.name, TIME_FORMAT(t1.session_time,'%h:%i%p'),  t1.seshid, r1.isMakeup 
                    
150					FROM reservation r1, test_session t1, test t2, location l1 
                    
                
Database.singleton.php https://code.google.com/p/gctour/ | PHP | 311 lines
                    
132	// do query
                    
133	$this->query_id = @mysql_query($sql, $this->link_id);
                    
134
                    
                
qmigo_sendsms.php https://github.com/deviltry/qmigo.git | PHP | 266 lines
                    
35# Get the LATEST OFFER INFO query on the database through the connection
                    
36$result = mysql_query($SqlStatement,$connection);
                    
37if (!$result)
                    
67# Get the LATEST OFFER INFO query on the database through the connection
                    
68$result1 = mysql_query($SqlStatement1,$connection);
                    
69if (!$result1)
                    
86
                    
87	$result2 = mysql_query($SqlStatement2,$connection);
                    
88	if ($row2 = mysql_fetch_array($result2, MYSQL_ASSOC)) 
                    
95	
                    
96	$result3 = mysql_query($SqlStatement3,$connection);
                    
97	
                    
114		$SqlStatement4 = "INSERT into qmigo_status (member_id, offer_id, QR_status) VALUES ($member_id, $offer_id, 0);";
                    
115		mysql_query($SqlStatement4,$connection) or die(mysql_error());
                    
116		//set QR status to 0.
                    
                
tests.inc.php https://github.com/harriswong/ATutor.git | PHP | 214 lines
                    
21$sql = 'SELECT * FROM '.TABLE_PREFIX."content_tests_assoc WHERE content_id=$_REQUEST[cid]";
                    
22$result = mysql_query($sql, $db);
                    
23while ($row = mysql_fetch_assoc($result)) {
                    
31            ORDER BY start_date DESC";
                    
32$result	= mysql_query($sql, $db);
                    
33$num_tests = mysql_num_rows($result);
                    
70	$sql_sub = "SELECT COUNT(*) AS sub_cnt FROM ".TABLE_PREFIX."tests_results WHERE status=1 AND test_id=".$row['test_id'];
                    
71	$result_sub	= mysql_query($sql_sub, $db);
                    
72	$row_sub = mysql_fetch_assoc($result_sub);
                    
76	$sql_sub = "SELECT COUNT(*) AS marked_cnt FROM ".TABLE_PREFIX."tests_results WHERE status=1 AND test_id=".$row['test_id']." AND final_score=''";
                    
77	$result_sub	= mysql_query($sql_sub, $db);
                    
78	$row_sub = mysql_fetch_assoc($result_sub);
                    
82	$sql_sub = "SELECT G.title FROM ".TABLE_PREFIX."groups G INNER JOIN ".TABLE_PREFIX."tests_groups T USING (group_id) WHERE T.test_id=".$row['test_id'];
                    
83	$result_sub	= mysql_query($sql_sub, $db);
                    
84	if (mysql_num_rows($result_sub) == 0) {
                    
                
listarUsuarios.php https://github.com/antonioformatic/curso2011.git | PHP | 218 lines
                    
90$query_limit_usuarios = sprintf("%s LIMIT %d, %d", $query_usuarios, $startRow_usuarios, $maxRows_usuarios);
                    
91$usuarios = mysql_query($query_limit_usuarios, $conexionEmpresa) or die(mysql_error());
                    
92$row_usuarios = mysql_fetch_assoc($usuarios);
                    
96} else {
                    
97  $all_usuarios = mysql_query($query_usuarios);
                    
98  $totalRows_usuarios = mysql_num_rows($all_usuarios);
                    
                
companyclass.php https://github.com/samsonnguyen/CPSC471carinsurance.git | PHP | 280 lines
                    
23		}
                    
24		mysql_query($sql) or die(mysql_error());
                    
25		return true;
                    
29		$sql="DELETE FROM `Company` WHERE Commercial_License_No='$companyno'";
                    
30		mysql_query($sql) or die(mysql_error());
                    
31		return true;
                    
34	static function getAllCompanies($selection){
                    
35		$companies = mysql_query("SELECT * FROM `Company`");// or die(mysql_error());
                    
36		if($companies != null){
                    
89		}
                    
90		return mysql_query($sql);
                    
91	}
                    
140		$sql = "SELECT * FROM `Company` ORDER BY Commercial_License_No ASC LIMIT $offset, $limit";
                    
141		$result = mysql_query($sql);
                    
142		print "<table class=\"company\"><tr>";
                    
                
homepage.php https://github.com/GE3/GE3.git | PHP | 258 lines
                    
19                  //název
                    
20                  $radek = mysql_fetch_assoc( Mysql_query("SELECT * FROM $CONF[sqlPrefix]gal_kat WHERE id=$idGalerie AND skryta='ne'") );
                    
21                  $tmplGalerie->prirad("id", $radek["id"]);
                    
24                  //fotky
                    
25                  $dotaz = Mysql_query("SELECT x.id as idKategorie, x.slozka, x.nazev, y.* FROM 
                    
26                                          $CONF[sqlPrefix]gal_kat x JOIN $CONF[sqlPrefix]galerie y ON x.id=y.kategorie
                    
54    
                    
55    $dotaz2 = Mysql_query("SELECT * FROM $CONF[sqlPrefix]clanky WHERE typ='novinka' ORDER BY id DESC LIMIT 2");
                    
56    $i = 0;
                    
77    $dotaz2 = "SELECT *, MIN(cenaSDph), MIN(cenaBezDph) FROM $CONF[sqlPrefix]zbozi WHERE akce=1 GROUP BY produkt ORDER BY id DESC LIMIT 0,".$radek["pocet_zbozi"]."";
                    
78    $dotaz2 = Mysql_query($dotaz2);
                    
79
                    
148    $tmplClanek = new GlassTemplate("templates/$CONF[vzhled]/clanek.html");    
                    
149    $dotaz2=Mysql_query("SELECT *
                    
150                         FROM $CONF[sqlPrefix]clanky
                    
                
AddressImportGeocom.php https://github.com/ParveenArora/AddressHunter.git | PHP | 204 lines
                    
92}
                    
93mysql_query("SET NAMES UTF8", $dbh);
                    
94
                    
176			);
                    
177			$dbresult = mysql_query($insert, $dbh);
                    
178			if (!$dbresult) {
                    
                
database.php https://gitlab.com/billyprice1/b374k | PHP | 343 lines
                    
80			if(class_exists('mysqli')) return $con->query($query);
                    
81			elseif(function_exists('mysql_query')) return mysql_query($query);
                    
82		}
                    
                
MySql.php https://github.com/joshbhamilton/todophp.git | PHP | 438 lines
                    
319	 *          sends the SQL query query to MySQL without automatically fetching and buffering the
                    
320	 *          result rows as `mysql_query()` does (for less memory usage).
                    
321	 * @return resource Returns the result resource handle if the query is successful.
                    
332
                    
333			$func = ($options['buffered']) ? 'mysql_query' : 'mysql_unbuffered_query';
                    
334			$resource = $func($sql, $self->connection);
                    
                
weather_xml.php https://github.com/michaelmwu/saratogahigh.com.git | PHP | 334 lines
                    
94	$query = "DELETE FROM weather_xml WHERE last_updated < '$expiredatetime'";
                    
95	$result = mysql_query($query) or die('Invalid query: ' . mysql_error());
                    
96
                    
97	$query = "SELECT * FROM weather_xml WHERE xml_url = '$xml_url'"; 
                    
98	$result = mysql_query($query) or die('Invalid query: ' . mysql_error());
                    
99	$row = mysql_fetch_array($result);
                    
124			$query = "INSERT INTO weather_xml VALUES ('$xml_url', '$xml', '$datetime')";
                    
125			$result = mysql_query($query) or die('Invalid query: ' . mysql_error());
                    
126		}
                    
                
spo.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 218 lines
                    
14        <?php $selPle="select localitati.nume, localitati.id_localitate from spo inner join localitati on spo.id_oras = localitati.id_localitate inner join tari on localitati.id_tara = tari.id_tara where tari.nume = 'Romania' Group by localitati.id_localitate Order by localitati.nume ";
                    
15		$quePle=mysql_query($selPle, $conn_tz) or die(mysql_error()); ?>
                    
16		Localitate Plecare:
                    
24       <?php $selPle="select tari.nume, tari.id_tara from spo inner join tari on spo.id_tara = tari.id_tara inner join localitati on spo.id_oras = localitati.id_localitate inner join tari as tari_plec on localitati.id_tara = tari_plec.id_tara where tari_plec.nume = 'Romania' Group by tari.id_tara Order by tari.nume ";
                    
25		$quePle=mysql_query($selPle, $conn_tz) or die(mysql_error()); ?>
                    
26		Tari sosire:
                    
46	$insEx="INSERT INTO exceptii_lista_spo (spo) VALUES ('".$_GET['scoate']."') ";
                    
47	$queEx=mysql_query($insEx, $connect->link) or die(mysql_error());
                    
48	@mysql_free_result($queEx);
                    
52$selEX="SELECT spo FROM exceptii_lista_spo GROUP BY spo ";
                    
53$queEX=mysql_query($selEX, $connect->link) or die(mysql_error());
                    
54while($rowEX=mysql_fetch_array($queEX)) {
                    
89
                    
90$rez=mysql_query($query);
                    
91$numar_total=mysql_num_rows($rez);
                    
                
postdata.php https://github.com/camlegleiter/Project-CyCal.git | PHP | 304 lines
                    
151		$value = mysql_real_escape_string($errorvalue);
                    
152		mysql_query("INSERT INTO panel(userid,rss,posx,posy,sizex,sizey,themeid,minimized) VALUES ('$userid','$value','$posx','$posy','$sizex','$sizey','$themeid','$minimized')");
                    
153		$rows = mysql_affected_rows();
                    
171		$feed = mysql_real_escape_string(urlencode($feed));
                    
172		$rssCheck = mysql_query("DELETE FROM panel WHERE userid='$userid' AND rss='$feed'");
                    
173		$rssCheckTheme = mysql_query("DELETE FROM theme WHERE userid='$userid' AND rss='$feed'");
                    
193	$feed = mysql_real_escape_string(urlencode($rss[0]));
                    
194	if(mysql_query("UPDATE panel SET posx='$posx',posy='$posy', sizex='$sizex' , sizey='$sizey' WHERE userid='$userid' AND rss='$feed'")){
                    
195		successMessage('');
                    
209	}
                    
210	$getRSS = mysql_query("SELECT * FROM panel WHERE userid='$userid' $panelTheme");
                    
211	$rssarr = array();
                    
227			$rss['themeid']['type'] = "User";
                    
228			$getTheme = mysql_query("SELECT * FROM theme WHERE userid='$userid' AND rss='".$row['rss']."'");
                    
229			$themeRow = mysql_fetch_assoc($getTheme);
                    
                
ebpls.reportgenerator.funcs.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 458 lines
                    
84
                    
85	$res = mysql_query( $sqlSelect, $dbLink );
                    
86
                    
111
                    
112	$res = mysql_query( $sqlSelect, $dbLink );
                    
113
                    
139
                    
140	$res = mysql_query( $sqlSelect, $dbLink );
                    
141
                    
166
                    
167	$res = mysql_query( $sqlSelect, $dbLink );
                    
168
                    
200
                    
201	$res = mysql_query( $sqlSelect, $dbLink );
                    
202
                    
                
todolist.php https://gitlab.com/jonz94/2016NCU_FreshWeb_HW | PHP | 187 lines
                    
11    $query_RecUser = "SELECT `nickname`,`permission` FROM `user` WHERE `username`='".$username."'";
                    
12    $RecUser = mysql_query($query_RecUser);
                    
13    $row_RecUser = mysql_fetch_assoc($RecUser);
                    
30    $query_RecLogin = "SELECT * FROM `user` WHERE `username`='".$_POST["username"]."'";
                    
31    $RecLogin = mysql_query($query_RecLogin);   
                    
32    //取出帳號密碼的值
                    
                
op-name.php https://github.com/micheleberg/Calontir-OP.git | PHP | 283 lines
                    
51

                    
52$awardRS = mysql_query("SELECT AwardDate FROM Awards ORDER BY AwardDate DESC");

                    
53$numAward = mysql_num_rows($awardRS);

                    
138

                    
139  $kListRS = mysql_query("SELECT * FROM Kingdoms ORDER BY KingdomInd");

                    
140  $numKList = mysql_num_rows($kListRS);

                    
164

                    
165  $countRS = mysql_query("SELECT count(PopInd) as recCount FROM Populace WHERE $whereClause ORDER BY Name");

                    
166  $numPop = mysql_num_rows($countRS);

                    
174  {

                    
175    $popRS = mysql_query("SELECT * FROM Populace WHERE $whereClause ORDER BY Name");

                    
176    $numPop = mysql_num_rows($popRS);

                    
204        {

                    
205          $awardRS = mysql_query("SELECT Awards.PopInd, Awards.AwardCode, Awards.AwardDate, Awards.KingdomCode, AwardList.Precedence FROM Awards, AwardList WHERE Awards.PopInd =' $popInd ' and AwardList.AwardInd = Awards.AwardCode ORDER BY Awards.AwardDate, AwardList.Precedence");          

                    
206        }

                    
                
install.php https://github.com/benbruscella/Grammafone.git | PHP | 424 lines
                    
5  $query = "SELECT user_id FROM mp3act_users";
                    
6  $result = @mysql_query($query);
                    
7	if(@mysql_num_rows($result) > 0){
                    
351foreach($querys as $key=>$query){
                    
352	if(mysql_query($query)){
                    
353		
                    
396			  $query = "UPDATE mp3act_settings SET invite_mode=$_POST[invite],sample_mode=$_POST[sample_mode],downloads=$_POST[downloads],amazonid=\"$_POST[amazonid]\",mp3bin=\"$_POST[mp3bin]\",lamebin=\"$_POST[lamebin]\",phpbin=\"$_POST[phpbin]\",jukemode=\"$_POST[jukemode]\",mpdserver=\"$_POST[mpdserver]\",mpdport=\"$_POST[mpdport]\" WHERE id=1";
                    
397  			mysql_query($query);
                    
398  			echo "<strong>Settings Saved....</strong><br/><br/>";
                    
409  			$query = "INSERT INTO `mp3act_users` VALUES (NULL, 'admin', 'Admin', 'User', PASSWORD(\"$random_password\"), 10, NOW(), 1, '', 'streaming', 0, 's', '21232f297a57a5a743894a0e4a801fc3', '', '0000-00-00 00:00:00', 1,'','','',0)";
                    
410  			mysql_query($query);
                    
411  			echo "<br/><strong>Username:</strong> Admin<br/><strong>Password:</strong> $random_password (Please change this password as soon as you login.)<br/><br/>";
                    
                
classes.php https://github.com/camlegleiter/Project-Pencl.git | PHP | 378 lines
                    
26	$classid = mysql_real_escape_string($classid);
                    
27	$padRow = mysql_query("SELECT name,description,password,owner FROM classes WHERE id='$classid'");
                    
28	$row = mysql_fetch_assoc($padRow);
                    
54	$classid = mysql_real_escape_string($classid);
                    
55	$padRow = mysql_query("SELECT notebookid FROM classbooks WHERE classid='$classid'");
                    
56	$notepadHTML = "";
                    
69	$classid = mysql_real_escape_string($classid);
                    
70	$padRow = mysql_query("SELECT userid FROM classmates WHERE classid='$classid'");
                    
71	$notepadHTML = "";
                    
87	$id = mysql_real_escape_string($id);
                    
88	$padRow = mysql_query("SELECT name,description,created,modified,userid FROM notebooks WHERE id='$id'");
                    
89	$row = mysql_fetch_assoc($padRow);
                    
122	$id = mysql_real_escape_string($id);
                    
123	$padRow = mysql_query("SELECT username FROM users WHERE userid='$id'");
                    
124	$row = mysql_fetch_assoc($padRow);
                    
                
mutate_htmlsnippet.dynamic.php https://github.com/garryn/evolution.git | PHP | 225 lines
                    
35$sql = 'SELECT internalKey, username FROM '.$tbl_active_users.' WHERE action=78 AND id=\''.$id.'\'';
                    
36$rs = mysql_query($sql);
                    
37$limit = mysql_num_rows($rs);
                    
51	$sql = 'SELECT * FROM '.$tbl_site_htmlsnippets.' WHERE id=\''.$id.'\'';
                    
52	$rs = mysql_query($sql);
                    
53	$limit = mysql_num_rows($rs);
                    
                
simulador-comparador-pruebas.php https://gitlab.com/fredyteheranto/gestionet | PHP | 332 lines
                    
70					  $hoy = date("Y-m-d");
                    
71				      $result = mysql_query("SELECT * FROM extranet_cash_productos WHERE id_tipo_producto = $tipoConsulta AND fecha_hasta >= '$hoy' ORDER BY cuantia_max ASC, anyos ASC;");
                    
72					  while ($row=mysql_fetch_array($result)) {
                    
73					  	$idBanco = $row['id_entidad'];
                    
74					  	$resultBanco = mysql_query("SELECT * FROM extranet_cash_entidades WHERE id = $idBanco;");
                    
75					  	$rowBanco=mysql_fetch_array($resultBanco);
                    
113					<?php
                    
114						$resultFecha = mysql_query("SELECT MAX(f_user) AS fecha FROM extranet_cash_productos");
                    
115						$rowFecha=mysql_fetch_array($resultFecha);
                    
152						<?php
                    
153					      $result = mysql_query("SELECT * FROM extranet_cash_productos WHERE id IN ($seleccion) ORDER BY cuantia_max ASC, anyos ASC;");
                    
154						  while ($row=mysql_fetch_array($result)) {
                    
155						  	$idBanco = $row['id_entidad'];
                    
156						  	$resultBanco = mysql_query("SELECT * FROM extranet_cash_entidades WHERE id = $idBanco;");
                    
157						  	$rowBanco=mysql_fetch_array($resultBanco);
                    
                
class.eyemysqladap.inc.php https://github.com/kevinroberts/snippetz.git | PHP | 438 lines
                    
116	{
                    
117		$result = mysql_query($query, $this->link);
                    
118
                    
                
mysqlquery.php https://bitbucket.org/deditec/finoplaner.git | PHP | 562 lines
                    
179		#echo '<!--'.$this->_query.'-->';
                    
180		$this->_result = mysql_query($this->_query, $this->_dbHandle);
                    
181		$result = array();
                    
211						#echo '<!--'.$queryChild.'-->';
                    
212						$resultChild = mysql_query($queryChild, $this->_dbHandle);
                    
213				
                    
263						#echo '<!--'.$queryChild.'-->';
                    
264						$resultChild = mysql_query($queryChild, $this->_dbHandle);
                    
265				
                    
316
                    
317		$this->_result = mysql_query($query, $this->_dbHandle);
                    
318
                    
374			$query = 'DESCRIBE '.$this->_table;
                    
375			$this->_result = mysql_query($query, $this->_dbHandle);
                    
376			while ($row = mysql_fetch_row($this->_result)) {
                    
                
mysql.php http://seo-phpbb.googlecode.com/svn/trunk/ | PHP | 479 lines
                    
58				{
                    
59					@mysql_query("SET NAMES 'utf8'", $this->db_connect_id);
                    
60					// enforce strict mode on databases that support it
                    
62					{
                    
63						$result = @mysql_query('SELECT @@session.sql_mode AS sql_mode', $this->db_connect_id);
                    
64						$row = @mysql_fetch_assoc($result);
                    
82						$mode = implode(',', $modes);
                    
83						@mysql_query("SET SESSION sql_mode='{$mode}'", $this->db_connect_id);
                    
84					}
                    
114			case 'begin':
                    
115				return @mysql_query('BEGIN', $this->db_connect_id);
                    
116			break;
                    
118			case 'commit':
                    
119				return @mysql_query('COMMIT', $this->db_connect_id);
                    
120			break;
                    
                
parsetodb.php https://gitlab.com/bjwebb-codedump/plingconica.git | PHP | 219 lines
                    
33    
                    
34    if ($result = mysql_query("SELECT * FROM `".$tablename."` WHERE id='".$array["id"]."'", $con));
                    
35    else die(mysql_error());
                    
66    if ($query) {
                    
67        if (mysql_query($query));
                    
68        else {
                    
215
                    
216if (mysql_query("UPDATE `custom` SET `uptodate`=0 WHERE `uptodate`=1"));
                    
217else die(mysql_error());
                    
                
xpdomanager.class.php https://github.com/Kleist/xPDO.git | PHP | 296 lines
                    
81                if (!$rt= @ mysql_select_db($dsnArray['dbname'], $conn)) {
                    
82                    @ mysql_query($sql, $conn);
                    
83                $errorNo= @ mysql_errno($conn);
                    
105                if (@ mysql_select_db($dsnArray['dbname'], $conn)) {
                    
106                    if (@ mysql_query($sql, $conn)) {
                    
107                        $removed= 1;
                    
                
sqlite.php https://github.com/yourhty/hypervm.git | PHP | 635 lines
                    
131		//print($string . "\n");
                    
132		$res = mysql_query($string, $res);
                    
133		if (!$res) {
                    
136			$this->reconnect();
                    
137			$res = mysql_query($string, $res);
                    
138		}
                    
333		if ($sgbl->__var_database_type === 'mysql') {
                    
334			$result = mysql_query("SHOW COLUMNS FROM $this->__sqtable", $gbl->$fdbvar);
                    
335			if (!$result) {
                    
337				$this->reconnect();
                    
338				$result = mysql_query("SHOW COLUMNS FROM $this->__sqtable", $gbl->$fdbvar);
                    
339			}
                    
                
index.php https://github.com/adanganan/chits.git | PHP | 317 lines
                    
72
                    
73/*mysql_query("ALTER TABLE `m_patient` DROP PRIMARY KEY , ADD PRIMARY KEY (`patient_id`)");
                    
74mysql_query("ALTER TABLE `m_consult` DROP PRIMARY KEY , ADD PRIMARY KEY (`consult_id`)");
                    
74mysql_query("ALTER TABLE `m_consult` DROP PRIMARY KEY , ADD PRIMARY KEY (`consult_id`)");
                    
75mysql_query("ALTER TABLE `m_family` DROP PRIMARY KEY , ADD PRIMARY KEY (`family_id`)");
                    
76mysql_query("ALTER TABLE `m_consult_notes` DROP PRIMARY KEY , ADD PRIMARY KEY (`notes_id`)");
                    
76mysql_query("ALTER TABLE `m_consult_notes` DROP PRIMARY KEY , ADD PRIMARY KEY (`notes_id`)");
                    
77mysql_query("ALTER TABLE `content` DROP PRIMARY KEY , ADD PRIMARY KEY (`content_id`)");
                    
78mysql_query("ALTER TABLE `m_patient_mc` DROP PRIMARY KEY, ADD PRIMARY KEY(`mc_id`)");
                    
78mysql_query("ALTER TABLE `m_patient_mc` DROP PRIMARY KEY, ADD PRIMARY KEY(`mc_id`)");
                    
79mysql_query("ALTER TABLE `m_patient_fp` DROP PRIMARY KEY, ADD PRIMARY KEY(`fp_id`)");
                    
80mysql_query("ALTER TABLE `m_patient_ccdev` DROP PRIMARY KEY, ADD PRIMARY KEY(`ccdev_id`)");
                    
80mysql_query("ALTER TABLE `m_patient_ccdev` DROP PRIMARY KEY, ADD PRIMARY KEY(`ccdev_id`)");
                    
81mysql_query("ALTER TABLE `m_patient_ntp` DROP PRIMARY KEY, ADD PRIMARY KEY(`ntp_id`)"); 
                    
82mysql_query("ALTER TABLE `m_consult_appointments` DROP PRIMARY KEY, ADD PRIMARY KEY(`schedule_id`)");
                    
                
home.php https://github.com/budigutama/tes-repo.git | PHP | 304 lines
                    
107	if($_SESSION['string'] == $_POST['code']){
                    
108		$ncari = mysql_num_rows(mysql_query("SELECT *
                    
109								 				 FROM member
                    
112				$verifikasi = md5(uniqid());
                    
113				mysql_query("INSERT INTO member VALUES(null, $_POST[kota], '$_POST[nama]', '$_POST[alamat]',
                    
114							'$_POST[telp]', '$_POST[kodepos]', '$_POST[email]', '".md5($_POST['password'])."',
                    
129if(isset($_GET['code'])){
                    
130	if(mysql_num_rows(mysql_query("SELECT * FROM member WHERE verificationcode_member = '$_GET[code]' AND status_member = '0'")) == 1){
                    
131		mysql_query("UPDATE member
                    
140	
                    
141	$tampil2 = mysql_query($sqlproduk) or die(mysql_error());
                    
142	$jmldata = mysql_num_rows($tampil2);
                    
226					  
                    
227	$qproduk = mysql_query($sqlproduk) or die(mysql_error());
                    
228	$no = 0;
                    
                
create_question_likert.php https://github.com/harriswong/ATutor.git | PHP | 203 lines
                    
86		$sql = vsprintf(AT_SQL_QUESTION_LIKERT, $sql_params);
                    
87				$result	= mysql_query($sql, $db);
                    
88		
                    
100		$sql	= "SELECT * FROM ".TABLE_PREFIX."tests_questions WHERE question_id=$_POST[preset_num] AND course_id=$_SESSION[course_id]";
                    
101		$result	= mysql_query($sql, $db);
                    
102		if ($row = mysql_fetch_assoc($result)){
                    
133			$sql = "SELECT * FROM ".TABLE_PREFIX."tests_questions WHERE course_id=$_SESSION[course_id] AND type=4";
                    
134			$result = mysql_query($sql, $db);
                    
135			if ($row = mysql_fetch_assoc($result)) {
                    
                
SocialGroup.class.php https://github.com/harriswong/ATutor.git | PHP | 486 lines
                    
42			$sql = 'SELECT * FROM '.TABLE_PREFIX.'social_groups WHERE id='.$this->group_id;
                    
43			$result = mysql_query($sql, $db);
                    
44			if (mysql_num_rows($result) > 0){
                    
76		$sql = 'SELECT * FROM '.TABLE_PREFIX.'social_groups_members WHERE group_id='.$this->group_id;
                    
77		$result = mysql_query($sql, $db);
                    
78		if ($result){
                    
100		 $sql = 'SELECT a,id AS id, a.title AS title FROM '.TABLE_PREFIX.'social_groups_activities g LEFT JOIN '.TABLE_PREFIX.'social_activities a ON g.activity_id=a.id WHERE g.group_id='.$this->group_id;
                    
101		 $result = mysql_query($sql, $db);
                    
102		 if ($result){
                    
127
                    
128		$rs = mysql_query($sql, $db);
                    
129		if($rs){
                    
143		 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_groups_board WHERE group_id='.$this->getID().' ORDER BY created_date DESC';
                    
144		 $rs = mysql_query($sql, $db);
                    
145
                    
                
install.php https://code.google.com/p/ezrpg/ | PHP | 340 lines
                    
170QUERY;
                    
171            mysql_query($query1) or die('Something went wrong.');
                    
172            
                    
184QUERY;
                    
185            mysql_query($query2) or die('Something went wrong.');
                    
186            
                    
309            $query = 'INSERT INTO `' . DB_PREFIX . 'players` (`username`, `password`, `email`, `secret_key`, `registered`, `rank`) VALUES(\'' . mysql_real_escape_string($_POST['username']) . '\', \'' . mysql_real_escape_string(sha1($secret_key . $_POST['password'] . SECRET_KEY)) . '\', \'' . mysql_real_escape_string($_POST['email']) . '\', \'' . mysql_real_escape_string($secret_key) . '\', ' . time() . ', 10)';
                    
310            mysql_query($query);
                    
311            
                    
                
feedback.php https://bitbucket.org/maxpanzer/cred_katherine.git | PHP | 175 lines
                    
28		echo $sql;
                    
29		mysql_query($sql) or die(mysql_error());
                    
30?>
                    
                
mysql.php https://gitlab.com/ken3/bluSky | PHP | 443 lines
                    
92
                    
93			mysql_query('SET '.implode(', ', $variables), $this->_connection);
                    
94		}
                    
151			// PHP is compiled against MySQL 4.x
                    
152			$status = (bool) mysql_query('SET NAMES '.$this->quote($charset), $this->_connection);
                    
153		}
                    
185		// Execute the query
                    
186		if (($result = mysql_query($sql, $this->_connection)) === FALSE)
                    
187		{
                    
286
                    
287		if ($mode AND ! mysql_query("SET TRANSACTION ISOLATION LEVEL $mode", $this->_connection))
                    
288		{
                    
293
                    
294		return (bool) mysql_query('START TRANSACTION', $this->_connection);
                    
295	}
                    
                
page_class.php https://github.com/dariostric/CMS.git | PHP | 238 lines
                    
11        if ($language==0) {
                    
12        $response1=mysql_query("SELECT * FROM languages");
                    
13        $row1=mysql_fetch_array($response1, MYSQL_ASSOC);
                    
13        $row1=mysql_fetch_array($response1, MYSQL_ASSOC);
                    
14            $response=mysql_query("SELECT * FROM pages where underpage='0' ORDER BY id");
                    
15            while ($row=mysql_fetch_array($response, MYSQL_ASSOC)) {
                    
18        } else {
                    
19            $response1=mysql_query("SELECT * FROM languages where id='".$language."'");
                    
20            while ($row1=mysql_fetch_array($response1, MYSQL_ASSOC)) {
                    
20            while ($row1=mysql_fetch_array($response1, MYSQL_ASSOC)) {
                    
21            $response=mysql_query("SELECT * FROM pages where underpage='0' ORDER BY id");
                    
22            while ($row=mysql_fetch_array($response, MYSQL_ASSOC)) {
                    
39        if($id==0) {
                    
40            $response=mysql_query("SELECT * FROM pages");
                    
41            $row=mysql_fetch_array($response, MYSQL_ASSOC);
                    
                
panel_producer_admin.php https://gitlab.com/Henaway/CLFC | PHP | 308 lines
                    
33        producer_id = "'.mysql_real_escape_string ($_SESSION['producer_id_you']).'"';
                    
34    $resultr = @mysql_query($sqlr,$connection) or die(debug_print ("ERROR: 904933", array ($sqlr,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
35    $message = 'Producer # '.$producer_id.' has been updated.<br>';
                    
48        producer_id = "'.mysql_real_escape_string ($_GET['producer_id_you']).'"';
                    
49    $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 860943 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
50    while ($row = mysql_fetch_object($result))
                    
73//       LIMIT 0,1';
                    
74//     $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 537557 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
75//     while ($row = mysql_fetch_object($result))
                    
99    business_name';
                    
100$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 759326 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
101while ( $row = mysql_fetch_object($result) )
                    
                
Database.php https://github.com/durand54/caresite.git | PHP | 395 lines
                    
95		//$this->queries[] = $query;
                    
96		return mysql_query($query);
                    
97	}
                    
                
adhesion.php https://gitlab.com/radicalcinema/AnarchistNewsroom | PHP | 369 lines
                    
19$del=$_GET['del'];
                    
20$sql = mysql_query("SELECT * FROM ".$prefix."cotisations WHERE id = '$del'");
                    
21	$nb_rep_request = mysql_num_rows($sql);
                    
23	{
                    
24		mysql_query("DELETE FROM ".$prefix."cotisations WHERE id = '$del'");
                    
25	}
                    
262
                    
263$sql_cotisations = mysql_query("SELECT * FROM ".$prefix."cotisations WHERE id_user = '$id_user_online' ORDER BY date_debut DESC");
                    
264while($cotis = mysql_fetch_array($sql_cotisations)) { 
                    
                
class.Ticker.inc.php http://flaimo-php.googlecode.com/svn/trunk/ | PHP | 266 lines
                    
211		$sql .= ' VALUES (' . $tm->getTimestamp() . ',"' . addslashes($tm->getText()) . '");';
                    
212		$result =  mysql_query($sql, $this->conn) or die ('Request not possible! SQL Statement: ' . $sql . ' / ' . mysql_error());
                    
213	} // end function
                    
                
searchresult2.php https://bitbucket.org/ayudh_das/khaugali.com.git | PHP | 412 lines
                    
19			$query = "select * from restaurant";
                    
20			$resultset = mysql_query($query,$connection);
                    
21			confirmQuery($resultset);
                    
38						on cuisines.cuisine_id=cid.cuisine_id";
                    
39				$res = mysql_query($q2, $connection);
                    
40				confirmQuery($res);
                    
46						on city.city_id=cityid.city_id";
                    
47				$res = mysql_query($q2, $connection);
                    
48				confirmQuery($res);
                    
80						where restaurant.res_id=r2.rest_id";
                    
81				$resultset = mysql_query($query,$connection);
                    
82				confirmQuery($resultset);
                    
99							on cuisines.cuisine_id=cid.cuisine_id";
                    
100					$res = mysql_query($q2, $connection);
                    
101					confirmQuery($res);
                    
                
form.php https://github.com/damanlovett/ucc.git | PHP | 263 lines
                    
59  mysql_select_db($database_connCareer, $connCareer);
                    
60  $Result1 = mysql_query($insertSQL, $connCareer) or die(mysql_error());
                    
61
                    
                
slip.php https://gitlab.com/msdusad/all_ones | PHP | 324 lines
                    
11{ 
                    
12     $inslipnos=mysql_query("SELECT * FROM slip;");
                    
13    while($sl=mysql_fetch_array($inslipnos)){
                    
18$_SESSION['number'] = $_SESSION['number'] + 1; 
                    
19  $inslipno=mysql_query("UPDATE slip SET slipno='{$_SESSION['number']}';");
                    
20} 
                    
121     $ms=$_GET['sl'];
                    
122     $result=mysql_query("SELECT * FROM trregistration where id='$ms';");
                    
123if($result){
                    
                
import.php https://github.com/atutor/scorm_packages.git | PHP | 490 lines
                    
183
                    
184	$result = mysql_query($sql, $db);
                    
185	$q_row	= mysql_fetch_assoc($result);
                    
333
                    
334	$result = mysql_query($sql, $db);
                    
335	if (!$result) {
                    
357
                    
358			$result = mysql_query($sql, $db);
                    
359			if (!$result) {
                    
376				)";
                    
377			$result = mysql_query($sql, $db);
                    
378			break;
                    
402				)";
                    
403			$result = mysql_query($sql, $db);
                    
404			if (!$result) {
                    
                
edit_post.php https://github.com/harriswong/ATutor.git | PHP | 104 lines
                    
41		$sql = "UPDATE ".TABLE_PREFIX."blog_posts SET private=$_POST[private], title='$_POST[title]', body='$_POST[body]', date=date WHERE owner_type=".BLOGS_GROUP." AND owner_id=$_REQUEST[oid] AND post_id=$id";
                    
42		mysql_query($sql, $db);
                    
43
                    
52$sql = "SELECT private, title, body FROM ".TABLE_PREFIX."blog_posts WHERE owner_type=".BLOGS_GROUP." AND owner_id=$_REQUEST[oid] AND post_id=$id";
                    
53$result = mysql_query($sql, $db);
                    
54$post_row = mysql_fetch_assoc($result);
                    
                
confirm.php https://github.com/harriswong/ATutor.git | PHP | 170 lines
                    
30	$sql    = "SELECT creation_date FROM ".TABLE_PREFIX."members WHERE member_id=$id";
                    
31	$result = mysql_query($sql, $db);
                    
32	if ($row = mysql_fetch_assoc($result)) {
                    
36			$sql = "UPDATE ".TABLE_PREFIX."members SET email='$e', last_login=NOW(), creation_date=creation_date WHERE member_id=$id";
                    
37			$result = mysql_query($sql, $db);
                    
38
                    
54	$sql    = "SELECT email, creation_date FROM ".TABLE_PREFIX."members WHERE member_id=$id AND status=".AT_STATUS_UNCONFIRMED;
                    
55	$result = mysql_query($sql, $db);
                    
56	if ($row = mysql_fetch_assoc($result)) {
                    
64			}
                    
65			$result = mysql_query($sql, $db);
                    
66
                    
106	$sql    = "SELECT member_id, email, creation_date, status FROM ".TABLE_PREFIX."members WHERE email='$_POST[email]'";
                    
107	$result = mysql_query($sql, $db);
                    
108
                    
                
FrontlineSMSParser.php https://github.com/rkabir/Swiftriver.git | PHP | 306 lines
                    
287
                    
288        $myResult = mysql_query($sqlQuery, $myConnection);
                    
289        $myArray = array();
                    
                
Index.php https://gitlab.com/ElvisAns/tiki | PHP | 260 lines
                    
21        $this->table = new Search_MySql_Table($db, $index);
                    
22        $this->builder = new Search_MySql_QueryBuilder($db);
                    
23        $this->tfTranslator = new Search_MySql_TrackerFieldTranslator();
                    
162            return $resultSet;
                    
163        } catch (Search_MySql_QueryException $e) {
                    
164            if (empty($e->suppress_feedback)) {
                    
254                $this->table->ensureHasIndex($indexToRestore['Column_name'], $indexType);
                    
255            } catch (Search_MySql_QueryException $exception) {
                    
256                // Left blank on purpose
                    
                
mysql.php https://bitbucket.org/pastor399/newcastleunifc.git | PHP | 413 lines
                    
90		// Set sql_mode to non_strict mode
                    
91		mysql_query("SET @@SESSION.sql_mode = '';", $this->connection);
                    
92
                    
270		// Execute the query. Error suppression is used here to prevent warnings/notices that the connection has been lost.
                    
271		$this->cursor = @mysql_query($query, $this->connection);
                    
272
                    
                
student_2.php https://bitbucket.org/deba666/accitsoftware.git | PHP | 93 lines
                    
55                                                                        <?php $std_row="select * from student ORDER BY STUD_NO DESC";
                    
56                                                                            $q=mysql_query($std_row);
                    
57                                                                            while($row=mysql_fetch_array($q))
                    
                
assetfunctions.php https://github.com/iitgrad/cellarworxiPhoneApp.git | PHP | 751 lines
                    
164
                    
165     mysql_query($query);
                    
166
                    
176
                    
177       $result=mysql_query($query);
                    
178
                    
204
                    
205//       $result=mysql_query($query);
                    
206
                    
232
                    
233       $result=mysql_query($query);
                    
234
                    
258
                    
259       $result=mysql_query($query);
                    
260
                    
                
form3New.php https://gitlab.com/cesardemora/neaticketwebapphomeEs | PHP | 296 lines
                    
54                    $valor = $_GET['fecha_alta'];
                    
55                    $result = mysql_query("SELECT * FROM CLIENTES WHERE fecha_alta LIKE '$valor%' LIMIT $init, $limit_end");
                    
56                    $count = "SELECT COUNT(*) FROM CLIENTES WHERE fecha_alta LIKE '$valor%'";
                    
62                    $valor = $_GET['email'];
                    
63                    $result = mysql_query("SELECT * FROM CLIENTES WHERE mail LIKE '%$valor%' LIMIT $init, $limit_end");
                    
64                    $count = "SELECT COUNT(*) FROM CLIENTES WHERE mail LIKE '%$valor%'";
                    
                
lib.inc.php https://github.com/harriswong/ATutor.git | PHP | 143 lines
                    
126	$sql = 'SELECT p.* FROM '.TABLE_PREFIX.'pa_photos p LEFT JOIN '.TABLE_PREFIX."pa_course_album ca ON p.album_id=ca.album_id WHERE member_id=$member_id AND ca.course_id IS NULL";
                    
127	$result = mysql_query($sql, $db);
                    
128	if ($result){
                    
                
DBMysql.php https://github.com/sergiygladkyy/OEF.git | PHP | 495 lines
                    
115       
                    
116      if (!mysql_query("SET CHARACTER SET ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
                    
117      if (!mysql_query("SET character_set_client = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
                    
117      if (!mysql_query("SET character_set_client = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
                    
118      if (!mysql_query("SET character_set_results = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
                    
119      if (!mysql_query("SET character_set_connection = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
                    
257   {
                    
258      return mysql_query($query, $this->conn);
                    
259   }
                    
                
new_account.php https://github.com/atutor/mahara.git | PHP | 244 lines
                    
22$sql = 'SELECT * FROM '.TABLE_PREFIX.'members WHERE member_id="'.$_SESSION['member_id'].'"';
                    
23$result = mysql_query($sql, $db);
                    
24$row = mysql_fetch_assoc($result);
                    
182$sql = "INSERT INTO ".TABLE_PREFIX."mahara SET at_login='".$_SESSION['login']."', username='".$registration->username."', password='".$random_password."'";
                    
183if (!mysql_query($sql, $db_atutor))
                    
184    exit;              // in case there's some external error; prevent being caught in an infinite loop
                    
                
prueba.php https://gitlab.com/gustCL/syscar | PHP | 268 lines
                    
80        {
                    
81            mysql_query('SET NAMES'.$this->charset);
                    
82        }
                    
95                $tables = array();
                    
96                $result = mysql_query('SHOW TABLES');
                    
97                while($row = mysql_fetch_row($result))
                    
116
                    
117                $result = mysql_query('SELECT * FROM '.$table);
                    
118                $numFields = mysql_num_fields($result);
                    
120                $sql .= 'DROP TABLE IF EXISTS '.$table.';';
                    
121                $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
                    
122                $sql.= "\n\n".$row2[1].";\n\n";
                    
220      $tables = array();
                    
221      $result = mysql_query('SHOW TABLES');
                    
222      while($row = mysql_fetch_row($result))
                    
                
connection.php https://github.com/abdelm/stationwagon.git | PHP | 447 lines
                    
168			// PHP is compiled against MySQL 4.x
                    
169			$status = (bool) mysql_query('SET NAMES '.$this->quote($charset), $this->_connection);
                    
170		}
                    
211		// Execute the query
                    
212		if (($result = mysql_query($sql, $this->_connection)) === false)
                    
213		{
                    
                
sqlquery.lib.php https://github.com/akash6190/pragyan.git | PHP | 256 lines
                    
36		$sqlQueryQuery = 'SELECT `sqlquery_title`, `sqlquery_query` FROM `sqlquery_desc` WHERE `page_modulecomponentid` = \'' . $this->moduleComponentId."'";
                    
37		$sqlQueryResult = mysql_query($sqlQueryQuery);
                    
38		if(!$sqlQueryResult) {
                    
88			$query="SHOW TABLES";
                    
89			$res=mysql_query($query);
                    
90			while($row=mysql_fetch_row($res))
                    
102			$query="SELECT * FROM '$tablename'";
                    
103			$res=mysql_query($query);
                    
104			$numfields=mysql_num_fields($res);
                    
137			$query="SELECT * FROM '$tablename' LIMIT 1";
                    
138			$res=mysql_query($query);
                    
139			for($i=0;$i<mysql_num_fields($res);$i++)
                    
161			$defaultValueQuery = 'SELECT `sqlquery_title`, `sqlquery_query` FROM `sqlquery_desc` WHERE `page_modulecomponentid` = \'' . $this->moduleComponentId."'";
                    
162			$defaultValueResult = mysql_query($defaultValueQuery);
                    
163			if(!$defaultValueResult) {
                    
                
Installer.class.php https://github.com/prabhupathak/openemr.git | PHP | 372 lines
                    
123        $sql_results .= "Creating $title tables...\n";
                    
124	// mysql_query("USE $dbname",$dbh);
                    
125	$fd = fopen($filename, 'r');
                    
308    }
                    
309    $results = mysql_query($sql, $this->dbh);
                    
310    if ( $results ) {
                    
                
CMySQL.php https://github.com/stargazers/CMySQL.git | PHP | 401 lines
                    
97        // Execute query
                    
98        $ret = @mysql_query( $query, $this->_connection );
                    
99
                    
                
contactus.php https://github.com/AvinashMudunuri/Modernize.git | PHP | 92 lines
                    
20  mysql_select_db($database_powermigrate, $powermigrate);
                    
21  $Result1 = mysql_query($insertSQL, $powermigrate) or die(mysql_error());
                    
22  SendContactUsMail($_POST['company_name'], $_POST['contact_name'], $_POST['job_title'], $_POST['telephone'], $_POST['email'], $_POST['comments']);	
                    
                
index.php https://github.com/damanlovett/SEAHO.git | PHP | 202 lines
                    
36$query_rsEditorsOne = "SELECT * FROM state_editors WHERE `column` = 1 ORDER BY `order` ASC";
                    
37$rsEditorsOne = mysql_query($query_rsEditorsOne, $Directory) or die(mysql_error());
                    
38$row_rsEditorsOne = mysql_fetch_assoc($rsEditorsOne);
                    
42$query_rsEditorsTwo = "SELECT * FROM state_editors WHERE `column` = 2 ORDER BY `order` ASC";
                    
43$rsEditorsTwo = mysql_query($query_rsEditorsTwo, $Directory) or die(mysql_error());
                    
44$row_rsEditorsTwo = mysql_fetch_assoc($rsEditorsTwo);
                    
59  mysql_select_db($database_Directory, $Directory);
                    
60  $Result1 = mysql_query($updateSQL, $Directory) or die(mysql_error());
                    
61}
                    
                
all_hotels.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 143 lines
                    
2$sel_hoteluri = "SELECT Accommodation_UnitID, Accommodation_Name, Accommodation_Stars, Accommodation_City_Name, Accommodation_City_ID FROM preturi_transilvania GROUP BY Accommodation_UnitID ";
                    
3$que_hoteluri = mysql_query($sel_hoteluri);
                    
4while($row_hoteluri = mysql_fetch_array($que_hoteluri)) {
                    
15	$sel_loc = "SELECT * FROM localitati_corespondent WHERE nume_furnizor = '".$hotels['localitate'][$key]."' AND code_furnizor = '".$hotels['localitate_id'][$key]."' AND id_furnizor = '".$id_furnizor."' ";
                    
16	$que_loc = mysql_query($sel_loc);
                    
17	$row_loc = mysql_fetch_array($que_loc);
                    
19		$ins_city = "INSERT INTO localitati_corespondent (nume_furnizor, code_furnizor, id_furnizor) VALUES ('".$hotels['localitate'][$key]."', '".$hotels['localitate_id'][$key]."', '".$id_furnizor."') ";
                    
20		$que_city = mysql_query($ins_city) or die(mysql_error());
                    
21		@mysql_free_result($que_city);
                    
23		$sel_oras = "SELECT id FROM localitati_corespondent WHERE nume_furnizor = '".$hotels['localitate'][$key]."' AND code_furnizor = '".$hotels['localitate_id'][$key]."' AND id_furnizor = '".$id_furnizor."' ";
                    
24		$que_oras = mysql_query($sel_oras);
                    
25		$row_oras = mysql_fetch_array($que_oras);
                    
34	$sel_hotels = "SELECT * FROM import_hoteluri WHERE nume_hotel = '".$value."' AND stele_hotel = '".$hotels['stele'][$key]."' AND city = '".$hotel_city."' ";
                    
35	$que_hotels = mysql_query($sel_hotels);
                    
36	$row_hotels = mysql_fetch_array($que_hotels);
                    
                
agent_calendar_2007.php https://bitbucket.org/anneivycat/california-tour.git | PHP | 313 lines
                    
17ORDER BY tt;';
                    
18$r = mysql_query($sql);
                    
19$nr = mysql_num_rows($r);
                    
265//  echo "<span style='font-size: 70%;'>$query</span><br />\n";
                    
266  $mysql_result = mysql_query($query);
                    
267  $totalnumrows = mysql_num_rows($mysql_result);
                    
272    $querytour = "SELECT * FROM TOUR WHERE TOUR_ID = '$TourId'";
                    
273    $mysql_result_tour = mysql_query($querytour);
                    
274    $rowtour = mysql_fetch_array($mysql_result_tour);
                    
                
MySQLTableInfo.php https://bitbucket.org/ferOnti/processmaker.git | PHP | 252 lines
                    
48
                    
49        $res = mysql_query("SHOW COLUMNS FROM `" . $this->name . "`", $this->conn->getResource());
                    
50
                    
110        // Primary Keys
                    
111        $res = mysql_query("SHOW KEYS FROM `" . $this->name . "`", $this->conn->getResource());
                    
112
                    
143        // Indexes
                    
144        $res = mysql_query("SHOW INDEX FROM `" . $this->name . "`", $this->conn->getResource());
                    
145
                    
173    // First make sure we have supported version of MySQL:
                    
174    $res = mysql_query("SELECT VERSION()");
                    
175    $row = mysql_fetch_row($res);
                    
191       // Get the CREATE TABLE syntax
                    
192    $res = mysql_query("SHOW CREATE TABLE `" . $this->name . "`", $this->conn->getResource());
                    
193    $row = mysql_fetch_row($res);
                    
                
developerProfile.php https://bitbucket.org/jasonrogena/fulcrum-dqs.git | PHP | 195 lines
                    
18    $query="SELECT * FROM developer WHERE username='$devUsername'";
                    
19    $result=mysql_query($query) or die(mysql_error());
                    
20    $fetchedResults=mysql_fetch_array($result);
                    
                
index.php https://github.com/chacha13/runningmate.git | PHP | 399 lines
                    
82
                    
83	$query = mysql_query($sql); 
                    
84
                    
167
                    
168	$query = mysql_query($sql); 
                    
169
                    
                
postfooter.php https://github.com/karlforshaw/One-Panel.git | PHP | 217 lines
                    
63			$sql .= 'LIMIT 3';
                    
64			$result = mysql_query( $sql );
                    
65			
                    
                
index.php https://bitbucket.org/chadsaun/ifrogz-panel.git | PHP | 134 lines
                    
19			   WHERE username="'.mysql_real_escape_string(unstripslashes(trim(@$_COOKIE["WRITECKL"]))).'" and password="'.mysql_real_escape_string(unstripslashes(trim(@$_COOKIE["WRITECKP"]))).'"';
                    
20	$rs_rbi = mysql_query($rbiSQL);
                    
21	if(mysql_num_rows($rs_rbi) > 0) {
                    
34$sSQL = "SELECT adminEmail,adminStoreURL,adminShipping,adminVersion,adminUser,adminPassword FROM admin WHERE adminID=1";
                    
35$result = mysql_query($sSQL) or print(mysql_error());
                    
36$rs = mysql_fetch_assoc($result);
                    
                
trainingNaiveBayes.php https://bitbucket.org/astahiam/penduduk.git | PHP | 300 lines
                    
29                $tabel = "select * from penduduktrain";
                    
30				$hasilSelect = mysql_query($tabel) or die (mysql_error());
                    
31				$jumlahRow = mysql_num_rows($hasilSelect);
                    
55				$querycek = "select * from hasiltrain where hasil is not null";
                    
56				$c = mysql_query($querycek) or die (mysql_error());
                    
57				if(mysql_num_rows($c) > 0 ) {
                    
62				//echo $querySejahtera;
                    
63				$s = mysql_query($querySejahtera) or die (mysql_error());
                    
64				$jmlSejahtera = mysql_num_rows($s);
                    
71				//echo $querySejahtera;
                    
72				$p = mysql_query($queryPraSejahtera) or die (mysql_error());
                    
73				$jmlPraSejahtera = mysql_num_rows($p);
                    
84				$queryNikahSejahtera = "SELECT p.*,h.* FROM penduduktrain p, hasiltrain h WHERE p.nik = h.idpenduduk and p.status = 'MENIKAH' and h.hasil = 'SEJAHTERA'";
                    
85				$ns = mysql_query($queryNikahSejahtera) or die (mysql_error());
                    
86				$jmlNikahSejahtera = mysql_num_rows($ns);
                    
                
image_upload.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 108 lines
                    
24// if ($al && $user['id'] == $user_id || $rights >= 7) {
                    
25    // $req_a = mysql_query("SELECT * FROM `cms_album_cat` where `website` = '$website' AND  `id` = '$al' AND `user_id` = '" . $user['id'] . "'");
                    
26    // if (!mysql_num_rows($req_a)) {
                    
71                    // $description = mb_substr($description, 0, 500);
                    
72                    // mysql_query("INSERT INTO `cms_album_files` SET
                    
73                        // `album_id` = '$al',
                    
                
search.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 279 lines
                    
18

                    
19$result = @mysql_query($sql,$conn);

                    
20

                    
                
home_product.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 202 lines
                    
22

                    
23		@$result = mysql_query("delete from ".$tableConfig." where id='".$id."'",$conn);

                    
24

                    
42

                    
43			@$result = mysql_query("delete from ".$tableConfig." where id='".$id."'",$conn);

                    
44

                    
126

                    
127$result=mysql_query($sql,$conn);

                    
128

                    
                
quan_ly.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 168 lines
                    
121	$b_tv="select count(*) from hoadon";
                    
122	$b_tv_1=mysql_query($b_tv);
                    
123	$b_tv_2=mysql_fetch_row($b_tv_1);
                    
126	$tv="select * from hoadon order by id desc limit $vtbd,$sd";
                    
127	$tv_1=mysql_query($tv);
                    
128?>
                    
                
hours.inc.php https://bitbucket.org/websightdesigns/project-manager.git | PHP | 256 lines
                    
60		//echo $insert_sql . "<br />";
                    
61		$q = mysql_query($insert_sql);
                    
62		//$_SESSION["command_results"]["addhours"] = "Your hours were added.";
                    
81			$project_sql = "SELECT id FROM projects WHERE project_name LIKE '%" . str_replace($search_project, "", $_POST['search']) . "%'";
                    
82			$project_q = mysql_query($project_sql);
                    
83			while($i = mysql_fetch_object($project_q)) {
                    
107			$client_sql = "SELECT id FROM clients WHERE fullname LIKE '%" . str_replace($search_client, "", $_POST['search']) . "%'";
                    
108			$client_q = mysql_query($client_sql);
                    
109			while($i = mysql_fetch_object($client_q)) {
                    
133			$task_sql = "SELECT id FROM tasks WHERE task_title LIKE '%" . str_replace($search_task, "", $_POST['search']) . "%'";
                    
134			$task_q = mysql_query($task_sql);
                    
135			while($i = mysql_fetch_object($task_q)) {
                    
182	//echo "<pre>".$sql."</pre><br />";
                    
183	$q = mysql_query($sql) or die(mysql_error());
                    
184	$total_numrows = mysql_num_rows($q);
                    
                
index.php https://github.com/damanlovett/SEAHO.git | PHP | 193 lines
                    
28$query_limit_rsBallot = sprintf("%s LIMIT %d, %d", $query_rsBallot, $startRow_rsBallot, $maxRows_rsBallot);
                    
29$rsBallot = mysql_query($query_limit_rsBallot, $Directory) or die(mysql_error());
                    
30$row_rsBallot = mysql_fetch_assoc($rsBallot);
                    
36$query_limit_rsBallot = sprintf("%s LIMIT %d, %d", $query_rsBallot, $startRow_rsBallot, $maxRows_rsBallot);
                    
37$rsBallot = mysql_query($query_limit_rsBallot, $Directory) or die(mysql_error());
                    
38$row_rsBallot = mysql_fetch_assoc($rsBallot);
                    
44} else {
                    
45  $all_rsBallot = mysql_query($query_rsBallot);
                    
46  $totalRows_rsBallot = mysql_num_rows($all_rsBallot);
                    
                
offer.php https://github.com/deviltry/qmigo.git | PHP | 279 lines
                    
67
                    
68$result = mysql_query($SqlStatement,$connection);
                    
69if (!$result) die("Error " . mysql_errno() . " : " . mysql_error());
                    
82$SqlStatement = "SELECT firstname, lastname FROM qmigo_members WHERE id=$member_id ";
                    
83$result = mysql_query($SqlStatement,$connection);
                    
84if (!$result) die("Error " . mysql_errno() . " : " . mysql_error());
                    
99$SqlStatement = "SELECT * FROM qmigo_offers WHERE id=$offer_id ";
                    
100$result = mysql_query($SqlStatement,$connection);
                    
101if (!$result) die("Error " . mysql_errno() . " : " . mysql_error());
                    
144$SqlStatement = "SELECT  QR_status from qmigo_status  WHERE member_id = ". $member_id ." AND offer_id = " . $offer_id ;
                    
145$result = mysql_query($SqlStatement,$connection);
                    
146if (!$result) die("Error " . mysql_errno() . " : " . mysql_error());
                    
172# Run the LATEST VENDOR INFO + OFFER INFO query on the database through the connection
                    
173$result = mysql_query($SqlStatement,$connection);
                    
174
                    
                
tests_questions.inc.php https://github.com/harriswong/ATutor.git | PHP | 168 lines
                    
52
                    
53$result	= mysql_query($sql, $db);
                    
54if ($_GET['category_id'] <= 0) {
                    
109	$sql	= "SELECT * FROM ".TABLE_PREFIX."tests_questions WHERE course_id=$_SESSION[course_id] AND category_id=".$cat['category_id']." ORDER BY question";
                    
110	$result	= mysql_query($sql, $db);
                    
111	if ($row = mysql_fetch_assoc($result)) {
                    
                
MysqlCacheProvider.php https://github.com/ChuguluGames/mediawiki-svn.git | PHP | 189 lines
                    
106		// Check for database
                    
107		$test = mysql_query("SHOW TABLES FROM $this->_db LIKE '$this->_table'",$this->_link);
                    
108		if (!is_resource($test)) {
                    
125			);
                    
126			$success = mysql_query($query, $this->_link);
                    
127			if (!$success) {
                    
139		$sql="select `value` from `$this->_db`.`$this->_table` where `key`='$key'";
                    
140		$result=mysql_query($sql,$this->_link);
                    
141		if (!is_resource($result)) {
                    
157		$sql = sprintf("DELETE FROM `%s`.`%s` WHERE `key` = '%s'", $this->_db, $this->_table, $key);
                    
158		$success = mysql_query($sql, $this->_link);
                    
159		if (!$success) {
                    
163		$sql = sprintf("INSERT INTO `%s`.`%s` (`key`,`value`) VALUES ('%s','%s')", $this->_db, $this->_table, $key, $value);
                    
164		$success = mysql_query($sql,$this->_link);
                    
165		if (!$success) {
                    
                
editproduct.php https://bitbucket.org/shikhaupadhyay/advt.git | PHP | 208 lines
                    
19		 
                    
20	mysql_query($updatequery); 
                    
21	
                    
25			$sqlptype="select * from product_type where ProductId='".$_REQUEST['id']."'";
                    
26			$resptype=mysql_query($sqlptype);
                    
27			$numptype=mysql_num_rows($resptype);
                    
31			$Query = "update product_type set ProductId = '".$_GET['id']."' , ProductsType = '".$ProductType."' , SpicyType = '".$SpicyType."' , AddDate = '".date('Y-m-d H:i:s')."' where Id='".$rowptype['Id']."'"; 
                    
32			mysql_query($Query);
                    
33			}
                    
35			$Query = "insert into product_type set ProductId = '".$_GET['id']."' , ProductsType = '".$ProductType."' , SpicyType = '".$SpicyType."' , AddDate = '".date('Y-m-d H:i:s')."'"; 
                    
36			mysql_query($Query);	
                    
37			}
                    
42$selectquery="select * from products where id='".$_GET['id']."'";
                    
43$result=mysql_query($selectquery) or die(mysql_error());
                    
44$row=mysql_fetch_object($result);
                    
                
routelist.php https://bitbucket.org/mac_pasha/neticketing.git | PHP | 167 lines
                    
39$query_routelist = "SELECT distinct source FROM launch_info";
                    
40$routelist = mysql_query($query_routelist, $neticketing) or die(mysql_error());
                    
41$row_routelist = mysql_fetch_assoc($routelist);
                    
                
MenuProduct.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 237 lines
                    
4	
                    
5		mysql_query("INSERT INTO ".menu_product." SET 
                    
6		category='".$_POST['category']."',stt='".$_POST['order']."',parent='".$_POST['parent']."',,stthome='".$_SESSION['stthome']."'");
                    
13	
                    
14	mysql_query("UPDATE ".menu_product." SET 
                    
15	category='".$_POST['category']."',stt='".$_POST['order']."',parent='".$_POST['parent']."',,stthome='".$_SESSION['stthome']."' WHERE id='".intval($_GET['Edit'])."'");
                    
29		  
                    
30			  mysql_query("DELETE FROM ".menu_product." WHERE id in (".implode(",",$_POST['element']).")");
                    
31			  mysql_query("DELETE FROM ".menu_product." WHERE parent in (".implode(",",$_POST['element']).")");
                    
43		  
                    
44			  mysql_query("UPDATE  ".menu_product." SET status='false' WHERE id in (".implode(",",$_POST['element']).")");
                    
45			 
                    
57		  
                    
58			  mysql_query("UPDATE  ".menu_product." SET status='true' WHERE id in (".implode(",",$_POST['element']).")");
                    
59			 
                    
                
content_category.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 148 lines
                    
6		$r = getRecord("tbl_content_category","id=".$id);


                    
7		$resultParent = mysql_query("select id from tbl_content_category where parent='".$id."'",$conn);


                    
8		if (mysql_num_rows($resultParent) <= 0){


                    
8		if (mysql_num_rows($resultParent) <= 0){


                    
9			@$result = mysql_query("delete from tbl_content_category where id='".$id."'",$conn);


                    
10			if ($result){


                    
27			$r = getRecord("tbl_content_category","id=".$id);


                    
28			$resultParent = mysql_query("select id from tbl_content_category where parent='".$id."'",$conn);


                    
29			if (mysql_num_rows($resultParent) <= 0){


                    
29			if (mysql_num_rows($resultParent) <= 0){


                    
30				@$result = mysql_query("delete from tbl_content_category where id='".$id."'",$conn);


                    
31				if ($result){


                    
97$sql="select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from tbl_content_category where parent<>0 and $where $sortby $direction limit ".($p*$MAXPAGE).",".$MAXPAGE;


                    
98$result=mysql_query($sql,$conn);


                    
99$i=0;


                    
                
sql.php https://bitbucket.org/lordgnu/greyhole.git | PHP | 256 lines
                    
90	function db_query($query) {
                    
91		return mysql_query($query);
                    
92	}
                    
                
 

Source

Language