100+ results results for 'mysql_query lang:PHP' (468 ms)
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 . ' / ' . $photocount . ($newcount ? ' / <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);
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);
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);
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);
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 }
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)) {
install.php https://github.com/gburca/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/>";
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/lxcenter/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 }