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';

4

5 require_once("../DBconfig.php");

6

7 function updateuserid()

8 {

9 $query="SELECT userid FROM users WHERE 1";

10 $result = mysql_query($query);

11

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

2

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 ?>

14

counters.php (https://gitlab.com/phamngsinh/baitaplon_sinhvien) PHP · 203 lines

1 <?php

2 /**

3 * @package JohnCMS

22 global $website;

23

24 $albumcount = mysql_result(mysql_query("SELECT COUNT(DISTINCT `user_id`) FROM `cms_album_files` WHERE `website` = '$website'"), 0);

25 $photocount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `website` = '$website'"), 0);

26 $newcount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND `time` > '" . (time() - 259200) . "' AND `access` > '1'"), 0);

27 return $albumcount . '&#160;/&#160;' . $photocount . ($newcount ? '&#160;/&#160;<span class="red"><a href="' . core::$system_set['homeurl'] . '/users/album.php?act=top">+' . $newcount . '</a></span>' : '');

37 global $website;

38

39 $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND `type` = 'file'"), 0);

40 $new = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND `time` > '" . (time() - 259200) . "' AND `type` = 'file'"), 0);

53 global $website;

54

55 $total_thm = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND `type` = 't'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0);

56 $total_msg = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND `type` = 'm'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0);

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 <?

38

39 $sql = "SELECT * FROM CMS_ONLINE_RESOURCES".$orderByQuery.$limitQuery;

40 $result = MYSQL_QUERY($sql);

41 $numberOfRows = MYSQL_NUM_ROWS($result);

42

63 ?>

64

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 <?

14

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 = "";

27

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 <?

38

39 $sql = "SELECT * FROM CMS_OFFLINE_RESOURCES".$orderByQuery.$limitQuery;

40 $result = MYSQL_QUERY($sql);

41 $numberOfRows = MYSQL_NUM_ROWS($result);

42

63 ?>

64

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

2

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";

265

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'";

25

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 }

37

46 $query = "UPDATE automarking SET SampleSoln='$sampleSoln', Configs='$configs', AssnID='$assnID' WHERE AutomarkID='$automarkID'";

47

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

33

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 }

14

25 mysql_select_db($dbname, $con);

26

27 mysql_query("UPDATE user set password='$newpassword' where fsuid='$fsuid'");

28 }

29

38 mysql_select_db($dbname, $con);

39

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.

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");

125

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)){

130

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

1 <?php

2 /**

3 * EyeMySQLAdap

115 public function query($query)

116 {

117 $result = mysql_query($query, $this->link);

118

119 $this->result = $result;

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);

47

69 // $SQL = "SELECT * FROM $table_name WHERE $clause";

70 //echo $SQL;die();

71 // $result = mysql_query($SQL);

72 // mysql_close($db_handle);

73

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);

99

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');

18

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>

29

30 <form name="menu" action="'.$PHP_SELF.'" method="post" class="opciones">

31

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'";}

13

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");

16

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;");

43

44 $ivers = 0;

93

94

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;");

96

97

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'];?>&nbsp;&nbsp;<?=$row['MNAME'];?>&nbsp;&nbsp;<?=$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);

22

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

2

3 import('lib/db/DBManager');

114 }

115

116 if (!mysql_query("SET CHARACTER SET ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");

117 if (!mysql_query("SET character_set_client = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");

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");

159

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

2

3 class MK_RecordModule extends MK_Record{

26 $config = MK_Config::getInstance();

27

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 }

38

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 }

63

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);

65

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

170

171 $q = "SELECT admin FROM {$CONFIG->dbprefix}users_entity WHERE guid = $guid";

172 $r = mysql_query($q);

173

174 $admin = mysql_fetch_assoc($r);

187

188 $q = "SELECT admin FROM {$CONFIG->dbprefix}users_entity WHERE guid = $guid";

189 $r = mysql_query($q);

190

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

2

3 if(!file_exists("connect.php")){

4 ob_start();

5 header( "Location: setup.php" );

6 ob_flush();

7 }

8

9 require("config.php");

10 require("connect.php");

11

12 $config=mysql_fetch_assoc(mysql_query("SELECT * FROM config WHERE id = '1'"));

13

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">

18

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

1 <?php // $Id$

2 if ( count( get_included_files() ) == 1 ) die( '---' );

3

243 WHERE `tool_id` <= 0";

244

245 $sql = mysql_query($req);

246

247 $res = mysql_fetch_assoc($sql);

255 WHERE `code` = '".$course_code."'";

256

257 $sql = mysql_query($req);

258

259 $res = mysql_fetch_assoc($sql);

mysql.idl.php (https://github.com/diegoIta/hiphop-php.git) PHP · 203 lines

1 <?php

2

3 include_once 'base.php';

93 'link_identifier' => array(Variant, 'null')));

94

95 f('mysql_query', Variant,

96 array('query' => String,

97 'link_identifier' => array(Variant, 'null')));

CMySQL.php (https://github.com/stargazers/CMySQL.git) PHP · 401 lines

1 <?php

2

3 /*

4 Class for using MySQL database with PHP.

5 Copyright (C) 2008, 2009, 2011 Aleksi Räsänen <aleksi.rasanen@runosydan.net>

6

96

97 // Execute query

98 $ret = @mysql_query( $query, $this->_connection );

99

100 // If there were error, throw Exception

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 }

88

96 MODIFY o_lang_dt int(10) UNSIGNED NOT NULL

97 ";

98 return mysql_query($sql, $this->getDBCon());

99 }

100

109 ) ". $this->getTableOptionsCode() . "

110 ";

111 return mysql_query($sql, $this->getDBCon());

112 }

113

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 <?

19

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 = "";

37

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.

105

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 {

21

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);

25

62

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);

66

77

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);

81

breadcrumbs.lib.php (https://github.com/akash6190/pragyan.git) PHP · 91 lines

1 <?php

2 if(!defined('__PRAGYAN_CMS'))

3 {

17

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);

32

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');

6

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 */

12

68 }

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

72 if ($ins)

110 $hours = round($hours, 2);

111

112 $upd = mysql_query("UPDATE timetracker SET task='$task',comment='$comment',started='$started',ended='$ended',hours='$hours' WHERE ID = $id");

113

114 if ($upd)

utlMySqlWork.php (https://github.com/fmake/fmake.git) PHP · 114 lines

1 <?php

2 namespace fmake\libs\dataBase;

3 function errorExit()

76

77 if($this->CurrentResult>1){ if(!$this->DoNotFreeResult){ mysql_free_result($this->CurrentResult); }}

78 $this->CurrentResult=mysql_query($ss,$this->Connection_id);

79 $this->checkError($ss,$Line);

80 return $this->CurrentResult;

utlMySqlWork.php (https://github.com/fmake/fmake.git) PHP · 114 lines

1 <?php

2

3 function errorExit()

76

77 if($this->CurrentResult>1){ if(!$this->DoNotFreeResult){ mysql_free_result($this->CurrentResult); }}

78 $this->CurrentResult=mysql_query($ss,$this->Connection_id);

79 $this->checkError($ss,$Line);

80 return $this->CurrentResult;

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

6

7 include( "config_mgr.php" );

8

9 if($_SESSION['access_type'] != "mgr"){ echo "Operation cannot be performed in demo mode"; exit; }

10

11 $settings_result = mysql_query("SELECT * FROM settings where id = '1'", $db);

12 $setting = mysql_fetch_object($settings_result);

13

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);

30

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>

94

95 <?php include("footer.php"); ?>

96 </div>

97

class.engine.php (https://github.com/NoVatutz/RevCMS.git) PHP · 134 lines

1 <?php

2

3 namespace Revolution;

19 $this->setMySQL('pconnect', @mysql_pconnect);

20 $this->setMysql('select_db', @mysql_select_db);

21 $this->setMySQL('query', @mysql_query);

22 $this->setMySQL('num_rows', @mysql_num_rows);

23 $this->setMySQL('fetch_assoc', @mysql_fetch_assoc);

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 <?

19

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 = "";

37

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();

5

6

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();

15

16 if ($migrateAll) {

17 mysql_query("delete from transforms where transf_from != ''" .

18 "or transf_to != ''");

19 }

32

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++;

106

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();

4

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");

25

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

12

13 <?php

14

15 $q1=mysql_query("select count(uid) from students") or die(mysql_error());

16 $q2=mysql_query("select count(id) from guest") or die(mysql_error());

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']);

11

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 <?

38

39 $sql = "SELECT * FROM CMS_PROJECTS".$orderByQuery.$limitQuery;

40 $result = MYSQL_QUERY($sql);

41 $numberOfRows = MYSQL_NUM_ROWS($result);

42

63 ?>

64

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

4

5

6 /* SQL specific functions call for users.php */

7

8 // connect to server

9 include ("../sqlfuncs.php");

10

11 // open a connection to mysql

18 $query = "SELECT * FROM COUNTRY ORDER BY COUNTRY_DESC ASC";

19

20 $mysql_result = mysql_query($query, $mysql_link);

21

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++;

106

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

2 <?php session_start(); ?>

3 <html>

4 <?php include("../partes/head.php"); ?>

5 <body>

6 <?php include("../partes/header.php");

106

107

108 <?php include("../partes/scripts.php");

109

110 include("../partes/footer.php");

158

159

160 <?php include("../partes/scripts.php");

161

162 include("../partes/footer.php");

index.php (https://github.com/nylen/wesabe-balances.git) PHP · 136 lines

1 <?php

2

3 $time = microtime(true);

4

5 require_once 'settings.php';

6

7 $link = mysql_connect($db_server, $db_username, $db_password)

10 mysql_select_db($db_database) or die(mysql_error());

11

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

92

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 */

7

12 use PMA\libraries\dbi\DBIMysql;

13

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>

34

35 <?php require_once 'body_head.php';?>

36

37

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>

231

232 /* inject into database */

233 mysql_query( $query . $val_query);

234 }

235

276 {

277 $excel_timestamp = $xl_date - 25568;

278 $php_timestamp = mktime(0,0,0,1,$excel_timestamp,1970);

279

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...');

3

101 }

102

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);

112

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

2

3 $b = $_SERVER['REQUEST_URI'];

15 $http = "http://" . $_SERVER['HTTP_HOST'] . substr($b,0,strlen($b)-5);

16

17 require_once($root . "user/configuration.php");

18 require_once($root . "themes/".$theme."/configuration.php");

19 require_once($root . "functions/session.php");

20

21 if(is_numeric($id)) {

28

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));

35

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 */

15

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

8

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>

19

20 <h1>PHPspeed | <?php echo $_SERVER['HTTP_HOST']; ?></h1>

21

22 </header>

136

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>

143

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

2

3 //MySQL Connection Information

4 include('/home/phikai/boxee.thinkonezero.com/mysql_connect.inc.php');

5

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';");

10

11

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);

