100+ results results for 'php mysql_query repo:rev22/timekoin' (330 ms)
1<?php
2require 'authorisation.php';
2require 'authorisation.php';
3require 'format.php';
4require 'hc.php';
19$query = "select *, unix_timestamp(comDateTo) as comUnixTo from tblCompetition where comPk=$comPk";
20$result = mysql_query($query) or die('Query failed: ' . mysql_error());
21$title = 'highcloud.net';
47 $id = accept_track($comUnixTo, $comContact);
48 redirect("tracklog_map.php?trackid=$id&comPk=$comPk&ok=1");
49 exit(0);
69<br><br>
70<?php
71function upload_track($file,$pilPk,$contact)
123 $query = "select pilPk, pilHGFA from tblPilot where pilLastName='$name'";
124 $result = mysql_query($query) or die('Query failed: ' . mysql_error());
125
ebpls_abstractcoll.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 260 lines
3define('FPDF_FONTPATH','font/');
4require('../ebpls-php-lib/html2pdf_lib/fpdf.php');
5include("../lib/phpFunctions-inc.php");
5include("../lib/phpFunctions-inc.php");
6include("../includes/variables.php");
7include("../lib/multidbconnection.php");
72
73 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference")
74 or die(mysql_error());
144 //check if line is paid
145 $lp = mysql_query("select * from ebpls_transaction_payment_or_details a, ebpls_transaction_payment_or b where a.trans_id='$owner_id' and a.payment_id='$business_id' and a.ts between '$date_from 00:00:00' and '$date_to 23:59:59' and a.or_no = b.or_no");
146 //echo "select * from tempbusnature where owner_id='$owner_id' and business_id='$business_id' and recpaid='1'";
146 //echo "select * from tempbusnature where owner_id='$owner_id' and business_id='$business_id' and recpaid='1'";
147 //$lp = mysql_query("select * from tempbusnature a, ebpls_buss_nature b, ebpls_transaction_payment_or_details c where owner_id='$owner_id' and business_id='$business_id' and recpaid='1' and a.bus_code=b.natureid and
148 //a.owner_id=c.trans_id and a.business_id=c.payment_id and c.ts between '$date_from 00:00:00' and '$date_to 23:59:59'");
heidelpay_response.php https://bitbucket.org/isaacoheneayisi/ecommerce.git | PHP | 190 lines
1<?php
2
9 * @copyright Copyright (C) Heidelberger Payment GmbH
10 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
11 */
12
13include('../../../../configuration.php');
14$config = new JConfig();
35
36$PATH = preg_replace('@plugins\/vmpayment\/heidelpay\/heidelpay\/heidelpay_response\.php@','', $_SERVER['SCRIPT_NAME']);
37$URL = $_SERVER['HTTP_HOST'] . $PATH ;
39
40$redirectURL = $Protocol.$URL.'index.php?option=com_virtuemart&view=pluginresponse&task=pluginresponsereceived&on='.$_GET['on'].'&pm='.$_GET['pm'].'&Itemid='.$_GET['Itemid'];
41$cancelURL = $Protocol.$URL.'index.php?option=com_virtuemart&view=pluginresponse&task=pluginUserPaymentCancel&on='.$_GET['on'].'&pm='.$_GET['pm'].'&Itemid='.$_GET['Itemid'];
48 mysql_select_db($connect->db);
49 $result = mysql_query("SELECT virtuemart_order_id FROM ".$connect->dbprefix."virtuemart_orders"." WHERE order_number = '".mysql_real_escape_string($orderID)."';");
50 $row = mysql_fetch_object($result);
ebpls_bus_indtaxdelinquent.html http://ebpls.googlecode.com/svn/trunk/ | HTML | 199 lines
3require_once("lib/ebpls.utils.php");
4require_once("ebpls-php-lib/utils/ebpls.search.funcs.php");
5//require_once("includes/eBPLS_header.php");
10
11<?php
12echo date("F dS Y h:i:s A");
126 // unang gawang tama
127 $result=mysql_query("select ' ', ' ', ' ' , ' ', ' '
128 from ebpls_business_enterprise") or die(mysql_error());
131 /* sample/test ko lng
132 $result=mysql_query("select a.owner_id, a.business_name, a.business_city_code, a.business_type_code,
133 a.business_street, a.business_capital_investment, a.business_last_yrs_dec_gross_sales, b.fee_amount,
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>
ebpls_ctc_issued.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 214 lines
3define('FPDF_FONTPATH','font/');
4require('../ebpls-php-lib/html2pdf_lib/fpdf.php');
5include("../lib/phpFunctions-inc.php");
76
77include'../includes/variables.php';
78
78
79include_once("../lib/multidbconnection.php");
80
87$getlgu = @mysql_fetch_row($getlgu);
88$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'");
89$getprov = @mysql_fetch_row($getprov);
115$date_to = date('Y-m-d', $xdate);
116 $result1=mysql_query("select concat(ctc_first_name, ' ', ctc_middle_name, ' ', ctc_last_name) as name, ctc_code,
117 ctc_address, ctc_date_issued, ctc_tax_due, ctc_tax_interest, ctc_additional_tax1, ctc_additional_tax2, ctc_additional_tax3 from ebpls_ctc_individual where ctc_date_issued between '$date_from' and '$date_to' order by name asc")
Database.singleton.php https://code.google.com/p/gctour/ | PHP | 311 lines
1<?php
2# Name: Database.singleton.php
26
27//require("config.inc.php");
28//$db = Database::obtain(DB_SERVER, DB_USER, DB_PASS, DB_DATABASE);
132 // do query
133 $this->query_id = @mysql_query($sql, $this->link_id);
134
296 <tr><th colspan=2>Database Error</th></tr>
297 <tr><td align="right" valign="top">Message:</td><td><?php echo $msg; ?></td></tr>
298 <?php if(!empty($this->error)) echo '<tr><td align="right" valign="top" nowrap>MySQL Error:</td><td>'.$this->error.'</td></tr>'; ?>
298 <?php if(!empty($this->error)) echo '<tr><td align="right" valign="top" nowrap>MySQL Error:</td><td>'.$this->error.'</td></tr>'; ?>
299 <tr><td align="right">Date:</td><td><?php echo date("l, F j, Y \a\\t g:i:s A"); ?></td></tr>
300 <?php if(!empty($_SERVER['REQUEST_URI'])) echo '<tr><td align="right">Script:</td><td><a href="'.$_SERVER['REQUEST_URI'].'">'.$_SERVER['REQUEST_URI'].'</a></td></tr>'; ?>
300 <?php if(!empty($_SERVER['REQUEST_URI'])) echo '<tr><td align="right">Script:</td><td><a href="'.$_SERVER['REQUEST_URI'].'">'.$_SERVER['REQUEST_URI'].'</a></td></tr>'; ?>
301 <?php if(!empty($_SERVER['HTTP_REFERER'])) echo '<tr><td align="right">Referer:</td><td><a href="'.$_SERVER['HTTP_REFERER'].'">'.$_SERVER['HTTP_REFERER'].'</a></td></tr>'; ?>
302 </table>
companyclass.php https://github.com/samsonnguyen/CPSC471carinsurance.git | PHP | 280 lines
34 static function getAllCompanies($selection){
35 $companies = mysql_query("SELECT * FROM `Company`");// or die(mysql_error());
36 if($companies != null){
89 }
90 return mysql_query($sql);
91 }
155 if (($info['Commercial_License_No']!=null) && ($info['Commercial_License_No']!=0)){
156 print "<td><a href='company.php?action=update&company=".$info['Commercial_License_No']."'>".$info['Commercial_License_No']."</a>\n</td>";
157 } else {
166 print "<td>".$info['Manager']."</td>";
167 print "<td><a href='policy.php?action=update&policy=".$info['Policy_No']."&type=0'>".$info['Policy_No']."</a>\n</td>";
168 $this->printOptions($info['Commercial_License_No']);
174 function printOptions($companyno){
175 print "<td><a href=\"company.php?action=remove&company=$companyno\">X</a></td><td> <a href=\"company.php?action=update&company=$companyno\">Edit</a></td>\n";
176 }
spo.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 218 lines
19 <?php while($rowPle=mysql_fetch_array($quePle)) { ?>
20 <option value="<?php echo $rowPle['id_localitate']; ?>" <?php if($_GET['plecare']==$rowPle['id_localitate']) { ?> selected="selected" <?php } ?>><?php echo $rowPle['nume']; ?></option>
21 <?php } @mysql_free_result($quePle); ?>
29 <?php while($rowPle=mysql_fetch_array($quePle)) { ?>
30 <option value="<?php echo $rowPle['id_tara']; ?>" <?php if($_GET['tara']==$rowPle['id_tara']) { ?> selected="selected" <?php } ?>><?php echo $rowPle['nume']; ?></option>
31 <?php } @mysql_free_result($quePle); ?>
190 $i++; ?>
191 <tr class="normal" onmouseout="this.className='normal'; if(document.getElementById('tools<?php echo $row['id']; ?>').style.visibility == 'visible'){ document.getElementById('tools<?php echo $row['id']; ?>').style.visibility = 'hidden'; }" onmouseover="this.className='hover'; if(document.getElementById('tools<?php echo $row['id']; ?>').style.visibility == 'hidden'){ document.getElementById('tools<?php echo $row['id']; ?>').style.visibility = 'visible'; }else{ document.getElementById('tools<?php echo $row['id']; ?>').style.display = 'hidden'; }">
192 <td align="right" valign="top"><?php echo $i; ?></td>
195 <div style="visibility:hidden;" id="tools<?php echo $row['id']; ?>" class="tools">
196 <a href="preturi_teztour.php?pas=2&spo=<?php echo $row['id']; ?>">Adauga</a> | <a href="javascript: if(confirm('Sunteti siguri ca doriti sa scoateti aceasta oferta din lista?')) document.location.href='/adm/preturi_teztour.php?plecare=<?php echo $_GET['plecare']; ?>&tara=<?php echo $_GET['tara']; ?>&nr_pagina=<?php echo $_GET['nr_pagina']; ?>&scoate=<?php echo $row['id']; ?>'; ">Scoateti din lista</a>
197 </div>
201 <td align="center" valign="top"><?php echo $row['data_start']." - ".$row['data_end']; ?></td>
202 <td align="center" valign="top">Tara: <?php echo $row['denumire_tara']; ?> <?php for($j=1;$j<=3;$j++) { if($row['zona'.$j]) { echo "<br/>Zona".$j.": "; $selZo="select zone.nume from zone where id_zona = '".$row['zona'.$j]."' "; $queZo=mysql_query($selZo, $conn_tz) or die(mysql_error()); $rowZo=mysql_fetch_array($queZo); @mysql_free_result($queZo); echo $rowZo['nume']; } } ?> </td>
203 <td align="center" valign="top"><?php echo $row['pret_minim_dbl']; ?></td>
mutate_htmlsnippet.dynamic.php https://github.com/garryn/evolution.git | PHP | 225 lines
132 <a href="#" onclick="documentDirty=false; document.mutate.save.click();">
133 <img src="<?php echo $_style["icons_save"]?>" /> <?php echo $_lang['save']?>
134 </a>
148 <?php } else { ?>
149 <li id="Button3"><a href="#" onclick="deletedocument();"><img src="<?php echo $_style["icons_delete_document"]?>" /> <?php echo $_lang['delete']?></a></li>
150 <?php } ?>
150 <?php } ?>
151 <li id="Button5"><a href="#" onclick="documentDirty=false;document.location.href='index.php?a=76';"><img src="<?php echo $_style["icons_cancel"] ?>" /> <?php echo $_lang['cancel']?></a></li>
152 </ul>
176 <td align="left" valign="top" style="padding-top:5px;"><span style="font-family:'Courier New', Courier, mono"> </span><input name="newcategory" type="text" maxlength="45" value="<?php echo isset($content['newcategory']) ? $content['newcategory'] : ''?>" class="inputBox" style="width:300px;" onChange="documentDirty=true;"></td></tr>
177 <tr><td align="left" colspan="2"><input name="locked" type="checkbox"<?php echo $content['locked'] == 1 || $content['locked'] == 'on' ? ' checked="checked"' : ''?> class="inputBox" value="on" /> <?php echo $_lang['lock_htmlsnippet']?>
178 <span class="comment"><?php echo $_lang['lock_htmlsnippet_msg']?></span></td></tr>
189 <select id="which_editor" name="which_editor" onchange="changeRTE();">
190 <option value="none"<?php echo $which_editor == 'none' ? ' selected="selected"' : ''?>><?php echo $_lang['none']?></option>
191 <?php
class.eyemysqladap.inc.php https://github.com/kevinroberts/snippetz.git | PHP | 438 lines
1<?php
2/**
116 {
117 $result = mysql_query($query, $this->link);
118
mysql.php http://seo-phpbb.googlecode.com/svn/trunk/ | PHP | 479 lines
4* @package dbal
5* @version $Id: mysql.php 8479 2008-03-29 00:22:48Z naderman $
6* @copyright (c) 2005 phpBB Group
13*/
14if (!defined('IN_PHPBB'))
15{
18
19include_once($phpbb_root_path . 'includes/db/dbal.' . $phpEx);
20
82 $mode = implode(',', $modes);
83 @mysql_query("SET SESSION sql_mode='{$mode}'", $this->db_connect_id);
84 }
114 case 'begin':
115 return @mysql_query('BEGIN', $this->db_connect_id);
116 break;
parsetodb.php https://gitlab.com/bjwebb-codedump/plingconica.git | PHP | 219 lines
1<?php
2/**
19
20require_once "config.php";
21$con = mysql_connect($db_host,$db_name,$db_pass);
28define('LACONICA', true);
29require_once "../lib/common.php";
30
33
34 if ($result = mysql_query("SELECT * FROM `".$tablename."` WHERE id='".$array["id"]."'", $con));
35 else die(mysql_error());
66 if ($query) {
67 if (mysql_query($query));
68 else {
211$days = 7;
212#echo "http://feeds.plings.net/xml.activity.php/$days?APIKey=$apikey";
213$feed = file_get_contents("plingconica.xml");
class.Ticker.inc.php http://flaimo-php.googlecode.com/svn/trunk/ | PHP | 266 lines
1<?php
2
2
3include_once 'class.TickerBase.inc.php';
4include_once 'class.TickerMessage.inc.php';
124 $message,
125 'From: ' . $GLOBALS[TICKER_GLOBALNAME]['Mailbox']['email'] . "\r\n" . 'X-Mailer: PHP/' . phpversion());
126 */
211 $sql .= ' VALUES (' . $tm->getTimestamp() . ',"' . addslashes($tm->getText()) . '");';
212 $result = mysql_query($sql, $this->conn) or die ('Request not possible! SQL Statement: ' . $sql . ' / ' . mysql_error());
213 } // end function
events.php https://github.com/cybernet/CyBerFuN-CoDeX.git | PHP | 272 lines
1<?php
2require_once("include/bittorrent.php");
2require_once("include/bittorrent.php");
3require_once ("include/user_functions.php");
4require_once ("include/bbcode_functions.php");
4require_once ("include/bbcode_functions.php");
5require_once("include/function_bonus.php");
6dbconn();
10 // moddifed logginorreturn by retro//Remember to change the following line to match your server
11 print("<html><h1>Not Found</h1><p>The requested URL /{$_SERVER['PHP_SELF']} was not found on this server.</p><hr /><address>Apache/1.1.11 ".$SITENAME." Server at " . $_SERVER['SERVER_NAME'] . " Port 80</address></body></html>\n");
12 die();
100}
101<?php
102exit();
114$sql = "DELETE FROM `events` WHERE `id` = $id LIMIT 1;";
115$res = mysql_query($sql);
116if(mysql_error()!=0)
install.php https://code.google.com/p/ezrpg/ | PHP | 340 lines
1<?php
2error_reporting(0);
3define('IN_EZRPG', true);
4include './lib/func.rand.php';
5
43{
44 if (!is_writable('config.php') || !is_writable('smarty/templates_c'))
45 {
48 echo '<p>Please make sure the following files and folders are writable:';
49 echo '<strong>config.php</strong><br />';
50 echo '<strong>smarty/templates_c</strong><br />';
59 echo '<br />Chmod those files and folders to 0755 or 0777.</p>';
60 echo '<p><a href="install.php">Click here to check again</a></p>';
61 displayFooter();
68 echo '<p>You have given the files/folders the correct file permissions.</p>';
69 echo '<p><a href="install.php?act=2">Continue to next step</a></p>';
70 displayFooter();
student_2.php https://bitbucket.org/deba666/accitsoftware.git | PHP | 93 lines
1<?php
2 /*
54 <tbody>
55 <?php $std_row="select * from student ORDER BY STUD_NO DESC";
56 $q=mysql_query($std_row);
64 <td class=" "><?=$row['GENDER'];?></td>
65 <?php
66 $originalDate5 = $row['DOB'];
67 $newDate5 = date("d/m/y", strtotime($originalDate5)); ?>
68 <td class=" "><?php echo $newDate5 ?></td>
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>
74 <?php } ?>
75 </tbody>
postfooter.php https://github.com/karlforshaw/One-Panel.git | PHP | 217 lines
1<?php
2
63 $sql .= 'LIMIT 3';
64 $result = mysql_query( $sql );
65
functions_db.php https://github.com/justinmc/turkiball.com.git | PHP | 389 lines
1<?php
2
34
35 $QUERY = mysql_query("SELECT * FROM $table WHERE Index = '$index'");
36 $DATA = mysql_fetch_array($QUERY);
54
55 $QUERY = mysql_query("SELECT * FROM $table WHERE `Index` = $index");
56 $DATA = mysql_fetch_array($QUERY);
74
75 $QUERY = mysql_query("SELECT * FROM smf_messages WHERE ID_MSG = $id");
76 $DATA = mysql_fetch_array($QUERY);
94
95 $QUERY = mysql_query("SELECT * FROM smf_members WHERE ID_MEMBER = $id");
96 $DATA = mysql_fetch_array($QUERY);
123 {
124 $QUERY = mysql_query("SELECT * FROM smf_members WHERE ID_MEMBER = $count");
125 $DATA = mysql_fetch_array($QUERY);
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 ";
2$sel_hoteluri = "SELECT Accommodation_UnitID, Accommodation_Name, Accommodation_Stars, Accommodation_City_Name, Accommodation_City_ID FROM preturi_transilvania GROUP BY Accommodation_UnitID ";
3$que_hoteluri = mysql_query($sel_hoteluri);
4while($row_hoteluri = mysql_fetch_array($que_hoteluri)) {
15 $sel_loc = "SELECT * FROM localitati_corespondent WHERE nume_furnizor = '".$hotels['localitate'][$key]."' AND code_furnizor = '".$hotels['localitate_id'][$key]."' AND id_furnizor = '".$id_furnizor."' ";
16 $que_loc = mysql_query($sel_loc);
17 $row_loc = mysql_fetch_array($que_loc);
19 $ins_city = "INSERT INTO localitati_corespondent (nume_furnizor, code_furnizor, id_furnizor) VALUES ('".$hotels['localitate'][$key]."', '".$hotels['localitate_id'][$key]."', '".$id_furnizor."') ";
20 $que_city = mysql_query($ins_city) or die(mysql_error());
21 @mysql_free_result($que_city);
23 $sel_oras = "SELECT id FROM localitati_corespondent WHERE nume_furnizor = '".$hotels['localitate'][$key]."' AND code_furnizor = '".$hotels['localitate_id'][$key]."' AND id_furnizor = '".$id_furnizor."' ";
24 $que_oras = mysql_query($sel_oras);
25 $row_oras = mysql_fetch_array($que_oras);
34 $sel_hotels = "SELECT * FROM import_hoteluri WHERE nume_hotel = '".$value."' AND stele_hotel = '".$hotels['stele'][$key]."' AND city = '".$hotel_city."' ";
35 $que_hotels = mysql_query($sel_hotels);
36 $row_hotels = mysql_fetch_array($que_hotels);
core.php https://github.com/rezamoussavi/MouRe.git | PHP | 351 lines
1<?php
2
25 if(!$osdbcon){ $_result=null; return;}
26 $_result= mysql_query(parseQuery($caller,$s),$osdbcon);
27 }
29 global $osdbcon,$_result;
30 if(!($_result= $osdbcon? mysql_query($s,$osdbcon):false)){
31 osLog("os","query()","calling mysql_query() <b><font color=red>ERROR</font><br />Query:</b><br />".$s);
hours.inc.php https://bitbucket.org/websightdesigns/project-manager.git | PHP | 256 lines
8 </a>
9 <a class="brand" href="<?php echo $basehref; ?>images/">Hours</a>
10 <div class="nav-collapse nav-images-collapse collapse">
36<!--
37<?php
38 if(!isset($_POST['doAddHours'])) $_POST['doAddHours'] = "0";
60 //echo $insert_sql . "<br />";
61 $q = mysql_query($insert_sql);
62 //$_SESSION["command_results"]["addhours"] = "Your hours were added.";
81 $project_sql = "SELECT id FROM projects WHERE project_name LIKE '%" . str_replace($search_project, "", $_POST['search']) . "%'";
82 $project_q = mysql_query($project_sql);
83 while($i = mysql_fetch_object($project_q)) {
107 $client_sql = "SELECT id FROM clients WHERE fullname LIKE '%" . str_replace($search_client, "", $_POST['search']) . "%'";
108 $client_q = mysql_query($client_sql);
109 while($i = mysql_fetch_object($client_q)) {
searchFriend.php http://projetwebdubail.googlecode.com/svn/trunk/ | PHP | 255 lines
3--->
4<?php
5if(isset($_SESSION['isConnected']) && $_SESSION['isConnected'])
15 <tr>
16 <form method="post" action="index.php?cat=searchFriend" name="submitSearch">
17 <td/>
56 --->
57 <?php
58
104
105 $data=mysql_query($sql, $link);
106
138 </tr>
139 <?php
140 while($row=mysql_fetch_array($data))
trainingNaiveBayes.php https://bitbucket.org/astahiam/penduduk.git | PHP | 300 lines
1<?php
2include('header.php');
2include('header.php');
3include('menukiri.php');
4 //Open database connection
15 <div class="module_content">
16<form action="trainingDataNaiveBayes.php" method="post"
17 enctype="multipart/form-data">
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";
30 $hasilSelect = mysql_query($tabel) or die (mysql_error());
31 $jumlahRow = mysql_num_rows($hasilSelect);
32 ?>
33 jumlah data: <?php echo $jumlahRow; ?>
34
editproduct.php https://bitbucket.org/shikhaupadhyay/advt.git | PHP | 208 lines
1<?php include('includes/header.php');
2$imgurl = $dbfn->siteUrl().'proimages/';
37 }
38 echo "<script>window.location.href='products.php?msg=upd'</script>";
39
124
125 <input type="text" class="form-control" placeholder="Enter price" style='width:65%' name="price" value="<?php echo $row->price;?>">
126
133 $sqltype="select * from product_type where ProductId=".$row->id;
134 $restype=mysql_query($sqltype);
135 $rowtype=mysql_fetch_array($restype);
161 <?php while($cat = mysql_fetch_object($catquery)){?>
162 <option value="<?php echo $cat->id;?>" <?php if($cat->id==$row->cid){echo 'selected';}?>><?php echo $cat->title;?></option>
163 <?php }?>
205
206<?php include('includes/footer.php');?>
207
themes.php http://novaboard.googlecode.com/svn/trunk/ | PHP | 487 lines
1<?php
2/*
9| ========================================
|+--------------------------------------------------------------------------
10| themes.php - install/remove forum themes
11
18
19require_once "scripts/php/dUnzip2.inc.php";
20
20
21template_hook("pages/admin/themes.template.php", "start");
22
24
25 nova_redirect("index.php?page=error&error=11","error/11");
26
82
83 template_hook("pages/admin/themes.template.php", "form_1");
84
user.php https://github.com/carlosefonseca/ER-client-webapp.git | PHP | 215 lines
30 global $client;
31 require_once(u("DBconnect.php"));
32 /* Add slashes if necessary (for query) */
48
49 $result = mysql_query($q);
50 if(!$result || (mysql_num_rows($result) != 1)){
198 /* Quick self-redirect to avoid resending data on refresh */
199 //echo "<meta http-equiv=\"Refresh\" content=\"0;url=$HTTP_SERVER_VARS[PHP_SELF]\">";
200 header("Location: $_SERVER[PHP_SELF]");
tara_new.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 340 lines
10
11 <h3><a href="<?php echo $link; ?>" class="link vtip" title="Sejur <?php echo $rowl['denumire']; ?>"><?php echo $rowl['denumire']; ?></a></h3>
12
14
15 <img src="<?php echo $sitepath_parinte.'thumb_localitate/'.$rowl['poza1']; ?>" width="240" height="100" alt="<?php echo $rowl['denumire'].' din '.$zona.' - '.ucwords($tara); ?>" onclick="location.href='<?php echo $link; ?>';" />
16
30
31 <a href="<?php echo $link_t; ?>" class="link-red" title="<?php echo $value_t['denumire'].' '.$rowl['denumire']; ?>"><strong><?php echo $value_t['denumire'].' '.$rowl['denumire']; ?></strong></a>
32
123
124 <a href="<?php echo $link_t; ?>" title="<?php echo $value_t['denumire'].' '.ucwords($tara); ?>"><?php echo $value_t['denumire'].' '.ucwords($tara); ?></a>
125
255
256 <a href="<?php echo $link_t; ?>" title="<?php echo $value_t['denumire'].' '.$rowZ['denumire'].'-'.ucwords($tara); ?>"><?php echo $value_t['denumire'].' '.$rowZ['denumire'].'-'.ucwords($tara); ?></a>
257
phorum.rb https://bitbucket.org/bitworkvn/cs_discourse.git | Ruby | 218 lines
30
31 total_count = mysql_query("SELECT count(*) count FROM #{TABLE_PREFIX}users;").first['count']
32
33 batches(BATCH_SIZE) do |offset|
34 results = mysql_query(
35 "SELECT user_id id, username, email, real_name name, date_added created_at,
59
60 categories = mysql_query("
61 SELECT forum_id id, name, description, active
76 # categories.each do |category|
77 # Permalink.create(url: "list.php?#{category['id']}", category_id: category_id_from_imported_category_id(category['id'].to_i))
78 # end
83
84 total_count = mysql_query("SELECT count(*) count from #{TABLE_PREFIX}messages").first["count"]
85
payment_info.php https://github.com/azeckoski/az-php-sandbox.git | PHP | 394 lines
16// connect to database
17require $ACCOUNTS_PATH.'sql/mysqlconnect.php';
18
42 $sql = "update conferences set activated='N' where id='".$_REQUEST['deactivate']."'";
43 $result = mysql_query($sql) or die("Update query failed ($sql): " . mysql_error());
44 }
79$count_sql = "select count(*) " . $from_sql . $sqlsearch;
80$result = mysql_query($count_sql) or die('Count query failed: ' . mysql_error());
81$row = mysql_fetch_array($result);
197</script>
198<?php include $ACCOUNTS_PATH.'include/header.php' ?>
199<div id="maindata">
393</div>
394<?php require $ACCOUNTS_PATH.'include/footer.php'; ?>
395
mysql.inc git://pkgs.fedoraproject.org/mrbs | PHP | 508 lines
57// a MIN or MAX aggregate function applied over no rows.
58function sql_mysql_query1 ($sql, $db_conn = null)
59{
61
62 $r = mysql_query($sql, $db_conn);
63 if (! $r)
83
84 $r = mysql_query($sql, $db_conn);
85 return $r;
189 global $sql_mysql_mutex_shutdown_registered, $sql_mysql_mutex_unlock_name;
190 if (!sql_mysql_query1("SELECT GET_LOCK('$name', 20)", $db_conn))
191 {
422 {
423 $length = defined('PHP_INT_MAX') ? PHP_INT_MAX : 9999;
424 }
index.php http://clients-oriented-ftp.googlecode.com/svn/trunk/ | PHP | 308 lines
53 <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
54 <title><?php echo $page_title_install; ?> » <?php echo SYSTEM_NAME; ?></title>
55 <link rel="shortcut icon" href="../favicon.ico" />
195 ?>
196 <p><?php _e('You may proceed to','cftp_admin'); ?> <a href="<?php echo $base_uri; ?>" target="_self"><?php _e('log in','cftp_admin'); ?></a> <?php _e('with your newely created username and password.','cftp_admin'); ?></p>
197 <?php
222 is_complete(this.install_user_username,'<?php echo $validation_no_user; ?>');
223 is_length(this.install_user_username,<?php echo MIN_USER_CHARS; ?>,<?php echo MAX_USER_CHARS; ?>,'<?php echo $validation_length_user; ?>');
224 is_alpha(this.install_user_username,'<?php echo $validation_alpha_user; ?>');
228 is_email(this.install_user_mail,'<?php echo $validation_invalid_mail; ?>');
229 is_length(this.install_user_pass,<?php echo MIN_USER_CHARS; ?>,<?php echo MAX_USER_CHARS; ?>,'<?php echo $validation_length_pass; ?>');
230 is_password(this.install_user_pass,'<?php $chars = addslashes($validation_valid_chars); echo $validation_valid_pass." ".$chars; ?>');
243 <h3><?php _e('Basic system options','cftp_admin'); ?></h3>
244 <p><?php _e("You need to provide this data for a correct system installation. The site name will be visible along the system panel, and the client's lists.<br />Don't forget to edit <em>/includes/sys.config.php</em> with your database settings before installing. If the file doesn't exist, you can create it by renanming the dummy file sys.config.sample.php.",'cftp_admin'); ?></p>
245 </li>
novoUsuario.php https://bitbucket.org/leopublic/dataweb.git | PHP | 242 lines
1<?php
2$opcao = "USU";
2$opcao = "USU";
3include ("../../LIB/autenticacao.php");
4include ("../../LIB/cabecalho.php");
4include ("../../LIB/cabecalho.php");
5include ("../../LIB/geral.php");
6include ("../../LIB/combos.php");
6include ("../../LIB/combos.php");
7include ("../javascript/novoUsuario_js.php");
8
32 $sql = $sql." from USUARIO as a, PERFIL as b where a.NU_PERFIL = b.NU_PERFIL and a.NU_USUARIO = $id ";
33 $resultado = mysql_query($sql);
34 if(mysql_errno() != 0) {
87 </tr>
88 <form action="insereUsuario.php" method="post" onSubmit="return validarDados(this)">
89 <input type="hidden" name="id" value='<?=$id?>'>
_liste_commandes_8inc_8php_source.html https://github.com/rcampistron/ParagrapheCMS.git | HTML | 64 lines
4<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
5<title>CMSCroisix: Fichier source de class/ListeCommandes.inc.php</title>
6<link href="tabs.css" rel="stylesheet" type="text/css"/>
13<div class="contents">
14<h1>ListeCommandes.inc.php</h1><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <?php
15<a name="l00008"></a><a class="code" href="class_liste_commandes.html">00008</a> <span class="keyword">class </span><a class="code" href="class_liste_commandes.html">ListeCommandes</a> <span class="keyword">implements</span> IteratorAggregate {
33<a name="l00061"></a>00061
34<a name="l00062"></a>00062 <span class="comment">/*if ($this->formation) $result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE if_bo_com.numcom=if_bo_detail.numcom AND if_bo_detail.designation='Inscription formation' $fin_req ORDER BY hcrea DESC");</span>
35<a name="l00063"></a>00063 <span class="comment"> else $result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE etat $this->etat $fin_req AND if_bo_com.numcom=if_bo_detail.numcom ORDER BY hcrea DESC");*/</span>
35<a name="l00063"></a>00063 <span class="comment"> else $result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE etat $this->etat $fin_req AND if_bo_com.numcom=if_bo_detail.numcom ORDER BY hcrea DESC");*/</span>
36<a name="l00064"></a>00064 <span class="keywordflow">if</span> ($this->formation) { $result=mysql_query(<span class="stringliteral">"SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE if_bo_com.numcom=if_bo_detail.numcom AND if_bo_detail.designation='Inscription formation' $fin_req ORDER BY hcrea DESC"</span>);
37<a name="l00065"></a>00065 } <span class="keywordflow">else</span> {
37<a name="l00065"></a>00065 } <span class="keywordflow">else</span> {
38<a name="l00066"></a>00066 <span class="comment">//$result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE etat $this->etat $fin_req AND if_bo_com.numcom=if_bo_detail.numcom ORDER BY hcrea DESC"); </span>
39<a name="l00067"></a>00067 $result=mysql_query(<span class="stringliteral">"SELECT if_bo_com.numcom FROM if_bo_com WHERE etat $this->etat $fin_req ORDER BY hcrea DESC"</span>);
MysqlAdapter.php https://github.com/andho/simdal.git | PHP | 301 lines
1<?php
2/**
80
81 mysql_query($sql, $this->_conn);
82
126
127 $query = mysql_query($sql, $this->_conn) or error_log(mysql_error($this->_conn), 0);
128
145
146 $query = mysql_query($sql, $this->_conn) or error_log(mysql_error($this->_conn), 0);
147
164
165 if (!($query = mysql_query($sql, $this->_conn))) {
166 error_log(mysql_error($this->_conn), 0);
251
252 $result = mysql_query($sql, $this->_conn);
253
GuestBook.php https://bitbucket.org/onlinechessportal/onlinechessgameportal | PHP | 215 lines
3require '../Control/RegisterLogic.php';
4require '../Control/LoginLogic.php';
5require '../Control/SendMail.php';
45
46 <li> <a class="on" href="Home.php">HOME</a></li>
47 <li> <a href="Contact.php">Contact</a> </li>
77 if (mysql_query($insert)) {
78 $entries = mysql_query("SELECT `gb_timestamp`,gb_name,gb_email,gb_message FROM guestbook ORDER BY `gb_timestamp` DESC ");
79 if (mysql_num_rows($entries) == 0) {
103 <hr />
104 <form action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" method="POST">
105 <strong>Post Something...</strong><br />
125 |
126 <a href="Contact.php" title="Contact Us">Contact Us</a>
127 </div></div>
moreinfo.php https://github.com/damanlovett/SEAHO.git | PHP | 145 lines
1<?php require_once('../../../Connections/CMS.php'); ?>
2<?php require_once('../../includefiles/initDelegates.php'); ?>
3<?php
111 <p><?php echo $row_rsConference['conference_theme']; ?><br />
112 <?php echo $row_rsConference['location']; ?>, <?php echo $row_rsConference['start_date']; ?> - <?php echo $row_rsConference['end_date']; ?></p>
113 <p>Registration begins <strong><?php echo formatDate($row_rsConference['start_date'],'M. d, Y'); ?></strong> and ends <strong><?php echo formatDate($row_rsConference['registration_deadline'],'M. d, Y'); ?></strong>. Late registration begins on <strong><?php echo $row_rsConference['registration_late']; ?></strong>.</p>
118 <?php do { ?>
119 <li><?php echo $row_rsFees['label']; ?> - <?php echo DoFormatCurrency($row_rsFees['amount'], 2, '.', ',', '$'); ?></li>
120 <?php } while ($row_rsFees = mysql_fetch_assoc($rsFees)); ?></ul></td>
123 <?php do { ?>
124 <li><?php echo $row_rsItems['label']; ?> - <?php echo DoFormatCurrency($row_rsItems['amount'], 2, '.', ',', '$'); ?></li>
125 <?php } while ($row_rsItems = mysql_fetch_assoc($rsItems)); ?></ol></td>
134 </tr>
135 <?php require_once('../../../includefiles/footer.inc.php'); ?>
136</table>
cometchat_receive.php https://github.com/chacha13/runningmate.git | PHP | 274 lines
1<?php
2
55
56include_once "cometchat_init.php";
57
70 $sql = ("select id from cometchat order by id desc limit 1");
71 $query = mysql_query($sql);
72 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); }
102 $sql = updateLastActivity($userid);
103 $query = mysql_query($sql);
104 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); }
119 $sql = getUserStatus($userid);
120 $query = mysql_query($sql);
121 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); }
157 $sql = ("select id from cometchat order by id desc limit 1");
158 $query = mysql_query($sql);
159 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); }
task.php http://airscore.googlecode.com/svn/trunk/ | PHP | 430 lines
7<div id="vhead"><h1>airScore admin</h1></div>
8<?php
9require_once 'authorisation.php';
9require_once 'authorisation.php';
10require_once 'format.php';
11
37 $sql = "select T.*, TW.* from tblTask T left outer join tblTaskWaypoint TW on T.tasPk=TW.tasPk and TW.tawType='goal' where T.tasPk=$tasPk";
38 $result = mysql_query($sql,$link)
39 or die('Task not associated correctly with a competition: ' . mysql_error());
73 $query = "select traPk from tblComTaskTrack where tasPk=$tasPk";
74 $result = mysql_query($query,$link);
75 $tracks = array();
98$query = "select comPk from tblTask where tasPk=$tasPk";
99$result = mysql_query($query) or die('Task not associated with a competition: ' . mysql_error());
100$comPk = mysql_result($result,0,0);
class.plugin.php https://bitbucket.org/icarito/pmc | PHP | 255 lines
1<?php
2
28
29 $ins = mysql_query("INSERT INTO plugins (name,description) VALUES ('$name','$description')");
30 if ($ins)
57 $plugin = (int) $plugin;
58 $del = mysql_query("DELETE FROM plugins WHERE ID = $plugin");
59 $this->delAllPluginEvents($plugin);
79 $plugin = (int) $plugin;
80 $upd = mysql_query("UPDATE plugins SET state = 1 WHERE ID = $id");
81 }
91 $plugin = (int) $plugin;
92 $upd = mysql_query("UPDATE plugins SET state = 0 WHERE ID = $id");
93 }
104
105 $sel = mysql_query("SELECT ID FROM plugins WHERE name = '$pluginname'");
106 $chk = mysql_fetch_row($sel);
listCMS_ONLINE_RESOURCES.php https://github.com/juddy/GIP.git | PHP | 211 lines
1<?php
2include_once("../common/dbConnection.php");
2include_once("../common/dbConnection.php");
3include_once("../common/header.php");
4?>
39$sql = "SELECT * FROM CMS_ONLINE_RESOURCES".$orderByQuery.$limitQuery;
40$result = MYSQL_QUERY($sql);
41$numberOfRows = MYSQL_NUM_ROWS($result);
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<? } ?>
70?>
71<a href="<? echo $_SERVER['PHP_SELF']; ?>?startLimit=<? echo $nextStartLimit; ?>&limitPerPage=<? echo $limitPerPage; ?>&sortBy=<? echo $sortBy; ?>&sortOrder=<? echo $sortOrder; ?>">Next <? echo $limitPerPage; ?> Results</a>
72<? } ?>
77 <TD>
78 <a href="<? echo $PHP_SELF; ?>?sortBy=RESOURCE_ID&sortOrder=<? echo $newSortOrder; ?>&startLimit=<? echo $startLimit; ?>&rows=<? echo $limitPerPage; ?>">
79 <B>RESOURCE_ID</B>
listGridCMS_GROUPUSERS.php https://github.com/juddy/GIP.git | PHP | 225 lines
1<?php
2include_once("../common/dbConnection.php");
2include_once("../common/dbConnection.php");
3include_once("../common/header.php");
4?>
15 $sqlUpdate = "UPDATE CMS_GROUPUSERS SET GROUP_ID = '$thisGROUP_ID' , USER_ID = '$thisUSER_ID' , GROUPUSER_FLAGS = '$thisGROUPUSER_FLAGS' WHERE GROUP_ID = '$thisGROUP_ID'";
16 $resultUpdate = MYSQL_QUERY($sqlUpdate);
17 echo "<b>Record with Id ".$thisGROUP_IDFromForm." has been Updated<br></b>";
28 $sqlInsert = "INSERT INTO CMS_GROUPUSERS (GROUP_ID , USER_ID , GROUPUSER_FLAGS ) VALUES ('$thisGROUP_ID' , '$thisUSER_ID' , '$thisGROUPUSER_FLAGS' )";
29 $resultInsert = MYSQL_QUERY($sqlInsert);
30 echo "<b>Record has been inserted in Database<br></b>";
41 $sqlDelete = "DELETE FROM CMS_GROUPUSERS WHERE GROUP_ID = '$thisGROUP_ID'";
42 $resultDelete = MYSQL_QUERY($sqlDelete);
43
81$sql = "SELECT * FROM CMS_GROUPUSERS".$orderByQuery.$limitQuery;
82$result = MYSQL_QUERY($sql);
83$numberOfRows = MYSQL_NUM_ROWS($result);
listCMS_OFFLINE_RESOURCES.php https://github.com/juddy/GIP.git | PHP | 211 lines
1<?php
2include_once("../common/dbConnection.php");
2include_once("../common/dbConnection.php");
3include_once("../common/header.php");
4?>
39$sql = "SELECT * FROM CMS_OFFLINE_RESOURCES".$orderByQuery.$limitQuery;
40$result = MYSQL_QUERY($sql);
41$numberOfRows = MYSQL_NUM_ROWS($result);
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<? } ?>
70?>
71<a href="<? echo $_SERVER['PHP_SELF']; ?>?startLimit=<? echo $nextStartLimit; ?>&limitPerPage=<? echo $limitPerPage; ?>&sortBy=<? echo $sortBy; ?>&sortOrder=<? echo $sortOrder; ?>">Next <? echo $limitPerPage; ?> Results</a>
72<? } ?>
77 <TD>
78 <a href="<? echo $PHP_SELF; ?>?sortBy=RESOURCE_ID&sortOrder=<? echo $newSortOrder; ?>&startLimit=<? echo $startLimit; ?>&rows=<? echo $limitPerPage; ?>">
79 <B>RESOURCE_ID</B>
room_edit.php https://bitbucket.org/deba666/accitsoftware.git | PHP | 144 lines
1<?php
2if($_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";
20 <div class="title_left">
21 <?php
22 if($_SESSION['s_msg'] || $_SESSION['e_msg'])
28 </div>
29 <?php
30 unset($_SESSION['s_msg']);
index.php https://gitlab.com/zanzilan/bgpanel.git | PHP | 427 lines
198 <td> <?php echo T_('Client'); ?> </td>
199 <td> <a href="clientsummary.php?id=<?php echo $rowsonlineClients['clientid']; ?>"><?php echo htmlspecialchars($rowsonlineClients['username'], ENT_QUOTES); ?></a> </td>
200 </tr>
265 <tr>
266 <td> <a href="serversummary.php?id=<?php echo $rowsServers['serverid']; ?>"><?php echo htmlspecialchars($rowsServers['name'], ENT_QUOTES); ?></a> </td>
267 <td> <span class="label label-success"><?php echo T_('Online'); ?></span> </td>
274 <tr>
275 <td> <a href="serversummary.php?id=<?php echo $rowsServers['serverid']; ?>"><?php echo htmlspecialchars($rowsServers['name'], ENT_QUOTES); ?></a> </td>
276 <td> <span class="label label-important"><?php echo T_('Offline'); ?></span> </td>
313 <tr>
314 <td> <a href="boxsummary.php?id=<?php echo $rowsBoxes['boxid']; ?>"><?php echo htmlspecialchars($rowsBoxes['name'], ENT_QUOTES); ?></a> </td>
315 <td> <span class="badge badge-<?php
344 </table>
345 <div class="well"><?php echo T_('Last Update'); ?> : <span class="label"><?php echo formatDate($cron['value']); ?></span><?php
346
diff.php http://timoseven.googlecode.com/svn/trunk/ | PHP | 419 lines
39<body>
40<form id="form1" name="form1" method="post" action="<?php $_SERVER['PHP_SELF']?>">
41<table width="996" height="127" border="1">
53 <select name="ISP">
54 <?php
55 $sql="SELECT distinct ISP from iplist";
55 $sql="SELECT distinct ISP from iplist";
56 $result = mysql_query($sql);
57 if (isset($_POST['submit']) || isset($_POST['sort1']) ||isset($_POST['sort2'])) {
129 <select name="test2">
130 <?php
131 $sql="select distinct bestregion from stat order by bestregion";
131 $sql="select distinct bestregion from stat order by bestregion";
132 $result = mysql_query($sql);
133 if (isset($_POST['submit']) || isset($_POST['sort1']) ||isset($_POST['sort2'])) {
diff.php http://timoseven.googlecode.com/svn/trunk/ | PHP | 419 lines
1<?php
2#Timo Seven (timoqi@sohu-inc.com)
4
5 include("header.php");
6 include("cidr2range.php");
39<body>
40<form id="form1" name="form1" method="post" action="<? $_SERVER['PHP_SELF']?>">
41<table width="996" height="127" border="1">
53 <select name="ISP">
54 <?php
55 $sql="SELECT distinct ISP from iplist";
55 $sql="SELECT distinct ISP from iplist";
56 $result = mysql_query($sql);
57 if (isset($_POST['submit']) || isset($_POST['sort1']) ||isset($_POST['sort2'])) {
60 $sql1 = "SELECT distinct ISP from iplist where ISP <> '$subisp'";
61 $result1 = mysql_query($sql1);
62 while($record = mysql_fetch_array($result1)) {
merge_dico.inc http://twpug.googlecode.com/svn/trunk/ | PHP | 209 lines
1<?php
2
76 //replace the file name by the translation file name
77 $file_name = ereg_replace("[^\\./]+.lang.php$", $translationKey.".lang.php", $sugar_lang_rec->file);
78 //values are the same key
94//As well as terms that where left for translation
95mysql_query("DELETE FROM sugar_terms WHERE lang = 'TRX' and version_id='$version_id' ");
96mysql_query("DELETE FROM sugar_lang_trx where trx = ''");
125 msg("($count) translated values have been found in the 'To Translate' (sugar_lang_trx) table.");
126 msg("You should commit or clear the existing values in the <A href=totrx.php>To Translate module</A>.");
127 $arr_old_to_trx = query_db("SELECT ref FROM sugar_lang_trx where trx != ''");
156 $query .= implode("),(", $sql_values).")";
157 mysql_query($query) or die("<SPAN class=msg-err>A mysql error occured : ".mysql_error()."</SPAN>");
158}
161$lang_pack_name = $trxMnf->get("name");
162mysql_query("UPDATE sugar_terms SET text = '$html_charset' where version_id = $version_id and lang = 'TRX' and array_id = 'app_strings' and label_id = 'LBL_CHARSET'");
163mysql_query("UPDATE sugar_terms SET text = '$lang_pack_name' where version_id = $version_id and lang = 'TRX' and array_id = 'app_list_strings' and label_id = 'language_pack_name'");
inc.openup.php http://dj-r-old-admin.googlecode.com/svn/trunk/ | PHP | 251 lines
26 <td></td>
27 <td><a href=\"pop.openup_expo_csv.php?who=hugo_h&sql_openup=$sql_openup\" target=_blank>Hug</a></td>
28 <td><a href=\"pop.openup_expo_csv.php?who=samuel_h&sql_openup=$sql_openup\" target=_blank>Sam</a></td>
28 <td><a href=\"pop.openup_expo_csv.php?who=samuel_h&sql_openup=$sql_openup\" target=_blank>Sam</a></td>
29 <td><a href=\"pop.openup_expo_csv.php?who=david_h&sql_openup=$sql_openup\" target=_blank>Dav</a></td>
30 <td><a href=\"pop.openup_expo_csv.php?who=justin_h&sql_openup=$sql_openup\" target=_blank>Jus</a></td>
30 <td><a href=\"pop.openup_expo_csv.php?who=justin_h&sql_openup=$sql_openup\" target=_blank>Jus</a></td>
31 <td><a href=\"pop.openup_expo_csv.php?who=mike_h&sql_openup=$sql_openup\" target=_blank>Mik</a></td>
32 <td><a href=\"pop.openup_expo_csv.php?who=yann_h&sql_openup=$sql_openup\" target=_blank>Yan</a></td>".
32 <td><a href=\"pop.openup_expo_csv.php?who=yann_h&sql_openup=$sql_openup\" target=_blank>Yan</a></td>".
33 //"<td><a href=\"pop.openup_expo_csv.php?who=jc_h&sql_openup=$sql_openup\" target=_blank>JC</a></td>".
34 "<td><a href=\"pop.openup_expo_csv.php?who=nicolas_h&sql_openup=$sql_openup\" target=_blank>Nic</a></td>
34 "<td><a href=\"pop.openup_expo_csv.php?who=nicolas_h&sql_openup=$sql_openup\" target=_blank>Nic</a></td>
35 <td><a href=\"pop.openup_expo_csv.php?who=matthieu_h&sql_openup=$sql_openup\" target=_blank>Mat</a></td>".
36 //"<td><a href=\"pop.openup_expo_csv.php?who=yannick_h&sql_openup=$sql_openup\" target=_blank>Yannick</a></td>".
MySQLStorage.php https://bitbucket.org/maconeto/proman.git | PHP | 354 lines
1<?php
2/**
18 *
19 * PHP version 5.3
20 *
144 {
145 if (!mysql_query(
146 "CREATE DATABASE IF NOT EXISTS `{$this->dbName}`",
154
155 $create = mysql_query(
156 "CREATE TABLE IF NOT EXISTS `{$this->dbName}`.`{$this->dbTable}` (
251 $this->connect();
252 $result = mysql_query(
253 "SELECT * FROM `{$this->dbName}`.`{$this->dbTable}`",
285 //Remove the pclass if it exists.
286 mysql_query(
287 "DELETE FROM `{$this->dbName}`.`{$this->dbTable}`
reporte_genera_reporte.php https://bitbucket.org/redesvas/rceldas.git | PHP | 357 lines
1<?php
2 date_default_timezone_set('America/Santiago');
3 ini_set("display_errors", 1);
4 include_once("config.php");
5
26
27 #### SE EJECUTA UN CORREO DE ALERTA - DETALLES EN ARCHIVO config.php
28 infoMail_urgente(1,"","HUDSON");
47 $date=date("Y-m-d H:i:s");
48 echo "[$date][INICIO] [".basename($_SERVER['PHP_SELF'])."] \n";
49
53 $sql="SELECT * FROM ".$_db.".PROCESOS_STATUS WHERE PROCESO='GENERA_REPORTE' ";
54 $res = mysql_query($sql, $_link);
55
67 $sql="SELECT * FROM ".$_db.".PROCESOS_STATUS_DETALLE WHERE ID_PROCESO = 6 ";
68 $result = mysql_query($sql, $_link);
69
buscar_producto.php https://code.google.com/p/zapatillas-4-dsw1/ | PHP | 269 lines
2session_start ();
3require_once './php_lib/conexion.php';
4if (!function_exists("GetSQLValueString")) {
133?>
134 <option value=" = <?php echo $row_Color['col_id']?>"><?php echo $row_Color['col_descripcion']?></option>
135 <?php
184?>
185 <option value=" = <?php echo $row_PerfilCliente['perfc_id']?>"><?php echo $row_PerfilCliente['perfc_descripcion']?></option>
186 <?php
201?>
202 <option value=" = <?php echo $row_Tipo['tip_id']?>"><?php echo $row_Tipo['tip_descripcion']?></option>
203 <?php
237 <td><?php echo $rsEmp['tip_descripcion']; ?></td>
238 <td width="8%"><a href="eliminar.php?per_rut=<?php echo $row_Recordset3['per_rut']; ?>"><img src="imagenes/borrar.gif" width="15" height="17" alt="Eliminar" /></a></td>
239 </tr>
Mysql.php git://github.com/ushahidi/Ushahidi_Web.git | PHP | 499 lines
1<?php defined('SYSPATH') OR die('No direct access allowed.');
2/**
87 // Set the cached object
88 self::$query_cache[$hash] = new Mysql_Result(mysql_query($sql, $this->link), $this->link, $this->db_config['object'], $sql);
89 }
94
95 return new Mysql_Result(mysql_query($sql, $this->link), $this->link, $this->db_config['object'], $sql);
96 }
324
325 if ($query = mysql_query('SHOW COLUMNS FROM '.$this->escape_table($table), $this->link))
326 {
assessment.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 260 lines
24
25$getd1 = mysql_query ("select c.tfodesc, a.taxfeeamtfor, a.taxfeeid, b.naturedesc, a.taxfeeind,
26 a.taxfeeoption, a.taxfeemode,c.taxfeetype
45
46 $temp = mysql_query ("select a.natureid, a.taxfeeid, a.multi,
47 c.tfodesc, b.taxfeeamtfor,b.taxfeeind
144
145 $getrange = mysql_query("select rangeamount, rangelow from ebpls_buss_taxrange where
146 taxfeeid=$getd[2] and rangelow = $xv") or die ("f");
149
150 $getrange = mysql_query("select rangeamount from ebpls_buss_taxrange where
151 taxfeeid=$getd[2] and rangelow <= $xv and
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>
base3.php https://github.com/crocus/virpl.git | PHP | 224 lines
1<?php
2require_once('_scriptsphp/r_conn.php');
3function utf8_JSON_russian_cyr($str){
165$num=0;
166$Recordset3 = @mysql_query($GenerQuery , $realtorplus) or die(mysql_error());
167$row_Recordset3 = mysql_fetch_assoc($Recordset3);
database.php https://bitbucket.org/sspssp/akk-berlin.git | PHP | 578 lines
1<?php
2
102
103 $out=mysql_query( $query , $this->db ) or die('something went wrong');
104
126
127 mysql_query( $query , $this->db ) or die('somethnig went wrong');
128
143
144 mysql_query( $query , $this->db ) or die('somethnig went wrong');
145
163
164 mysql_query( $query , $this->db ) or die('somethnig went wrong');
165
185
186 mysql_query( $query , $this->db ) or die('somethnig went wrong');
187
ebpls_orderpayment.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 292 lines
3define('FPDF_FONTPATH','font/');
4require('../ebpls-php-lib/html2pdf_lib/fpdf.php');
5include("../lib/phpFunctions-inc.php");
5include("../lib/phpFunctions-inc.php");
6include("../includes/variables.php");
7include("../lib/multidbconnection.php");
10
11$bgy = mysql_query("select * from ebpls_barangay where barangay_code='$brgy_name'");
12$bgy = mysql_fetch_assoc($bgy);
123
124 $result = mysql_query ("select concat(b.owner_first_name, ' ', b.owner_middle_name, ' ', b.owner_last_name) as fulln,
125 concat(b.owner_street, ' ', i.barangay_desc, ' ',j.city_municipality_desc, ' ', k.province_desc, ' ',
138
139 $result = mysql_query ("select concat(b.owner_first_name, ' ', b.owner_middle_name, ' ', b.owner_last_name) as fulln,
140 concat(b.owner_street, ' ', i.barangay_desc, ' ',j.city_municipality_desc, ' ', k.province_desc, ' ',
add.php https://github.com/anodyne/sms.git | PHP | 366 lines
1<?php
2
49
50 $result = mysql_query($query);
51
66 $getPosType = "SELECT positionType FROM sms_positions WHERE positionid = $position LIMIT 1";
67 $getPosTypeResult = mysql_query($getPosType);
68 $positionType = mysql_fetch_row($getPosTypeResult);
78 $getGroupLevels = "SELECT * FROM sms_accesslevels WHERE id = $accessID LIMIT 1";
79 $getGroupLevelsResult = mysql_query($getGroupLevels);
80 $groups = mysql_fetch_array($getGroupLevelsResult);
110
111 $result = mysql_query($query);
112
132 /* send the email */
133 mail( $to, $subject, $message, "From: " . $from . "\nX-Mailer: PHP/" . phpversion() );
134 }
master.php https://gitlab.com/suman0359/physiohealthrs.com.git | PHP | 175 lines
6 <title>Rising Sun Physiotherapy & Health - Home</title>
7 <link href="<?php echo base_url(); ?>css/stylesheet.css" rel="stylesheet" type="text/css"/>
8 <link href="<?php echo base_url(); ?>css/dropdown.css" rel="stylesheet" type="text/css"/>
26 while ($search = mysql_fetch_array($sql)) { ?>
27 {label: "<?php echo $search['blog_title'];?>", the_link: "<?php echo base_url(); ?>welcome/read_more/<?php echo $search['blog_id']; ?>"},
28 <?php }
112 <li>
113 <a href="<?php echo base_url(); ?>menu/menu_wise_news/<?php echo $value->menu_link; ?>"><?php echo $value->menu_name; ?></a>
114 <?php if ($value->menu_dropdown == "dropdown") { ?>
122
123 <li><a href="<?php echo base_url(); ?>menu/menu_wise_news/<?php echo $dropdown['menu_link']; ?>"><?php echo $dropdown['menu_name']; ?></a></li>
124 <?php } ?>
131 ?>
132 <li><a href="<?php echo base_url(); ?>menu/menu_wise_news/<?php $menu_link="open_voice"; echo $menu_link; ?>">Open Voice</a></li>
133 <li><a href="<?php echo base_url(); ?>contact">Contact Us</a></li>
lstof_duedates-inc.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 303 lines
83<tr>
84<td colspan=2>[ <a href=index.php?part=4&class_type=Preference&selMode=ebpls_npenalty&action_=7&itemEvent=3&data_item=0&yahooo=102>Quarterly</a> | <a href=index.php?part=4&class_type=Preference&selMode=ebpls_npenalty&action_=7&itemEvent=3&data_item=0&yahooo=103>Semi-Annual</a> | <a href=<?php echo $PHP_SELF;?>?part=4&class_type=Preference&selMode=ebpls_npenalty&action_=7&itemEvent=1&data_item=0>Back to Penalty</a>]</td>
85</tr>
170//?>
171</select> <input type=text name=x41 size=4 maxlength=2 value="<?php echo $x41;?>"> <?php echo $iLGURenYear;?><input type=hidden name=x21 size=4 maxlength=4 value="<?php echo date('Y');?>"> <font size=2><?php echo date('Y');?></font>-->
172</td>
193//?>
194</select> <input type=text name=x411 size=4 maxlength=2 value="<?php echo $x411;?>"> <?php echo $iLGURenYear;?><input type=hidden name=x211 size=4 maxlength=4 value="<?php echo date('Y');?>"> <font size=2><?php echo date('Y');?></font>-->
195</td>
217?>
218</select> <input type=text name=x4111 size=4 maxlength=2 value="<?php echo $x4111;?>"> <?php echo $iLGURenYear;?><input type=hidden name=x2111 size=4 maxlength=4 value="<?php echo date('Y');?>"> <font size=2><?php echo date('Y');?></font>-->
219</td>
240?>
241</select> <input type=text name=x41111 size=4 maxlength=2 value="<?php echo $x41111;?>"> <?php echo $iLGURenYear;?><input type=hidden name=x21111 size=4 maxlength=4 value="<?php echo date('Y');?>"> <font size=2><?php echo date('Y');?></font>-->
242</td>
SlowPub_webservicesE.php http://slowpub-development.googlecode.com/svn/trunk/ | PHP | 512 lines
1<?php
2
73 $query = "SELECT * FROM reg_menu WHERE type = 'soup_salad_appy'";
74 $result = mysql_query($query);
75 $numberOfFields = mysql_num_rows($result);
83 $query = "SELECT * FROM reg_menu WHERE type = 'main_forno'";
84 $result = mysql_query($query);
85 $numberOfFields = mysql_num_rows($result);
93 $query = "SELECT * FROM reg_menu WHERE type = 'sandwich_pasta'";
94 $result = mysql_query($query);
95 $numberOfFields = mysql_num_rows($result);
142 $query = "SELECT * FROM daily_menu";
143 $result = mysql_query($query);
144 $numberOfFields = mysql_num_rows($result);
185 $query = "SELECT 'offsaleText' FROM details";
186 $result = mysql_query($query);
187 $row = mysql_fetch_array($result);
mysql.dbi.lib.php git://github.com/jyr/MNPP.git | PHP | 451 lines
1<?php
2/* vim: set expandtab sw=4 ts=4 sts=4: */
5 *
6 * @package phpMyAdmin-DBI-MySQL
7 * @version $Id$
8 */
9if (! defined('PHPMYADMIN')) {
10 exit;
12
13require_once './libraries/logging.lib.php';
14
53{
54 global $cfg, $php_errormsg;
55
171 if ($options == ($options | PMA_DBI_QUERY_STORE)) {
172 $r = mysql_query($query, $link);
173 } elseif ($options == ($options | PMA_DBI_QUERY_UNBUFFERED)) {
class_db_mysql.php http://lansuite.googlecode.com/svn/trunk/ | PHP | 267 lines
1<?php
2
18 if (extension_loaded("mysqli")) $this->mysqli = 1;
19 elseif (!extension_loaded("mysql")) echo HTML_FONT_ERROR . t('Das MySQL-PHP Modul ist nicht geladen. Bitte f?ge die mysql.so Erweiterung zur php.ini hinzu und restarte den Webserver neu. Lansuite wird abgebrochen') . HTML_FONT_END;
20 }
31 $this->errorsFound = 1;
32 // Need to use mysql_querys here, to prevent loops!!
33 $query = 'INSERT INTO '. $config['database']['prefix'] .'log SET date = NOW(), userid = '. (int)$auth['userid'] .', type = 3, description = "'. strip_tags($error) .'", sort_tag = "SQL-Fehler"';
34 if ($this->mysqli) mysqli_query($this->link_id, $query);
35 else mysql_query($query, $this->link_id);
36
91 if ($this->mysqli) @mysqli_query($this->link_id, "/*!40101 SET NAMES utf8_general_ci */;");
92 else @mysql_query("/*!40101 SET NAMES utf8_general_ci */;", $this->link_id);
93 $this->success = true;
100 if ($this->mysqli) @mysqli_query($this->link_id, "/*!40101 SET NAMES utf8_general_ci */;");
101 else @mysql_query("/*!40101 SET NAMES utf8_general_ci */;", $this->link_id);
102 }
mysql.php https://gitlab.com/cherian/xmec.git | PHP | 317 lines
1<?php
2
7if(!defined("PHORUM_ADMIN") && !function_exists("mysql_connect")){
8 echo "<b>Error: You have configured Phorum to use MySQL. MySQL support is not available to PHP on this server.</b>";
9 exit();
90 // mysql_select_db($db->database, $db->connect_id); // If you are having trouble with other apps uncomment this line.
91 $this->result=@mysql_query($query, $db->connect_id);
92 return $this->result;
rezervare_sejur_succes.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 269 lines
79<body>
80 <?php include($_SERVER['DOCUMENT_ROOT'].'/includes/header/admin_bar_responsive.php'); ?>
81
136
137 <?php echo $detalii_hotel['localitate']?> / <?php echo $detalii_hotel['zona']?> / <?php echo $detalii_hotel['tara']?> </span>
138 </span>
170 </span>
171 <span class="bigger-12em green bold result"><?php echo $row_rez['transport']; ?></strong><?php if($row_rez['oras_plecare']) echo ', plecare din <strong>'.get_den_localitate($row_rez['oras_plecare']).'</strong>'; ?></span>
172 <span class="clear" style="display: block"></span>
262 <?php // Footer ?>
263<?php require_once($_SERVER['DOCUMENT_ROOT']."/includes/newsletter_responsive.php" ); ?>
264
265 <?php require_once( $_SERVER['DOCUMENT_ROOT']."/includes/footer/footer_responsive.php" ); ?>
266 <?php include_once( $_SERVER['DOCUMENT_ROOT'] . "/includes/addins_bodybottom_responsive.php" ); ?>
267
CariKelompokTaniUser.php https://bitbucket.org/ArgoWibowo/dutatani.git | PHP | 191 lines
50 mysql_select_db("iais_ukdw") or die("Database tidak ditemukan");
51 $query= mysql_query("SELECT * FROM master_petani where ID_User = '$id_user';");
52 $brsnama = mysql_fetch_array($query)
117 <div style="margin-bottom:15px;" align="center">
118 <form action="DataKelompokTaniUser.php" method="post">
119 <input type="text" name="input_cari" placeholder="Cari" style="height:30px;width:430px;color:black;"
138
139 <?php
140 // jika data kurang dari 1
143 <p>Data Tidak Ditemukan!</p>
144 <?php
145 }
176 <td><?php echo $kel_tani['Deskripsi']?></td>
177 <td><a class="btn btn-s btn-primary" href="DetailKelompokTaniUser.php?id=<?php
178 echo $kel_tani['ID_Kelompok_Tani'] ?>">Detail</a></td>
posts_controller.php https://github.com/jcalado/planetuga.git | PHP | 327 lines
1<?php
2class PostsController extends AppController {
186 // List all feeds
187 $sql = mysql_query("SELECT * FROM feeds ORDER BY id;");
188 $numberfeeds = mysql_num_rows($sql);
231 // Check if it already exists using the permalink
232 $check = mysql_query("SELECT * FROM posts WHERE permalink = '$permalink'") or die(mysql_error());
233 if (mysql_num_rows($check) == "0") {
236 $insert = "INSERT INTO posts (feed_id,user_id,title,slug,permalink,created_at,category,content) VALUES (\"$feed_id\",\"$user_id\",\"$title\",\"$slug\",'$permalink','$created_at','$category','$content')";
237 mysql_query($insert) or die(mysql_error());
238
setdata.php https://bitbucket.org/dmdonnelly/developer-test.git | PHP | 207 lines
10 <!-- All SQL connection code contained to a seperate file -->
11 <? include("connect.php"); ?>
12 </head>
19 <h3 class="text-center card-header">Set Test Data</h3>
20 <form class="card-body" action="<?=$PHP_SELF?>" method="post">
21 <div class="form-group row">
76
77 $result1 = mysql_query("DROP TABLE IF EXISTS `venue`");
78 if (!$result1) {
82
83 $result2 = mysql_query(
84 "CREATE TABLE IF NOT EXISTS `venue` (
93
94 $result3 = mysql_query("DROP TABLE IF EXISTS `venue_booking`");
95 if (!$result3) {
Db_Mysql.php http://slightphp.googlecode.com/svn/trunk/ | PHP | 471 lines
1<?php
2/*{{{LICENSE
3+-----------------------------------------------------------------------+
4| SlightPHP Framework |
5+-----------------------------------------------------------------------+
12+-----------------------------------------------------------------------+
13| Supports: http://www.slightphp.com |
14+-----------------------------------------------------------------------+
17/**
18 * @package SlightPHP
19 * @subpackage SDb
389 if(!empty($this->charset)){
390 mysql_query("SET NAMES ".$this->charset);
391 }
400 }
401 $result = mysql_query($sql,Db_Mysql::$globals[$this->key]);
402 if(!$result){
functions.php https://bitbucket.org/asada03/camino.git | PHP | 266 lines
1<?php
2
22 Based on code from evolt.org by jpmaster77
23 http://evolt.org/php_login_script_with_remember_me_feature
24
26
27if ('functions.php' == basename($_SERVER['SCRIPT_FILENAME']))
28 exit("You cannot access this file directly");
42 $q = "select password from ".DB_PREFIX."users where username = '$username' limit 1";
43 $result = mysql_query($q,$conn);
44 if(!$result || (mysql_numrows($result) < 1)){
64
65// prevent including php or html in a string
66function cleanString($string, $length) {
66function cleanString($string, $length) {
67 $string = filter_var($string, FILTER_SANITIZE_STRING); // PHP 5
68 $string = trim($string);
mysql.php https://hg.codeplex.com/cp3046team16bj | PHP | 413 lines
1<?php
2// If this file is not included from the MMHTTPDB possible hacking problem.
6
7define('MYSQL_NOT_EXISTS', create_error("Your PHP server doesn't have the MySQL module loaded or you can't use the mysql_(p)connect functions."));
8define('CONN_NOT_OPEN_GET_TABLES', create_error('The Connection is not opened when trying to retrieve the tables. Please refer to www.interaktonline.com for more information.'));
15
16// Now let's handle the crashes or any other PHP errors that we can catch
17function KT_ErrorHandler($errno, $errstr, $errfile, $errline) {
31 2048=> "E_ALL",
32 2049=> "PHP5 E_STRICT"
33
53/*
54 // The 'var' keyword is deprecated in PHP5 ... we will define these variables at runtime.
55 var $isOpen;
132 if ($this->isOpen && isset($this->connectionId) && is_resource($this->connectionId)){
133 // 1. mysql_list_tables and mysql_tablename are deprecated in PHP5
134 // 2. For backward compatibility GetTables don't have any parameters
getCities.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 129 lines
1<?php
2include_once("includes/variables.php");
2include_once("includes/variables.php");
3include_once("lib/multidbconnection.php");
4include_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))
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))
70 echo "obj.options[obj.options.length] = new Option('-Please Select Barangay-','');\n";
71 $resultset = mysql_query("SELECT * FROM ebpls_barangay where upper='$prov'") or die(mysql_error()."dd");
72 while($datarow = @mysql_fetch_array($resultset))
89 echo "obj.options[obj.options.length] = new Option('-Please Select Zone-','');\n";
90 $resultset = mysql_query("SELECT * FROM ebpls_zone where upper='$prov'") or die(mysql_error()."dd");
91 while($datarow = @mysql_fetch_array($resultset))
profile.php https://github.com/hovvit/Newsletter.git | PHP | 446 lines
1<?php
2 $user="";
70 WHERE userID='$userID'";
71 $result_saveData = mysql_query($query_saveData, $cxn)
72 or die ("Couldn't execute query 1");
89 $query_getID = "SELECT userID FROM userdata WHERE emailAddress='$currentUser'";
90 $result_getID = mysql_query($query_getID, $cxn)
91 or die ("Couldn't execute query 1");
96 $qInsert = "INSERT INTO userdata SET emailAddress='$currentUser'";
97 $qResult= mysql_query($qInsert, $cxn)
98 or die ("Couldn't execute query 3");
102 $query_getID = "SELECT userID FROM userdata WHERE emailAddress='$currentUser'";
103 $result_getID = mysql_query($query_getID, $cxn)
104 or die ("Couldn't execute query 1");
233 </tr>
234 <tr><td align='center'><a href='publications.php'>[Archive]</a> <a href='signup.php'>[Log out]</a><br /><br /></td></tr>
235 </table><br />
installtables.php https://github.com/holsinger/openfloor.git | PHP | 357 lines
1<?php
2include_once ('../libs/db.php');
10$sql = 'DROP TABLE IF EXISTS `' . table_blogs . '`;';
11mysql_query( $sql, $conn );
12
24echo 'Creating table: \'blogs\'...<br />';
25mysql_query( $sql, $conn );
26
28$sql = 'DROP TABLE IF EXISTS `' . table_categories . '`;';
29mysql_query( $sql, $conn );
30
46echo 'Creating table: \'categories\'...<br />';
47mysql_query( $sql, $conn );
48
50$sql = 'DROP TABLE IF EXISTS `' . table_comments . '`;';
51mysql_query( $sql, $conn );
52
Session2.php https://bitbucket.org/Dzoki/travianx.git | PHP | 187 lines
10
11 include("GameEngine/Database/db_MYSQL.php");
12
38 }
39 $banned = mysql_query("SELECT reason, end FROM " . TB_PREFIX . "banlist WHERE active = 1 and time-" . time() . "<1 and uid = '" . $this->uid . "';");
40 if(mysql_num_rows($banned)) {
55 }
56 $this->url = $_SESSION['url'] = $_SERVER['PHP_SELF'];
57 $this->SurfControl();
73 if($_SESSION['wid'] == '') {
74 $query = mysql_query('SELECT * FROM `' . TB_PREFIX . 'vdata` WHERE `owner` = ' . $database->getUserField($_SESSION['username'], "id", 1) . ' LIMIT 1');
75 $data = mysql_fetch_assoc($query);
166 }
167 $pagearray = array("index.php", "anleitung.php", "tutorial.php", "login.php", "activate.php", "anmelden.php", "xaccount.php");
168 if(!$this->logged_in) {
enroll_credit_bank_charge.php https://bitbucket.org/deba666/accitsoftware.git | PHP | 250 lines
25}
26 mysql_query("update `due` set `AMOUNT`='".$due_amount."' where `IND_NO`='".$_POST['IND_NO'][$i]."'");
27 $_SESSION['s_msg']="<strong>Fine!</strong>Payment Credited Successfully";
47 <div class="title_left">
48 <?php
49 if($_SESSION['s_msg'] || $_SESSION['e_msg'])
86 <input id="who" name="WHO_DATE" type="hidden" value="<?php echo $date?>">
87 <input id="when" name="user" type="hidden" value="<?php echo $_SESSION['user_no']?>">
88 <input id="when" name="enrol_no" type="hidden" value="<?=$_GET['enrol_no']?>">
102 <tbody>
103 <?php
104 $i=1;
163 </td>
164 <td><input type="checkbox" name="chk[]" value="<?= $row2a['AMOUNT']?>" id="chk<?php echo $i;?>" onClick="getVal(this, 'inp<?php echo $i;?>')" ></td>
165 <td><input class="sum1" type="text" name="inp[]" id="inp<?php echo $i;?>" onmousemove="add1()"></td>
studentfeed_lookup_questions.php https://code.google.com/p/classroom-presenter/ | PHP | 346 lines
1<?php
2 function connectToDB()
5
6 include '../../db_credentials.php';
7
32
33 $voteresults = mysql_query($votequery, $db_conn);
34 if (!$voteresults)
96 }
97 $results = mysql_query($query, $db_conn);
98 if (!$results)
134 // Run the query and fetch the results
135 $results = mysql_query($query, $db_conn);
136 if (!$results)
176 // Run the query and fetch the results
177 $results = mysql_query($query, $db_conn);
178 if (!$results)
database_mysql.php https://github.com/tigerdan/TinyIB.git | PHP | 220 lines
1<?php
2if (!defined('TINYIB_BOARD')) { die(''); }
13// Create the posts table if it does not exist
14if (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
45if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . TINYIB_DBBANS . "'")) == 0) {
46 mysql_query("CREATE TABLE `" . TINYIB_DBBANS . "` (
58function uniquePosts() {
59 $row = mysql_fetch_row(mysql_query("SELECT COUNT(DISTINCT(`ip`)) FROM " . TINYIB_DBPOSTS));
60 return $row[0];
63function postByID($id) {
64 $result = mysql_query("SELECT * FROM `" . TINYIB_DBPOSTS . "` WHERE `id` = '" . mysql_real_escape_string($id) . "' LIMIT 1");
65 if ($result) {
72function threadExistsByID($id) {
73 return mysql_result(mysql_query("SELECT COUNT(*) FROM `" . TINYIB_DBPOSTS . "` WHERE `id` = '" . mysql_real_escape_string($id) . "' AND `parent` = 0 LIMIT 1"), 0, 0) > 0;
74}
history-functions.php https://squirrelmail.svn.sourceforge.net/svnroot/squirrelmail | PHP | 312 lines
1<?php
2
3////////////////////////////////////////////////////////////////////////////
4// $Id: history-functions.php 8819 2005-02-08 11:35:07Z tokul $
5//
146
147 $results=@mysql_query("SELECT sdate, SUM(translated) AS translated, SUM(total) AS total " .
148 " FROM essential WHERE rev='$rev' AND team<>'templates' " .
200
201 $results=@mysql_query("SELECT sdate, SUM(translated) AS translated, SUM(total) AS total " .
202 " FROM essential WHERE rev='$rev' AND team='$teamcode' " .
mysqlstorage.class.php https://bitbucket.org/programmerlab/ourteam.co.in.git | PHP | 336 lines
1<?php
2defined ('_JEXEC') or die();
5 *
6 * PHP Version 5.3
7 *
18 */
19require_once 'storage.intf.php';
20
126
127 if (!mysql_query(
128 "CREATE DATABASE IF NOT EXISTS `{$this->dbName}`",
136
137 $create = mysql_query(
138 "CREATE TABLE IF NOT EXISTS `{$this->dbName}`.`{$this->dbTable}` (
233 $this->connect();
234 $result = mysql_query(
235 "SELECT * FROM `{$this->dbName}`.`{$this->dbTable}`",
save_QueryBuilder.class.php http://antilophpe.googlecode.com/svn/ | PHP | 317 lines
1<?php
2/**
2/**
3 * File QueryBuilder.class.php
4 *
283 $query = "SELECT DISTINCT $field FROM $table";
284 $result = mysql_query($query, $db);
285 while ($row = oci_fetch_array($result)){
309 $query = "SELECT DISTINCT $labelField FROM $table WHERE id ='$foreignKey'";
310 $result = mysql_query($query, $db);
311 $row = oci_fetch_array($result);
inc.stats.php http://dj-r-old-admin.googlecode.com/svn/trunk/ | PHP | 190 lines
1<?php
2 //error_reporting(E_ALL);
20$sql_select_interval="SELECT PERIOD_DIFF(".substr($today_format_mysql,0,4).substr($today_format_mysql,5,2).",200402) AS nb_de_mois;"; // arguments au format YYMM ou YYYYMM
21$req_interval= mysql_query($sql_select_interval) or die('Erreur SQL !<br>'.$sql_select_interval.mysql_error());
22if($data_interval= mysql_fetch_assoc($req_interval))
26
27// meilleure solution : tout en php !
28function datediff($a,$b)
40$sql_select="SELECT SUM(somme) AS ca FROM cpt_journal WHERE no_compte_credit='621' ";
41$req= mysql_query($sql_select) or die('Erreur SQL !<br>'.$sql_select.mysql_error());
42$data= mysql_fetch_assoc($req);
44$sql_select_2="SELECT SUM(somme) AS ca_en_cours FROM cpt_journal WHERE no_compte_credit='621' AND date>'2007-03-01 00:00:00' "; //modifier date ici
45$req_2= mysql_query($sql_select_2) or die('Erreur SQL !<br>'.$sql_select_2.mysql_error());
46$data3= mysql_fetch_assoc($req_2);
48$sql_select2="SELECT count(*) AS nb_client_total FROM `contacts` WHERE type_client='1' AND date_ajout BETWEEN '2004-03-01' AND NOW()";
49$req2= mysql_query($sql_select2) or die('Erreur SQL !<br>'.$sql_select2.mysql_error());
50$data2= mysql_fetch_assoc($req2);
addjp.php https://github.com/anodyne/sms.git | PHP | 347 lines
133 $userFetch.= "WHERE crew.crewid = $emailAuthor AND crew.rankid = rank.rankid LIMIT 1";
134 $userFetchResult = mysql_query( $userFetch );
135
154 /* send the email */
155 mail( $to, $subject, $message, "From: " . $from . "\nX-Mailer: PHP/" . phpversion() );
156 }
165
166 window.location = "<?php echo $webLocation;?>admin.php?page=post&sub=addjp&number=" + number;
167 });
185
186 This page should be used in the event that a member of the crew has accidentally posted incorrectly. For instance, if a player has replied to one of the emails sent out to the system instead of logging in and posting, you can copy and paste the contents of their email into this form and put the entry into the system. For all other joint posts, please use the <a href="<?=$webLocation;?>admin.php?page=post&sub=jp"> Write Joint Post</a> page.<br /><br />
187
194 <?php for ($k=2; $k<=JP_AUTHORS; $k++): ?>
195 <option value="<?php echo $k;?>"><?php echo $k;?> People</option>
196 <?php endfor;?>
admin.php https://code.google.com/p/nuked-klan/ | PHP | 266 lines
1<?php
2// -------------------------------------------------------------------------//
2// -------------------------------------------------------------------------//
3// Nuked-KlaN - PHP Portal //
4// http://www.nuked-klan.org //
11
12translate('modules/Defy/lang/' . $language . '.lang.php');
13
13
14include 'modules/Admin/design.php';
15
27 . "<div class=\"content-box-header\"><h3>" . _DEFY . "</h3>\n"
28 . "<div style=\"text-align:right;\"><a href=\"help/" . $language . "/Defy.php\" rel=\"modal\">\n"
29 . "<img style=\"border: 0;\" src=\"help/help.gif\" alt=\"\" title=\"" . _HELP . "\" /></a>\n"
31 . "<div class=\"tab-content\" id=\"tab2\"><div style=\"text-align: center;\">" . _DEFY . "<b> | "
32 . "<a href=\"index.php?file=Defy&page=admin&op=edit_pref\">" . _PREFS . "</a></b></div><br />\n"
33 . "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\">\n"
Morfologi tanaman.php https://bitbucket.org/ArgoWibowo/si_aktivitas_tani.git | PHP | 215 lines
1<?php
2 session_start();
3 if(!isset($_SESSION["ID_User"])){
4 header("Location:login.php?pesan=Mohon login terlebih dahulu");
5 }else if($_SESSION["ID_Kategori"] != "ADT")
6 {
7 header("Location:login.php?pesan=hanya untuk admin");
8 }
31 type : 'POST',
32 url : 'cek_id_morfologi.php',
33 data : $(this).serialize(),
64 <ul class="nav navbar-nav navbar-right">
65 <?php
66 $id_user = $_SESSION['ID_User'];
68 mysql_select_db("iais_ukdw") or die("Database tidak ditemukan");
69 $query= mysql_query("SELECT * FROM master_petani where ID_User = '$id_user';");
70 $brsnama = mysql_fetch_array($query)
db.class.php http://timoseven.googlecode.com/svn/trunk/ | PHP | 417 lines
1<?php
2/**
2/**
3 * phpmysql??????@oswind.com
4 * ??????????
41 mysql_errno () != 0 && $this->halt ( "Connect($pconnect) to MySQL failed" );
42 mysql_query ( "SET character_set_connection=" . $this->charset . ", character_set_results=" . $this->charset . ", character_set_client=binary" );
43 mysql_query ( "SET NAMES " . $this->charset );
78 } else {
79 $query = mysql_query ( $sql );
80 }
114 } else {
115 $query = mysql_query ( $sql );
116 }
cso_summary_of_enrollment_ways.php https://github.com/eedsonpaul/iris.git | PHP | 222 lines
1<?php
2//File: CSO Degree Programs
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
37
37
38 include ('connect_to_database.php');
39 include ('cso_enrollment_functions.php');
49
50<?php
51
53
54 $prog_array = mysql_query("SELECT * FROM degree_program");
55 while ($programs = mysql_fetch_array($prog_array)) {
upload2.php https://github.com/delete66/sikevux-s-tracker.git | PHP | 93 lines
1<?php
2require_once("include/bittorrent.php");
2require_once("include/bittorrent.php");
3require_once ("include/user_functions.php");
4require_once ("include/bbcode_functions.php");
10// moddifed logginorreturn by retro//Remember to change the following line to match your server
11print("<html><h1>Not Found</h1><p>The requested URL /{$_SERVER['PHP_SELF']} was not found on this server.</p><hr /><address>Apache/1.1.11 (xxxxx) Server at ".$_SERVER['SERVER_NAME']." Port 80</address></body></html>\n");
12die();
16{
17stdmsg("Sorry...", "You are not authorized to upload torrents. (See <a href=\"rules.php\">Read the site rules</a>)");
18stdfoot();
22<div align=Center>
23<form name=upload enctype="multipart/form-data" action="takeupload2.php" method="post">
24<input type="hidden" name="MAX_FILE_SIZE" value="<?=$max_torrent_size?>" />
32//==== offer dropdown for offer mod
33$res = mysql_query("SELECT id, name, allowed FROM offers WHERE userid = $CURUSER[id] ORDER BY name ASC") or sqlerr(__FILE__, __LINE__);
34if (mysql_num_rows($res) > 0) {
ebpls_bus_masterlist.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 288 lines
3define('FPDF_FONTPATH','font/');
4require('../ebpls-php-lib/html2pdf_lib/fpdf.php');
5include("../lib/phpFunctions-inc.php");
5include("../lib/phpFunctions-inc.php");
6include("../includes/variables.php");
7include("../lib/multidbconnection.php");
10
11$bgy = mysql_query("select * from ebpls_barangay where barangay_code='$brgy_name'");
12$bgy = mysql_fetch_assoc($bgy);
97 $resulta=mysql_fetch_row($result);
98$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'");
99$getlgu = @mysql_fetch_row($getlgu);
172 } else {
173 $result = mysql_query ("select distinct (c.business_permit_code) as pid, a.business_name,
174 concat(a.business_lot_no, ' ', a.business_street, ' ', f.barangay_desc, ' ',
@dbs.php https://bitbucket.org/comarius/buzznet.git | PHP | 549 lines
1<?php
2 require_once('@set.php');
4 // Author: Justin Vincent (justin@visunet.ie)
5 // Web: http://php.justinvincent.com
6 // Name: ezSQL
71 // ====================================================================
72 // Format a string correctly for safe insert under all PHP conditions
73
164
165 // Perform the query via std mysql_query function..
166 $this->result = @mysql_query($query,$this->dbh);
public-auto-spare-part.php https://gitlab.com/Chhorvan/autoexpresscambodia_mobile.git | PHP | 276 lines
1<?php
2################################################################################
14################################################################################
15include('view/3rdparty/pagination/pagination.php');
16class publicAutoSparePart
43 //echo $item.''.$category;
44 require_once BASE_CLASS . 'class-connect.php';
45
71 $sql_count_str=$sql_search;
72 $sql_count = @mysql_query($sql_count_str);
73 $this->total_num_row= @mysql_num_rows($sql_count);
84 //echo $sql_search;
85 if( !$sql = @mysql_query($sql_search) ){
86 require_once BASE_CLASS . 'class-log.php';
115
116 require_once BASE_CLASS . 'class-connect.php';
117
DB.php https://github.com/zackster/antfarm.git | PHP | 182 lines
1<?php
2
8 function __construct() {
9 require(dirname(__FILE__) . '/config.php'); // this works
10 $this->link = mysql_connect('localhost', $dbusername, $dbpassword, true);
16 $query = sprintf("SELECT disable_email_notifications FROM users WHERE id=%d", $uid);
17 $res = mysql_query($query);
18 $row = mysql_fetch_assoc($res);
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;
30 $query = sprintf("set @cnt :=0");
31 mysql_query($query);
32 $query = sprintf("select @cnt := @cnt+1 as rank,dt.* FROM (SELECT users.username,sum(experience.value) as score from experience,users where users.id=experience.uid group by uid order by score desc limit 50) as dt");
33
34 $res = mysql_query($query);
35 $ret = array();
main.php https://code.google.com/p/nuked-klan/ | PHP | 226 lines
38
39echo "<br /><form method=\"get\" action=\"index.php\">\n"
40. "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"10\" border=\"0\">\n"
42. "<td style=\"width: 50%;\" align=\"right\"><br /><b>" . _SEARCH . " :</b> <input type=\"text\" name=\"query\" size=\"25\" /><br />\n"
43. "[ <a href=\"index.php?file=Forum&page=search\">" . _ADVANCEDSEARCH . "</a> ] "
44. "<input type=\"hidden\" name=\"file\" value=\"Forum\" />\n"
88
89 $req3 = mysql_query("SELECT forum_id from " . FORUM_MESSAGES_TABLE . " WHERE forum_id = '" . $forum_id . "'");
90 $num_mess = mysql_num_rows($req3);
91
92 $req4 = mysql_query("SELECT MAX(id) from " . FORUM_MESSAGES_TABLE . " WHERE forum_id = '" . $forum_id . "'");
93 $idmax = mysql_result($req4, 0, "MAX(id)");
116 . "<td style=\"width: 5%;\" align=\"center\">" . $img . "</td>\n"
117 . "<td style=\"width: 40%;\" onmouseover=\"this.style.backgroundColor='" . $color1 . "'; this.style.cursor='hand';\" onmouseout=\"this.style.backgroundColor='" . $color2 . "'\" onclick=\"document.location='index.php?file=Forum&page=viewforum&forum_id=" . $forum_id . "'\"><a href=\"index.php?file=Forum&page=viewforum&forum_id=" . $forum_id . "\"><big><b>" . $nom ." </b></big></a><br />" . $comment . "</td>\n";
118
privatemessages.php http://mxprojects.googlecode.com/svn/trunk/ | PHP | 280 lines
1<?php
2// Include config file
2// Include config file
3include('./common.php');
4
91 //fire it off
92 $result = mysql_query("UPDATE ".TABLE_PREFIX."_private SET ".$userType."Status = ".$statusToUpdate." WHERE messageID = ".$id);
93
100 if($statusToUpdate == PM_DELETE_MESSAGE){
101 $result = mysql_query("DELETE FROM ".TABLE_PREFIX."_private
102 WHERE messageID = ".$id."
160 // Build query to fetch the PMs
161 $result = mysql_query("SELECT SQL_CALC_FOUND_ROWS p.*, u.username
162 FROM ".TABLE_PREFIX."_users u, ".TABLE_PREFIX."_private p
172 //get the total PMs
173 $totalResult = mysql_query("SELECT FOUND_ROWS() AS totalMessages");
174 if(!$totalResult){
consoles.php https://github.com/Markkaz/Spelcodes.git | PHP | 162 lines
1<?php
2error_reporting(E_ALL & ~E_DEPRECATED);
6/* Classes importeren */
7include_once('Classes/User.php');
8include_once('Classes/Template.php');
10/* Includes importeren */
11include_once('Includes/connect.php');
12include_once('Includes/slashes.php');
21if (isset($_GET['id'])) {
22 include('Includes/login.php');
23
27 $sQuery = "SELECT consoleid, naam FROM consoles WHERE consoleid='" . add($_GET['id']) . "';";
28 $cResult = mysql_query($sQuery);
29 if ($cResult && $aData = mysql_fetch_assoc($cResult)) {
55 }
56 if ($cResult = mysql_query($sQuery)) {
57 $sKleur = '';
Sections.php https://code.google.com/p/nuked-klan/ | PHP | 161 lines
23 $titre = "<big><b>" . _VALIDART . "</b></big>";
24 $action = "index.php?file=Suggest&page=admin&op=valid_suggest&module=Sections";
25 $autor = $content[3];
33 . "if (confirm('" . _DELETESUG . " '+id+' ! " . _CONFIRM . "'))\n"
34 . "{document.location.href = 'index.php?file=Suggest&page=admin&op=raison&sug_id='+id;}\n"
35 . "}\n"
46 . "<div style=\"text-align: center;\"><br />\n"
47 . "[ <a href=\"index.php?file=Sections\" style=\"text-decoration: underline\">" . _INDEXSECTIONS . "</a> | "
48 . "<a href=\"index.php?file=Sections&op=classe&orderby=news\" style=\"text-decoration: underline\">" . _NEWSART . "</a> | "
48 . "<a href=\"index.php?file=Sections&op=classe&orderby=news\" style=\"text-decoration: underline\">" . _NEWSART . "</a> | "
49 . "<a href=\"index.php?file=Sections&op=classe&orderby=count\" style=\"text-decoration: underline\">" . _TOPART . "</a> | "
50 . _SUGGESTART . " ]";
154 ."function screen() { \n"
155 ."screenon('index.php?file=Sections&op=article&artid=".$artid."', 'index.php?file=Suggest&page=admin');\n"
156 ."}\n"
quanlyphim.php http://quan-li-cua-hang-bang-dia.googlecode.com/svn/trunk/ | PHP | 152 lines
14<p align="center" id="tieude"><b><u>Danh Sách Phim</u></b> <br></p>
15 <p align="center"> <a href="themphim.php">Thęm M?i</a> <a href="admin.php">Trang Admin </a></p>
16<table width="800" border="1" align="center" cellpadding="0" cellspacing="0">
106 <td width="50"><div align="center"><a href="suaphim.php?idphim=<?php echo $dong["maphim"]; ?>">S?a</a></div></td>
107 <td width="50"><div align="center"><a href="xoaphim.php?idphim=<?php echo $dong["maphim"]; ?>">Xóa</a></div></td>
108 </tr>
118 ?>
119 <a href="quanlyphim.php?n=<?php echo $n1;?>&tst=<?php echo $tongsotrang;?>"> Back </a>
120 <?php } ?>
139 ?>
140 <a href="quanlyphim.php?p=<?php echo $i;?>&tst=<?php echo $tongsotrang;?>"><?php echo $i." ";?></a>
141 <?php } }
146 ?>
147 <a href="quanlyphim.php?n=<?php echo $n2;?>&tst=<?php echo $tongsotrang;?>"> Next </a>
148 <?php } ?>
insert_moduli.php https://code.google.com/p/bilugcms/ | PHP | 174 lines
54 $annulla = "<input type=\"button\"
55 class=\"medio\" name=\"Annulla\" value=\"Annulla\" onclick=\"javascript:window.location='area.php?pag=elenco_moduli_new.php'\" />";
56}
61 $annulla ="<input type=\"button\"
62 class=\"medio\" name=\"Annulla\" value=\"Annulla\" onclick=\"javascript:window.location='area.php?pag=elenco_moduli_new.php'\" />";
63
64 $str=" SELECT titolo, titvideo, modulo, posizione, attivo, zona, ordine, titvideo_en, titvideo_fr, titvideo_de, titvideo_es, titvideo_pt FROM moduli where ID = $id LIMIT 1";
65 $risultato=mysql_query($str);
66 if (mysql_num_rows($risultato)>0)
71<div class="contenitore">
72<form name="statiche" method="post" action="insert_moduli_query.php" enctype="multipart/form-data">
73<input type="hidden" name="id" value="<?=$id?>"/>
146 $str1=" SELECT titolo,ordine FROM moduli order by ordine";
147 $risultato1=mysql_query($str1);
148 if (mysql_num_rows($risultato1)>0)
MySql.php https://github.com/amanai/next24.git | PHP | 374 lines
1<?php
2class MySql
42 /**
43 * Wrapper for mysql_query, to extend it with logging abilities
44 *
270 if ($link !== null)
271 return mysql_query($sql, $link);
272 else
272 else
273 return mysql_query($sql);
274 }
Utente.class.php http://antilophpe.googlecode.com/svn/ | PHP | 373 lines
1<?php
2/**
2/**
3 * File Utente.class.php
4 *
276 WHERE ant_Utente.id = ".$this->getId()."";
277 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
278 while($user_array=mysql_fetch_array($result)){
299 AND ant_Utente_File.tableObject='ant_Utente'";
300 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
301 $filesList=array();
315 WHERE ant_Utente_File.id='$fileId'";
316 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection file in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
317 $user_File_array=mysql_fetch_assoc($result);
329 AND ant_Utente_File.tableObject='ant_Utente'";
330 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
331 $user_File_array=mysql_fetch_array($result);
eBPLS.economic.class.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 340 lines
3
4Module : eBPLS.economic.class.php
5
6Dependencies :
7 eBPLS.dbfuncs.php
8 eBPLS.dataencapsulator.class.php
19
20require_once("class/eBPLS.dataencapsulator.class.php");
21require_once("lib/eBPLS.dbfuncs.php");
286 {
287 $tx = mysql_query("select * from $tble where economic_area_id = '$origid' ");
288 $tx = mysql_fetch_array($tx);
290
291 $rx=mysql_query("select * from $tble where $prim_key = '$new_code' and $prim_key <> '$origid' ");
292 $this->outnumrow = mysql_num_rows($rx);
Db.inc.php https://github.com/Kodomo/Dazzler.git | PHP | 205 lines
1<?php
2/* !
65 else{
66 mysql_query("SET NAMES 'utf8';",$this->Identificador);
67 }
150 $NumeroDeConsultas++;
151 $this->ResultadoConsulta = @mysql_query($Query,$this->Identificador);
152 $this->UltimoId = @mysql_insert_id($this->Identificador);
agree_arc_det.php https://github.com/aryonp/Magnolia.git | PHP | 167 lines
16 "WHERE u.id = '$agr_id' ";
17$agree = @mysql_query($q_agree) or die(mysql_error());
18$showAgree = mysql_fetch_array($agree);
32 "WHERE a.id = '$agr_id' ";
33$agree_data_SQL = @mysql_query($agree_data_query) or die(mysql_error());
34$array = mysql_fetch_array($agree_data_SQL);
35
36$this_page = $_SERVER['PHP_SELF']."?id=".$agr_id;
37
50 $update_file_query = "UPDATE agreement SET code_date = '$file_date', code_val = '$file_validated', code_notes = '$file_note' WHERE id = '$agr_id';";
51 @mysql_query($update_file_query) or die(mysql_error());
52 log_hist("",$agr_id);
91 <tr>
92<?php if (!file_exists($file_agreeement)) {?>
93 <td align="center"><font color="red"><b>No Policies data</b></font></td>
166<//-----------------CONTENT-END-------------------------------------------------//>
167<?php include THEME_DEFAULT.'footer.php';?>
useradmin.php https://gitlab.com/jack/senegad.git | PHP | 439 lines
104 <html><head>
105 <title>phpEventCalendar: <?php echo $mode?> Calendar User</title>
106 <link rel="stylesheet" type="text/css" href="css/adminpgs.css">
128 f.method = "post";
129 f.action = "useradmin.php?flag=<?php echo $formaction ?>";
130 f.submit();
166 <?php echo $editorstr?>
167 <option value="2" <?php echo $admin ?>><?php echo $lang['adminoption'] ?></option>
168 </select>
289 <td><span class="user_list_header"><?php echo $lang['ulistheader']?></span></td>
290 <td align="right" valign="bottom"><span class="user_list_options">[ <a href="useradmin.php?flag=add"><?php echo $lang['adduser']?></a> | <a href="index.php"><?php echo $lang['return']?></a> ]</span></td>
291 </tr>
395 <td colspan="2" align="right"><input type="submit" value="<?php echo $lang['changepw']?>">
396 <input type="button" value="<?php echo $lang['cancel']?>" onClick="location.replace('index.php');">
397 </td>
prenatal.php https://github.com/mikeymckay/chits.git | PHP | 466 lines
1<?php
2session_start();
3ob_start();
4require('./fpdf/fpdf.php');
5
123 else:
124 $brgy_name = mysql_query("SELECT barangay_name FROM m_lib_barangay WHERE barangay_id='$_SESSION[brgy]'") or die("Cannot query: 124");
125 list($brgy_label) = mysql_fetch_array($brgy_name);
160
161 $q_px = mysql_query("SELECT patient_lastname,patient_firstname,TO_DAYS(patient_dob) as kaarawan FROM m_patient WHERE patient_id='$r_prenatal[$i]'") or die(mysql_error());
162
162
163 $q_name = mysql_query("SELECT a.patient_id,a.patient_lastname,a.patient_firstname,TO_DAYS(a.patient_dob) as day_bday,b.family_id,c.address,d.barangay_name FROM m_patient a,m_family_members b,m_family_address c,m_lib_barangay d WHERE a.patient_id='$r_prenatal[$i]' AND a.patient_id=b.patient_id AND b.family_id=c.family_id AND c.barangay_id=d.barangay_id") or die("Cannot query: 137");
164 $r_name = mysql_fetch_array($q_name);
165
166 //$q_prenatal = mysql_query("SELECT a.patient_lmp,a.patient_edc,a.obscore_gp,b.prenatal_date,TO_DAYS(b.prenatal_date) as day_prenatal FROM m_patient_mc a, m_consult_mc_prenatal b WHERE a.patient_id='$r_prenatal[$i]' AND a.patient_id=b.patient_id AND b.visit_sequence='1' AND end_pregnancy_flag='N'") or die(mysql_error());
167 $q_prenatal = mysql_query("SELECT a.patient_lmp,a.patient_edc,a.obscore_gp,b.prenatal_date,TO_DAYS(b.prenatal_date) as day_prenatal FROM m_patient_mc a, m_consult_mc_prenatal b WHERE a.patient_id='$r_prenatal[$i]' AND a.patient_id=b.patient_id AND end_pregnancy_flag='N' ORDER by b.prenatal_date ASC") or die(mysql_error());
index.php http://ourproject.googlecode.com/svn/trunk/ | PHP | 363 lines
14if (@ include ("../data/phpyun.lock")) {
15 show_view('??????PHPyun????????phpyun_lock??????');
16 exit ();
59 <p>
60 3. ??????????????????????????????????PHPYUN ???? ?????????????????????Powered by PHPYun.???????????????
61 </p>
82 <p>
83 ?? ?????! ??????????????????????????PHPYUN ????????? ????????????????????????????????????????????????????????????????????????????????????????????????????????????????? PHPYUN1.3 BETA???????????????????????????????????????????????????????????????????????????????????????????????????????????
84 </p>
147 $tablepre = $_POST[tablepre];
148 $fp=file_get_contents("data/phpjob_table.php");
149 $fp=str_replace("phpjob_",$tablepre,$fp);
156 //??????
157 $fpp=file_get_contents("data/phpjob_data.php");
158 $fpp=str_replace("phpjob_",$tablepre,$fpp);
index.php https://github.com/jomartigcal/cvsea.git | PHP | 239 lines
94 <legend class="position">Error</legend>
95 <p>It seems like your database driver is missing or misconfigured.<br />Please correct it at system/application/config/database.php.</p>
96 </fieldset>
142 <td>
143 <?php
144 // simple URL autodetection; cannot cover all use cases so give the user freedom to edit
167 <?php for ($i = 4; $i < 11; $i++) { ?>
168 <option value="<?php echo $i; ?>"><?php echo $i; ?></option>
169 <?php } ?>
175 <?php for ($i = 4; $i < 11; $i++) { ?>
176 <option value="<?php echo $i; ?>"><?php echo $i; ?></option>
177 <?php } ?>
187 <?php for ($i = 4; $i < 11; $i++) { ?>
188 <option value="<?php echo $i; ?>"><?php echo $i; ?></option>
189 <?php } ?>
sync_functions.php https://bitbucket.org/kostyantyn_kyyashko/kino-teatr.ua.git | PHP | 343 lines
1<?php
2
4 $sql = "SELECT mc.id, mc.name AS name, mcl.title AS name_ukr FROM grifix_main_cinemas mc LEFT JOIN grifix_main_cinemas_lng mcl ON (mc.id = mcl.record_id AND mcl.lang_id = 3)";
5 $res = mysql_query($sql);
6 $arr = array();
14 $sql = "SELECT mch.id AS hall_id, mch.cinema_id, mch.name, mchl.title AS name_ukr FROM grifix_main_cinemas_halls mch LEFT JOIN grifix_main_cinemas_halls_lng mchl ON (mch.id = mchl.record_id AND mchl.lang_id = 3)";
15 $res = mysql_query($sql);
16 $arr = array();
100 $sql = "SELECT gmf.title_orig, gmf.name AS title, gmf.year, gmf.id, gmfl.title AS title_ukr, gmfr.title AS title_rus FROM grifix_main_films gmf LEFT JOIN grifix_main_films_lng gmfl ON (gmf.id = gmfl.record_id AND gmfl.lang_id = 3) LEFT JOIN grifix_main_films_lng gmfr ON (gmf.id = gmfr.record_id AND gmfr.lang_id = 1)";
101 $res = mysql_query($sql);
102 $arr = array();
144 $sites_url = 'http://server.megakino.com.ua/gate/sites';
145 mysql_query("TRUNCATE temp_auto_films_cmd");
146 $sites_url .= '?sessionid='.$session_id;
187// $sql = "INSERT INTO `grifix_main_shows_eventmap`(`show_id`, `event_id`, `site_id`, `response`) VALUES ($show_id,$event_id,'$site_id','$map_response')";
188// mysql_query($sql);
189// }
ebpls_fish_permit.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 298 lines
3define('FPDF_FONTPATH','font/');
4require('../ebpls-php-lib/html2pdf_lib/fpdf.php');
5$permit_type='Fishery';
5$permit_type='Fishery';
6include"../includes/variables.php";
7include_once("../lib/multidbconnection.php");
9
10 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());
11 $resulta=mysql_fetch_row($result);
80if ($reportpermit == '1') {
81 $fish= mysql_query("select boat_name, crew, engine_type, engine_cap, reg_no from fish_boat where owner_id='$resulta[2]'")
82 or die("12".mysql_error());
114if ($reportpermit == '1') {
115$getboat = mysql_query("select * from fish_boat where owner_id='$resulat[2]'") or die('3'.mysql_error);
116} else {
normal.php https://github.com/jaynathan79/CFAT-March-Madness.git | PHP | 299 lines
1<?php
2include("cfatheader.php");
2include("cfatheader.php");
3include("menu.php");
4
41 "FROM scores, scoring_info WHERE scores.scoring_type = scoring_info.type GROUP BY scoring_type ORDER BY display_name";
42$scoringTypes = mysql_query($scoringTypesQuery,$db) or die(mysql_error());
43
73 $rankingQuery = "SELECT id, score FROM scores WHERE scoring_type = '".$scoringSystem."' ORDER BY score DESC";
74 $ranking = mysql_query($rankingQuery,$db) or die(mysql_error());
75
106
107 scoringDescriptions = new Array( <?php echo $scoringDescriptions; ?> );
108
166 <th><strong>Best</strong></th>
167 <!--<th><strong><a href="standings.php?type=best">Best</a></strong></th>-->
168 <th><strong>Tiebreaker</strong></th>
applicationforms.php https://bitbucket.org/mannir/agp.git | PHP | 173 lines
1<?php
2global $url; if($_SERVER['HTTP_HOST']=='localhost') { $cn=mysql_connect("localhost","root",""); mysql_select_db("agpapp");
5global $url; $url='http://agpapp.esystems.me/sites/all/modules/manniragp/'; }
6require_once('tcpdf/config/lang/eng.php');
7require_once('tcpdf/tcpdf.php');
9if(isset($_REQUEST['from']) && isset($_REQUEST['to']) && isset($_REQUEST['sortby'])) { $fr=$_REQUEST['from']; $to=$_REQUEST['to']; $sb=$_REQUEST['sortby'];
10 $query = mysql_query("SELECT *,(select department from _programmes where _programmes.PROGRAMME=_application.programme1 LIMIT 1) AS department FROM `_application`
11WHERE id>='$fr' AND id<='$to' ORDER BY '$sb'"); $ar = array(); while($line = mysql_fetch_array($query, MYSQL_ASSOC)){ $ar[] = $line; }
15 $o = (object) mysqli_fetch_assoc(mysqli_query($con,"SELECT max(id) as mxid FROM _application")); $mxid=$o->mxid;
16$query = mysql_query("SELECT *,(select department from _programmes where _programmes.PROGRAMME=_application.programme1 LIMIT 1) AS department FROM `_application`
17WHERE id>=1 AND id<='$mxid'"); $ar = array(); while($line = mysql_fetch_array($query, MYSQL_ASSOC)){ $ar[] = $line; }
menu_tecnico.php https://bitbucket.org/joseluisroot/general.git | PHP | 210 lines
62 <span>Bienvenido,</span>
63 <h2><?php echo $_SESSION['Usuario']; ?></h2>
64 </div>
77 <ul class="nav child_menu">
78 <li><a href="../control/orden_trabajo.php" >Orden Trabajo</a></li>
79 </ul>
126 <a href="javascript:;" class="user-profile dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
127 <img src="../img/mecanico.png" alt=""><?php echo $_SESSION['Usuario']; ?>
128 <span class=" fa fa-angle-down"></span>
138 <li><a href="javascript:;">Help</a></li>
139 <li><a href="../conexion/salir.php"><i class="fa fa-sign-out pull-right"></i> Salir</a></li>
140 </ul>
157 <a>
158 <a href="../control/orden_detalle.php?Id=<?php echo $row_result[0]; ?>"><span class="image"><img src="../img/engrane.png" alt="Profile Image" /></span>
159 <span>
rollback.php http://timoseven.googlecode.com/svn/trunk/ | PHP | 107 lines
1<?php
2 include("header.php");
7
8<form id="rollback" method="post" action="<? $_SERVER['PHP_SELF']?>">
9<center>
13 <select name="group_name" id="group_name" onclick="showtest(this.value)">
14 <?php
15 $sql="select distinct group_name from group_ip_map;";
15 $sql="select distinct group_name from group_ip_map;";
16 $result = mysql_query($sql);
17 while($record = mysql_fetch_array($result)) {
31<p><input type="submit" name="save" value="???????" onclick="javascript:return confirm('?????????');"></p>
32<?php
33function testNginx()
72 $insertsql = "insert into `conf_file` (`group_name`,`nginx_file`,`admin_ip`) values ('".$group."','".$newcontent."','".$ip."')";
73 mysql_query($insertsql);
74 $ipsql="select ip_addr from group_ip_map where group_name='$group'";
soap_sis_laporan_keuangan.php http://sistem-informasi-sekolah-online.googlecode.com/svn/trunk/ | PHP | 267 lines
1<?php
2require_once("rpcl/rpcl.inc.php");
2require_once("rpcl/rpcl.inc.php");
3require_once("soap_sis_common.php");
4require_once("soap_sis_common_laporan_keuangan.php");
5//Includes
6use_unit("webservices.inc.php");
7use_unit("forms.inc.php");
7use_unit("forms.inc.php");
8use_unit("extctrls.inc.php");
9use_unit("stdctrls.inc.php");
28
29 $result = mysql_query($sql);
30
59
60 $result = mysql_query($sql);
61
mysql_backup.class.php https://github.com/holsinger/openfloor.git | PHP | 348 lines
1<?php
2////////////////////////////////////////////////////////////////////////////////
4// Class name: mysql_backup
5// PHP version: 4.0.2
6// Function: Back up/Restore a MySql db.
79
80 $res2=mysql_query("select * from $tablename",$con);
81 $nf=mysql_num_fields($res2);
121 {
122 case 4: //little weakness here...there is no way (thru the PHP/MySQL interface) to tell the difference between a tinyint and a year field type
123 $sql.="tinyint";
250 $sql = "SHOW TABLES FROM $dbname";
251 $result = mysql_query($sql);
252
262
263 $result2 = mysql_query("SHOW CREATE TABLE `".$row[0]."`");
264 $row2 = mysql_fetch_row($result2);
functions.php https://bitbucket.org/shopworksnl/wrike.git | PHP | 433 lines
1<?php
2include_once("/www/wrike/config.php");
30 // redirect to auth page
31 $callback_url = "http://" . $_SERVER["HTTP_HOST"] . "/wrike/authorize.php?oauth_token_secret=" . $token_secret;
32
55
56 $_url = "http://" . $_SERVER["HTTP_HOST"] . "/wrike/authorize.php?access_token=" . $access_token . "&access_token_secret=" . $access_token_secret;
57
107 if(is_object($object)){
108 mysql_query("INSERT INTO wrike SET wrike_task_id='".$object->task->id."', zendesk_id='".$extraParams['zendesk_id']."'") or die(mysql_error());
109 }
178 global $consumer;
179 $q = mysql_query("SELECT * FROM wrike WHERE zendesk_id='".$extraParams['zendesk_id']."'");
180 $r = mysql_fetch_assoc($q);
function.mysql-query.html git://pkgs.fedoraproject.org/kdewebdev | HTML | 496 lines
82><P
83> (PHP 3, PHP 4 )</P
84>mysql_query -- Send a MySQL query</DIV
93CLASS="methodname"
94>mysql_query</B
95> ( string query [, resource link_identifier [, int result_mode]])<BR
191CLASS="function"
192>mysql_query()</B
193> fails and returns <TT
215CLASS="function"
216>mysql_query()</B
217></B
226CLASS="php"
227><php
228$result = mysql_query("SELECT * WHERE 1=1")
index.php https://github.com/adanganan/chits.git | PHP | 317 lines
24// standard class includes
25include "../class.mysqldb.php";
26include "../class.user.php";
26include "../class.user.php";
27include "../class.site.php";
28include "../class.module.php";
28include "../class.module.php";
29include "../class.datanode.php";
30
32// courtesy of http://www.fpdf.org/
33include "../class.fpdf.php";
34include "../class.pdf.php";
37
38include "../initsession.php";
39
AloneDB.php http://phpfor.googlecode.com/svn/trunk/ | PHP | 269 lines
1<?php
2class AloneDB{
53
54 if($rs = mysql_query($sql,$db_lnk)){
55 $db_result = array('rs'=>&$rs,'sql'=>$sql);
146 if(constant('DB_CHARSET')){
147 mysql_query('SET NAMES \''.DB_CHARSET.'\'',$lnk);
148 }
173 if(!function_exists('db_get_update_sql')){
174 require('core/db.tools.php');
175 // require(CORE_INCLUDE_DIR.'/core/db.tools.php');
181 if(!function_exists('db_get_insert_sql')){
182 require(CORE_INCLUDE_DIR.'/core/db.tools.php');
183 }
252 if(!function_exists('database_split_sql')){
253 require(CORE_INCLUDE_DIR.'/core/db.split_sql.php');
254 }
confirmfinalbill.php https://bitbucket.org/vincentbii/amurt.git | PHP | 200 lines
12define('NO_CHAIN',1);
13require_once($root_path.'include/inc_front_chain_lang.php');
14require_once($root_path.'include/inc_date_format_functions.php');
15
16 /* include('includes/condb.php');
17 error_reporting(0);
106 Date
107 : <?php echo $presdate; ?></td>
108 </tr>
180 <input type="hidden" name="lang" value="<?php echo $lang ?>">
181 <input type="hidden" name="sid" value="<?php echo $sid ?>">
182 <input type="hidden" name="full_en" value="<?php echo $full_en ?>">
185 <a href="javascript:submitform();"><img <?php echo createLDImgSrc($root_path,'savedisc.gif','0'); ?>></a>
186 <a href="<?php echo $breakfile ?>"><img <?php echo createLDImgSrc($root_path,'cancel.gif','0'); ?>></a> </center>
187
klotterplank.php https://github.com/Rambutan/hamsterpaj.git | PHP | 298 lines
1<?php
2
12
13// header('location: /traffa/klotterplanket.php');
14
18
19 require('../include/core/common.php');
20 $ui_options['menu_path'] = array('traeffa', 'gamla_klotterplanket');
47 $query = makeQuery($mode, $criteria);
48 $result = mysql_query($query) or die('Ett fel har upstått:<br/>' . mysql_error());
49 $genderlabels['P'] = 'Pojke';
87 echo fix_time($data['timestamp']) . ' (inlägg #' . $data['id'] . ') <a style="text-decoration:none;" href="javascript:#;" onclick="javascript:document.gbform.message.value=document.gbform.message.value+\''.$data['username'].' : \';document.gbform.message.focus();">[^]</a><br/>' . "\n";
88 echo '<a href="' . $hp_url . '/traffa/profile.php?id=' . $data['userid'] . '">' . "\n";
89 echo '<b>' . $data['username'] . '</b></a> ' . "\n";
128 $query = 'SELECT COUNT(id) AS total FROM klotterplank WHERE userid = ' . $_SESSION['login']['id'] . ' AND timestamp > UNIX_TIMESTAMP() - 60';
129 $result = mysql_query($query);
130 $data = mysql_fetch_assoc($result);
fonctionsClients.php http://auberge-de-jeunesse-de-rimouski.googlecode.com/svn/trunk/ | PHP | 251 lines
1<?php
2/**
7 session_start();
8 include ("../include/fctDb.php");
9
19 connectDb();
20 $requete = mysql_query("SELECT id_client from Client WHERE id_client='".mysql_real_escape_string($_SESSION['idClient'])."'");
21 $ligne = mysql_fetch_row($requete);
37 connectDb();
38 $requete = mysql_query("SELECT nom_cl FROM Client WHERE id_client='".mysql_real_escape_string($ipNoClient)."'");
39 $ligne = mysql_fetch_row($requete);
53 connectDb();
54 $requete = mysql_query("SELECT prenom_cl FROM Client WHERE id_client='".mysql_real_escape_string($ipNoClient)."'");
55 $ligne = mysql_fetch_row($requete);
69 connectDb();
70 $requete = mysql_query("SELECT tarif FROM Tarif_lit t, Facture f WHERE t.id_tarif = f.id_tarif AND f.id_facture='".mysql_real_escape_string($ipNoFacture)."'");
71 $ligne = mysql_fetch_row($requete);
EditKecamatan.php https://bitbucket.org/ArgoWibowo/si_petani.git | PHP | 219 lines
1<?php
2 session_start();
2 session_start();
3 $koneksi = include("koneksi.php");
4 $Kec = $_GET['id'];
31 <ul class="nav navbar-nav navbar-right">
32 <?php
33 $id_user = $_SESSION['ID_User'];
35 mysql_select_db("iais_ukdw") or die("Database tidak ditemukan");
36 $query= mysql_query("SELECT * FROM master_petani where ID_User = '$id_user';");
37 $brsnama = mysql_fetch_array($query)
38 ?>
39 <li><a href="#">Welcome <?php echo $brsnama['Nama_Petani'] ?></a></li>
40 <li><a href="logout.php">Keluar</a></li>
70 <ul class="nav-pills nav-stacked" style="list-style-type:none;">
71 <li><a href="Wilayah.php"> Pendataan Wilayah</a></li>
72 <!-- <li><a href="PetaniUser.php">Pendataan Petani</a></li> -->
trace2table.php https://github.com/hipe/php-analysis.git | PHP | 369 lines
1<?php
2/*
78 $q = "show tables where Tables_in_".$this->database." = '$this->table_name'";
79 $rs = mysql_query( $q );
80 return (bool) mysql_num_rows( $rs );
84 $q = "select count(*) from `$this->table_name`";
85 $rs = mysql_query( $q );
86 $row = mysql_fetch_row( $rs );
173 protected function run_sql( $q ){
174 $ret = mysql_query( $q );
175 if (false===$ret){
250 return "Usage:\n".
251 " php ".$GLOBALS['argv'][0].' import <parameters file> <input csv>'."\n".
252 "\n".
253 "to output an example parameters file:\n".
254 " php ". $GLOBALS['argv'][0].' example <parameters file name>'."\n "
255 ;
lgu_page.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 189 lines
93 <td align=center class='hdr' width="10%">
94 <a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&is_desc=<?php echo $is_desc;?>&orderkey=city_municipality_code'> LGU Code</a>
95 </td>
96 <td align=center class='hdr' width="35%">
97 <a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&is_desc=<?php echo $is_desc;?>&orderkey=city_municipality_desc'> Name of LGU</a>
98 </td>
99 <td align=center class='hdr' width="35%">
100 <a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&is_desc=<?php echo $is_desc;?>&orderkey=upper'> Province</a>
101 </td>
104 <tr width=90%>
105<?php
106 /*
124$get_province = @mysql_fetch_assoc($province);
125include'tablecolor-inc.php';
126print "<tr bgcolor='$varcolor'>\n";
project.php https://github.com/mbmccormick/issuebox.git | PHP | 215 lines
1<?php
2
6
7 $result = mysql_query("SELECT * FROM project WHERE id='" . params('id') . "'");
8 $project = mysql_fetch_array($result);
11 {
12 $result = mysql_query("SELECT * FROM issue WHERE projectid='$project[id]' ORDER BY isurgent DESC, number ASC");
13 while($row = mysql_fetch_array($result))
14 {
15 $sql = mysql_query("SELECT COUNT(*) AS rowcount FROM comment WHERE issueid='$row[id]'");
16 $return = mysql_fetch_array($sql);
18
19 $sql = mysql_query("SELECT id, username FROM user WHERE id='$row[createdby]'");
20 $user = mysql_fetch_array($sql);
55 set("project", $project);
56 return html("project/view.php");
57 }
mem_edit_invoice_admin.php https://github.com/traceyambrose/foodcoop.git | PHP | 360 lines
1<?php
2if( $updatevalues == 'ys' )
11 product_id = "'.$product_id.'"';
12 $resulti = @mysql_query($sqli,$connection) or die(mysql_error());
13 while ( $row = mysql_fetch_array($resulti) )
25 AND product_id = "'.$product_id.'"';
26 $resultq = @mysql_query($sqlq,$connection) or die(mysql_error());
27 while ( $row = mysql_fetch_array($resultq) )
50 AND product_id = "'.$product_id.'"';
51 $resultdelete = @mysql_query($sqld,$connection) or die(mysql_error());
52 $message4 = '<b>Product was removed from basket.</b>';
62 product_id = "'.$product_id.'"';
63 $resultus = @mysql_query($sqlus,$connection) or die("Could not execute query updating stock in public product list.");
64 $sqlus2 = '
70 product_id = "'.$product_id.'"';
71 $resultus2 = @mysql_query($sqlus2,$connection) or die("Could not execute query updating stock in prep list.");
72 }
EditNode.php https://github.com/ninuxorg/wnmap.git | PHP | 254 lines
1<?php
2/*
20
21require ("config.php");
22require ("geocode_lib.php");
83 <body>
84<?php
85
93$query = "SELECT * FROM " . MYSQL_NODES_TABLE . " WHERE adminHash='$hash' AND status <> '0'";
94$result = mysql_query ($query, $connection) or die (mysql_error());
95
114?>
115 <h1><?php echo EDIT_NODE;?></h1>
116 <form action="EditNodeSubmit.php" method="POST">
119 <td colspan="2" style="border-bottom: 1px solid #eee">
120 <h2><?php echo NODE_INFORMATION;?></h2>
121 <input type="hidden" value="<?php echo $hash;?>" name="hash" />
process_registration.php git://github.com/aichallenge/aichallenge.git | PHP | 312 lines
8
9require_once 'mysql_login.php';
10require_once 'bad_words.php';
10require_once 'bad_words.php';
11require_once 'web_util.php';
12require_once('memcache.php');
124 $sql="select email from user where email = '$user_email' and admin = 0";
125 $result = mysql_query($sql);
126 if ($result && mysql_num_rows($result) > 0) {
305
306<?php } else { ?>
307
311
312<?php require_once 'footer.php'; ?>
313
block_event.php https://gitlab.com/donaldinou/nuked-gamer.git | PHP | 298 lines
1<?php
2// -------------------------------------------------------------------------//
2// -------------------------------------------------------------------------//
3// Nuked-KlaN - PHP Portal //
4// http://www.nuked-klan.org //
12global $nuked, $language;
13translate('modules/Calendar/lang/' . $language . '.lang.php');
14
67 $blok['content'] .= '<table style="margin:0 auto;text-align:left" cellpadding="0" cellspacing="0"><tr><td>'."\n"
68 . '<a href="index.php?file='.$file.'&mo=' . $prevmonth . '&ye='.$prevyear.'" title="'._PREVMONTH.'"><small><<</small></a> <b>'.$months[$this_month].' '.$year.'</b> '."\n"
69 . '<a href="index.php?file='.$file.'&mo='.$nextmonth.'&ye='.$nextyear.'" title="'._NEXTMONTH.'"><small>>></small></a></td></tr></table>'."\n"
100
101 $sql1 = mysql_query('SELECT titre, date_jour, date_mois, date_an, heure, auteur FROM ' . CALENDAR_TABLE . ' WHERE date_an = \'' . $year . '\' AND date_mois = \'' . $month . '\' AND date_jour = \'' . $event_date . '\' ORDER BY heure');
102 $nb_event = mysql_num_rows($sql1);
104 if (defined("WARS_TABLE")){
105 $sql2 = mysql_query('SELECT * FROM ' . WARS_TABLE . ' WHERE date_an = \'' . $year . '\' AND date_mois = \'' . $month . '\' AND date_jour = \'' . $event_date . '\' ');
106 $nb_match = mysql_num_rows($sql2);
sort_hourly.php https://github.com/ClickBooth/XTracks.git | PHP | 237 lines
1<? include_once($_SERVER['DOCUMENT_ROOT'] . '/xtracks-app/bootstrap.php');
2
16 $user_sql = "SELECT user_pref_breakdown, user_pref_show, user_cpc_or_cpv FROM 202_users_pref WHERE user_id=".$mysql['user_id'];
17 $user_result = _mysql_query($user_sql, $dbGlobalLink); //($user_sql);
18 $user_row = mysql_fetch_assoc($user_result);
136 $breakdown_sql = "SELECT * FROM 202_sort_breakdowns WHERE user_id='".$mysql['user_id']."' " . $mysql['order'];
137 $breakdown_result = mysql_query($breakdown_sql) or record_mysql_error($breakdown_sql); ?>
138
140 <tr>
141 <th><a class="onclick_color" onclick="loadContent('/ajax/sort_hourly.php','','<? echo $html['sort_breakdown_order']; ?>');">Time</a></th>
142 <th><a class="onclick_color" onclick="loadContent('/ajax/sort_hourly.php','','<? echo $html['sort_breakdown_clicks_order']; ?>');">Clicks</a></th>
142 <th><a class="onclick_color" onclick="loadContent('/ajax/sort_hourly.php','','<? echo $html['sort_breakdown_clicks_order']; ?>');">Clicks</a></th>
143 <th><a class="onclick_color" onclick="loadContent('/ajax/sort_hourly.php','','<? echo $html['sort_breakdown_leads_order']; ?>');">Leads</a></th>
144 <th><a class="onclick_color" onclick="loadContent('/ajax/sort_hourly.php','','<? echo $html['sort_breakdown_su_ratio_order']; ?>');">Avg S/U</a></th>
144 <th><a class="onclick_color" onclick="loadContent('/ajax/sort_hourly.php','','<? echo $html['sort_breakdown_su_ratio_order']; ?>');">Avg S/U</a></th>
145 <th><a class="onclick_color" onclick="loadContent('/ajax/sort_hourly.php','','<? echo $html['sort_breakdown_payout_order']; ?>');">Avg Payout</a></th>
146 <th><a class="onclick_color" onclick="loadContent('/ajax/sort_hourly.php','','<? echo $html['sort_breakdown_epc_order']; ?>');">Avg EPC</a></th>
ebpls_professional_tax.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 345 lines
3define('FPDF_FONTPATH','font/');
4require('ebpls-php-lib/html2pdf_lib/fpdf.php');
5include("lib/phpFunctions-inc.php");
187require_once("lib/ebpls.utils.php");
188require_once("ebpls-php-lib/utils/ebpls.search.funcs.php");
189//require_once("includes/eBPLS_header.php");
220<h4 align="center"> <?php echo $resulta[0]; ?> </h4>
221<h4 align="center"> <?php echo $resulta[2]; ?> </h4>
222<h4 align="center"><u> BUSINESS FEE COLLECTION </u></h4>
234 /* This is the correct SQL
235 $result=mysql_query("select a.business_permit_code, a.application_date, b.business_name, b.business_street, a.transaction,
236 concat(c.owner_first_name, ' ', c.owner_middle_name, ' ', c.owner_last_name), c.owner_gender,
328 <tr>
329 <td align="center"><b><u> <?php echo $resulta[3]; ?> </b></u> <br> <?php echo $resulta[7]; ?> <br> <br> <br> <br> <br> </td>
330 </tr>
mysql.php https://github.com/openaustralia/twfy.git | PHP | 364 lines
1<?php
2
7
8Somewhere (probably in includes/easyparliament/init.php) there should be something like:
9
136
137 $q = mysql_query($sql,$this->conn) or $this->error(mysql_errno().": ".mysql_error());
138
309 global $global_connection;
310 // These vars come from config.php.
311
345 // We could also output $q->mysql_info() here, but that's for
346 // PHP >= 4.3.0.
347
serviceSummary.php https://github.com/zsalwen/Service-Office.git | PHP | 208 lines
1<?
2include 'common.php';
3function monthConvert($month){
68function attorneyCustomLang($att,$str){
69 $r=@mysql_query("SELECT * FROM ps_str_replace where attorneys_id = '$att'");
70 while ($d=mysql_fetch_array($r, MYSQL_ASSOC)){
80 $qn="SELECT * FROM ps_history WHERE packet_id = '$packet' and defendant_id = '$defendant' order by history_id ASC";
81 $rn=@mysql_query($qn);
82 $list = "<div>";
96function nameDef($defendant,$packet){
97 $r=@mysql_query("SELECT name".$defendant." from ps_packets WHERE packet_id='$packet'") or die (mysql_error());
98 $d=mysql_fetch_array($r,MYSQL_ASSOC);
102 $qh="SELECT action_str, serverID, address, wizard, resident, residentDesc FROM ps_history WHERE packet_id='$packet' AND defendant_id='$defendant' AND (WIZARD='BORROWER' OR WIZARD='NOT BORROWER')";
103 $rh=@mysql_query($qh) or die (mysql_error());
104 $dh=mysql_fetch_array($rh,MYSQL_ASSOC);
edit.php https://github.com/heidymadia/sfbackup.git | PHP | 54 lines
1<?php
2include('config.php');
7$sql = "UPDATE `opportunities` SET `AccountId` = '{$_POST['AccountId']}' , `Amount` = '{$_POST['Amount']}' , `CampaignId` = '{$_POST['CampaignId']}' , `CloseDate` = '{$_POST['CloseDate']}' , `CreatedById` = '{$_POST['CreatedById']}' , `CreatedDate` = '{$_POST['CreatedDate']}' , `CurrentGenerators__c` = '{$_POST['CurrentGenerators__c']}' , `DeliveryInstallationStatus__c` = '{$_POST['DeliveryInstallationStatus__c']}' , `Description` = '{$_POST['Description']}' , `ExpectedRevenue` = '{$_POST['ExpectedRevenue']}' , `Fiscal` = '{$_POST['Fiscal']}' , `FiscalQuarter` = '{$_POST['FiscalQuarter']}' , `FiscalYear` = '{$_POST['FiscalYear']}' , `ForecastCategory` = '{$_POST['ForecastCategory']}' , `ForecastCategoryName` = '{$_POST['ForecastCategoryName']}' , `HasOpportunityLineItem` = '{$_POST['HasOpportunityLineItem']}' , `IsClosed` = '{$_POST['IsClosed']}' , `IsDeleted` = '{$_POST['IsDeleted']}' , `IsPrivate` = '{$_POST['IsPrivate']}' , `IsWon` = '{$_POST['IsWon']}' , `LastActivityDate` = '{$_POST['LastActivityDate']}' , `LastModifiedById` = '{$_POST['LastModifiedById']}' , `LastModifiedDate` = '{$_POST['LastModifiedDate']}' , `LeadSource` = '{$_POST['LeadSource']}' , `MainCompetitors__c` = '{$_POST['MainCompetitors__c']}' , `Name` = '{$_POST['Name']}' , `NextStep` = '{$_POST['NextStep']}' , `OrderNumber__c` = '{$_POST['OrderNumber__c']}' , `OwnerId` = '{$_POST['OwnerId']}' , `Pricebook2Id` = '{$_POST['Pricebook2Id']}' , `Probability` = '{$_POST['Probability']}' , `StageName` = '{$_POST['StageName']}' , `SystemModstamp` = '{$_POST['SystemModstamp']}' , `TotalOpportunityQuantity` = '{$_POST['TotalOpportunityQuantity']}' , `TrackingNumber__c` = '{$_POST['TrackingNumber__c']}' , `Type` = '{$_POST['Type']}' WHERE `id` = '$id' ";
8mysql_query($sql) or die(mysql_error());
9echo (mysql_affected_rows()) ? "Edited row.<br />" : "Nothing changed. <br />";
9echo (mysql_affected_rows()) ? "Edited row.<br />" : "Nothing changed. <br />";
10echo "<a href='list.php'>Back To Listing</a>";
11}
11}
12$row = mysql_fetch_array ( mysql_query("SELECT * FROM `opportunities` WHERE `id` = '$id' "));
13?>
build-editor.php https://bitbucket.org/obsidian/selador | PHP | 389 lines
1<?php
2
2
3/* build-editor.php - Front-end code for the building editor in admin pages
4 *
50 $query = "delete from $module where id=".$_REQUEST['id'];
51 mysql_query ($query);
52 $cmd = "overview"; // Und wieder die Übersicht anzeigen
182 echo $query;
183 if (!mysql_query ($query))
184 echo "<b>Fehler beim Einfügen von $query: ".mysql_error()."</b><br>\n";
194 $cmd = "overview";
195 // echo "<a href=\"gebliste.php\">Zurück zur Liste</a>.";
196 }
202 $query = "select * from $module where id=".$id;
203 $res = mysql_query ($query);
204 $dbrow = mysql_fetch_array ($res);
export.php https://bitbucket.org/geoffwong/airscore.git | PHP | 372 lines
1<?php
2require 'authorisation.php';
82print $sql;
83$result = mysql_query($sql, $link) or die("can't select comp details");
84$row = mysql_fetch_array($result, MYSQL_ASSOC);
96$sql = "select comPk from hgfa_ladder.tblCompetition where comName='$cname' and comDateFrom='$cfrom'";
97$result = mysql_query($sql, $link) or die("can't select comp details" . mysql_error() . "\n");
98$HcomPk = 0;
107 $sql = "insert into hgfa_ladder.tblCompetition (comName,comLocation,comDateFrom,comDateTo,comMeetDirName,sanValue) values ('$cname','$cloc','$cfrom','$cto','$cdirname','$csanction')";
108 $result = mysql_query($sql, $link) or die("can't insert new competition: " . mysql_error() . "\n");
109 $HcomPk = mysql_insert_id();
113 $sql = "update hgfa_ladder.tblCompetition set comLocation='$cloc', comDateTo='$cto',comMeetDirName='$cdirname',sanValue='$csanction' where comPk=$HcomPk";
114 $result = mysql_query($sql, $link) or die("can't update competition" . mysql_error() . "\n");
115}
123$sql = "select * from xcdb.tblFormula where forPk=$forPk";
124$result = mysql_query($sql,$link) or die("Unable to find formula: " . mysql_error() . "\n");
125$row = mysql_fetch_array($result, MYSQL_ASSOC);
DetailStrukturOrganisasi.php https://bitbucket.org/ArgoWibowo/si_petani.git | PHP | 230 lines
1<?php
2 session_start();
3 if (!isset($_SESSION ['ID_User'])){
4 header("location:login.php?pesan=Mohon Login");
5 }
7 {
8 header("Location:login.php?pesan=khusus untuk admin ");
9 }
33 <ul class="nav navbar-nav navbar-right">
34 <?php
35 $id_user = $_SESSION['ID_User'];
37 mysql_select_db("iais_ukdw") or die("Database tidak ditemukan");
38 $query= mysql_query("SELECT * FROM master_petani where ID_User = '$id_user';");
39 $brsnama = mysql_fetch_array($query)
40 ?>
41 <li><a href="#">Welcome <?php echo $brsnama['Nama_Petani'] ?></a></li>
42 <li><a href="logout.php">Keluar</a></li>
index.php http://showslow.googlecode.com/svn/trunk/ | PHP | 228 lines
1<?php
2require_once(dirname(dirname(dirname(__FILE__))).'/global.php');
12 );
13 $result = mysql_query($query);
14
27
28 if (!mysql_query($query))
29 {
35
36$post_data = file_get_contents("php://input");
37$post = json_decode($post_data, true);
125
126 if (!mysql_query($query))
127 {
209<h1>Configure your YSlow</h1>
210<p><b style="color: red">WARNING! Only use this beacon If you're OK with all your YSlow 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>
211
paginar.php http://cachoncr.googlecode.com/svn/trunk/ | PHP | 253 lines
1<?php
2 //inicializo el criterio y recibo cualquier cadena que se desee buscar
147
148$rs = mysql_query($ssql,$conn);
149
158
159 $resultado=mysql_query($strselect,$conn);
160
163
164 $consulta = mysql_query($strselect);
165 $totalfilas= mysql_num_rows($consulta);
242
243 echo "<a href='index.php?mod=catalogo&acc=paginar&pagina=" . $i ."&nivel=".$nivel. "&criterio=" . $txt_criterio . "'>" . $i . "</a> ";
244
cadastroProtocolo.php http://controlprot.googlecode.com/svn/trunk/ | PHP | 285 lines
1<?php
2if(!isset($_SESSION["loginIndex"])){
3echo "<script language=\"JavaScript\">
4document.location=\"index.php\";
5</script>";
12echo "
13<form method=\"POST\" name=\"cabecalhoFormulario\" action=\"index2.php?pagina=Novo\">
14<table border=\"0\" align=center>
40<div>
41<form method=\"POST\" name=\"itemFormulario\" action=\"index2.php?pagina=Novo\">
42<table border=\"0\" width=\"650\" align=\"center\" class=\"tabItemProtocolo\">
57 where A.codProtocolo ='".$_SESSION['codProtocolo']."'";
58 $resultado = mysql_query($sql) or die ("erro sql".mysql_error());
59 $total = mysql_num_rows($resultado);
68 <td class=\"resultCampo\">".$linha['obs']."</td>
69 <td><a href=\"index2.php?pagina=Novo&item=".$linha['cpfCnpjCliente']."\" >X</a></td>
70 </tr>";
detaillegal.php https://bitbucket.org/Iowane_Tamani/feejeetrav.git | PHP | 400 lines
120
121 <?php include('navBar.php'); ?>
122
140 <header><h3>English</h3></header>
141 <form action="editlegal.php?id=<?php echo $id;?>&lang=<?php echo "1";?>" method="post" enctype="multipart/form-data">
142 <?php
162 <select style="width:92%;" name="language" id="language" >
163 <?php
164 $resultq = $conn->query("SELECT * FROM `language`where lang_id='$varLang'");
222 <header><h3>Chinese</h3></header>
223 <form action="editlegal.php?id=<?php echo $id;?>&lang=<?php echo "2";?>" method="post" enctype="multipart/form-data">
224 <?php
303 <header><h3>Japanese</h3></header>
304 <form action="editlegal.php?id=<?php echo $id;?>&lang=<?php echo "3";?>" method="post" enctype="multipart/form-data">
305 <?php
update_cpc.php https://github.com/ClickBooth/XTracks.git | PHP | 226 lines
1<? include_once($_SERVER['DOCUMENT_ROOT'] . '/xtracks-app/bootstrap.php');
2
37 $aff_network_sql = "SELECT * FROM 202_aff_networks WHERE aff_network_id='".$mysql['aff_network_id']."' AND user_id='".$mysql['user_id']."'";
38 $aff_network_result = mysql_query($aff_network_sql) or record_mysql_error($aff_network_sql);
39 $aff_network_row = mysql_fetch_assoc($aff_network_result);
52 $aff_campaign_sql = "SELECT * FROM 202_aff_campaigns WHERE aff_campaign_id='".$mysql['aff_campaign_id']."' AND user_id='".$mysql['user_id']."'";
53 $aff_campaign_result = mysql_query($aff_campaign_sql) or record_mysql_error($aff_campaign_sql);
54 $aff_campaign_row = mysql_fetch_assoc($aff_campaign_result);
67 $text_ad_sql = "SELECT * FROM 202_text_ads WHERE text_ad_id='".$mysql['text_ad_id']."' AND user_id='".$mysql['user_id']."'";
68 $text_ad_result = mysql_query($text_ad_sql) or record_mysql_error($text_ad_sql);
69 $text_ad_row = mysql_fetch_assoc($text_ad_result);
96 $landing_page_sql = "SELECT * FROM 202_landing_pages WHERE landing_page_id='".$mysql['landing_page_id']."' AND user_id='".$mysql['user_id']."'";
97 $landing_page_result = mysql_query($landing_page_sql) or record_mysql_error($landing_page_sql);
98 $landing_page_row = mysql_fetch_assoc($landing_page_result);
114 $ppc_network_sql = "SELECT * FROM 202_ppc_networks WHERE ppc_network_id='".$mysql['ppc_network_id']."' AND user_id='".$mysql['user_id']."'";
115 $ppc_network_result = mysql_query($ppc_network_sql) or record_mysql_error($ppc_network_sql);
116 $ppc_network_row = mysql_fetch_assoc($ppc_network_result);
play.php https://bitbucket.org/StasPiv/playzone | PHP | 283 lines
1<?php
2
48 }
49 $arGame = mysql_fetch_assoc(mysql_query($sql));
50 if (!$arGame)
88 $sQueryRests = "SELECT `id_player`,`id_tournament`,`in_rest` FROM `jos_uplab_rests_list` WHERE 1";
89 $rQueryRests = mysql_query($sQueryRests);
90 while ($row = mysql_fetch_assoc($rQueryRests))
143 $sQuery = "SELECT TIMESTAMPDIFF(SECOND , time_last_move, NOW( ) ) AS diff FROM jos_uplab_games_list WHERE `id` = '$idGame'";
144 $iDiff = mysql_result(mysql_query($sQuery), 0);
145 if ($iDiff < 0)
181 {
182 mysql_query("UPDATE `jos_uplab_games_list` SET `time_last_move` = NOW() WHERE `id` = '$idGame'");
183 // обновляем последний ход обоих игроков
183 // обновляем последний ход обоих игроков
184 mysql_query("UPDATE `jos_uplab_register_users` SET last_move = NOW() WHERE `id` IN ('{$arGame['id_white']}','{$arGame['id_black']}')");
185 // записываем партию в лог
Summary_grafik_detail_kecamatan.php https://bitbucket.org/ArgoWibowo/si_aktivitas_tani.git | PHP | 210 lines
66 <li><a href="Daftar Kalender Tanam-lihat.php"> Kalender Tanaman</a></li>
67 <li><a href="Daftar Peta Lahan-lihat.php"> Peta Lahan</a></li>
68 </ul>
84 <li><a href="Grafik_panen_tanaman.php"></span> Grafik Hasil Panen Tanaman</a></li>
85 <li><a href="Perkiraan_panen.php"> Perkiraan Panen</a></li>
86 <li><a href="Grafikpanen.php"></span> Grafik Hasil Panen</a></li>
86 <li><a href="Grafikpanen.php"></span> Grafik Hasil Panen</a></li>
87 <li><a href="Grafik_detail_panen.php"></span> Grafik Hasil Panen Detail</a></li>
88 </ul>
107 ?>
108 <h1>Summary Hasil Panen <?php echo $brsnama['Nama_Tanaman']?> Kecamatan <?php echo $tahun?></h1>
109 <div class="col-md-2">
112 <div class="col-md-2">
113 <a style="font-size:20px". href="Daftar laporan detail panen kecamatan.php?Kabupaten=<?php echo $_GET['Kabupaten']?>&spesies=<?php echo $id_spesies ?>&tahun=<?php echo $tahun;?>"><span class="glyphicon glyphicon-print"></span> Cetak</a>
114 </div>
takeedit.php https://github.com/delete66/sikevux-s-tracker.git | PHP | 199 lines
1<?php
2/**
3 * @Author Neptune
4 * @Credits All credit to Retro for the great idea of his updated modtask.php
5 * @Project TBDev.net
8 */
9require 'include/bittorrent.php';
10require 'include/bbcode_functions.php';
27// moddifed logginorreturn by retro//Remember to change the following line to match your server
28print("<html><h1>Not Found</h1><p>The requested URL /{$_SERVER['PHP_SELF']} was not found on this server.</p><hr /><address>Apache/1.1.11 (xxxxx) Server at ".$_SERVER['SERVER_NAME']." Port 80</address></body></html>\n");
29die();
67
68$select_torrent = mysql_query('SELECT * FROM torrents WHERE id = ' . sqlesc($id)) or sqlerr(__FILE__, __LINE__);
69$fetch_assoc = mysql_fetch_assoc($select_torrent) or stderr('Error', 'No torrent with this ID!');
192$updateset[] = 'multiplicator = ' . sqlesc($multiplicator);
193mysql_query('UPDATE torrents SET ' . implode(',', $updateset) . ' WHERE id = ' . sqlesc($id)) or sqlerr(__FILE__, __LINE__);
194
change.php https://bitbucket.org/deba666/accitsoftware.git | PHP | 155 lines
1<?php
2if($_POST['username'])
4 {
5 if(mysql_query("UPDATE `users` SET `USER_NAME`='".$_POST['username']."', `LOCATION_NO`='".$_POST['location']."', `FNAME`='".$_POST['fname']."', `LNAME`='".$_POST['lname']."', `EMAIL`='".$_POST['email']."', `ACCESS_LEVEL`='".$_POST['permission']."' WHERE `USER_NO`=".$_GET['change']))
6 $_SESSION['s_msg']="<strong>Well done!</strong> User successfully updated";
23 <div class="title_left">
24 <?php
25 if($_SESSION['s_msg'] || $_SESSION['e_msg'])
31 </div>
32 <?php
33 unset($_SESSION['s_msg']);
ebpls_collection_summary.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 249 lines
3define('FPDF_FONTPATH','font/');
4require('../ebpls-php-lib/html2pdf_lib/fpdf.php');
5include("../lib/phpFunctions-inc.php");
5include("../lib/phpFunctions-inc.php");
6include("../includes/variables.php");
7include("../lib/multidbconnection.php");
101$datenext = $dateprev + 1;
102$lgu=mysql_query("select * from ebpls_buss_preference")
103 or die(mysql_error());
109// $resulta=mysql_fetch_array($result);
110$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[lguname]'");
111$getlgu = @mysql_fetch_row($getlgu);
111$getlgu = @mysql_fetch_row($getlgu);
112$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[lguprovince]'");
113$getprov = @mysql_fetch_row($getprov);
utils.php https://gitlab.com/jiyath/pligg-cms.git | PHP | 488 lines
1<?php
2
2
3if(!defined('mnminclude')){header('Location: ../error_404.php');die();}
4
11 } else {
12 include_once(mnminclude.'mailer.php');
13 }
17 // checks to see if a table in the database exists
18 $result = mysql_query('select * from ' . $table);
19 if (!$result) {
118function check_email_address($email) {
119 //from http://www.ilovejackdaniels.com/php/email-address-validation/
120 // First, we check that there's one @ symbol, and that the lengths are right
346
347// function makeCategoryFriendly has been moved to admin_categories.php
348
backup_compress.php https://bitbucket.org/meerdevelopersoffice/bolivia.git | PHP | 492 lines
1<?php
2
263 {
264 $result = mysql_query($sql, $this->link_id);
265 }
267 {
268 $result = mysql_query($sql);
269 }
375 $value .= '# MySQL version: ' . mysql_get_server_info() . MSB_NL;
376 $value .= '# PHP version: ' . phpversion() . MSB_NL;
377 if (!empty($this->database))
menu_edit.php https://github.com/anodyne/sms.git | PHP | 241 lines
1<?php
2
3/* need to connect to the database */
4require_once('../../framework/dbconnect.php');
5
6/* pulling a function from new library */
7require_once('../../framework/session.name.php');
8
11
12/* rewrite master php.ini session.name */
13ini_set('session.name', $sysuid);
26{
27 include_once('../../framework/functionsGlobal.php');
28 include_once('../../framework/functionsAdmin.php');
28 include_once('../../framework/functionsAdmin.php');
29 include_once('../../framework/functionsUtility.php');
30
user-show-autoinfo.php https://gitlab.com/Chhorvan/autoexpresscambodia_mobile.git | PHP | 353 lines
1<?php
2################################################################################
14################################################################################
15include('resize-class.php');
16class userShowAutoinfo
41 function deleteAutoInfo(){
42 require_once BASE_CLASS . 'class-connect.php';
43 $cnx = new Connect();
50 $sql_delete="DELETE from `auto_info` WHERE `id` = '$delete' AND `owner`='$owner'";
51 @mysql_query($sql_delete);
52 header("Location: auto-info?deleteresult=success");
59 function foundAutoInfo($id, $owner){
60 require_once BASE_CLASS . 'class-connect.php';
61
65 $sql_search="SELECT * from auto_info WHERE id = '$id' AND `owner`='$owner'";
66 $sql= @mysql_query($sql_search) ;
67 if(mysql_num_rows($sql)>0) return true;
SumarryKelTaniKabupaten_User.php https://bitbucket.org/ArgoWibowo/dutatani.git | PHP | 210 lines
38 mysql_select_db("iais_ukdw") or die("Database tidak ditemukan");
39 $query= mysql_query("SELECT * FROM master_petani where ID_User = '$id_user';");
40 $brsnama = mysql_fetch_array($query)
41 ?>
42 <li style="background-color: #024A0B"><a href="Homei.php">Selamat Datang <?php echo $id_user ?></a></li>
43 <li style="background-color: #024A0B"><a href="logout.php">Keluar</a></li>
85 <a href="SumarryKelTaniPerkemb_User.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-list-alt fa-stack-1x "></i></span> Tabel</a>
86 <a href="GrafikKelTaniPerkemb_User.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-signal fa-stack-1x "></i></span> Grafik</a>
87 </li>
122 <div class="col-md-5">
123 <button class="btn btn-lg btn-primary" onclick="window.location.href='DetailKelTani_Kab.php?provinsi=<?php echo $_GET['provinsi']; ?>'"> Cetak Daftar</button>
124 </div>
180 ?>
181 <?php echo" ". $data2['jumlah'];?>
182 </td>
install.php https://bitbucket.org/icarito/pmc | PHP | 430 lines
8
9require("./init.php");
10$action = getArrayVal($_GET, "action");
32 $templatesdir = is_writable(CL_ROOT . "/templates_c/");
33 $phpver = phpversion();
34
34
35 $template->assign("phpver", $phpver);
36 $template->assign("configfile", $configfilechk);
166
167 $table7 = mysql_query("CREATE TABLE `milestones_assigned` (
168 `ID` int(10) NOT NULL auto_increment,
346
347 $table20 = mysql_query("
348CREATE TABLE `roles_assigned` (
koberitaacara.php https://bitbucket.org/justmyfreak/sisfokampus | PHP | 206 lines
25</style>
26<?php
27 $level=$_SESSION ['level'];
31 if($level=='Karyawan Jurusan'){
32 $jur=mysql_query("SELECT a.Kode , b.Nama_Indonesia FROM karyawan_jurusan a , jurusan b where a.Kode=b.Kode AND a.ID=$unip");
33 }
34 else if($level=='Mahasiswa'){
35 $jur=mysql_query("SELECT a.KodeJurusan as Kode , b.Nama_Indonesia FROM mhsw a , jurusan b where a.KodeJurusan=b.Kode AND a.nim=$unip");
36 }
37else if($level=='Dosen'){
38 $jur=mysql_query("SELECT a.KodeJurusan as Kode , b.Nama_Indonesia FROM dosen a , jurusan b where a.KodeJurusan=b.Kode AND a.id=$unip");
39 }
40 else if($level=='Kajur'){
41 $jur=mysql_query("SELECT a.Kode , b.Nama_Indonesia FROM kajur a , jurusan b where a.Kode=b.Kode AND a.ID=$unip");
42 }
tematica_localitate_vechi.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 323 lines
1<?php include_once($_SERVER['DOCUMENT_ROOT']."/includes/peste_tot.php");
2include_once($_SERVER['DOCUMENT_ROOT'].'/config/functii_pt_afisare.php');
297/*if($_SERVER['REQUEST_URI']=="/oferte-".fa_link_vechi($tip_c)."/".fa_link_vechi($tara_c)."/".fa_link_vechi($zona_c)."/".fa_link_vechi($oras_c)."/") { ?><link rel="canonical" href="<?php echo $sitepath."oferte-".fa_link($tip_c)."/".fa_link($tara_c)."/".fa_link($zona_c)."/".fa_link($oras_c)."/"; ?>" /> <?php }
298if($_REQUEST['from'] || ($id_transport || $nr_stele || $nmasa || $din_luna || ($distanta && $distanta<>'toate') || $_REQUEST['ordonare'])) {*/ ?><?php /*?><link rel="canonical" href="<?php echo $link_p; ?>" /><?php */?><?php /*}*/ ?>
299<?php echo $meta_canonical." ".$meta_prev." ".$meta_next."\n"; ?>
310 <div class="NEW-column-full">
311 <?php include_once($_SERVER['DOCUMENT_ROOT']."/includes/sejururi/localitate_new1.php"); ?>
312 </div>
312 </div>
313 <?php //include_once($_SERVER['DOCUMENT_ROOT']."/includes/newsletter_abonare.php"); ?>
314 <?php //include_once($_SERVER['DOCUMENT_ROOT']."/includes/dreapta/circuite_tari.php"); ?>
314 <?php //include_once($_SERVER['DOCUMENT_ROOT']."/includes/dreapta/circuite_tari.php"); ?>
315 <?php include_once($_SERVER['DOCUMENT_ROOT']."/includes/oferte_vizualizate.php"); ?>
316 </div>
318<div id="footer">
319 <?php include_once($_SERVER['DOCUMENT_ROOT']."/includes/footer.php"); ?>
320</div>