100+ results for 'php mysql_query'
Not the results you expected?
mgmtUser.php (https://github.com/andyjdbest/Tennis-Masters---PBBG.git) PHP · 233 lines
1 <?php
2 #include the common file
3 require_once 'common.php';
5 require_once("../DBconfig.php");
7 function updateuserid()
8 {
9 $query="SELECT userid FROM users WHERE 1";
10 $result = mysql_query($query);
12 //global $useriddata;
20 function showDormantUsers() {
21 $query = "SELECT DISTINCT userid,username FROM users WHERE isAdmin = 0 AND isAssigned = 1 AND isMember = 0 AND userid NOT IN (SELECT iduser FROM logins WHERE DATEDIFF(CURDATE(), time) < 30)";
22 $result = mysql_query($query);
23 global $dormantData;
24 while ($row = mysql_fetch_object($result)) {
carrier_menu.php (https://github.com/inspectorfegter/WP-SMS.git) PHP · 326 lines
1 <?php
3 if(isset($_GET['edit']))
24 <div class=wrap>
25 <h2>EasySMS Carriers</h2>
26 <p class='easysms_text'><a href="admin.php?page=easySMS_carriers&add=true">Add A Carrier</a></p>
27 <br />
28 <table class="widefat">
45 {
46 $sql = "SELECT * FROM easysms WHERE carrierEmail = '".$results->ID."'";
47 $result1 = mysql_query($sql);
48 $num_rows = mysql_num_rows($result1);
49 if($num_rows == 0){$num_rows = 'None';}
53 <td><? echo $results->carrierEmail ?></td>
54 <td><? echo $num_rows ?></td>
55 <td><a href="admin.php?page=easySMS_carriers&edit=<? echo $results->ID ?>">Edit</a></td>
56 <td><a href="admin.php?page=easySMS_carriers&delete=<? echo $results->ID ?>">Delete</a></td>
log-2016-01-20.php (https://gitlab.com/fcupen/PHP) PHP · 44 lines
21 ERROR - 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
22 ERROR - 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
23 ERROR - 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
35 ERROR - 2016-01-20 12:43:59 --> 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
36 ERROR - 2016-01-20 12:43:59 --> 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
37 ERROR - 2016-01-20 12:43:59 --> 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
38 ERROR - 2016-01-20 12:50:24 --> 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
39 ERROR - 2016-01-20 12:50:24 --> 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
40 ERROR - 2016-01-20 12:50:24 --> 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
41 ERROR - 2016-01-20 12:50:24 --> 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
42 ERROR - 2016-01-20 12:50:47 --> 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
43 ERROR - 2016-01-20 12:50:47 --> 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
44 ERROR - 2016-01-20 12:50:47 --> 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
edit.php (https://github.com/heidymadia/sfbackup.git) PHP · 54 lines
1 <?php
2 include('config.php');
6 foreach($_POST AS $key => $value) { $_POST[$key] = mysql_real_escape_string($value); }
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' ";
8 mysql_query($sql) or die(mysql_error());
9 echo (mysql_affected_rows()) ? "Edited row.<br />" : "Nothing changed. <br />";
10 echo "<a href='list.php'>Back To Listing</a>";
11 }
12 $row = mysql_fetch_array ( mysql_query("SELECT * FROM `opportunities` WHERE `id` = '$id' "));
13 ?>
counters.php (https://gitlab.com/phamngsinh/baitaplon_sinhvien) PHP · 203 lines
1 <?php
2 /**
3 * @package JohnCMS
22 global $website;
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);
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>' : '');
37 global $website;
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);
53 global $website;
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);
halloffame.php (https://github.com/breakthenet/HackMe-SQL-Injection-Challenges.git) PHP · 334 lines
12 $h = new headers;
13 $h->startheaders();
14 include "mysql.php";
15 global $c;
16 $is =
29 <table width=75%> <tr> <td><a href='halloffame.php?action=level'>LEVEL</a></td> <td><a href='halloffame.php?action=money'>MONEY</a></td> <td><a href='halloffame.php?action=crystals'>CRYSTALS</a></td> <td><a href='halloffame.php?action=total'>TOTAL STATS</a></td> </tr>
30 <tr> <td><a href='halloffame.php?action=strength'>STRENGTH</a></td> <td><a href='halloffame.php?action=agility'>AGILITY</a></td> <td><a href='halloffame.php?action=guard'>GUARD</a></td> <td><a href='halloffame.php?action=labour'>LABOUR</a></td> <td><a href='halloffame.php?action=iq'>IQ</a></td> </tr> </table>";
31 switch ($_GET['action'])
32 {
67 <table width=75%><tr style='background:gray'> <th>Pos</th> <th>User</th> <th>Level</th> </tr>";
68 $q =
69 mysql_query(
70 "SELECT u.* FROM users u WHERE u.user_level != 0 ORDER BY level DESC,userid ASC LIMIT 20",
71 $c);
97 <table width=75%><tr style='background:gray'> <th>Pos</th> <th>User</th> <th>Money</th> </tr>";
98 $q =
99 mysql_query(
100 "SELECT u.* FROM users u WHERE u.user_level != 0 ORDER BY money DESC,userid ASC LIMIT 20",
101 $c);
listCMS_ONLINE_RESOURCES.php (https://github.com/juddy/GIP.git) PHP · 211 lines
1 <?php
2 include_once("../common/dbConnection.php");
3 include_once("../common/header.php");
4 ?>
5 <?
39 $sql = "SELECT * FROM CMS_ONLINE_RESOURCES".$orderByQuery.$limitQuery;
40 $result = MYSQL_QUERY($sql);
41 $numberOfRows = MYSQL_NUM_ROWS($result);
63 ?>
65 <a href="<? echo $_SERVER['PHP_SELF']; ?>?startLimit=<? echo $previousStartLimit; ?>&limitPerPage=<? echo $limitPerPage; ?>&sortBy=<? echo $sortBy; ?>&sortOrder=<? echo $sortOrder; ?>">Previous <? echo $limitPerPage; ?> Results</a>....
66 <? } ?>
67 <?
listGridCMS_GROUPUSERS.php (https://github.com/juddy/GIP.git) PHP · 225 lines
1 <?php
2 include_once("../common/dbConnection.php");
3 include_once("../common/header.php");
4 ?>
5 <?
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>";
18 $thisGROUP_IDFromForm = "";
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>";
31 $thisGROUP_IDFromForm = "";
listCMS_OFFLINE_RESOURCES.php (https://github.com/juddy/GIP.git) PHP · 211 lines
1 <?php
2 include_once("../common/dbConnection.php");
3 include_once("../common/header.php");
4 ?>
5 <?
39 $sql = "SELECT * FROM CMS_OFFLINE_RESOURCES".$orderByQuery.$limitQuery;
40 $result = MYSQL_QUERY($sql);
41 $numberOfRows = MYSQL_NUM_ROWS($result);
63 ?>
65 <a href="<? echo $_SERVER['PHP_SELF']; ?>?startLimit=<? echo $previousStartLimit; ?>&limitPerPage=<? echo $limitPerPage; ?>&sortBy=<? echo $sortBy; ?>&sortOrder=<? echo $sortOrder; ?>">Previous <? echo $limitPerPage; ?> Results</a>....
66 <? } ?>
67 <?
upload.php (https://gitlab.com/vado/scadi) PHP · 320 lines
1 <?php
3 function recepcioImatgeProducte($db,$idProducte)
132 //guardar path imatge a bbdd
133 //echo "<br>update ".$mPars['taulaProductes']." set imatge='".$nomImatge."' where id='".$idProducte."' AND llista_id='".$mPars['selLlistaId']."'";
134 if(!$result=mysql_query("update ".$mPars['taulaProductes']." set imatge='".$nomImatge."' where id='".$idProducte."' AND llista_id='".$mPars['selLlistaId']."'",$db))
135 {
136 //echo "<br> 136 upload.php ".mysql_errno() . ": " . mysql_error(). "\n";
266 //guardar path imatge a bbdd
267 if(!$result=mysql_query("update vehicles set imatge='".$nomImatge."' where id='".$idVehicle."'",$db))
268 {
269 //echo "<br> 77. upload.php ".mysql_errno() . ": " . mysql_error(). "\n";
admin_editToDB.php (https://github.com/loboda/cs411.git) PHP · 301 lines
1 <?php
2 include 'includes/mysqlAdminLoginAssignment.php';
24 $query = "UPDATE assignment SET AssnName='$assnName', GroupWork='$groupWork', MaxMark='$maxMark', AvgMark='$avgMark', MedianMark='$medianMark', CourseID='$courseID', DueTime=FROM_UNIXTIME('$dueTime') WHERE AssnID='$assnID'";
26 if (!mysql_query($query, $mysqlConnection))
27 {
28 die ('Error: ' . mysql_error());
33 <script src="admin_functions.js"></script>
34 <meta http-equiv="refresh" content="0;url=admin.html?displayTable=1">
35 <?php
36 }
46 $query = "UPDATE automarking SET SampleSoln='$sampleSoln', Configs='$configs', AssnID='$assnID' WHERE AutomarkID='$automarkID'";
48 if (!mysql_query($query, $mysqlConnection))
49 {
50 die ('Error: ' . mysql_error());
Abstract.php (https://github.com/hettema/Stages.git) PHP · 325 lines
1 <?php
2 /**
3 * class Core_Model_Resource_Abstract
34 /**
35 * @var Mysql_Query
36 */
37 protected $_query;
313 /**
314 *
315 * @return Main_Mysql_Query object
316 */
317 public function _getQuery()
318 {
319 if(!$this->_query) {
320 $this->_query = new Main_Mysql_Query();
321 }
322 return $this->_query;
printprod_new.php (https://gitlab.com/Henaway/CLFC) PHP · 201 lines
1 <?php
2 include_once ("config_foodcoop.php");
3 include_once ("general_functions.php");
4 session_start();
5 valid_auth('producer_admin,site_admin');
33 sort_order ASC,
34 subcategory_name ASC';
35 $rs = @mysql_query($sql, $connection) or die("Couldn't execute category query: ".mysql_error());
36 while ( $row = mysql_fetch_array($rs) )
37 {
97 ORDER BY
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) )
101 {
data_access.php (https://github.com/jroglesby/Test-Reservation-System.git) PHP · 322 lines
1 <?php
2 $localhost = "localhost:3306";
3 $dbusername = "testres";
10 {
11 $_SESSION['message'] = "Please sign in.";
12 header( 'Location: http://troyprog.dyndns.tv/~testres/testres.php' ) ;
13 }
25 mysql_select_db($dbname, $con);
27 mysql_query("UPDATE user set password='$newpassword' where fsuid='$fsuid'");
28 }
38 mysql_select_db($dbname, $con);
40 $result = mysql_query("SELECT * from user WHERE fsuid='$username' AND password='$password'");
41 $arr=array();
42 while($row = mysql_fetch_array($result))
ebpls_bus_indtaxdelinquent.html
(http://ebpls.googlecode.com/svn/trunk/)
HTML · 199 lines
✨ Summary
This HTML code generates a report for a business enterprise, displaying information such as tax due, penalty, and amount due. It also shows inspection details, including who inspected and noted by, and approval status. The report includes tables, forms, and text elements to display this data in a structured format.
This HTML code generates a report for a business enterprise, displaying information such as tax due, penalty, and amount due. It also shows inspection details, including who inspected and noted by, and approval status. The report includes tables, forms, and text elements to display this data in a structured format.
3 require_once("lib/ebpls.utils.php");
4 require_once("ebpls-php-lib/utils/ebpls.search.funcs.php");
5 //require_once("includes/eBPLS_header.php");
126 // unang gawang tama
127 $result=mysql_query("select ' ', ' ', ' ' , ' ', ' '
128 from ebpls_business_enterprise") or die(mysql_error());
129 while ($resulta=mysql_fetch_row($result)){
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,
134 b.input_date from ebpls_business_enterprise a, ebpls_fees_paid b where a.owner_id = b.owner_id and
182 </tr>
183 <tr>
184 <td align="center"><b><u> <?php echo $resulta[0]; ?> </b></u> <br> <?php echo $resulta[2]; ?> <br> <br> <br> <br> <br> </td>
185 </tr>
186 <tr>
postdata.php (https://github.com/camlegleiter/Project-CyCal.git) PHP · 304 lines
1 <?php
2 /*
3 =====================================
7 if (!isset($TO_ROOT))
8 $TO_ROOT = "../";
9 require $TO_ROOT."includes/membersOnly.php";
10 require $TO_ROOT."includes/simple_html_dom.php";
150 $errorvalue = urlencode($value);
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();
154 if($rows != -1){
170 {
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'");
class.eyemysqladap.inc.php (https://github.com/kevinroberts/snippetz.git) PHP · 438 lines
database.php (https://github.com/aaraashkhan/echoback.git) PHP · 364 lines
1 <?php
2 /**
3 DataBase Module which is
43 // $SQL = "SELECT * FROM $table_name WHERE $clause";
44 // //echo $SQL;die();
45 // $result = mysql_query($SQL);
46 // mysql_close($db_handle);
69 // $SQL = "SELECT * FROM $table_name WHERE $clause";
70 //echo $SQL;die();
71 // $result = mysql_query($SQL);
72 // mysql_close($db_handle);
95 // $SQL = "SELECT * FROM $table_name WHERE $clause ORDER BY $order";
96 // echo $SQL;die();
97 // $result = mysql_query($SQL);
98 // mysql_close($db_handle);
usuarios.php (https://gitlab.com/phpdelivery/phpdelivery.git) PHP · 159 lines
1 <?php
2 session_start();
3 ?>
11 </head>
12 <body>
13 <?php
14 // archivo de configuracion
15 require('config.inc.php');
19 if($_SESSION["adminlogueado"]){
20 echo '<a href="controles/cerrarsesion.php" class="cerrar">Cerrar Sesi�n</a>';
21 }else{
22 header('location:pantallalogueo.php');
28 <p class="title">Seleccione la categoria que desea editar:</p>
30 <form name="menu" action="'.$PHP_SELF.'" method="post" class="opciones">
32 <input type="submit" name="ar" value="Alta Usuario">
inc.user_agents.php (https://bitbucket.org/pombredanne/spip-zone-treemap.git) PHP · 157 lines
1 <?php
2 if(!empty($annee) && !empty($mois) && !empty($jour)) { $format_date_sql = "date='$annee-$mois-$jour'";}
3 if(!empty($annee) && !empty($mois) && empty($jour)) { $format_date_sql = "'$annee-$mois-01' <= date AND date <= '$annee-$mois-31'";}
14 $req_nav = "SELECT COUNT(logiciel) AS user_agent_total FROM ".lire_config("spongespip/prefixe")."_statistiques WHERE $format_date_sql and logiciel!='';";
15 $nb_nav_total = @mysql_result(mysql_query($req_nav),0,"user_agent_total");
17 $req_browser = @mysql_query("SELECT logiciel,COUNT(logiciel) AS nbref FROM ".lire_config("spongespip/prefixe")."_statistiques WHERE $format_date_sql AND type_logiciel!=2 GROUP BY logiciel ORDER BY nbref DESC;");
40 if($logiciel != 'unknown' || $logiciel != 'safari')
41 {
42 $req_browser_version = @mysql_query("SELECT version,COUNT(version) AS nbref FROM ".lire_config("spongespip/prefixe")."_statistiques WHERE $format_date_sql AND type_logiciel != '2' AND logiciel='$logiciel' AND version != '0' GROUP BY version ORDER BY nbref DESC;");
44 $ivers = 0;
95 $req_browser = mysql_query("SELECT logiciel,COUNT(logiciel) AS nbref FROM ".lire_config("spongespip/prefixe")."_statistiques WHERE $format_date_sql AND type_logiciel=2 GROUP BY logiciel ORDER BY nbref DESC;");
student_2.php (https://bitbucket.org/deba666/accitsoftware.git) PHP · 93 lines
1 <?php
2 /*
3 * @package ACCIT
53 </thead>
54 <tbody>
55 <?php $std_row="select * from student ORDER BY STUD_NO DESC";
56 $q=mysql_query($std_row);
63 <td class=" "><?=$row['FNAME'];?> <?=$row['MNAME'];?> <?=$row['LNAME'];?></td>
64 <td class=" "><?=$row['GENDER'];?></td>
65 <?php
66 $originalDate5 = $row['DOB'];
67 $newDate5 = date("d/m/y", strtotime($originalDate5)); ?>
69 <td class=" "><?=$row['L_MOBILE'];?></td>
70 <td class=" "><a href="mailto: <?=$row['L_EMAIL'];?>" ><?=$row['L_EMAIL'];?></a></td>
71 <td class="last"><a href="dashboard.php?op=<?=MD5('offer')?>&stu_no=<?=$row['EXT_STN']?>&sname=<?php echo $name;?>&cust_no=<?=$row['CUSTOMER_NO']?>&cun_no=<?=$row['COUNTRY_NO']?>">Add Offer</a>
72 </td>
73 </tr>
all_hotels.php (https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git) PHP · 143 lines
1 <?php
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);
14 foreach($hotels['denumire'] as $key => $value) {
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);
18 if(mysql_num_rows($que_loc)<1) {
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);
26 @mysql_free_result($que_oras);
DBMysql.php (https://github.com/sergiygladkyy/OEF.git) PHP · 495 lines
1 <?php
3 import('lib/db/DBManager');
114 }
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");
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");
160 /**
161 * (non-PHPdoc)
162 * @see lib/db/mDBManager#fetchRow($res)
163 */
RecordModule.class.php (https://bitbucket.org/rkandpal/nustechgmgitfork.git) PHP · 346 lines
1 <?php
3 class MK_RecordModule extends MK_Record{
26 $config = MK_Config::getInstance();
28 $get_module = mysql_query("SELECT * FROM `modules` WHERE `id` = '".mysql_real_escape_string($this->getId(), $config->db->con)."'", $config->db->con);
29 $this->meta = mysql_fetch_assoc($get_module);
30 mysql_free_result($get_module);
37 }
39 $get_fields = mysql_query("SELECT * FROM `modules_fields` WHERE `module_id` = '".mysql_real_escape_string($this->getId(), $config->db->con)."' ORDER BY `order` ASC", $config->db->con);
40 while($res_fields = mysql_fetch_assoc($get_fields)){
41 $this->fields[$res_fields['name']] = $res_fields['id'];
62 }
64 $get_records = mysql_query("SELECT * FROM `".$this->getTable()."`".(count($sql_where) > 0 ? " WHERE ".implode(" AND ", $sql_where) : '').(count($sql_orderby) > 0 ? " ORDER BY ".implode(", ", $sql_orderby) : ''), $config->db->con);
66 if(mysql_num_rows($get_records) > 0){
users.php (https://github.com/wangaiying/elgg4ysu.git) PHP · 234 lines
1 <?php
2 /**
3 * Elgg Test ElggUser
171 $q = "SELECT admin FROM {$CONFIG->dbprefix}users_entity WHERE guid = $guid";
172 $r = mysql_query($q);
174 $admin = mysql_fetch_assoc($r);
188 $q = "SELECT admin FROM {$CONFIG->dbprefix}users_entity WHERE guid = $guid";
189 $r = mysql_query($q);
191 $admin = mysql_fetch_assoc($r);
extprofile_mysql.h (https://github.com/babannasd/hiphop-php.git) C Header · 321 lines
1 /*
2 +----------------------------------------------------------------------+
3 | HipHop for PHP |
4 +----------------------------------------------------------------------+
5 | Copyright (c) 2010- Facebook, Inc. (http://www.facebook.com) |
6 | Copyright (c) 1997-2010 The PHP Group |
7 +----------------------------------------------------------------------+
8 | This source file is subject to version 3.01 of the PHP license, |
9 | that is bundled with this package in the file LICENSE, and is |
10 | available through the world-wide-web at the following url: |
11 | http://www.php.net/license/3_01.txt |
12 | If you did not receive a copy of the PHP license and are unable to |
13 | obtain it through the world-wide-web, please send a note to |
14 | license@php.net so we can mail you a copy immediately. |
15 +----------------------------------------------------------------------+
16 */
index.php (https://github.com/MrMEEE/dommerbord.git) PHP · 142 lines
1 <?php
3 if(!file_exists("connect.php")){
4 ob_start();
5 header( "Location: setup.php" );
6 ob_flush();
7 }
9 require("config.php");
10 require("connect.php");
12 $config=mysql_fetch_assoc(mysql_query("SELECT * FROM config WHERE id = '1'"));
14 if (($config['klubadresse']=="") || ($config['klubpath']=="") || ($config['klubnavn']=="")){
trainingNaiveBayes.php (https://bitbucket.org/astahiam/penduduk.git) PHP · 300 lines
1 <?php
2 include('header.php');
3 include('menukiri.php');
4 //Open database connection
5 $con = mysql_connect("localhost","root","");
14 <header><h3>Proses Training Data Naive Bayes</h3></header>
15 <div class="module_content">
16 <form action="trainingDataNaiveBayes.php" method="post"
17 enctype="multipart/form-data">
25 <header><h3>DATA Penduduk</h3></header>
26 <div class="module_content">
27 <?php
28 //$tabel = "SELECT p.*, h.sebelumdm FROM penduduk p, hasil h where p.NIK = h.idpenduduk";
29 $tabel = "select * from penduduktrain";
lib.inc.php (https://github.com/radiocontrolled/ATutor.git) PHP · 143 lines
1 <?php
2 /***********************************************************************/
3 /* ATutor */
125 $memory_usage = 0;
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){
129 while ($row=mysql_fetch_assoc($result)){
upgrade_course_110.lib.php (https://github.com/TeamRocketScience/Claroline-TRS-Edition.git) PHP · 285 lines
mysql.idl.php (https://github.com/diegoIta/hiphop-php.git) PHP · 203 lines
CMySQL.php (https://github.com/stargazers/CMySQL.git) PHP · 401 lines
ARC2_StoreTableManager.php (https://github.com/mterenzio/FollowThis.git) PHP · 287 lines
1 <?php
2 /**
3 * ARC2 RDF Store Table Manager
84 ) ". $this->getTableOptionsCode() . "
85 ";
86 return mysql_query($sql, $this->getDBCon());
87 }
96 MODIFY o_lang_dt int(10) UNSIGNED NOT NULL
97 ";
98 return mysql_query($sql, $this->getDBCon());
99 }
109 ) ". $this->getTableOptionsCode() . "
110 ";
111 return mysql_query($sql, $this->getDBCon());
112 }
listGridCMS_PUBLISH_HISTORY.php (https://github.com/juddy/GIP.git) PHP · 285 lines
1 <?php
2 include_once("../common/dbConnection.php");
3 include_once("../common/header.php");
4 ?>
5 <?
20 $sqlUpdate = "UPDATE CMS_PUBLISH_HISTORY SET HISTORY_ID = '$thisHISTORY_ID' , PUBLISH_TAG = '$thisPUBLISH_TAG' , STRUCTURE_ID = '$thisSTRUCTURE_ID' , RESOURCE_ID = '$thisRESOURCE_ID' , RESOURCE_PATH = '$thisRESOURCE_PATH' , RESOURCE_STATE = '$thisRESOURCE_STATE' , RESOURCE_TYPE = '$thisRESOURCE_TYPE' , SIBLING_COUNT = '$thisSIBLING_COUNT' WHERE HISTORY_ID = '$thisHISTORY_ID'";
21 $resultUpdate = MYSQL_QUERY($sqlUpdate);
22 echo "<b>Record with Id ".$thisHISTORY_IDFromForm." has been Updated<br></b>";
23 $thisHISTORY_IDFromForm = "";
38 $sqlInsert = "INSERT INTO CMS_PUBLISH_HISTORY (HISTORY_ID , PUBLISH_TAG , STRUCTURE_ID , RESOURCE_ID , RESOURCE_PATH , RESOURCE_STATE , RESOURCE_TYPE , SIBLING_COUNT ) VALUES ('$thisHISTORY_ID' , '$thisPUBLISH_TAG' , '$thisSTRUCTURE_ID' , '$thisRESOURCE_ID' , '$thisRESOURCE_PATH' , '$thisRESOURCE_STATE' , '$thisRESOURCE_TYPE' , '$thisSIBLING_COUNT' )";
39 $resultInsert = MYSQL_QUERY($sqlInsert);
40 echo "<b>Record has been inserted in Database<br></b>";
41 $thisHISTORY_IDFromForm = "";
MysqlCacheProvider.php (https://github.com/ChuguluGames/mediawiki-svn.git) PHP · 189 lines
1 <?php
2 /**
3 * Copyright (c) 2011 ScientiaMobile, Inc.
106 // Check for database
107 $test = mysql_query("SHOW TABLES FROM $this->_db LIKE '$this->_table'",$this->_link);
108 if (!is_resource($test)) {
109 throw new WURFL_Xml_PersistenceProvider_Exception("Couldn't show tables from database $this->_db (".mysql_error($this->_link).")");
124 $this->_keycolumn
125 );
126 $success = mysql_query($query, $this->_link);
127 if (!$success) {
128 throw new WURFL_Xml_PersistenceProvider_Exception("Table $this->_table missing in $this->_db (".mysql_error($this->_link).")");
138 $key = mysql_escape_string($key);
139 $sql="select `value` from `$this->_db`.`$this->_table` where `key`='$key'";
140 $result=mysql_query($sql,$this->_link);
141 if (!is_resource($result)) {
142 throw new WURFL_Xml_PersistenceProvider_Exception("MySql error ".mysql_error($this->_link)."in $this->_db");
test.php (https://github.com/UniBus/Server.git) PHP · 282 lines
1 <?php
2 function openDB($dbServer, $dbUser, $dbPass, $dbName)
3 {
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);
breadcrumbs.lib.php (https://github.com/akash6190/pragyan.git) PHP · 91 lines
1 <?php
2 if(!defined('__PRAGYAN_CMS'))
3 {
18 /**
19 * breadcrumbs.lib.php
20 * To generate the bread crumbs required to show the location of the page with links to each level.
21 * Generate breadcrumbs for a given page
29 $pageIdList = join($pageIdArray, ",");
30 $query = 'SELECT `page_id`, `page_name`, `page_title` FROM `' . MYSQL_DATABASE_PREFIX . 'pages` WHERE `page_id` IN (' . $pageIdList . ')';
31 $resultId = mysql_query($query);
33 while ($row = mysql_fetch_assoc($resultId))
userstats.php (https://bitbucket.org/stavrossk/openmaidos.git) PHP · 69 lines
1 <?php
2 require_once('functions.php');
3 require_once('authentication.php');
4 require_once('maintenance.php');
5 include('header.php');
7 $u = Authenticate();
22 $getPluginId = $_GET['plugin_id'];
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);
26 if ($numrows <> 1) die("Are you scamming an old or non-existant plugin?");
59 echo "</a></td>";
60 echo "<td id=\"plugininfos\">";
61 echo "<a href=\"detail.php?plugin_id=" . $enreg2["plugin_ID"] . "\"><b>" . $enreg2["plugin_Name"] . "</b></a> by <a href=\"thelist.php?author=" . urlencode($enreg2["plugin_Author"]) . "\"><i>" . $enreg2["plugin_Author"] . "</i></a> ";
62 VoteWorking($u, $plugin_id, $plugin_version, "", "userstats.php?");
class.timetracker.php (https://gitlab.com/vectorci/Collabtive) PHP · 438 lines
1 <?php
2 /**
3 * This class provides methods to realize timetracking
8 * @package Collabtive
9 * @link http://www.o-dyn.de
10 * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v3 or later
11 */
68 }
70 $ins = mysql_query("INSERT INTO timetracker (user,project,task,comment,started,ended,hours,pstatus) VALUES ($user,$project,$task,'$comment','$started','$ended','$hours',0)");
72 if ($ins)
110 $hours = round($hours, 2);
112 $upd = mysql_query("UPDATE timetracker SET task='$task',comment='$comment',started='$started',ended='$ended',hours='$hours' WHERE ID = $id");
114 if ($upd)
utlMySqlWork.php (https://github.com/fmake/fmake.git) PHP · 114 lines
utlMySqlWork.php (https://github.com/fmake/fmake.git) PHP · 114 lines
envio.php (https://gitlab.com/merintec/barvo) PHP · 55 lines
1 <?php
2 include("../../comunes/variables.php");
3 include("../../comunes/conexion.php");
4 // Recibiendo Datos para enviar
5 $titulo='Contacto WEB';
11 $contenido_mail = "<b>".$nombre."</b> ha escrito por medio de la pagina.<br><b>Su correo es: </b> ".$correo.".<br><b>Asunto:</b> ".$titulo.".<br><b>Su mensaje:</b><br>".$contenido;
12 if ($titulo!='' AND $nombre!='' AND $correo!='' AND $contenido!=''){
13 require 'PHPMailerAutoload.php';
14 $mail = new PHPMailer;
41 // Si se envía el correo se almacena en base de datos
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();
45 if (mysql_error()==NULL){
actions_email.php (https://github.com/GansukhB/phtstr.git) PHP · 195 lines
1 <?php
2 session_start();
3 include( "check_login_status.php" );
5 // COPY ACTIONS UPDATED 3.4.04
7 include( "config_mgr.php" );
9 if($_SESSION['access_type'] != "mgr"){ echo "Operation cannot be performed in demo mode"; exit; }
11 $settings_result = mysql_query("SELECT * FROM settings where id = '1'", $db);
12 $setting = mysql_fetch_object($settings_result);
27 // SAVE DATA
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);
31 $last_result = mysql_query("SELECT id FROM email_copy order by id desc", $db);
index.php (https://github.com/silverwolf897/WebInterface.git) PHP · 99 lines
8 require 'scripts/itemInfo.php';
9 require 'scripts/updateTables.php';
10 $isAdmin = $_SESSION['Admin'];
11 $canBuy = $_SESSION['canBuy'];
29 <style type="text/css" title="currentStyle">
30 @import "css/table_jui.css";
31 @import "css/<?php echo $uiPack?>/jquery-ui-1.8.16.custom.css";
32 </style>
33 <link rel="stylesheet" type="text/css" href="css/<?php echo $cssFile?>.css" />
49 </head>
50 <div id="holder">
51 <?php include("topBoxes.php"); ?>
52 <h1>Web Auction</h1>
53 <br/>
93 <div class="spacer"></div>
95 <?php include("footer.php"); ?>
96 </div>
class.engine.php (https://github.com/NoVatutz/RevCMS.git) PHP · 134 lines
listGridCMS_HISTORY_PRINCIPALS.php (https://github.com/juddy/GIP.git) PHP · 285 lines
1 <?php
2 include_once("../common/dbConnection.php");
3 include_once("../common/header.php");
4 ?>
5 <?
20 $sqlUpdate = "UPDATE CMS_HISTORY_PRINCIPALS SET PRINCIPAL_ID = '$thisPRINCIPAL_ID' , PRINCIPAL_NAME = '$thisPRINCIPAL_NAME' , PRINCIPAL_DESCRIPTION = '$thisPRINCIPAL_DESCRIPTION' , PRINCIPAL_OU = '$thisPRINCIPAL_OU' , PRINCIPAL_EMAIL = '$thisPRINCIPAL_EMAIL' , PRINCIPAL_TYPE = '$thisPRINCIPAL_TYPE' , PRINCIPAL_USERDELETED = '$thisPRINCIPAL_USERDELETED' , PRINCIPAL_DATEDELETED = '$thisPRINCIPAL_DATEDELETED' WHERE PRINCIPAL_ID = '$thisPRINCIPAL_ID'";
21 $resultUpdate = MYSQL_QUERY($sqlUpdate);
22 echo "<b>Record with Id ".$thisPRINCIPAL_IDFromForm." has been Updated<br></b>";
23 $thisPRINCIPAL_IDFromForm = "";
38 $sqlInsert = "INSERT INTO CMS_HISTORY_PRINCIPALS (PRINCIPAL_ID , PRINCIPAL_NAME , PRINCIPAL_DESCRIPTION , PRINCIPAL_OU , PRINCIPAL_EMAIL , PRINCIPAL_TYPE , PRINCIPAL_USERDELETED , PRINCIPAL_DATEDELETED ) VALUES ('$thisPRINCIPAL_ID' , '$thisPRINCIPAL_NAME' , '$thisPRINCIPAL_DESCRIPTION' , '$thisPRINCIPAL_OU' , '$thisPRINCIPAL_EMAIL' , '$thisPRINCIPAL_TYPE' , '$thisPRINCIPAL_USERDELETED' , '$thisPRINCIPAL_DATEDELETED' )";
39 $resultInsert = MYSQL_QUERY($sqlInsert);
40 echo "<b>Record has been inserted in Database<br></b>";
41 $thisPRINCIPAL_IDFromForm = "";
download_4_1.php (https://gitlab.com/optimistic_mamun/project1) PHP · 269 lines
1 <?php ob_start();?>
2 <?php session_start();
7 include('connect.php');
8 $query = "SELECT * FROM ice_4_1 WHERE roll='$roll'";
9 $result = mysql_query($query) or die(mysql_error());
31 }
32 ?>
33 <?php
34 include('connect.php');
35 $query1 = "SELECT * FROM reg_info WHERE roll='$roll'";
36 $result1 = mysql_query($query1) or die(mysql_error());
37 $count1 = mysql_num_rows($result1);
38 while ($row1 = mysql_fetch_array($result1)) {
migrateDmlrModels.php (https://github.com/vladtraista/DEXonline.git) PHP · 100 lines
1 <?php
2 require_once("../../phplib/util.php");
3 assert_options(ASSERT_BAIL, 1);
4 debug_off();
16 if ($migrateAll) {
17 mysql_query("delete from transforms where transf_from != ''" .
18 "or transf_to != ''");
19 }
33 // Load all the DMLR model records
34 mysql_query("delete from model_description where md_model = {$model->id}");
35 $query = "select form, infl_id, variant, is_baseform from dmlr_models " .
36 "where model_type = '{$model->modelType}' " .
mysql.php (https://bitbucket.org/ke2083/transfans.co.uk-website.git) PHP · 335 lines
1 <?php
2 /***************************************************************************
3 * mysql.php
4 * -------------------
5 * begin : Saturday, Feb 13, 2001
6 * copyright : (C) 2001 The phpBB Group
7 * email : support@phpbb.com
8 *
9 * $Id: mysql.php,v 1.16 2002/03/19 01:07:36 psotfx Exp $
10 *
11 ***************************************************************************/
105 $this->num_queries++;
107 $this->query_result = @mysql_query($query, $this->db_connect_id);
108 }
109 if($this->query_result)
registration_exec.php (https://bitbucket.org/isanneh/campus-pages.git) PHP · 150 lines
1 <?php
2 //Start session
3 session_start();
5 //Include database connection details
6 //require_once('connect.php');
7 include("connect.php");
111 if($email_address != '') {
112 $qry = "SELECT * FROM users WHERE email_address='$email_address'";
113 $result = mysql_query($qry);
114 if($result) {
115 if(mysql_num_rows($result) > 0) {
129 $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
130 session_write_close();
131 header("location: register.php");
132 exit();
133 }
config.php (https://github.com/GrottoCenter/GrottoCenter.git) PHP · 87 lines
1 <?php
2 /**
3 * This file is part of GrottoCenter.
22 error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED);
23 date_default_timezone_set('Europe/Paris');
24 include("session.php");
26 /*header("Cache-Control: no-cache, must-revalidate");
63 if (is_resource($connect_db)) {
64 mysql_select_db($bdd_db,$connect_db);
65 mysql_query("SET NAMES UTF8");
66 return $connect_db;
67 } else {
mod.php (https://bitbucket.org/thomascherian91/online-hostel-manager.git) PHP · 111 lines
1 // mess_cut
2 <?php
3 $time=date("H:i");
4 if($time>$t)
5 {
6 header('Location: /timeout.php');
7 }
8 ?>
11 //mess_req_day
13 <?php
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());
17 $q3=mysql_query("select count(id) from staff") or die(mysql_error());
cont_issue.php (https://github.com/HBL/klassenboek.git) PHP · 81 lines
1 <? include("include/init.php");
2 check_login();
3 check_isset_array($_GET, 'notitie_id');
10 $notitie_id = mysql_escape_safe($_GET['notitie_id']);
12 $result = mysql_query_safe(<<<EOQ
13 SELECT tag, CONCAT(IFNULL(CONCAT(afkorting, ' '), ''), parents.text) text, CONCAT(agenda.week, CASE agenda.dag WHEN 1 THEN 'ma' WHEN 2 THEN 'di' WHEN 3 THEN 'wo' WHEN 4 THEN 'do' ELSE 'vr' END, agenda.lesuur) moment
14 FROM notities
58 }
59 ?>
60 <form action="do_cont_issue.php" accept-charset="UTF-8" method="POST">
61 <p><? echo($head_text) ?>
62 <p><textarea rows="3" cols="40" name="text0">
listCMS_PROJECTS.php (https://github.com/juddy/GIP.git) PHP · 190 lines
1 <?php
2 include_once("../common/dbConnection.php");
3 include_once("../common/header.php");
4 ?>
5 <?
39 $sql = "SELECT * FROM CMS_PROJECTS".$orderByQuery.$limitQuery;
40 $result = MYSQL_QUERY($sql);
41 $numberOfRows = MYSQL_NUM_ROWS($result);
63 ?>
65 <a href="<? echo $_SERVER['PHP_SELF']; ?>?startLimit=<? echo $previousStartLimit; ?>&limitPerPage=<? echo $limitPerPage; ?>&sortBy=<? echo $sortBy; ?>&sortOrder=<? echo $sortOrder; ?>">Previous <? echo $limitPerPage; ?> Results</a>....
66 <? } ?>
67 <?
countrysql.php (https://bitbucket.org/anneivycat/california-tour.git) PHP · 452 lines
6 /* SQL specific functions call for users.php */
8 // connect to server
9 include ("../sqlfuncs.php");
11 // open a connection to mysql
18 $query = "SELECT * FROM COUNTRY ORDER BY COUNTRY_DESC ASC";
20 $mysql_result = mysql_query($query, $mysql_link);
22 $totalnumrows = mysql_num_rows($mysql_result);
mysql.php (https://github.com/batl/sp.git) PHP · 335 lines
1 <?php
2 /***************************************************************************
3 * mysql.php
4 * -------------------
5 * begin : Saturday, Feb 13, 2001
6 * copyright : (C) 2001 The phpBB Group
7 * email : support@phpbb.com
8 *
9 * $Id: mysql.php 5211 2005-09-18 16:17:21Z acydburn $
10 *
11 ***************************************************************************/
105 $this->num_queries++;
107 $this->query_result = @mysql_query($query, $this->db_connect_id);
108 }
109 if($this->query_result)
comprobar.php (https://gitlab.com/FerSo/tesis) PHP · 171 lines
index.php (https://github.com/nylen/wesabe-balances.git) PHP · 136 lines
1 <?php
3 $time = microtime(true);
5 require_once 'settings.php';
7 $link = mysql_connect($db_server, $db_username, $db_password)
10 mysql_select_db($db_database) or die(mysql_error());
12 $result = mysql_query(<<<SQL
13 select a.name, a.type, a.id,
14 coalesce(b.balance, i.avail_cash + p.market_value) balance,
89 </head>
90 <body>
91 <?php
93 $account_types = array(
DBIMysqlTest.php (https://gitlab.com/luyxtran264/myproject) PHP · 331 lines
1 <?php
2 /**
3 * Tests for PMA\libraries\dbi\DBIMysql class
4 *
5 * @package PhpMyAdmin-test
6 */
12 use PMA\libraries\dbi\DBIMysql;
14 require_once 'libraries/relation.lib.php';
15 require_once 'libraries/url_generating.lib.php';
90 runkit_function_redefine('mysql_pconnect', '', 'return "mysql_pconnect";');
91 runkit_function_redefine('mysql_connect', '', 'return "mysql_connect";');
92 runkit_function_redefine('mysql_query', '', 'return "mysql_query";');
93 runkit_function_redefine(
94 'mysql_fetch_array', '', 'return "mysql_fetch_array";'
change_oid_name.php (https://github.com/SunnyBingoMe/monitor.git) PHP · 116 lines
1 <?php
2 session_start ();
3 ?><?php
5 if (! isset ( $_SESSION ['isAdmin'] )) {
6 // $_SESSION ['loginError'] == '1';
7 header( 'refresh: 2; url=index.php' );
8 echo "Login failed.";
9 exit ();
14 // exit ();
15 //}
16 require 'database_connection.php';
17 require 'sunny_function.php';
33 <body>
35 <?php require_once 'body_head.php';?>
excel2mysql.php (https://github.com/sangmadesu/tcake.git) PHP · 286 lines
1 <?php
2 require_once 'reader.php';
13 * website : http://blog.lentera.web.id
14 * cpyrite : anghuda
15 * lisence : http://www.php.net/license/3_0.txt PHP License 3.0
16 *
17 * require : Spreadsheet_Excel_Reader by Vadim Tkachenko <vt@phpapache.com>
232 /* inject into database */
233 mysql_query( $query . $val_query);
234 }
276 {
277 $excel_timestamp = $xl_date - 25568;
278 $php_timestamp = mktime(0,0,0,1,$excel_timestamp,1970);
280 $mysql_timestamp = date('Y-m-d', $php_timestamp);
MySQL.class.php (https://gitlab.com/Elron_MacBong/ecms) PHP · 229 lines
1 <?php
2 if(!defined('eCMS')) die('Hacking attempt...');
101 }
103 // Execute query. (mysql_query)
104 # @param string $sql
105 #
109 $this->sql_query = $sql;
110 $this->query_counter++;
111 $this->result = @mysql_query($this->sql_query, $this->connection);
113 if($this->result === false) { $this->error('QUERY.FAILED', NULL); return false; }
Privilege.php (https://github.com/bblc/tomatocms208v1.git) PHP · 130 lines
1 <?php
2 /**
3 * TomatoCMS
15 * @copyright Copyright (c) 2009-2010 TIG Corporation (http://www.tig.vn)
16 * @license http://www.gnu.org/licenses/gpl-2.0.txt GNU GENERAL PUBLIC LICENSE Version 2
17 * @version $Id: Privilege.php 5029 2010-08-28 17:02:10Z huuphuoc $
18 * @since 2.0.5
19 */
30 {
31 $sql = "SELECT * FROM " . $this->_prefix . "core_privilege";
32 $rs = mysql_query($sql);
33 $rows = array();
34 while ($row = mysql_fetch_object($rs)) {
43 $sql = sprintf("SELECT * FROM " . $this->_prefix . "core_privilege WHERE privilege_id = '%s' LIMIT 1",
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));
47 mysql_free_result($rs);
get_entry.php (https://github.com/danielhahne/corecms.git) PHP · 113 lines
1 <?php
3 $b = $_SERVER['REQUEST_URI'];
15 $http = "http://" . $_SERVER['HTTP_HOST'] . substr($b,0,strlen($b)-5);
17 require_once($root . "user/configuration.php");
18 require_once($root . "themes/".$theme."/configuration.php");
19 require_once($root . "functions/session.php");
21 if(is_numeric($id)) {
29 if($type == "page") {
30 $data = mysql_query("SELECT p.* FROM core_pages p WHERE p.page_title = \"$id\"");
31 $page_clicks = 0;
32 while($p = mysql_fetch_array($data)) {
Page.php (https://github.com/bblc/tomatocms208v1.git) PHP · 297 lines
1 <?php
2 /**
3 * TomatoCMS
15 * @copyright Copyright (c) 2009-2010 TIG Corporation (http://www.tig.vn)
16 * @license http://www.gnu.org/licenses/gpl-2.0.txt GNU GENERAL PUBLIC LICENSE Version 2
17 * @version $Id: Page.php 4891 2010-08-24 20:06:55Z huuphuoc $
18 * @since 2.0.5
19 */
34 mysql_real_escape_string($id));
36 $rs = mysql_query($sql);
37 $return = (0 == mysql_num_rows($rs)) ? null : new Page_Models_Page(mysql_fetch_object($rs));
38 mysql_free_result($rs);
51 $sql = 'SELECT MAX(right_id) AS right_id FROM ' . $this->_prefix . 'page';
52 }
53 $rs = mysql_query($sql);
54 $right = (0 == mysql_num_rows($rs)) ? null : new Page_Models_Page(mysql_fetch_object($rs));
55 $rightId = ($parentId) ? $right->right_id : $right->right_id + 1;
newsletter.lib.php (https://github.com/jithinkr/pragyan.git) PHP · 173 lines
1 <?php
2 if(!defined('__PRAGYAN_CMS'))
3 {
11 *
12 * To change the template for this generated file go to
13 * Window - Preferences - PHPeclipse - PHP - Code Templates
14 */
63 private static function moveUserToInternal($userEmail, $userId) {
64 $query = "SELECT `page_modulecomponentid` FROM `newsletter_externalusers` WHERE `user_email` = '$userEmail'";
65 $result = mysql_query($query);
66 while ($row = mysql_fetch_row($result)) {
67 if (!isInternalUserRegistered($userId, $row[0], false)) {
68 $insertQuery = "INSERT INTO `newsletter_users`(`page_modulecomponentid`, `newsletter_subscriptiontype`, `user_id`, `user_joindatetime`) VALUES ({$row[0]}, 'user', $userId, NOW())";
69 if (!mysql_query($insertQuery)) {
70 displayerror('Could not add user to internal list.');
71 }
index.php (https://github.com/SimonSimCity/PhpSpeed.git) PHP · 159 lines
9 <head>
10 <title>PHPspeed | <?php echo $_SERVER['HTTP_HOST']; ?></title>
11 <meta http-equiv="content-language" content="en-us" />
12 <meta http-equiv="content-type" content="text/html; charset=utf-8" />
18 <header>
20 <h1>PHPspeed | <?php echo $_SERVER['HTTP_HOST']; ?></h1>
22 </header>
137 <ul>
138 <li>PHP: <b><?php echo phpversion(); ?></b></li>
139 <li>MySQL: <b><?php printf(mysql_get_server_info()); ?></b></li>
140 <li><?php echo $_SERVER['SERVER_SOFTWARE']; ?></li>
141 <li>PHPspeed: <b><?php echo $ver['version']; ?></b></li>
142 </ul>
createResultObject.php (https://github.com/Jessicasoon/ProjectKentRidgeV2.git) PHP · 139 lines
22 <th width="120" valign="top" scope="row"><label for="result_title_<?php echo $result; ?>">Title</label></th>
23 <td><span id="sprytextfield-result_title_<?php echo $result; ?>" class="sprytextfield"><input type="text" name="result_title_<?php echo $result; ?>" id="result_title_<?php echo $result; ?>" value="<?php echo $row_getQuery['result_title']; ?>" /><span class="textfieldRequiredMsg">A value is required.</span></span>
24 <span class="desc">Provide a title for this result!</span></td>
25 </tr>
27 <th width="120" valign="top" scope="row"><label for="result_description_<?php echo $result; ?>">Description</label></th>
28 <td><span id="sprytextarea-result_description_<?php echo $result; ?>" class="sprytextarea"><textarea name="result_description_<?php echo $result; ?>" id="result_description_<?php echo $result; ?>" cols="45" rows="5"><?php echo $row_getQuery['result_description']; ?></textarea><span class="textareaRequiredMsg">Description should not be blank!</span></span>
29 <span class="desc">Tell the quiz taker what this result means</span></td>
30 </tr>
58 <td><?php // return uploaded images
59 if($unikey != ""){ foreach(glob("../quiz_images/".$unikey."*") as $filename){ ?>
60 <a href="javascript:;" onClick="selectImage(<?php echo $result; ?>, '<?php echo str_replace("'", "\\'", basename($filename)); ?>')"><img src="../quiz_images/imgcrop.php?w=80&h=60&f=<?php echo basename($filename); ?>" width="80" height="60" id="r<?php echo $result; ?>i<?php echo $count; ?>" class="selectImage"></a>
61 <?php $count++; }} ?>
129 <td><?php // return uploaded images
130 if($unikey != ""){ foreach(glob("../quiz_images/".$unikey."*") as $filename){ ?>
131 <a href="javascript:;" onClick="selectImage(<?php echo $result; ?>, '<?php echo basename($filename); ?>')"><img src="../quiz_images/imgcrop.php?w=80&h=60&f=<?php echo basename($filename); ?>" width="80" height="60" id="r<?php echo $result; ?>i<?php echo $count; ?>" class="selectImage"></a>
132 <?php $count++; }} ?>
statusbar.php (https://github.com/Jessicasoon/ProjectKentRidgeV2.git) PHP · 72 lines
14 <div id="dialog-message" style="display:none;" title="Feature Unavailable"> Oops, this feature is currently unavailable yet. Please hang in there while we work on it. </div>
15 <div id="statusbar-container">
16 <div id="statusbar"> <a href="index.php" id="statusbar-logo" title="Quizroo"><span>Quizroo</span></a>
17 <div id="statusbar-divider"></div>
18 <div id="statusbar-notification">
26 <div id="statusbar-quizcreator">
27 <!--<div id="statusbar-quizcreator-logo" title="Quiz Creator"></div>-->
28 <div id="statusbar-quizcreator-count-total" class="statusbar-achievements-quizcount-top" title="Quiz Creator Popularity Score"><div class="stretch--resizer" style="margin: 0pt; padding: 0pt; white-space: nowrap; overflow: hidden; font-size: 13px; word-spacing: 0px;" type="statusbar"><span class="stretch--handle" style="margin: 0pt; padding: 0pt;" type="statusbar"><?php echo $member->quizcreator_score; ?></span></div></div>
29 <div id="statusbar-quizcreator-count-today" class="statusbar-achievements-quizcount-bottom" title="Quiz Creator Score for Today"><div class="stretch--resizer" style="margin: 0pt; padding: 0pt; white-space: nowrap; overflow: hidden; font-size: 13px; word-spacing: 0px;" type="statusbar"><span class="stretch--handle" style="margin: 0pt; padding: 0pt;" type="statusbar"><?php echo $member->quizcreator_score_today; ?></span></div>
34 <div id="statusbar-quiztaker-count-total" class="statusbar-achievements-quizcount-top" title="Quiz Taker Score"><div class="stretch--resizer" style="margin: 0pt; padding: 0pt; white-space: nowrap; overflow: hidden; font-size: 13px; word-spacing: 0px;"><span class="stretch--handle" style="margin: 0pt; padding: 0pt;"><?php echo $member->quiztaker_score; ?></span></div></div>
35 <div id="statusbar-quiztaker-count-today" class="statusbar-achievements-quizcount-bottom" title="Quiz Taker Score for Today"><div class="stretch--resizer" style="margin: 0pt; padding: 0pt; white-space: nowrap; overflow: hidden; font-size: 13px; word-spacing: 0px;" type="statusbar"><span class="stretch--handle" style="margin: 0pt; padding: 0pt;" type="statusbar"><?php echo $member->quiztaker_score_today; ?></span></div>
36 </div>
37 </div>
65 <?php //do { ?>
66 <li><a href="topics.php?topic=<?php //echo $row_getTopics['cat_id']; ?>" class="topicTitle<?php //echo ($topic == $row_getTopics['cat_id']) ? " current" : ""; ?>" title="Total <?php //echo $row_getTopics['total']; ?> quizzes, <?php //echo ($row_getTopics['undone'] != NULL) ? $row_getTopics['undone'] : 0; ?> undone"><?php //echo $row_getTopics['cat_name']; ?></a></li>
67 <?php //} while ($row_getTopics = mysql_fetch_assoc($getTopics)); ?>
build_all_database.php (https://github.com/phikai/boxee-espn3.git) PHP · 247 lines
1 <?php
3 //MySQL Connection Information
4 include('/home/phikai/boxee.thinkonezero.com/mysql_connect.inc.php');
6 //MySQL Connection
7 mysql_connect($server,$username,$password);
8 @mysql_select_db($database) or die("Unable to select database");
9 mysql_query("SET time_zone = '-5:00';");
67 //MySQL Query for Each Item
68 $query = "INSERT INTO e3_live(fulldate, date, event_id, event, league, sport, time, thumb) VALUES(NOW(), DATE('{$safe['date']}'), '{$safe['idnum']}', '{$safe['event']}', '{$safe['league']}', '{$safe['sport']}', '{$safe['time']}', '{$safe['thumb']}')";
69 mysql_query($query);
71 }
class.plugin.php (https://bitbucket.org/icarito/pmc) PHP · 255 lines
1 <?php
3 class plugin
27 $description = mysql_real_escape_string($description);
29 $ins = mysql_query("INSERT INTO plugins (name,description) VALUES ('$name','$description')");
30 if ($ins)
31 {
56 {
57 $plugin = (int) $plugin;
58 $del = mysql_query("DELETE FROM plugins WHERE ID = $plugin");
59 $this->delAllPluginEvents($plugin);
78 {
79 $plugin = (int) $plugin;
80 $upd = mysql_query("UPDATE plugins SET state = 1 WHERE ID = $id");
81 }
quote.php (https://github.com/ecoeco/ecoeco.git) PHP · 304 lines
109 <?php (++ $i) ; ?>
110 <td><a href="index.php?id=<?php echo $quote_item['id_product'] = htmlentities($quote_item['id_product']) ; ?>"
111 style="font-size: 10pt; font-family: Arial, sans-serif; color: #666">
112 <img
183 <p><select size="1" name="item[<?php echo $quote_item['id_quote_item'] ; ?>]['color']">
184 <option selected style="font-size: 10pt; font-family: Arial, sans-serif; color: #666" value="<?php echo $quote_item['color']; ?>"><?php echo $quote_item['color']; ?></option>
185 <option value=" RAL 9016"> RAL 9016</option>
186 <option value=" RAL 9006"> RAL 9006</option>
200 <p><input
201 type="number"
202 value="<?php echo $quote_item['qty']; ?>" size="12" name="item[<?php echo $quote_item['id_quote_item']; ?>]['qty']" min="0" max="1000" value="1" /></p>
203 </td>
302 }
303 ?>
304 <?php //require 'templates/footer.php'; ?>
room_edit.php (https://bitbucket.org/deba666/accitsoftware.git) PHP · 144 lines
1 <?php
2 if($_POST['room_code'])
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";
6 else
19 <div class="page-title">
20 <div class="title_left">
21 <?php
22 if($_SESSION['s_msg'] || $_SESSION['e_msg'])
23 {
27 <?=($_SESSION['s_msg'])?$_SESSION['s_msg']:$_SESSION['e_msg']?>
28 </div>
29 <?php
30 unset($_SESSION['s_msg']);
31 unset($_SESSION['e_msg']);
z_instructoreval.php (https://github.com/drallen1/Rate-Your-Mate.git) PHP · 101 lines
16 $numB = mysql_num_rows($btwo);
17 $query2="INSERT INTO Eval (STUDENT_ID, Grader_ID, GROUP_ID, Grade) VALUES (" . $_POST[graded] . ", " . $session->STUDENT_ID . ", " . $session->GROUP_ID . ", '10')";
18 mysql_query($query2) or die(mysql_error());
20 $evalid = mysql_insert_id();
45 if($numE>1)
46 $page="evalform.php";
47 else
48 $page="evalprocess.php";
67 });
68 </script>
69 <input type="hidden" name="studentid" id="studentid" value="<?php echo $session->STUDENT_ID;?>" />
70 Student: <select name="graded" id="graded">
71 <option selected="selected">Please Select a Student to Grade</option>
72 <?php for($i=0;$i<$numE;$i++){
73 $rsix = mysql_fetch_array($qsix);?>
74 <option value="<?php echo $rsix[STUDENT_ID]?>"><?php echo $rsix[fname] . " " . $rsix[lname]?></option>
75 <?php };?>
failure_result_summary_by_host.php (https://github.com/matszpk/native-boinc-for-android.git) PHP · 89 lines
1 <?php
2 // This file is part of BOINC.
3 // http://boinc.berkeley.edu
62 ";
64 $result = mysql_query($main_query);
66 start_table();
77 $res->Host_ID,
78 $res->OS_Version, $res->Results_Today,
79 "<a href=db_action.php?table=result&detail=low&hostid=$res->Host_ID&app_version_id=$res->app_version_id&server_state=5&outcome=3>$res->error_count</a>"
80 );
81 }
86 admin_page_tail();
88 $cvs_version_tracker[]="\$Id: failure_result_summary_by_host.php 25171 2012-01-31 07:21:42Z davea $"; //Generated automatically - do not edit
89 ?>
api.php (https://gitlab.com/swimly/api) PHP · 76 lines
1 <?php
2 // 指定允许其他域名访问
3 header('Access-Control-Allow-Origin: *');
4 header('Access-Control-Allow-Credentials: true');
5 include_once("conn.php");
7 $type=isset($_GET["type"])?$_GET["type"]:null; /*get是获取、update是修改、delete是删除、add是添加*/
27 }
28 function getLists($conn,$table,$size,$sort,$field){
29 mysql_query("SET NAMES 'UTF8'",$conn);
30 $page =isset($_GET['page'])?$_GET['page']:1; //获取查询页数,如果没有get到page,默认就是第一页!
31 if(!preg_match('/^\d+$/',$page) || $page < 1) $page = 1; //如果输入的不是数字 或者小于1 默认第一页
32 $table=$table; //获取要查询的数据表
33 $pageSize =$size; //每页多少条
34 $result_pag_num = mysql_query("SELECT COUNT(*) AS count FROM $table"); //获取数据表中总记录条数
35 $row = mysql_fetch_array($result_pag_num);
36 $count = $row['count']; //返回记录总条数
db_lib.php (https://github.com/JohnBean/i3-character-creator.git) PHP · 259 lines
1 <?php
3 require_once('character.php');
4 require_once('card.php');
5 require_once('deck.php');
33 }
34 $query = "select uid from drusessions where sid = '$sid'";
35 $result = mysql_query($query);
36 if(!$result) {
37 return False;
65 $result = mysql_query($query);
66 if(!$result) {
67 return False;
admin_edituser.php (https://github.com/leviself/Feedmailer.git) PHP · 152 lines
29 $template->sidebar();
30 ?>
31 <form action="<?php echo $_SERVER[PHP_SELF];?>" method="post">
32 <div id="sidebar_page">
33 <div id="boxpadding">
88 <tr>
89 <td><strong>Email Count</strong></td>
90 <td><input type="text" readonly="readonly" value="<?php echo $user[email_count];?>" class="inputbox" /></td>
91 </tr>
92 <tr>
123 $template->sidebar();
124 ?>
125 <form action="<?php echo $_SERVER[PHP_SELF];?>" method="get">
126 <div id="sidebar_page">
127 <div id="boxpadding">
listCMS_ONLINE_RESOURCE_RELATIONS.php (https://github.com/juddy/GIP.git) PHP · 155 lines
1 <?php
2 include_once("../common/dbConnection.php");
3 include_once("../common/header.php");
4 ?>
5 <?
39 $sql = "SELECT * FROM CMS_ONLINE_RESOURCE_RELATIONS".$orderByQuery.$limitQuery;
40 $result = MYSQL_QUERY($sql);
41 $numberOfRows = MYSQL_NUM_ROWS($result);
63 ?>
65 <a href="<? echo $_SERVER['PHP_SELF']; ?>?startLimit=<? echo $previousStartLimit; ?>&limitPerPage=<? echo $limitPerPage; ?>&sortBy=<? echo $sortBy; ?>&sortOrder=<? echo $sortOrder; ?>">Previous <? echo $limitPerPage; ?> Results</a>....
66 <? } ?>
67 <?
listCMS_OFFLINE_RESOURCE_RELATIONS.php (https://github.com/juddy/GIP.git) PHP · 155 lines
1 <?php
2 include_once("../common/dbConnection.php");
3 include_once("../common/header.php");
4 ?>
5 <?
39 $sql = "SELECT * FROM CMS_OFFLINE_RESOURCE_RELATIONS".$orderByQuery.$limitQuery;
40 $result = MYSQL_QUERY($sql);
41 $numberOfRows = MYSQL_NUM_ROWS($result);
63 ?>
65 <a href="<? echo $_SERVER['PHP_SELF']; ?>?startLimit=<? echo $previousStartLimit; ?>&limitPerPage=<? echo $limitPerPage; ?>&sortBy=<? echo $sortBy; ?>&sortOrder=<? echo $sortOrder; ?>">Previous <? echo $limitPerPage; ?> Results</a>....
66 <? } ?>
67 <?
lap_ms_barang_kadaluarsa.php (https://github.com/reekoheek/srmis.git) PHP · 121 lines
signup.php (https://github.com/dadepo/Padly.git) PHP · 148 lines
1 <?php
8 <link rel="stylesheet" type="text/css" href="padly/html/style/bootstrap.css" />
10 <form method="post" action="<?php echo APP_PATH;?>/auth.php" class="form-stacked" id="pd_signupform">
12 <fieldset>
15 <legend>Signup For Account</legend>
17 <?php
19 //first take care of the database
20 //check if signup db exits
21 $test = mysql_query("select * from sul_signup_profile");//which is faster? this or mysql_list_table function
22 if (!$test)
23 {
department.php (https://bitbucket.org/devenbhooshan/paysewa.git) PHP · 135 lines
1 <?php
2 include("../dbinfo.php");
3 $clientid;
4 $name;
12 if(array_key_exists('id',$_GET)&& $_GET['id']!=0){
13 $clientid=$_GET['id'];
14 $query_for_cheching_status=mysql_query("select deptYN from clientdetails where id='$clientid'");
15 $row_for_status=mysql_fetch_array($query_for_cheching_status);
16 $status=$row_for_status['deptYN'];
17 if($status==1){
19 $mysql_query=mysql_query("select * from cdeptmaster where clientId='$clientid' order by id desc");
20 if(mysql_num_rows($mysql_query)>0){
41 <label class="control-label" for="inputName">Name</label>
42 <div class="controls">
43 <input type="text" id="inputName" placeholder="Name" name="name0" value="<?php if($flag_for_checking) echo $name?>">
44 </div>
45 </div>
ARC2_StoreDeleteQueryHandler.php (https://github.com/AramZS/thematicnightmare.git) PHP · 237 lines
1 <?php
2 /**
3 * ARC2 RDF Store DELETE Query Handler
71 foreach ($this->infos['query']['target_graphs'] as $g) {
72 if ($g_id = $this->getTermID($g, 'g')) {
73 $rs = mysql_query('DELETE FROM ' . $tbl_prefix . 'g2t WHERE g = ' .$g_id, $con);
74 $r += mysql_affected_rows($con);
75 }
132 $sql .= ' FROM ' . $this->getTripleTable() . ' T WHERE ' . $q;
133 }
134 $rs = mysql_query($sql, $con);
135 if ($er = mysql_error($con)) {
136 $this->addError($er .' in ' . $sql);
166 WHERE G.t IS NULL LIMIT 1
167 ';
168 if (($rs = mysql_query($sql, $con)) && mysql_num_rows($rs)) {
169 /* delete unconnected triples */
170 $sql = ($dbv < '04-01') ? 'DELETE ' . $tbl_prefix . 'triple' : 'DELETE T';
stats.php (https://github.com/kakaroto/humblehomebrew.git) PHP · 149 lines
21 <td width="40%" height="100%" align="center" valign="middle">
22 <table width="100%" height="100%" align="center" valign="middle">
23 <?php
24 list($total_amount, $total_donations, $average_donation, $total_signatures,
25 $total_downloads) = get_short_statistics($con);
33 <td class="style1">
34 <div align="center">
35 <?php echo $total_amount; ?>
36 </div>
37 </td>
45 <td class="style1">
46 <div align="center">
47 <?php echo $average_donation; ?>
48 </div>
49 </td>
admin_deletePage.php (https://github.com/loboda/cs411.git) PHP · 274 lines
1 <?php
2 include 'includes/mysqlAdminLoginAssignment.php';
13 $query = "DELETE FROM assignment WHERE assnID = '$rowID'";
15 if (!mysql_query($query, $mysqlConnection))
16 {
17 die ('Error: ' . mysql_error());
23 <script src="admin_functions.js"></script>
24 <meta http-equiv="refresh" content="0;url=admin.html?displayTable=1">
25 <?php
26 }
32 $query = "DELETE FROM automarking WHERE AutomarkID = '$rowID'";
34 if (!mysql_query($query, $mysqlConnection))
35 {
36 die ('Error: ' . mysql_error());
Rezervace.class.php (https://github.com/GE3/GE3.git) PHP · 265 lines
192 $insert = mysql_query("INSERT INTO $CONF[sqlPrefix]rezervRezervace (pokojId, datumStart, datumEnd, potvrzeno, pocetHostu, cena, detaily, datum) VALUES ('$this->pokojId','$this->datumStart','$this->datumEnd','$this->potvrzeno','$this->pocetHostu','$this->cena','$this->detaily',NOW())");
193 $rezervInsertId = mysql_insert_id();
194 $radek2=mysql_fetch_assoc(mysql_query("SELECT id FROM $CONF[sqlPrefix]rezervRezervace WHERE pokojId='$this->pokojId' AND datumStart='$this->datumStart'"));
195 foreach ($this->udaj as $key => $val) {
196 $insert = mysql_query("INSERT INTO $CONF[sqlPrefix]rezervRezervaceUdaje (idRezervace, nazev, hodnota) VALUES ('$rezervInsertId','$key','$val')");
213 $CONF = &$GLOBALS["config"];
214 if($this->id!=0){
215 $update=mysql_query("UPDATE $CONF[sqlPrefix]rezervRezervace SET pokojId='$this->pokojId', datumStart='$this->datumStart', datumEnd='$this->datumEnd', potvrzeno='$this->potvrzeno', pocetHostu='$this->pocetHostu', cena='$this->cena', detaily='$this->detaily' WHERE id='$this->id'");
216 foreach ($this->udaj as $key => $val) {
217 $update=mysql_query("UPDATE $CONF[sqlPrefix]rezervRezervaceUdaje SET hodnota='$this->udaj[$key]' WHERE idRezervace='$this->id' AND nazev='$key'");
239 }
240 /*
241 include("../config.php/default.conf.php");
242 $CONF = &$GLOBALS["config"];
cso_summary_of_enrollment_ways.php (https://github.com/eedsonpaul/iris.git) PHP · 222 lines
1 <?php
2 //File: CSO Degree Programs
3 //Version 2: Revision Date: October 6, 2010
28 <p class=notice>
29 <b>REPORT<br/>
30 <u><?php session_start(); echo $_SESSION['semester'];?>, <?php echo $_SESSION['academic_year'];?></u></b><br/>
31 AS OF <?php echo date("D M d H:i:s T Y"); ?>
35 <!-- BODY -->
36 <?php
38 include ('connect_to_database.php');
39 include ('cso_enrollment_functions.php');
40 $action = $_GET['by'];
db_printview.php (https://gitlab.com/a.loskutnikov/sitimobile) PHP · 264 lines
1 <?php
2 /* $Id: db_printview.php,v 1.18 2002/02/27 20:54:12 loic1 Exp $ */
6 * Gets the variables sent or posted to this script, then displays headers
7 */
8 require('./libraries/grab_globals.lib.php');
9 require('./header.inc.php');
13 * Defines the url to return to in case of error in a sql statement
14 */
15 $err_url = 'db_details.php'
16 . '?lang=' . $lang
17 . '&server=' . $server
28 if ($cfgSkipLockedTables == TRUE && PMA_MYSQL_INT_VERSION >= 32330) {
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
32 if ($result != FALSE && mysql_num_rows($result) > 0) {
matiere.php (https://github.com/Regis85/plugin_notes.git) PHP · 211 lines
1 <?php
2 /** Modele du module evaluations : action matiere
3 *
122 }
123 //echo $sql.'<br />';
124 if (mysql_query($sql)) {
125 return TRUE;
126 } else {
160 $sql="SELECT * FROM `cn_conteneurs`
161 WHERE `id` ='".$id_conteneur."' ";
162 $result = mysql_query($sql);
163 if ($result) {
164 $donnee_recu = mysql_fetch_array($result);
export_groups.php (https://bitbucket.org/lihorne/tedxuw.git) PHP · 329 lines
1 <?php
3 /**
21 global $g_table_prefix;
23 $query = mysql_query("
24 SELECT *
25 FROM {$g_table_prefix}module_export_groups
31 // get any custom list of clients, if this is a Private export type
32 $query = mysql_query("
33 SELECT account_id
34 FROM {$g_table_prefix}module_export_group_clients
55 global $g_table_prefix;
57 $query = mysql_query("
58 SELECT *
59 FROM {$g_table_prefix}module_export_groups
database.php (https://github.com/nicocode/BlaBlub.git) PHP · 293 lines
1 <?
2 /**
3 * Database.php
4 *
5 * The Database class is meant to simplify the task of accessing
9 * Last Updated: August 17, 2004
10 */
11 include("constants.php");
13 class MySQLDB
57 /* Verify that user is in database */
58 $q = "SELECT password FROM ".TBL_USERS." WHERE username = '$username'";
59 $result = mysql_query($q, $this->connection);
60 if(!$result || (mysql_numrows($result) < 1)){
61 return 1; //Indicates username failure
func.get_product.php (https://gitlab.com/Henaway/CLFC) PHP · 159 lines
1 <?php
2 // If the product exists, the subroutine returns the product information.
3 // Call with: get_product ($product_id, $product_version, $pvid)
67 ('.NEW_TABLE_PRODUCTS.'.pvid = "'.mysql_real_escape_string ($pvid).'"
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))
71 {
92 FROM
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))
96 {
106 product_version = "1",
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();
110 // Now increment the product_id until it is unique in the database
extension.cache.mysql.php (https://gitlab.com/x33n/ampache) PHP · 190 lines
1 <?php
2 /////////////////////////////////////////////////////////////////
3 /// getID3() by James Heinrich <info@getid3.org> //
7 /////////////////////////////////////////////////////////////////
8 // //
9 // extension.cache.mysql.php - part of getID3() //
10 // Please see readme.txt for more information //
11 // ///
22 * way as the getID3 class, but return cached information very fast
23 *
24 * Example: (see also demo.cache.mysql.php in /demo/)
25 *
26 * Normal getID3 usage (example):
27 *
28 * require_once 'getid3/getid3.php';
29 * $getID3 = new getID3;
30 * $getID3->encoding = 'UTF-8';
DB.php (https://github.com/zackster/antfarm.git) PHP · 182 lines
1 <?php
3 class DB {
8 function __construct() {
9 require(dirname(__FILE__) . '/config.php'); // this works
10 $this->link = mysql_connect('localhost', $dbusername, $dbpassword, true);
11 mysql_select_db($dbname, $this->link);
15 function are_email_notifications_enabled($uid) {
16 $query = sprintf("SELECT disable_email_notifications FROM users WHERE id=%d", $uid);
17 $res = mysql_query($query);
18 $row = mysql_fetch_assoc($res);
19 return (!(bool)$row['disable_email_notifications']);
23 function award_exp($uid,$act,$exp_value) {
24 $query = sprintf("INSERT INTO experience (uid,act,value) VALUES (%d,'%s',%d)", $uid,mysql_real_escape_string($act),$exp_value);
25 mysql_query($query);
26 return;
27 }
database_mysql.php (https://github.com/tigerdan/TinyIB.git) PHP · 220 lines
1 <?php
2 if (!defined('TINYIB_BOARD')) { die(''); }
13 // Create the posts table if it does not exist
14 if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . TINYIB_DBPOSTS . "'")) == 0) {
15 mysql_query("CREATE TABLE `" . TINYIB_DBPOSTS . "` (
44 // Create the bans table if it does not exist
45 if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . TINYIB_DBBANS . "'")) == 0) {
46 mysql_query("CREATE TABLE `" . TINYIB_DBBANS . "` (
57 # Post Functions
58 function uniquePosts() {
59 $row = mysql_fetch_row(mysql_query("SELECT COUNT(DISTINCT(`ip`)) FROM " . TINYIB_DBPOSTS));
60 return $row[0];
61 }
assessment.php
(http://ebpls.googlecode.com/svn/trunk/)
PHP · 260 lines
✨ Summary
This PHP code generates a table displaying tax calculations for various business transactions, including totals and grand totals. It uses dynamic variables to calculate tax amounts based on predefined formulas and multipliers, then stores these values in a temporary database table called tempassess
. The final total is displayed at the bottom of the table.
This PHP code generates a table displaying tax calculations for various business transactions, including totals and grand totals. It uses dynamic variables to calculate tax amounts based on predefined formulas and multipliers, then stores these values in a temporary database table called tempassess
. The final total is displayed at the bottom of the table.
143 $xv = $getn[2];
145 $getrange = mysql_query("select rangeamount, rangelow from ebpls_buss_taxrange where
146 taxfeeid=$getd[2] and rangelow = $xv") or die ("f");
147 $haveex = mysql_num_rows($getrange);
219 //delete if existing
220 $result = mysql_query ("delete from tempassess where assid='$varx'
221 and owner_id=$owner_id and business_id=$business_id") or die (mysql_error());
251 <table border =1 width=300><br>
252 <tr><td width=100></td> <td></td><td align=right>Total Tax:</td><td align=right>
253 <font color=red>Php <?php echo $ga = number_format($grandamt,2); ?></font></td></tr>
254 </table>
Registration.php (https://gitlab.com/swajib/MiniProject_Conception_B11) PHP · 284 lines
1 <?php
3 namespace App\BITM\SimpleRegistrationForm;
49 $query = "SELECT * FROM `registrations` WHERE deleted_at IS NULL";
50 $result = mysql_query($query);
52 while ($row = mysql_fetch_object($result)) {
69 $query = "SELECT * FROM `registrations` WHERE id=" . $id;
70 $result = mysql_query($query);
71 $row = mysql_fetch_object($result);
72 return $row;
85 $query = "DELETE FROM `miniproject`.`registrations` WHERE `registrations`.`id` =" . $id;
87 $result = mysql_query($query);
89 // var_dump($result);
professors.php (https://github.com/zerohun/Im-professor.git) PHP · 192 lines
deleteCMS_HISTORY_RESOURCES.php (https://github.com/juddy/GIP.git) PHP · 91 lines
hourlySales.php (https://github.com/maxolasersquad/FLOSS-POS.git) PHP · 116 lines
1 <html>
2 <?php
3 if(isset($_POST['submit'])){
4 foreach ($_POST AS $key => $value) {
71 ORDER BY hour";
73 $result1 = mysql_query($query1);
74 $result2 = mysql_query($query2);
75 $result3 = mysql_query($transCountQ);
76 $num1 = mysql_num_rows($result1);
77 $num2 = mysql_num_rows($result3);
91 $percentage = money_format('%i',100 * $portSales);
92 echo "<tr><td align='center'>".$row1[0]."</td><td align='right'>".$row1[1]."</td>";
93 echo "<td><img src=../image.php?size=$twoperSales></td>";
94 echo "<td align='right'>".$percentage." %</td>";
95 echo "<td align='right'>".$count."</td></tr>";
consoles.php (https://github.com/Markkaz/Spelcodes.git) PHP · 162 lines
1 <?php
2 error_reporting(E_ALL & ~E_DEPRECATED);
6 /* Classes importeren */
7 include_once('Classes/User.php');
8 include_once('Classes/Template.php');
10 /* Includes importeren */
11 include_once('Includes/connect.php');
12 include_once('Includes/slashes.php');
21 if (isset($_GET['id'])) {
22 include('Includes/login.php');
24 $cTPL->setFile('CONTENT', 'Templates/consoles.tpl');
index.php (https://gitlab.com/msdusad/all_ones) PHP · 82 lines
1 <?php
2 session_start();
3 include('conn.php');
5 $select="select * from login_detail where username='".$_POST['username']."' and password='".$_POST['password']."'";
6 $view=mysql_query($select) or die("Error in Insert plantype Table".mysql_error());
7 $num=mysql_fetch_array($view);
8 if($num>0)
12 $_SESSION['loguser'] = $num['username'];
13 $_SESSION['pass'] = $num['password'];
14 header('location:dashboard.php');
15 }
16 else
emsuser.php (https://gitlab.com/msdusad/all_ones) PHP · 92 lines
18 ?>
20 <?php include("header.php");?>
21 <div style="clear:both;"></div>
22 <div class="rightpanel" style="clear:both;">
31 <div class="dropdown userinfo">
32 <a class="dropdown-toggle" data-toggle="dropdown" data-target="#" href="#">
33 Welcome <b><?php echo $_SESSION['username']?></b>
35 <b class="caret"></b></a>
39 <li><a href="#"><span class="icon-eye-open"></span> Privacy Settings</a></li>
40 <li class="divider"></li>-->
41 <li><a href="sign_out.php"><span class="icon-off"></span> Sign Out</a></li>
42 </ul>
43 </div><!--dropdown-->
67 ?>
68 <tr>
69 <td><a href="show_users.php?sid=<?= $fetch['id'];?>"><?php echo $i;?></a></td>
70 <td><?php echo $fetch['username'];?></td>
opclass.php (https://bitbucket.org/f0vela/phpchat.git) PHP · 210 lines
1 <?php
2 class OpClass
3 {
20 $query .= " WHERE userID = ". $data['userID'];
22 $re = mysql_query($query);
24 fSession::set('name',$data['name']);
34 $newpass = fCryptography::hashPassword($data['password']);
35 $query = "INSERT INTO chat_admin (name,email,usertype,status,password,aspID) VALUES ('".$data['name']."', '".$data['email']."','". $data['usertype'] ."','". $data['status'] ."','". $newpass ."','1')";
36 $re = mysql_query($query);
37 $ret = mysql_insert_id($link);
38 return $ret;
46 $query .= " WHERE userID = ". $data['userID'];
48 $re = mysql_query($query);
50 }
index.php (https://github.com/FriedWishes/showslow.git) PHP · 178 lines
1 <?php
2 require_once(dirname(dirname(dirname(__FILE__))).'/global.php');
9 mysql_real_escape_string($url_id)
10 );
11 $result = mysql_query($query);
13 if (!$result) {
16 }
18 $post_data = file_get_contents("php://input");
19 $post = json_decode($post_data, true);
169 <h2>Configure your WebPageTest instance</h2>
170 <p><b style="color: red">WARNING! Only use this beacon If you're OK with all your WebPageTest data to be recorded by this instance of ShowSlow and displayed at <a href="<?php echo $showslow_base?>"><?php echo $showslow_base?></a><br/>You can also <a href="http://www.showslow.org/Installation_and_configuration">install ShowSlow on your own server</a> to limit the risk.</b></p>
172 <?php
download_3_2.php (https://gitlab.com/optimistic_mamun/project1) PHP · 276 lines
1 <?php ob_start();?>
2 <?php session_start();
4 $roll=$_SESSION['roll'];
6 include('connect.php');
7 $query = "SELECT * FROM ice_3_2 WHERE roll='$roll'";
8 $result = mysql_query($query) or die(mysql_error());
29 }
30 ?>
31 <?php
32 include('connect.php');
33 $query1 = "SELECT * FROM reg_info WHERE roll='$roll'";
34 $result1 = mysql_query($query1) or die(mysql_error());
35 $count1 = mysql_num_rows($result1);
36 while ($row1 = mysql_fetch_array($result1)) {
lap_order_qty.php (https://github.com/jonlord1012/srmis.git) PHP · 135 lines
1 <?php
3 // nama file
4 include "../include/koneksi.php";
5 $namaFile = "lap_order_qty.xls";
6 $tgl = date("d/m/Y");
83 $query = "SELECT * FROM ms_barang,quantity WHERE ms_barang.kd_barang=quantity.barang_id ORDER BY quantity.barang_id ASC";
84 $hasil = mysql_query($query);
86 // nilai awal untuk baris cell
94 // menampilkan no. urut data
96 /* $q_spb = mysql_query("SELECT * FROM detail_spb WHERE LAST_INSERT_ID(barang_id) AND barang_id = '$data[0]' ORDER BY barang_id DESC LIMIT 1");
97 $r_spb = mysql_fetch_array($q_spb);
lich-su-game.php (https://gitlab.com/phamngsinh/baitaplon_sinhvien) PHP · 100 lines
1 <? include ('class.php');?>
2 <title>Lịch sử danh sách những người đã đặt lệnh chơi - <?=title?></title>
3 <div class="box_sms" style="padding-top:6px">
18 </tr>
19 <?
20 $sql = mysql_query("select date_format(time,'%d-%m-%Y') as ngay,time,couples,xeng,type,port,idmember from ".predict." order by time desc");
21 if(mysql_num_rows($sql)>0){
22 $i=0; $demkq=0;
kqxsmn.php (https://gitlab.com/phamngsinh/baitaplon_sinhvien) PHP · 111 lines
1 <?
2 include ('domain.php');
3 include ('define_data.php');
4 include ('config.php');
5 include ('class.php');
50 }
51 //danh muc chinh
52 $sqlstr = mysql_query("select id,category from ".menu_product." where status='true' and parent='0' order by stthome limit 2,1");
53 if(mysql_num_rows($sqlstr)>0){
54 $row=mysql_fetch_assoc($sqlstr);
58 <?
59 foreach($arr_miennam as $tinhmn){
60 $sql = mysql_query("select date_format(postdate,'%d/%m/%Y') as ngay,result,province from ".result." where province = '".$tinhmn."' order by postdate desc");
61 if(mysql_num_rows($sql)>0){
62 $rs=mysql_fetch_assoc($sql);
78 <tr <?php echo $k==0?'class="bg_yellow"':''; ?>>
79 <td <?php echo $k==0?'width="26%"':'class="text-left"'; ?>><strong <?php echo $k==0?'class="clred"':''; ?>><?=$giai[$k]?></strong></td>
80 <td <?php echo $k==0?'width="74%"':''; ?>><strong <?php echo $k==0?'class="clred"':''; ?>><?=$chuoi?></strong></td>
filter.php (https://gitlab.com/phamngsinh/baitaplon_sinhvien) PHP · 81 lines
1 <?php
2 /*
3 ////////////////////////////////////////////////////////////////////////////////
14 defined('_IN_JOHNCMS') or die('Error: restricted access');
15 require('../incfiles/head.php');
16 if (!$id) {
17 echo functions::display_error($lng['error_wrong_data'], '<a href="index.php">' . $lng['to_forum'] . '</a>');
18 require('../incfiles/end.php');
19 exit;
20 }
28 unset($_SESSION['fsort_id']);
29 unset($_SESSION['fsort_users']);
30 header("Location: index.php?id=$id");
31 break;
buscar_zona_proceso.php (https://github.com/cabenitez/factuweb.git) PHP · 97 lines
11 $estilo_pag_info = "caja"; //OPCIONAL Cadena. Contiene el nombre del estilo CSS para la pagina actual.
13 include("paginador.php"); //OBLIGATORIO Incluimos el script de paginaci�n. �ste ya ejecuta la consulta autom�ticamente
14 //---------------------Fin Paginacion------------------------------------------------------------------------------------//
15 if($pag_filas > 0){
56 $consulta_cliente= "select cod_cliente from cliente where cod_zona = $codigo"; // consulta en la base de datos si ya no se ha registrado el stock inicial
57 $result_cliente = mysql_query($consulta_cliente); // hace la consulta
58 $nfilas_cliente = mysql_num_rows ($result_cliente); //indica la cantidad de resultados
88 $consulta_informe = ereg_replace("'","@@",$consulta_informe);
90 include('consulta_session.php'); // crea el div y el id de session del sql
91 //================================ FIN DE OBTIENE LA CONSULTA PARA IMPRIMIR ===========================================================================//
getCities.php
(http://ebpls.googlecode.com/svn/trunk/)
PHP · 129 lines
✨ Summary
This PHP code generates a dropdown menu with options based on user input from GET requests. It queries a database to retrieve data for provinces, cities, districts, barangays, and zones, and then populates an HTML select element with these options. The selected value is determined by the user’s input or default values.
This PHP code generates a dropdown menu with options based on user input from GET requests. It queries a database to retrieve data for provinces, cities, districts, barangays, and zones, and then populates an HTML select element with these options. The selected value is determined by the user’s input or default values.
1 <?php
2 include_once("includes/variables.php");
3 include_once("lib/multidbconnection.php");
4 include_once "lib/ebpls.utils.php";
17 echo "obj.options[obj.options.length] = new Option('-Please Select City-','');\n";
18 $resultset = mysql_query("SELECT * FROM `ebpls_city_municipality`where upper='$prov'") or die(mysql_error()."dd");
19 while($datarow = @mysql_fetch_array($resultset))
20 {
38 echo "obj.options[obj.options.length] = new Option('-Please Select District-','');\n";
39 $resultset = mysql_query("SELECT * FROM ebpls_district where upper='$prov'") or die(mysql_error()."dd");
40 while($datarow = @mysql_fetch_array($resultset))
41 {
config.m4 (https://github.com/filp/php-src.git) m4 · 159 lines
43 fi
45 if test "$PHP_PDO_MYSQL" = "yes" || test "$PHP_PDO_MYSQL" = "mysqlnd"; then
46 dnl enables build of mysqnd library
47 PHP_MYSQLND_ENABLED=yes
108 PHP_ADD_LIBRARY(z,, PDO_MYSQL_SHARED_LIBADD)
109 PHP_CHECK_LIBRARY($PDO_MYSQL_LIBNAME, mysql_query, [], [
110 AC_MSG_ERROR([Try adding --with-zlib-dir=<DIR>. Please check config.log for more information.])
111 ], [
127 ],[
128 AC_MSG_CHECKING([for PDO includes])
129 if test -f $abs_srcdir/include/php/ext/pdo/php_pdo_driver.h; then
130 pdo_cv_inc_path=$abs_srcdir/ext
131 elif test -f $abs_srcdir/ext/pdo/php_pdo_driver.h; then
132 pdo_cv_inc_path=$abs_srcdir/ext
133 elif test -f $prefix/include/php/ext/pdo/php_pdo_driver.h; then
134 pdo_cv_inc_path=$prefix/include/php/ext
evaluatee_instructor.php (https://github.com/bpbielicki/Rate-Your-Mate.git) PHP · 163 lines
1 <?php include ("../includes/check_authorization.php");
2 error_reporting(-1);
4 include ("../includes/config.php");
5 include ("../includes/opendb.php");
6 $prjID = $_SESSION['prjID'];
7 $groupChangeFlag = 0;
37 <div id="menu">
38 <?php include ("../includes/instruct_menu.php"); ?>
39 </div>
44 <?php
45 // Get all groups for this project
46 $groupIDQuery = mysql_query ( " SELECT DISTINCT G.GrpID FROM Groups G WHERE
47 G.PrjID = ".$prjID) or die( 'Error could not retrieve the group list' );
48 $cnt = 1;