70

71 }

class.plugin.php (https://bitbucket.org/icarito/pmc) PHP · 255 lines

1 <?php

2

3 class plugin

27 $description = mysql_real_escape_string($description);

28

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);

60

78 {

79 $plugin = (int) $plugin;

80 $upd = mysql_query("UPDATE plugins SET state = 1 WHERE ID = $id");

81 }

82

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>

204

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());

19

20 $evalid = mysql_insert_id();

44

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 ";

63

64 $result = mysql_query($main_query);

65

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();

87

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 ?>

90

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");

6

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

2

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;

63

64

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 <?

38

39 $sql = "SELECT * FROM CMS_ONLINE_RESOURCE_RELATIONS".$orderByQuery.$limitQuery;

40 $result = MYSQL_QUERY($sql);

41 $numberOfRows = MYSQL_NUM_ROWS($result);

42

63 ?>

64

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 <?

38

39 $sql = "SELECT * FROM CMS_OFFLINE_RESOURCE_RELATIONS".$orderByQuery.$limitQuery;

40 $result = MYSQL_QUERY($sql);

41 $numberOfRows = MYSQL_NUM_ROWS($result);

42

63 ?>

64

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

1 <?php

2

3 // nama file

4 include "../include/koneksi.php";

5 $namaFile = "lap_ms_barang_kadaluarsa.xls";

