100+ results results for 'mysql_query repo:topahead/csn.gs' (970 ms)
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);
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
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 ") ;
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,
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 }
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
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));
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>';
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());
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)){
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
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>";
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 }
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);
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 //取出帳號密碼的值
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);
class.eyemysqladap.inc.php https://github.com/kevinroberts/snippetz.git | PHP | 438 lines
116 {
117 $result = mysql_query($query, $this->link);
118
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());
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
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
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 }
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
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){
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)
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))
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%'";
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))
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);
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);
postfooter.php https://github.com/karlforshaw/One-Panel.git | PHP | 217 lines
63 $sql .= 'LIMIT 3';
64 $result = mysql_query( $sql );
65
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);
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);
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);
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);
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)){
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;
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
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();
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
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) {
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)){ ?>
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();
editUserNewEmp.php https://gitlab.com/cesardemora/neaticketwebapphomeEs | PHP | 236 lines
15
16 mysql_query("SET NAMES 'utf8'");
17 $consulta = "SELECT * FROM SECTORES ORDER BY id ASC";
17 $consulta = "SELECT * FROM SECTORES ORDER BY id ASC";
18 $resultado = mysql_query($consulta);
19
20 $consulta2 = "SELECT * FROM CODIGOSBARRAS ORDER BY id ASC";
21 $resultado2 = mysql_query($consulta2);
22 // Create the query
mysql_query.c git://github.com/xbmc/xbmc.git | C | 371 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{
download_4_1.php https://gitlab.com/optimistic_mamun/project1 | PHP | 269 lines
8 $query = "SELECT * FROM ice_4_1 WHERE roll='$roll'";
9 $result = mysql_query($query) or die(mysql_error());
10 $count = mysql_num_rows($result);
35 $query1 = "SELECT * FROM reg_info WHERE roll='$roll'";
36 $result1 = mysql_query($query1) or die(mysql_error());
37 $count1 = mysql_num_rows($result1);
task.php http://airscore.googlecode.com/svn/trunk/ | PHP | 430 lines
37 $sql = "select T.*, TW.* from tblTask T left outer join tblTaskWaypoint TW on T.tasPk=TW.tasPk and TW.tawType='goal' where T.tasPk=$tasPk";
38 $result = mysql_query($sql,$link)
39 or die('Task not associated correctly with a competition: ' . mysql_error());
73 $query = "select traPk from tblComTaskTrack where tasPk=$tasPk";
74 $result = mysql_query($query,$link);
75 $tracks = array();
98$query = "select comPk from tblTask where tasPk=$tasPk";
99$result = mysql_query($query) or die('Task not associated with a competition: ' . mysql_error());
100$comPk = mysql_result($result,0,0);
121 $query = "insert into tblTaskAirspace (tasPk, airPk) values ($tasPk, $airPk)";
122 $result = mysql_query($query) or die('Failed to connect airspace to task ' . mysql_error());
123}
130 $query = "delete from tblTaskAirspace where taPk=$taPk";
131 $result = mysql_query($query) or die('Failed to delete airspace association ' . mysql_error());
132 }
_liste_commandes_8inc_8php_source.html https://github.com/rcampistron/ParagrapheCMS.git | HTML | 64 lines
33<a name="l00061"></a>00061
34<a name="l00062"></a>00062 <span class="comment">/*if ($this->formation) $result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE if_bo_com.numcom=if_bo_detail.numcom AND if_bo_detail.designation='Inscription formation' $fin_req ORDER BY hcrea DESC");</span>
35<a name="l00063"></a>00063 <span class="comment"> else $result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE etat $this->etat $fin_req AND if_bo_com.numcom=if_bo_detail.numcom ORDER BY hcrea DESC");*/</span>
35<a name="l00063"></a>00063 <span class="comment"> else $result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE etat $this->etat $fin_req AND if_bo_com.numcom=if_bo_detail.numcom ORDER BY hcrea DESC");*/</span>
36<a name="l00064"></a>00064 <span class="keywordflow">if</span> ($this->formation) { $result=mysql_query(<span class="stringliteral">"SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE if_bo_com.numcom=if_bo_detail.numcom AND if_bo_detail.designation='Inscription formation' $fin_req ORDER BY hcrea DESC"</span>);
37<a name="l00065"></a>00065 } <span class="keywordflow">else</span> {
37<a name="l00065"></a>00065 } <span class="keywordflow">else</span> {
38<a name="l00066"></a>00066 <span class="comment">//$result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE etat $this->etat $fin_req AND if_bo_com.numcom=if_bo_detail.numcom ORDER BY hcrea DESC"); </span>
39<a name="l00067"></a>00067 $result=mysql_query(<span class="stringliteral">"SELECT if_bo_com.numcom FROM if_bo_com WHERE etat $this->etat $fin_req ORDER BY hcrea DESC"</span>);
novoUsuario.php https://bitbucket.org/leopublic/dataweb.git | PHP | 242 lines
32 $sql = $sql." from USUARIO as a, PERFIL as b where a.NU_PERFIL = b.NU_PERFIL and a.NU_USUARIO = $id ";
33 $resultado = mysql_query($sql);
34 if(mysql_errno() != 0) {
index.php http://clients-oriented-ftp.googlecode.com/svn/trunk/ | PHP | 308 lines
20 foreach ($query as $i => $value) {
21 $result = mysql_query($query[$i]);
22 if (mysql_error()) {
conf.php https://gitlab.com/m.mirsamie/arad_hotel | PHP | 220 lines
104 if(!(mysql_select_db($db,$conn)==FALSE)){
105 mysql_query("SET NAMES 'utf8'");
106 $q = mysql_query($sql,$conn);
118 if(!(mysql_select_db($db,$conn)==FALSE)){
119 mysql_query("SET NAMES 'utf8'");
120 $qq = mysql_query($sql,$conn);
131 if(!(mysql_select_db($db,$conn)==FALSE)){
132 mysql_query("SET NAMES 'utf8'");
133 $qqq = mysql_query($sql,$conn);
MysqlAdapter.php https://github.com/andho/simdal.git | PHP | 301 lines
80
81 mysql_query($sql, $this->_conn);
82
126
127 $query = mysql_query($sql, $this->_conn) or error_log(mysql_error($this->_conn), 0);
128
145
146 $query = mysql_query($sql, $this->_conn) or error_log(mysql_error($this->_conn), 0);
147
164
165 if (!($query = mysql_query($sql, $this->_conn))) {
166 error_log(mysql_error($this->_conn), 0);
251
252 $result = mysql_query($sql, $this->_conn);
253
producers_pending.php https://gitlab.com/Henaway/CLFC | PHP | 199 lines
25 producer_id = "'.mysql_real_escape_string($producer_id).'"';
26 $sql = mysql_query($query, $connection) or die("Couldn't execute query 4.");
27 $producer_info = mysql_fetch_object($sql);
36 producer_id="'.mysql_real_escape_string($producer_id).'"';
37 $sql = mysql_query($query);
38
80 producer_id="'.mysql_real_escape_string($producer_id).'"';
81 mysql_query($query);
82
87 producer_id="'.mysql_real_escape_string($producer_id).'"';
88 mysql_query($query);
89
102 member_id="'.mysql_real_escape_string($producer_info->member_id).'"';
103 mysql_query($query);
104 }
subscribe.php https://gitlab.com/oded/kamailio | 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)
api.php https://gitlab.com/swimly/api | PHP | 76 lines
28function getLists($conn,$table,$size,$sort,$field){
29 mysql_query("SET NAMES 'UTF8'",$conn);
30 $page =isset($_GET['page'])?$_GET['page']:1; //获取查询页数，如果没有get到page，默认就是第一页！
33 $pageSize =$size; //每页多少条
34 $result_pag_num = mysql_query("SELECT COUNT(*) AS count FROM $table"); //获取数据表中总记录条数
35 $row = mysql_fetch_array($result_pag_num);
40 $query_pag_data = "SELECT $field from $table order by id $sort LIMIT $start, $pageSize";
41 $result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error());
42 $arrList = array(); //初始化列表数组
58 $info=array();
59 mysql_query("set names 'utf8'");
60 mysql_query("SET CHARACTER SET UTF8");
60 mysql_query("SET CHARACTER SET UTF8");
61 mysql_query("SET CHARACTER_SET_RESULTS=UTF8'");
62 $result=@mysql_query($sql) or die();
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);
cometchat_receive.php https://github.com/chacha13/runningmate.git | PHP | 274 lines
70 $sql = ("select id from cometchat order by id desc limit 1");
71 $query = mysql_query($sql);
72 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); }
102 $sql = updateLastActivity($userid);
103 $query = mysql_query($sql);
104 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); }
119 $sql = getUserStatus($userid);
120 $query = mysql_query($sql);
121 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); }
157 $sql = ("select id from cometchat order by id desc limit 1");
158 $query = mysql_query($sql);
159 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); }
181
182 $query = mysql_query($sql);
183 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); }
GuestBook.php https://bitbucket.org/onlinechessportal/onlinechessgameportal | PHP | 215 lines
76 $insert = "INSERT INTO guestBook VALUES ('','$time','$gb_name','$gb_email','$gb_message')";
77 if (mysql_query($insert)) {
78 $entries = mysql_query("SELECT `gb_timestamp`,gb_name,gb_email,gb_message FROM guestbook ORDER BY `gb_timestamp` DESC ");
google_map_functions.php https://github.com/wesleyzhao/wheremyfriendsbe.git | PHP | 307 lines
28 $formattedAddress = mysql_escape_string($formattedAddress);
29 //$res = mysql_query("SELECT `lat`,`lng` FROM `geocodes` WHERE `location`='$formattedAddress'");
30 $res = mysql_query_cache("SELECT `lat`,`lng` FROM `geocodes` WHERE `location`='$formattedAddress'");
55 $location = $jsondata['results'][0]['geometry']['location'];
56 mysql_query("INSERT INTO geocodes (location,lat,lng) VALUES('$formattedAddress','{$location['lat']}','{$location['lng']}')");
57 return $location;
225 $oauth_id = intval($oauth_id);
226 //$res = mysql_query("SELECT name FROM users WHERE oauth_id = '$oauth_id'");
227 $res = mysql_query_cache("SELECT name FROM users WHERE oauth_id = '$oauth_id'");
232 $location = mysql_escape_string($location);
233 mysql_query("INSERT INTO users (name,oauth_id,lat,lng,access_token,location) VALUES('$name','$oauth_id','$lat','$lng','$token','$location')");
234 return true;
239 $location = mysql_escape_string($location);
240 mysql_query("UPDATE users SET lat = '$lat', lng='$lng',location='$location' WHERE oauth_id='$oauth_id'");
241 return true;
index.php https://gitlab.com/zanzilan/bgpanel.git | PHP | 427 lines
47$unixLastMin = time() - 1 * 60;
48$onlineClients = mysql_query( "SELECT `clientid`, `username` FROM `".DBPREFIX."client` WHERE `lastactivity` >= '".$unixLastMin."'" ); //We select all clients active in the last minute (based on unix timestamp)
49$onlineAdmins = mysql_query( "SELECT `adminid`, `username` FROM `".DBPREFIX."admin` WHERE `lastactivity` >= '".$unixLastMin."'" ); //Same 4 admins
53//Servers :
54$servers = mysql_query( "SELECT * FROM `".DBPREFIX."server` WHERE `status` = 'Active' && `panelstatus` = 'Started' ORDER BY `name`" );
55
57//Boxes :
58$boxes = mysql_query( "SELECT `boxid`, `name`, `cache` FROM `".DBPREFIX."box` ORDER BY `name`" );
59$cron = query_fetch_assoc( "SELECT `value` FROM `".DBPREFIX."config` WHERE `setting` = 'lastcronrun' LIMIT 1" );
62//Last 15 Actions :
63$logs = mysql_query( "SELECT * FROM `".DBPREFIX."log` ORDER BY `logid` DESC LIMIT 15" );
64
projusers.php https://gitlab.com/JoshJ/AGORA | PHP | 231 lines
46 $query = "SELECT LAST_INSERT_ID()";
47 $resultID = mysql_query($query, $linkID);
48 $row = mysql_fetch_assoc($resultID);
81 $query = "INSERT INTO projusers (proj_id, user_id, user_level) VALUES ($projID, $otheruserID, $level)";
82 $success = mysql_query($query, $linkID);
83 if($success){
124 }
125 mysql_query("START TRANSACTION");
126 $query = "DELETE FROM projusers WHERE proj_id=$projID AND user_id=$otheruserID";
127
128 $success = mysql_query($query, $linkID);
129 if($success){
133 ($otheruserID, 'Automatically created project', NULL, 1)";
134 $status = mysql_query($query, $linkID);
135 $newID = getLastInsert($linkID);
themes.php http://novaboard.googlecode.com/svn/trunk/ | PHP | 487 lines
103
104mysql_query("UPDATE {$db_prefix}settings SET theme_order='$order', theme_limit='$limit', theme_method='$method'");
105
217
218mysql_query("DELETE FROM {$db_prefix}themes WHERE theme_name ='$theme_name'");
219
219
220mysql_query("INSERT INTO {$db_prefix}themes (theme_name, installed) VALUES ('$theme_name', '1')");
221
273
274mysql_query("DELETE FROM {$db_prefix}themes WHERE theme_name ='$theme_name'");
275
class.plugin.php https://bitbucket.org/icarito/pmc | PHP | 255 lines
28
29 $ins = mysql_query("INSERT INTO plugins (name,description) VALUES ('$name','$description')");
30 if ($ins)
57 $plugin = (int) $plugin;
58 $del = mysql_query("DELETE FROM plugins WHERE ID = $plugin");
59 $this->delAllPluginEvents($plugin);
79 $plugin = (int) $plugin;
80 $upd = mysql_query("UPDATE plugins SET state = 1 WHERE ID = $id");
81 }
91 $plugin = (int) $plugin;
92 $upd = mysql_query("UPDATE plugins SET state = 0 WHERE ID = $id");
93 }
104
105 $sel = mysql_query("SELECT ID FROM plugins WHERE name = '$pluginname'");
106 $chk = mysql_fetch_row($sel);
listCMS_ONLINE_RESOURCES.php https://github.com/juddy/GIP.git | PHP | 211 lines
39$sql = "SELECT * FROM CMS_ONLINE_RESOURCES".$orderByQuery.$limitQuery;
40$result = MYSQL_QUERY($sql);
41$numberOfRows = MYSQL_NUM_ROWS($result);
listGridCMS_GROUPUSERS.php https://github.com/juddy/GIP.git | PHP | 225 lines
15 $sqlUpdate = "UPDATE CMS_GROUPUSERS SET GROUP_ID = '$thisGROUP_ID' , USER_ID = '$thisUSER_ID' , GROUPUSER_FLAGS = '$thisGROUPUSER_FLAGS' WHERE GROUP_ID = '$thisGROUP_ID'";
16 $resultUpdate = MYSQL_QUERY($sqlUpdate);
17 echo "<b>Record with Id ".$thisGROUP_IDFromForm." has been Updated<br></b>";
28 $sqlInsert = "INSERT INTO CMS_GROUPUSERS (GROUP_ID , USER_ID , GROUPUSER_FLAGS ) VALUES ('$thisGROUP_ID' , '$thisUSER_ID' , '$thisGROUPUSER_FLAGS' )";
29 $resultInsert = MYSQL_QUERY($sqlInsert);
30 echo "<b>Record has been inserted in Database<br></b>";
41 $sqlDelete = "DELETE FROM CMS_GROUPUSERS WHERE GROUP_ID = '$thisGROUP_ID'";
42 $resultDelete = MYSQL_QUERY($sqlDelete);
43
81$sql = "SELECT * FROM CMS_GROUPUSERS".$orderByQuery.$limitQuery;
82$result = MYSQL_QUERY($sql);
83$numberOfRows = MYSQL_NUM_ROWS($result);
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);
diff.php http://timoseven.googlecode.com/svn/trunk/ | PHP | 419 lines
55 $sql="SELECT distinct ISP from iplist";
56 $result = mysql_query($sql);
57 if (isset($_POST['submit']) || isset($_POST['sort1']) ||isset($_POST['sort2'])) {
60 $sql1 = "SELECT distinct ISP from iplist where ISP <> '$subisp'";
61 $result1 = mysql_query($sql1);
62 while($record = mysql_fetch_array($result1)) {
81 $sql="SELECT distinct province from iplist order by province";
82 $result = mysql_query($sql);
83 while($record = mysql_fetch_array($result)) {
105 $sql="select distinct bestregion from stat order by bestregion";
106 $result = mysql_query($sql);
107 if (isset($_POST['submit']) || isset($_POST['sort1']) ||isset($_POST['sort2'])) {
110 $sql1="select distinct bestregion from stat where bestregion <> '$subtest1' order by bestregion";
111 $result1 = mysql_query($sql1);
112 while($record = mysql_fetch_array($result1)) {
producer_orders_byproduct.php https://gitlab.com/Henaway/CLFC | PHP | 332 lines
53 business_name ASC';
54$resultp = @mysql_query($sqlp, $connection) or die(mysql_error() . "<br><b>Error No: </b>" . mysql_errno());
55while ( $row = mysql_fetch_array($resultp) )
96
97$rs = @mysql_query($sql, $connection) or die(mysql_error() . "<br><b>Error No: </b>" . mysql_errno());
98while ( $row = mysql_fetch_array($rs) )
137 '.TABLE_BASKET.'.item_date';
138 $resultpr = @mysql_query($sql, $connection) or die(mysql_error() . "<br><b>Error No: </b>" . mysql_errno());
139 while ( $row = mysql_fetch_array($resultpr) )
orders_list.php https://gitlab.com/Henaway/CLFC | PHP | 211 lines
20 AND member_id = "'.mysql_real_escape_string ($member_id).'"';
21 $resultf = @mysql_query($sqlf, $connection) or die(mysql_error());
22 }
48 '.TABLE_BASKET_ALL.'.basket_id DESC';
49$rs = @mysql_query($sql, $connection) or die(mysql_error());
50$num_orders = mysql_numrows($rs);
126 '.TABLE_BASKET_ALL.'.basket_id DESC';
127$rsf = @mysql_query($sqlfd, $connection) or die(mysql_error());
128while ( $row = mysql_fetch_array($rsf) )
installer_lib.php https://gitlab.com/rameshgurung/emi | PHP | 301 lines
165 {
166 mysql_query('CREATE DATABASE IF NOT EXISTS '.$database, $this->db);
167 }
185
186 mysql_query(sprintf(
187 "INSERT INTO core_sites (name, ref, domain, created_on) VALUES ('Default Site', '%s', '%s', '%s');",
229
230 @mysql_query($query, $this->db);
231
func.get_product.php https://gitlab.com/Henaway/CLFC | PHP | 159 lines
68 AND '.NEW_TABLE_PRODUCTS.'.pvid != "0")';
69 $result = mysql_query($query, $connection) or die(debug_print ("ERROR: 754004 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
70 if ($row = mysql_fetch_array($result))
93 '.NEW_TABLE_PRODUCTS;
94 $result = mysql_query($query, $connection) or die (debug_print ("ERROR: 856249 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
95 if ($row = mysql_fetch_array($result))
107 producer_id = "'.mysql_real_escape_string($producer_id).'"';
108 $result = mysql_query($query, $connection) or die (debug_print ("ERROR: 460569 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
109 $pvid = mysql_insert_id();
120 product_id = "'.mysql_real_escape_string($product_id).'"';
121 $result = mysql_query($query, $connection) or die (debug_print ("ERROR: 311047 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
122 if ($row = mysql_fetch_array($result))
138 pvid = "'.mysql_real_escape_string($pvid).'"';
139 $result = mysql_query($query, $connection) or die (debug_print ("ERROR: 939523 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
140 // And sync our external product_id variable
db_printview.php https://gitlab.com/a.loskutnikov/sitimobile | PHP | 264 lines
29 $local_query = 'SHOW OPEN TABLES FROM ' . PMA_backquote($db);
30 $result = mysql_query($query) or PMA_mysqlDie('', $local_query, '', $err_url);
31 // Blending out tables in use
42 $local_query = 'SHOW TABLES FROM ' . PMA_backquote($db);
43 $result = mysql_query($query) or PMA_mysqlDie('', $local_query, '', $err_url);
44 if ($result != FALSE && mysql_num_rows($result) > 0) {
47 $local_query = 'SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ' LIKE \'' . addslashes($tmp[0]) . '\'';
48 $sts_result = mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url);
49 $sts_tmp = mysql_fetch_array($sts_result);
62 $local_query = 'SHOW TABLE STATUS FROM ' . PMA_backquote($db);
63 $result = mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url);
64 if ($result != FALSE && mysql_num_rows($result) > 0) {
buscar_producto.php https://code.google.com/p/zapatillas-4-dsw1/ | PHP | 269 lines
35$query_Color = "SELECT * FROM Color";
36$Color = mysql_query($query_Color, $db_zapatos) or die(mysql_error());
37$row_Color = mysql_fetch_assoc($Color);
40$query_Talla = "SELECT * FROM Talla";
41$Talla = mysql_query($query_Talla, $db_zapatos) or die(mysql_error());
42$row_Talla = mysql_fetch_assoc($Talla);
45$query_Modelo = "SELECT mod_id, mod_descripcion FROM Modelo";
46$Modelo = mysql_query($query_Modelo, $db_zapatos) or die(mysql_error());
47$row_Modelo = mysql_fetch_assoc($Modelo);
50$query_PerfilCliente = "SELECT perfc_id, perfc_descripcion FROM Perfil_Cliente";
51$PerfilCliente = mysql_query($query_PerfilCliente, $db_zapatos) or die(mysql_error());
52$row_PerfilCliente = mysql_fetch_assoc($PerfilCliente);
55$query_Tipo = "SELECT * FROM Tipo";
56$Tipo = mysql_query($query_Tipo, $db_zapatos) or die(mysql_error());
57$row_Tipo = mysql_fetch_assoc($Tipo);
payment_info.php https://github.com/azeckoski/az-php-sandbox.git | PHP | 394 lines
39 $sql = "update conferences set activated='Y' where id='".$_REQUEST['activate']."'";
40 $result = mysql_query($sql) or die("Update query failed ($sql): " . mysql_error());
41 } else if ($_REQUEST['deactivate']) {
42 $sql = "update conferences set activated='N' where id='".$_REQUEST['deactivate']."'";
43 $result = mysql_query($sql) or die("Update query failed ($sql): " . mysql_error());
44 }
79$count_sql = "select count(*) " . $from_sql . $sqlsearch;
80$result = mysql_query($count_sql) or die('Count query failed: ' . mysql_error());
81$row = mysql_fetch_array($result);
126//print "SQL=$sql<br/>";
127$result = mysql_query($sql) or die("Fetch query failed ($sql): " . mysql_error());
128$items_displayed = mysql_num_rows($result);
243 $count_sql = "SELECT count(*) FROM conferences where activated = 'Y' and confId = '$CONF_ID'";
244 $count_result = mysql_query($count_sql) or die("Count failed ($count_sql): " . mysql_error());
245 $row = mysql_fetch_array($count_result);
reporte_genera_reporte.php https://bitbucket.org/redesvas/rceldas.git | PHP | 357 lines
53 $sql="SELECT * FROM ".$_db.".PROCESOS_STATUS WHERE PROCESO='GENERA_REPORTE' ";
54 $res = mysql_query($sql, $_link);
55
67 $sql="SELECT * FROM ".$_db.".PROCESOS_STATUS_DETALLE WHERE ID_PROCESO = 6 ";
68 $result = mysql_query($sql, $_link);
69
79 $sql_st="UPDATE ".$_db.".PROCESOS_STATUS SET STATUS = 'RUNNING' , OBS='' WHERE PROCESO='GENERA_REPORTE' ";
80 mysql_query($sql_st, $_link);
81 }
85 $sql_st="UPDATE ".$_db.".PROCESOS_STATUS SET STATUS = 'RUNNING' , OBS='' WHERE PROCESO='GENERA_REPORTE' ";
86 mysql_query($sql_st, $_link);
87 }
91 $sql_st="UPDATE ".$_db.".PROCESOS_STATUS SET STATUS = 'RUNNING' , OBS='' WHERE PROCESO='GENERA_REPORTE' ";
92 mysql_query($sql_st, $_link);
93 }
query_notes.php https://gitlab.com/Henaway/CLFC | PHP | 269 lines
26 last_name ASC';
27$resultm = @mysql_query($sqlm, $connection) or die("Couldn't execute query -m.");
28while ( $row = mysql_fetch_array($resultm) )
68 business_name ASC';
69 $result = @mysql_query($sql, $connection) or die("Couldn't execute query 1.");
70 while ( $row = mysql_fetch_array($result) )
204 AND '.TABLE_FUTURE_DELIVERY.'.future_delivery_id = '.TABLE_BASKET.'.future_delivery_id';
205 $rs = @mysql_query($sqlfd, $connection) or die("Couldn't execute query.");
206 while ( $row = mysql_fetch_array($rs) )
pn4.php https://gitlab.com/bulwye/reliquerunt | PHP | 243 lines
25// Poll Check table creation
26$result = mysql_query("CREATE TABLE poll_check (
27ip VARCHAR (20) NOT NULL,
30
31$result = mysql_query("CREATE TABLE blocks (
32bid INT (10) DEFAULT '0' not null AUTO_INCREMENT,
44// Main Block data migration
45$result = mysql_query("SELECT title, content FROM mainblock");
46list($title, $content) = mysql_fetch_row($result);
46list($title, $content) = mysql_fetch_row($result);
47$result = mysql_query("INSERT INTO blocks VALUES (NULL, 'main', '$title', '$content', '', 'l', '1', '1', '', '')");
48// Block data creation
48// Block data creation
49$result = mysql_query("INSERT INTO blocks VALUES (NULL, 'online', 'Who\'s Online', '', '', 'l', '2', '1', '', '')");
50// Admin Block data migration
MySQL.class.php https://gitlab.com/Elron_MacBong/ecms | PHP | 229 lines
102
103 // Execute query. (mysql_query)
104 # @param string $sql
110 $this->query_counter++;
111 $this->result = @mysql_query($this->sql_query, $this->connection);
112
main.php https://github.com/AtvirasAlus/Atviras-Alus.git | PHP | 408 lines
57 $db = mysql_select_db($conf['auth']['mysql']['database']);
58 $result = mysql_query("SET NAMES UTF8");
59 $sql = "SELECT * FROM beer_patarles ORDER BY RAND() LIMIT 1";
59 $sql = "SELECT * FROM beer_patarles ORDER BY RAND() LIMIT 1";
60 $result = mysql_query($sql) or die(mysql_error());
61 $row = mysql_fetch_assoc($result);
69 $sql = "SELECT * FROM users WHERE user_email = '".$umail."'";
70 $result = mysql_query($sql) or die(mysql_error());
71 $uid = mysql_fetch_assoc($result);
73 $sql = "SELECT * FROM mail_users WHERE user_id='".$uid."' AND mail_read='0'";
74 $result = mysql_query($sql) or die(mysql_error());
75 $msgs = mysql_num_rows($result);
wizard.2.php https://github.com/zsalwen/Service-Interface.git | PHP | 143 lines
38 $qs="SELECT * FROM ps_users WHERE id='".$_COOKIE[psdata][user_id]."'";
39 $rs=@mysql_query($qs) or die(mysql_error());
40 $ds=mysql_fetch_array($rs,MYSQL_ASSOC);
115 if ($defendant == "ALL"){
116 $history_items = @mysql_query("select * from ps_history where packet_id='$packet'") or die(mysql_error());
117 }else{
117 }else{
118 $history_items = @mysql_query("select * from ps_history where packet_id='$packet' and defendant_id='$defendant'") or die(mysql_error());
119 }
121 if ($defendant == "ALL"){
122 $history_items = @mysql_query("select * from ps_history where packet_id='$packet' and serverID='".$_COOKIE[psdata][user_id]."'") or die(mysql_error());
123 }else{
123 }else{
124 $history_items = @mysql_query("select * from ps_history where packet_id='$packet' and defendant_id='$defendant' and serverID='".$_COOKIE[psdata][user_id]."'") or die(mysql_error());
125 }
database.php https://bitbucket.org/sspssp/akk-berlin.git | PHP | 578 lines
102
103 $out=mysql_query( $query , $this->db ) or die('something went wrong');
104
126
127 mysql_query( $query , $this->db ) or die('somethnig went wrong');
128
143
144 mysql_query( $query , $this->db ) or die('somethnig went wrong');
145
163
164 mysql_query( $query , $this->db ) or die('somethnig went wrong');
165
185
186 mysql_query( $query , $this->db ) or die('somethnig went wrong');
187
inc.openup.php http://dj-r-old-admin.googlecode.com/svn/trunk/ | PHP | 251 lines
39
40 $res_openup=mysql_query($sql_openup,$db);
41 while($ligne_openup=mysql_fetch_object($res_openup))
113 ORDER BY date_out DESC, etat_num";
114 $res_events=mysql_query($sql_events,$db);
115 $total_loc_out=0;
resource_m3_modi.php https://gitlab.com/cigiko/brdnc.cafe24.com | PHP | 166 lines
57 $query="SELECT no, user_id, name, email, mobile, pj_seq, pj_where, pj_posi, pj_name FROM cms_member_table, cms_project1_info WHERE no='$edit_code' ";
58 $result=mysql_query($query, $connect);
59 $row=mysql_fetch_array($result);
84 $h_qry = "SELECT seq, pj_name FROM cms_project1_info WHERE is_end<>'1' ORDER BY seq ";
85 $h_rlt = mysql_query($h_qry, $connect);
86 while($h_rows = mysql_fetch_array($h_rlt)){
99 $h_qry = "SELECT seq, headq FROM cms_resource_headq WHERE pj_seq='$pj' ORDER BY headq ";
100 $h_rlt = mysql_query($h_qry, $connect);
101 while($h_rows = mysql_fetch_array($h_rlt)){
121 $t_qry = "SELECT seq, team FROM cms_resource_team WHERE pj_seq='$pj' AND headq_seq='$headq' ORDER BY team ";
122 $t_rlt = mysql_query($t_qry, $connect);
123 while($t_rows = mysql_fetch_array($t_rlt)){
room_edit.php https://bitbucket.org/deba666/accitsoftware.git | PHP | 144 lines
3 {
4 if(mysql_query("UPDATE `room` SET `ROOM_CODE`='".$_POST['room_code']."', `ROOM_DESC`='".$_POST['room_name']."', `ROOM_CAPACITY`='".$_POST['capacity']."', `LOCATION_NO`='".$_POST['location']."', `STATUS`='".$_POST['is_active']."' WHERE `ROOM_NO`=".$_GET['rid']))
5 $_SESSION['s_msg']="<strong>Well done!</strong> room successfully updated";
rezervare_sejur_succes.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 269 lines
47$sel_bnr="SELECT * FROM curs_valutar ";
48$que_bnr=mysql_query($sel_bnr) or die(mysql_error());
49$row_bnr=mysql_fetch_array($que_bnr);
base3.php https://github.com/crocus/virpl.git | PHP | 224 lines
165$num=0;
166$Recordset3 = @mysql_query($GenerQuery , $realtorplus) or die(mysql_error());
167$row_Recordset3 = mysql_fetch_assoc($Recordset3);
MySQLStorage.php https://bitbucket.org/maconeto/proman.git | PHP | 354 lines
144 {
145 if (!mysql_query(
146 "CREATE DATABASE IF NOT EXISTS `{$this->dbName}`",
154
155 $create = mysql_query(
156 "CREATE TABLE IF NOT EXISTS `{$this->dbName}`.`{$this->dbTable}` (
251 $this->connect();
252 $result = mysql_query(
253 "SELECT * FROM `{$this->dbName}`.`{$this->dbTable}`",
285 //Remove the pclass if it exists.
286 mysql_query(
287 "DELETE FROM `{$this->dbName}`.`{$this->dbTable}`
292 //Insert it again.
293 $result = mysql_query(
294 "INSERT INTO `{$this->dbName}`.`{$this->dbTable}`