100+ results results for 'mysql_query repo:jojoluzifer/honey-project' (235 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]");
phorum.rb https://gitlab.com/Ruwan-Ranganath/discourse | Ruby | 218 lines
30
31 total_count = mysql_query("SELECT count(*) count FROM #{TABLE_PREFIX}users;").first['count']
32
33 batches(BATCH_SIZE) do |offset|
34 results = mysql_query(
35 "SELECT user_id id, username, email, real_name name, date_added created_at,
59
60 categories = mysql_query("
61 SELECT forum_id id, name, description, active
83
84 total_count = mysql_query("SELECT count(*) count from #{TABLE_PREFIX}messages").first["count"]
85
86 batches(BATCH_SIZE) do |offset|
87 results = mysql_query("
88 SELECT m.message_id id,
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)){
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);
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 }
mysqldataprovider.cpp https://gitlab.com/ablu/invertika-backup-invertika | C++ | 454 lines
156 // actually execute the query.
157 if (mysql_query(mDb, sql.c_str()) != 0) {
158 throw DbSqlQueryExecFailure(mysql_error(mDb));
ref.mysql.html https://bitbucket.org/thncr/manuals.git | HTML | 425 lines
417
418 <h2>Table of Contents</h2><ul class="chunklist chunklist_reference"><li><a href="function.mysql-affected-rows.html">mysql_affected_rows</a> — 取得前一次 MySQL 操作所影响的记录行数</li><li><a href="function.mysql-client-encoding.html">mysql_client_encoding</a> — 返回字符集的名称</li><li><a href="function.mysql-close.html">mysql_close</a> — 关闭 MySQL 连接</li><li><a href="function.mysql-connect.html">mysql_connect</a> — 打开一个到 MySQL 服务器的连接</li><li><a href="function.mysql-create-db.html">mysql_create_db</a> — 新建一个 MySQL 数据库</li><li><a href="function.mysql-data-seek.html">mysql_data_seek</a> — 移动内部结果的指针</li><li><a href="function.mysql-db-name.html">mysql_db_name</a> — 取得结果数据</li><li><a href="function.mysql-db-query.html">mysql_db_query</a> — 发送一条 MySQL 查询</li><li><a href="function.mysql-drop-db.html">mysql_drop_db</a> — 丢弃（删除）一个 MySQL 数据库</li><li><a href="function.mysql-errno.html">mysql_errno</a> — 返回上一个 MySQL 操作中的错误信息的数字编码</li><li><a href="function.mysql-error.html">mysql_error</a> — 返回上一个 MySQL 操作产生的文本错误信息</li><li><a href="function.mysql-escape-string.html">mysql_escape_string</a> — 转义一个字符串用于 mysql_query</li><li><a href="function.mysql-fetch-array.html">mysql_fetch_array</a> — 从结果集中取得一行作为关联数组，或数字数组，或二者兼有</li><li><a href="function.mysql-fetch-assoc.html">mysql_fetch_assoc</a> — 从结果集中取得一行作为关联数组</li><li><a href="function.mysql-fetch-field.html">mysql_fetch_field</a> — 从结果集中取得列信息并作为对象返回</li><li><a href="function.mysql-fetch-lengths.html">mysql_fetch_lengths</a> — 取得结果集中每个输出的长度</li><li><a href="function.mysql-fetch-object.html">mysql_fetch_object</a> — 从结果集中取得一行作为对象</li><li><a href="function.mysql-fetch-row.html">mysql_fetch_row</a> — 从结果集中取得一行作为枚举数组</li><li><a href="function.mysql-field-flags.html">mysql_field_flags</a> — 从结果中取得和指定字段关联的标志</li><li><a href="function.mysql-field-len.html">mysql_field_len</a> — 返回指定字段的长度</li><li><a href="function.mysql-field-name.html">mysql_field_name</a> — 取得结果中指定字段的字段名</li><li><a href="function.mysql-field-seek.html">mysql_field_seek</a> — 将结果集中的指针设定为制定的字段偏移量</li><li><a href="function.mysql-field-table.html">mysql_field_table</a> — 取得指定字段所在的表名</li><li><a href="function.mysql-field-type.html">mysql_field_type</a> — 取得结果集中指定字段的类型</li><li><a href="function.mysql-free-result.html">mysql_free_result</a> — 释放结果内存</li><li><a href="function.mysql-get-client-info.html">mysql_get_client_info</a> — 取得 MySQL 客户端信息</li><li><a href="function.mysql-get-host-info.html">mysql_get_host_info</a> — 取得 MySQL 主机信息</li><li><a href="function.mysql-get-proto-info.html">mysql_get_proto_info</a> — 取得 MySQL 协议信息</li><li><a href="function.mysql-get-server-info.html">mysql_get_server_info</a> — 取得 MySQL 服务器信息</li><li><a href="function.mysql-info.html">mysql_info</a> — 取得最近一条查询的信息</li><li><a href="function.mysql-insert-id.html">mysql_insert_id</a> — 取得上一步 INSERT 操作产生的 ID</li><li><a href="function.mysql-list-dbs.html">mysql_list_dbs</a> — 列出 MySQL 服务器中所有的数据库</li><li><a href="function.mysql-list-fields.html">mysql_list_fields</a> — 列出 MySQL 结果中的字段</li><li><a href="function.mysql-list-processes.html">mysql_list_processes</a> — 列出 MySQL 进程</li><li><a href="function.mysql-list-tables.html">mysql_list_tables</a> — 列出 MySQL 数据库中的表</li><li><a href="function.mysql-num-fields.html">mysql_num_fields</a> — 取得结果集中字段的数目</li><li><a href="function.mysql-num-rows.html">mysql_num_rows</a> — 取得结果集中行的数目</li><li><a href="function.mysql-pconnect.html">mysql_pconnect</a> — 打开一个到 MySQL 服务器的持久连接</li><li><a href="function.mysql-ping.html">mysql_ping</a> — Ping 一个服务器连接，如果没有连接则重新连接</li><li><a href="function.mysql-query.html">mysql_query</a> — 发送一条 MySQL 查询</li><li><a href="function.mysql-real-escape-string.html">mysql_real_escape_string</a> — 转义 SQL 语句中使用的字符串中的特殊字符，并考虑到连接的当前字符集</li><li><a href="function.mysql-result.html">mysql_result</a> — 取得结果数据</li><li><a href="function.mysql-select-db.html">mysql_select_db</a> — 选择 MySQL 数据库</li><li><a href="function.mysql-set-charset.html">mysql_set_charset</a> — 设置客户端的字符集</li><li><a href="function.mysql-stat.html">mysql_stat</a> — 取得当前系统状态</li><li><a href="function.mysql-tablename.html">mysql_tablename</a> — 取得表名</li><li><a href="function.mysql-thread-id.html">mysql_thread_id</a> — 返回当前线程的 ID</li><li><a href="function.mysql-unbuffered-query.html">mysql_unbuffered_query</a> — 向 MySQL 发送一条 SQL 查询，并不获取和缓存结果的行</li></ul>
419</div>
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)
monitorremoto_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_bus_indtaxdelinquent.html http://ebpls.googlecode.com/svn/trunk/ | HTML | 199 lines
28
29 $result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());
30 $resulta=mysql_fetch_row($result);
126 // unang gawang tama
127 $result=mysql_query("select ' ', ' ', ' ' , ' ', ' '
128 from ebpls_business_enterprise") or die(mysql_error());
131 /* sample/test ko lng
132 $result=mysql_query("select a.owner_id, a.business_name, a.business_city_code, a.business_type_code,
133 a.business_street, a.business_capital_investment, a.business_last_yrs_dec_gross_sales, b.fee_amount,
160
161 $result=mysql_query("select gs_name, gs_pos, gs_office from global_sign where sign_id =1") or die(mysql_error());
162 $resulta=mysql_fetch_row($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
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);
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) {
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
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.
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 }
db_base.cpp https://github.com/matszpk/native-boinc-for-android.git | C++ | 500 lines
122 }
123 retval = mysql_query(mysql, p);
124 if (retval) {
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 //取出帳號密碼的值
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/>";
mysql_query.c https://github.com/xbmc/xbmc-rbp.git | C | 370 lines
48{
49 cmyth_mysql_query_t * query = (cmyth_mysql_query_t *)p;
50 if(query->buf != NULL)
206int
207cmyth_mysql_query_param_long(cmyth_mysql_query_t * query,long param)
208{
221int
222cmyth_mysql_query_param_ulong(cmyth_mysql_query_t * query,unsigned long param)
223{
280int
281cmyth_mysql_query_param_str(cmyth_mysql_query_t * query, const char *param)
282{
350int
351cmyth_mysql_query(cmyth_mysql_query_t * query)
352{
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;
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;
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 }
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)) {
load_MySQL.c https://bitbucket.org/vrrm/brl-cad-copy-for-fast-history-browsing-in-git.git | C | 221 lines
69 sprintf (query, "select gid from project where pid = '%d'", pid);
70 mysql_query (&slave_load_mysql_db, query);
71 res = mysql_use_result (&slave_load_mysql_db);
84 snprintf (query, 256, "select trinum,meshnum,gsize,gdata from geometry where gid = '%d'", gid);
85 mysql_query (&slave_load_mysql_db, query);
86 res = mysql_use_result (&slave_load_mysql_db);
173 snprintf (query, 256, "select attr from meshattrmap where mesh='%s' and gid=%d", slave_load_mesh_list[i].name, gid);
174 if (!mysql_query (&slave_load_mysql_db, query)) {
175 char attr[48];
186/* printf("query[%d]: %s\n", i, query); */
187 if (!mysql_query (&slave_load_mysql_db, query)) {
188 res = mysql_use_result (&slave_load_mysql_db);
198 snprintf (query, 256, "select asize,adata from geometry where gid='%d'", gid);
199 mysql_query (&slave_load_mysql_db, query);
200 res = mysql_use_result (&slave_load_mysql_db);
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 }
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
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) )
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){
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
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%'";
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 }
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
plugin.h.pp https://gitlab.com/envieidoc/tomato | Puppet | 142 lines
136void thd_get_xid(const void* thd, MYSQL_XID *xid);
137void mysql_query_cache_invalidate4(void* thd,
138 const char *key, unsigned int key_length,
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 {
mysqlnduhconnection.query.html https://bitbucket.org/thncr/manuals.git | HTML | 130 lines
117 <li class="member">
118 <span class="function"><a href="function.mysql-query.html" class="function" rel="rdfs-seeAlso">mysql_query()</a> - 发送一条 MySQL 查询</span>
119 </li>
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 ) {
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){
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);
mysql_db.cpp https://github.com/o1iver/Code-Backup.git | C++ | 426 lines
48
49as_value mysql_query(const fn_call& fn);
50as_value mysql_row(const fn_call& fn);
65 obj.init_member("disconnect", gl.createFunction(mysql_disconnect));
66 obj.init_member("query", gl.createFunction(mysql_query));
67 obj.init_member("fetch_row", gl.createFunction(mysql_fetch));
387as_value
388mysql_query(const fn_call& fn)
389{
sqlquery.lib.php https://github.com/jithinkr/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) {
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);
DatabaseMysql.cpp https://github.com/freghar/mangos-svn-backup.git | C++ | 390 lines
181
182 if(mysql_query(mMysql, sql))
183 {
247
248 if(mysql_query(mMysql, sql))
249 {
265{
266 if (mysql_query(mMysql, sql))
267 {
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);
extprofile_mysql.h https://github.com/github-ivan/hiphop-php.git | C Header | 321 lines
156
157inline Variant x_mysql_query(CStrRef query, CVarRef link_identifier = null) {
158 FUNCTION_INJECTION_BUILTIN(mysql_query);
158 FUNCTION_INJECTION_BUILTIN(mysql_query);
159 return f_mysql_query(query, link_identifier);
160}
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);
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
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)) {
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;
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) {
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
user.php https://github.com/carlosefonseca/ER-client-webapp.git | PHP | 215 lines
48
49 $result = mysql_query($q);
50 if(!$result || (mysql_num_rows($result) != 1)){
ARC2_StoreTableManager.php https://github.com/mterenzio/FollowThis.git | PHP | 287 lines
85 ";
86 return mysql_query($sql, $this->getDBCon());
87 }
97 ";
98 return mysql_query($sql, $this->getDBCon());
99 }
110 ";
111 return mysql_query($sql, $this->getDBCon());
112 }
119 ";
120 return mysql_query($sql, $this->getDBCon());
121 }
134 ";
135 return mysql_query($sql, $this->getDBCon());
136 }
mysql.idl.php https://github.com/zsj888/hiphop-php.git | PHP | 203 lines
94
95f('mysql_query', Variant,
96 array('query' => String,
video.php https://github.com/Airzign/Shiksha-Sankalp.git | PHP | 264 lines
48 $description = stripslashes($_POST['description']);
49 $result = mysql_query("select smallimgurl from video where id=$id");
50 $link = stripslashes($_POST['link']);
96 }
97 if(mysql_query("update video set heading='$heading',smallimgurl='$new_small_img_filename',link='$link',description='$description' where id = $id"))
98 $message .= 'The Video was updated successfully.';
102 $id=$_GET['id'];
103 $query = mysql_query("select * from video where id=$id");
104 $row=mysql_fetch_assoc($query);
106 unlink($video_img_dir.$row['smallimgurl']);
107 if(mysql_query("delete from video where id=$id"))
108 $message .= 'The video was deleted successfully.';
143 }
144 if(mysql_query("INSERT INTO video VALUES (default,'$heading','$description','$small_img_filename','$link',default);"))
145 $message .= 'New video created successfully.';
actions_email.php https://github.com/GansukhB/phtstr.git | PHP | 195 lines
10
11 $settings_result = mysql_query("SELECT * FROM settings where id = '1'", $db);
12 $setting = mysql_fetch_object($settings_result);
28 $sql = "INSERT INTO email_copy (title,subject,article,image_upload,image_area_name,image_w,image_h,file_upload,file_area_name) VALUES ('$title','$subject','$article','$set_image_upload','$set_image_area_name','$set_image_width','$set_image_height','$set_file_upload','$set_file_area_name')";
29 $result = mysql_query($sql);
30
30
31 $last_result = mysql_query("SELECT id FROM email_copy order by id desc", $db);
32 $last = mysql_fetch_object($last_result);
44 $sql = "INSERT INTO uploaded_files (reference,reference_id,filename,file_text) VALUES ('$_POST[reference]','$last->id','$fname','$_POST[file_text]')";
45 $result = mysql_query($sql);
46
71 $sql = "INSERT INTO uploaded_images (reference,reference_id,filename,caption) VALUES ('$_POST[reference]','$last->id','$image_details[1]','$_POST[image_caption]')";
72 $result = mysql_query($sql);
73 }
b3kicks.php https://github.com/xlr8or/echelon.git | PHP | 251 lines
29$query_limit_rs_activebans = sprintf("%s LIMIT %d, %d", $query_rs_activebans, $startRow_rs_activebans, $maxRows_rs_activebans);
30$rs_activebans = mysql_query($query_limit_rs_activebans, $b3connect) or die(mysql_error());
31$row_rs_activebans = mysql_fetch_assoc($rs_activebans);
34} else {
35 $all_rs_activebans = mysql_query($query_rs_activebans);
36 $totalRows_rs_activebans = mysql_num_rows($all_rs_activebans);
session.php https://github.com/danielhahne/corecms.git | PHP | 440 lines
64 global $theme_path;
65 $data = mysql_query("SELECT t.* FROM core_tags t ORDER BY t.tag_position DESC");
66
72 $id_str = "tags.tag" . $tag_id . "=";
73 $entries = mysql_query("SELECT e2t.entry_id FROM core_entry2tag e2t WHERE e2t.tag_id = $tag_id");
74
99 global $online_path, $theme_path, $current_tag, $thumb_w, $thumb_h, $root, $date_format, $separator_tags, $show_empty, $nice_permalinks;
100 $data_entries = mysql_query("SELECT * FROM core_entries e WHERE e.entry_show = 1 ORDER BY e.entry_position DESC");
101
135
136 $data_e2t = @mysql_query("SELECT e2t.tag_id FROM core_entry2tag e2t WHERE e2t.entry_id = $entry_id");
137
141 $tag_id = $e2t["tag_id"];
142 $data_tags = @mysql_query("SELECT t.tag_text FROM core_tags t WHERE t.tag_id = $tag_id ORDER BY t.tag_position DESC");
143 while($t = @mysql_fetch_array($data_tags)) {
searchFriend.php http://projetwebdubail.googlecode.com/svn/trunk/ | PHP | 255 lines
104
105 $data=mysql_query($sql, $link);
106
158 $reqvote="SELECT COUNT(*) FROM voteutilisateur WHERE idVotant=".$_SESSION['userID']." AND idUtilisateur=".$id.";";
159 $SQLVote=mysql_query($reqvote, $link);
160 $resultVote=mysql_result($SQLVote, 0);
246$req="SELECT COUNT(utilisateur.idUtilisateur) FROM utilisateur, estAmi WHERE estAmi.idUtilisateur=".$_SESSION['userID']." AND estAmi.idAmi=".$id." ; ";
247$sql=mysql_query($req, $link);
248$resultVote=mysql_result($sql, 0);
mysql.inc git://pkgs.fedoraproject.org/mrbs | PHP | 508 lines
43
44 if (mysql_query($sql, $db_conn))
45 {
57// a MIN or MAX aggregate function applied over no rows.
58function sql_mysql_query1 ($sql, $db_conn = null)
59{
61
62 $r = mysql_query($sql, $db_conn);
63 if (! $r)
79// Returns 0 on error; use sql_error to get the error message.
80function sql_mysql_query ($sql, $db_conn = null)
81{
83
84 $r = mysql_query($sql, $db_conn);
85 return $r;
mysql.php https://bitbucket.org/ke2083/transfans.co.uk-website.git | PHP | 335 lines
106
107 $this->query_result = @mysql_query($query, $this->db_connect_id);
108 }
tara_new.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 340 lines
77
78$queZ=mysql_query($selZ) or die(mysql_error());
79
189
190$queL=mysql_query($selL) or die(mysql_error());
191
313
314$queL=mysql_query($selL) or die(mysql_error());
315
Privilege.php https://github.com/bblc/tomatocms208v1.git | PHP | 130 lines
31 $sql = "SELECT * FROM " . $this->_prefix . "core_privilege";
32 $rs = mysql_query($sql);
33 $rows = array();
44 mysql_real_escape_string($id));
45 $rs = mysql_query($sql);
46 $return = (0 == mysql_num_rows($rs)) ? null : new Core_Models_Privilege(mysql_fetch_object($rs));
58 mysql_real_escape_string($privilege->controller_name));
59 mysql_query($sql);
60 return mysql_insert_id();
66 mysql_real_escape_string($id));
67 mysql_query($sql);
68 return mysql_affected_rows();
91
92 $rs = mysql_query($sql);
93 $rows = array();
envio.php https://gitlab.com/merintec/barvo | PHP | 55 lines
42 $insertar="INSERT into contacto (nomb_ape_cont,email_cont,come_cont,fech_cont,status,telefono) value ('".$nombre."','".$correo."','".$contenido."','".date('Y-m-d')."','pendiente','".$telefono."')";
43 $insertar=mysql_query($insertar);
44 echo mysql_error();
breadcrumbs.lib.php https://github.com/jithinkr/pragyan.git | PHP | 91 lines
30 $query = 'SELECT `page_id`, `page_name`, `page_title` FROM `' . MYSQL_DATABASE_PREFIX . 'pages` WHERE `page_id` IN (' . $pageIdList . ')';
31 $resultId = mysql_query($query);
32
upgrade_course_110.lib.php https://github.com/TeamRocketScience/Claroline-TRS-Edition.git | PHP | 285 lines
244
245 $sql = mysql_query($req);
246
256
257 $sql = mysql_query($req);
258
deposit_history.php https://github.com/webegg/Zencart-CMS.git | PHP | 206 lines
41 //$cb=mysqli_fetch_object(mysqli_query($link, "SELECT deposit FROM ".$usertable." WHERE ".$userid." = ".$useridentify.""));
42 $cb=mysql_fetch_object(mysql_query("SELECT deposit FROM users WHERE id = '$user_id'"));
43
44//select all the history of the user
45$sql = mysql_query("SELECT * FROM deposit_history WHERE user_id = '$user_id'");
46?>
test.php https://github.com/UniBus/Server.git | PHP | 282 lines
22 $query = 'SELECT agency_name FROM agency';
23 $result = mysql_query($query, $cityDBLink) or die('Query failed: '. mysql_error());
24 $totalRows= mysql_num_rows($result);
63 $query = 'SELECT service_id,start_date,end_date FROM calendar ORDER BY end_date DESC';
64 $result = mysql_query($query, $cityDBLink) or die('Query failed: '. mysql_error());
65 $totalRows= mysql_num_rows($result);
78 $query = 'SELECT service_id, date FROM calendar_dates ORDER BY date DESC';
79 $result = mysql_query($query, $cityDBLink) or die('Query failed: '. mysql_error());
80 $totalRows= mysql_num_rows($result);
100 $query = 'SELECT * FROM cities ORDER BY country, state, name';
101 $result = mysql_query($query, $link) or die('Query failed: '. mysql_error());
102 $totalRows= mysql_num_rows($result);
123 $query = 'SELECT * FROM stops ORDER BY RAND() LIMIT 1';
124 $result = mysql_query($query, $link) or die('Query failed: '. mysql_error());
125 $totalRows= mysql_num_rows($result);
comprobar.php https://gitlab.com/FerSo/tesis | PHP | 171 lines
35// comprobamos que los datos ingresados en el formulario coincidan con los de la BD
36$sql = mysql_query("SELECT * FROM usuarios WHERE usuario_nombre='" . $usuario_nombre . "' AND usuario_clave='" . $usuario_clave . "'");
37if ($row = mysql_fetch_array($sql)) {
46$accion = "Inicio de sesión";
47$bit = mysql_query("INSERT INTO bitacora (id_usuario, fecha, modulo, accion) VALUES ('" . $_SESSION['id_usuario'] . "', NOW(),'" . $modulo . "' , '" . $accion . "')");
48
118 // comprobamos que los datos ingresados en el formulario coincidan con los de la BD
119 $sql = mysql_query("SELECT * FROM usuarios WHERE usuario_nombre='" . $usuario_nombre . "' AND usuario_clave='" . $usuario_clave . "'");
120 if ($row = mysql_fetch_array($sql)) {
131 $accion = "Inicio de sesión";
132 $bit = mysql_query("INSERT INTO bitacora (id_usuario, fecha, modulo, accion) VALUES ('" . $_SESSION['id_usuario'] . "', NOW(),'" . $modulo . "' , '" . $accion . "')");
133
registrar.php https://gitlab.com/FerSo/tesis | PHP | 129 lines
50
51 $sql = mysql_query("SELECT usuario_nombre FROM usuarios WHERE usuario_nombre='" . $usuario_nombre . "'");
52 if (mysql_num_rows($sql) > 0) {
56 // ingresamos los datos a la BD
57 $reg = mysql_query("INSERT INTO usuarios (usuario_nombre, nombre, apellido, usuario_clave, usuario_email, fecha_reg) VALUES ('" . $usuario_nombre . "', '" . $nombre . "', '" . $apellido . "', '" . $usuario_clave . "', '" . $usuario_email . "', NOW())");
58
58
59 $consult = mysql_query("SELECT id_usuario FROM usuarios WHERE usuario_nombre = '" . $usuario_nombre . "'");
60 $cons = mysql_fetch_array($consult);
64
65 $bit = mysql_query("INSERT INTO bitacora (id_usuario, fecha, modulo, accion) VALUES ('" . $cons[0] . "', NOW(),'" . $modulo . "' , '" . $accion . "')");
66 if ($bit) {
userstats.php https://bitbucket.org/stavrossk/openmaidos.git | PHP | 69 lines
23 $getPluginVersion = $_GET['plugin_version'];
24 $res = mysql_query("SELECT * FROM plugins WHERE plugin_ID='$getPluginId' AND plugin_Version='$getPluginVersion'");
25 $numrows = mysql_numrows($res);
33}
34$res = mysql_query("SELECT plugin_ID, plugin_Name, plugin_Author, max(plugin_Date) as maxdate FROM plugins WHERE plugin_ReviewFlag = 'FALSE' GROUP BY plugin_ID ORDER BY maxdate desc LIMIT 10");
35while (($enreg=@mysql_fetch_array($res)))
41if ($u == "binary64") $where = "";
42$res = mysql_query("SELECT * FROM userdownloads $where ORDER BY download_Date DESC LIMIT 0,10");
43while (($enreg=@mysql_fetch_array($res)))
49//is vote still latest version?
50$res2 = mysql_query("SELECT * FROM plugins WHERE plugin_ID='$plugin_id' and plugin_Version='$plugin_version'");
51$enreg2 = @mysql_fetch_array($res2);
class.engine.php https://github.com/NoVatutz/RevCMS.git | PHP | 134 lines
20 $this->setMysql('select_db', @mysql_select_db);
21 $this->setMySQL('query', @mysql_query);
22 $this->setMySQL('num_rows', @mysql_num_rows);
view.php https://gitlab.com/jonz94/2016NCU_FreshWeb_HW | PHP | 240 lines
12 $query_RecUser = "SELECT `nickname`, `permission` FROM `user` WHERE `username`='".$username."'";
13 $RecUser = mysql_query($query_RecUser);
14 $row_RecUser = mysql_fetch_assoc($RecUser);
31 $query_Login = "SELECT * FROM `user` WHERE `username`='".$_POST["username"]."'";
32 $Login = mysql_query($query_Login);
33 //取出帳號密碼的值
81 $query_RecComment = "SELECT `comment`.*, `user`.`nickname`, `user`.`username`, `user`.`sex` FROM `comment`,`user` WHERE `comment`.`id`='".$id."' AND `comment`.`user_id`=`user`.`id`";
82 $RecComment = mysql_query($query_RecComment);
83 if(!$row_RecComment=mysql_fetch_assoc($RecComment)){ ?>
content_news_m.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 264 lines
77 }
78 if (mysql_query($sql,$conn)){
79 if(empty($_POST['id'])) $oldid = mysql_insert_id();
109 $sqlUpdate = "update ".$tableConfig." set $sqlUpdateField where id='".$oldid."'";
110 mysql_query($sqlUpdate,$conn);
111 }
123 $sql = "select * from ".$tableConfig." where id='".$oldid."'";
124 if ($result = mysql_query($sql,$conn)) {
125 $row=mysql_fetch_array($result);
subscribe.php https://github.com/claymodel/voip-foip.git | PHP | 500 lines
168 dbg_msg("$query <BR>");
169 $result = mysql_query($query) or html_die("Invalid SQL query");
170 if(mysql_num_rows($result) == 0)
186 $query = "UPDATE jusers SET tyep=1 WHERE sip_id='$sipuri'";
187 $result = mysql_query($query, $dblink);
188 if(mysql_affected_rows() != 1)
197 $query = "SELECT jab_id FROM jusers WHERE sip_id='$sipuri'";
198 $result = mysql_query($query, $dblink) or html_die("Invalid SQL query");
199 if(mysql_num_rows($result) == 0)
247 $query = "INSERT INTO jusers (jab_id, jab_passwd, sip_id) VALUES ('$sipname', '$new_passwd', '$sipuri')";
248 $result = mysql_query($query, $dblink);
249 if(mysql_affected_rows() != 1)
260 $query = "UPDATE jusers SET type=0 WHERE sip_id='$sipuri'";
261 $result = mysql_query($query, $dblink);
262 if(mysql_affected_rows() != 1)
players.php https://bitbucket.org/verax/to-ladder.git | PHP | 236 lines
13
14$playerinfo=mysql_query("SELECT * FROM users WHERE id='$playerid'");
15$myinfo=mysql_fetch_array($playerinfo);
20
21$playerinfo=mysql_query("SELECT *,DATE_FORMAT(joindate, '%M %d, %Y') FROM users WHERE id='$playerid'");
22$myinfo=mysql_fetch_array($playerinfo);
132</tr>";
133$teamson=mysql_query("SELECT teamid,status,DATE_FORMAT(joindate, '%M %d, %Y') FROM teammembers WHERE playerid='$playerid' ORDER by joindate");
134while(list($team,$status,$joindate)=mysql_fetch_row($teamson)){
134while(list($team,$status,$joindate)=mysql_fetch_row($teamson)){
135 $teaminfo=mysql_query("SELECT teamname,type FROM teams WHERE id='$team'");
136 $tinfo=mysql_fetch_array($teaminfo);
177//GET COMMENTS
178$getcomments=mysql_query("SELECT comment,addedby,DATE_FORMAT(added, '%M %d, %l:%i %p') FROM staffcomments WHERE id='$playerid' AND isateam='0' AND display='1' ORDER by added");
179while(list($comment,$addedby,$added)=mysql_fetch_row($getcomments)){
class.timetracker.php https://gitlab.com/vectorci/Collabtive | PHP | 438 lines
69
70 $ins = mysql_query("INSERT INTO timetracker (user,project,task,comment,started,ended,hours,pstatus) VALUES ($user,$project,$task,'$comment','$started','$ended','$hours',0)");
71
111
112 $upd = mysql_query("UPDATE timetracker SET task='$task',comment='$comment',started='$started',ended='$ended',hours='$hours' WHERE ID = $id");
113
132
133 $del = mysql_query("DELETE FROM timetracker WHERE ID = $id");
134
148 $id = (int) $id;
149 $upd = mysql_query("UPDATE timetracker SET pstatus = $pstatus WHERE ID = $id");
150
169
170 $sel = mysql_query("SELECT * FROM timetracker WHERE ID = $id");
171 $track = array();
questions_add.php https://github.com/web-gpambrosio/VMC.git | PHP | 281 lines
12$xttt = $_GET['Exam_Name'];
13$vav=mysql_query("select id, type from type where id='$xttt'");
14if (mysql_num_rows($vav) != "0")
89$dbquery = "insert into questions values ('','$empno', '$txtquestion', '$txta', '$txtb', '$txtc', '$txtd', '$xoption', '$xexamname', '$whencreated')";
90$dbresult = mysql_query($dbquery) or die ("Error in query: $query. " . mysql_error());
91echo "<script type='text/javascript'>alert('Record Saved!')</script>" ;
153$dbexamtype="Select type.id, type.type from type, examtype where examtype.examname = type.type and type.sync='0' order by id asc";
154$dbrexamtype=mysql_query($dbexamtype);
155echo "<select name=\"xexamname\" style=\"font-size:12px; width:220px; font-family:Verdana;color:#999999\"> ";
mod.php https://bitbucket.org/thomascherian91/online-hostel-manager.git | PHP | 111 lines
14
15$q1=mysql_query("select count(uid) from students") or die(mysql_error());
16$q2=mysql_query("select count(id) from guest") or die(mysql_error());
16$q2=mysql_query("select count(id) from guest") or die(mysql_error());
17$q3=mysql_query("select count(id) from staff") or die(mysql_error());
18$r1=mysql_fetch_array($q1) or die(mysql_error());
26
27$q1v=mysql_query("select count(uid) from students where veg_non='YES'") or die(mysql_error());
28$q2v=mysql_query("select count(id) from guest where veg_non='YES'") or die(mysql_error());
28$q2v=mysql_query("select count(id) from guest where veg_non='YES'") or die(mysql_error());
29$q3v=mysql_query("select count(id) from staff where veg_non='YES'") or die(mysql_error());
30$r1v=mysql_fetch_array($q1v) or die(mysql_error());
37
38$q1n=mysql_query("select count(uid) from students where veg_non='NO'") or die(mysql_error());
39$q2n=mysql_query("select count(id) from guest where veg_non='NO'") or die(mysql_error());
install.php https://github.com/benbruscella/Grammafone.git | PHP | 377 lines
6 $query = "SELECT user_id FROM mp3act_users";
7 $result = @mysql_query($query);
8 if(@mysql_num_rows($result) > 0){
309foreach($querys as $key=>$query){
310 if(mysql_query($query)){
311
349 $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]\" WHERE id=1";
350 mysql_query($query);
351 echo "<strong>Settings Saved....</strong><br/><br/>";
362 $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)";
363 mysql_query($query);
364 echo "<br/><strong>Username:</strong> Admin<br/><strong>Password:</strong> $random_password (Please change this password as soon as you login.)<br/><br/>";