6

81

82 $query = "SELECT * FROM ms_barang WHERE flags='9' ORDER BY ex_year,ex_month,ex_year ASC";

83 $hasil = mysql_query($query);

84

85 // nilai awal untuk baris cell

signup.php (https://github.com/dadepo/Padly.git) PHP · 148 lines

1 <?php

2

3

8 <link rel="stylesheet" type="text/css" href="padly/html/style/bootstrap.css" />

9

10 <form method="post" action="<?php echo APP_PATH;?>/auth.php" class="form-stacked" id="pd_signupform">

11

12 <fieldset>

15 <legend>Signup For Account</legend>

16

17 <?php

18

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){

18

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'";

14

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 }

27

32 $query = "DELETE FROM automarking WHERE AutomarkID = '$rowID'";

33

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"];

243

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"); ?>

34

35 <!-- BODY -->

36 <?php

37

38 include ('connect_to_database.php');

39 include ('cso_enrollment_functions.php');

40 $action = $_GET['by'];

41

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 . '&amp;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

2

3 /**

21 global $g_table_prefix;

22

23 $query = mysql_query("

24 SELECT *

25 FROM {$g_table_prefix}module_export_groups

30

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;

56

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");

12

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

2

3 class DB {

7

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(''); }

3

12

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 . "` (

43

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.

143 $xv = $getn[2];

144

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);

218

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());

222

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 &nbsp;<?php echo $ga = number_format($grandamt,2); ?></font></td></tr>

254 </table>

255

Registration.php (https://gitlab.com/swajib/MiniProject_Conception_B11) PHP · 284 lines

1 <?php

2

3 namespace App\BITM\SimpleRegistrationForm;

48

49 $query = "SELECT * FROM `registrations` WHERE deleted_at IS NULL";

50 $result = mysql_query($query);

51

52 while ($row = mysql_fetch_object($result)) {

68

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;

86

87 $result = mysql_query($query);

88

89 // var_dump($result);

professors.php (https://github.com/zerohun/Im-professor.git) PHP · 192 lines

1 <?php

2

3 require_once "model.php";

47 $this->professors[0]["infos"] = array();

48

49 $result = mysql_query($query);

50 $count = 0;

51 if($result){

deleteCMS_HISTORY_RESOURCES.php (https://github.com/juddy/GIP.git) PHP · 91 lines

1 <?php

2 include_once("../common/dbConnection.php");

3 include_once("../common/header.php");

4 ?>

5 <?php

23 <?

24 $sql = "DELETE FROM CMS_HISTORY_RESOURCES WHERE RESOURCE_ID = '$thisRESOURCE_ID'";

25 $result = MYSQL_QUERY($sql);

26

27 ?>

87 </table>

88

89 <?php

90 include_once("../common/footer.php");

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";

72

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);

3

5

6 /* Classes importeren */

7 include_once('Classes/User.php');

8 include_once('Classes/Template.php');

9

10 /* Includes importeren */

11 include_once('Includes/connect.php');

12 include_once('Includes/slashes.php');

20

21 if (isset($_GET['id'])) {

22 include('Includes/login.php');

23

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');

4

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 ?>

19

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>

34

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'];

21

22 $re = mysql_query($query);

23

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'];

47

48 $re = mysql_query($query);

49

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);

12

13 if (!$result) {

16 }

17

18 $post_data = file_get_contents("php://input");

19 $post = json_decode($post_data, true);

20

168

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>

171

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'];

5

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

2

3 // nama file

4 include "../include/koneksi.php";

5 $namaFile = "lap_order_qty.xls";

6 $tgl = date("d/m/Y");

82

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);

85

86 // nilai awal untuk baris cell

94 // menampilkan no. urut data

95

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);

98

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 ////////////////////////////////////////////////////////////////////////////////

13

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;

32

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.

12

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){

55

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

59

88 $consulta_informe = ereg_replace("'","@@",$consulta_informe);

89

90 include('consulta_session.php'); // crea el div y el id de session del sql

91 //================================ FIN DE OBTIENE LA CONSULTA PARA IMPRIMIR ===========================================================================//

92

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.

1 <?php

2 include_once("includes/variables.php");

3 include_once("lib/multidbconnection.php");

4 include_once "lib/ebpls.utils.php";

16

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 {

37

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

44

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);

3

4 include ("../includes/config.php");

5 include ("../includes/opendb.php");

6 $prjID = $_SESSION['prjID'];

7 $groupChangeFlag = 0;

36

37 <div id="menu">

38 <?php include ("../includes/instruct_menu.php"); ?>

39 </div>

40

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;