100+ results results for 'php mysql_query' (455 ms)
22 echo functions::display_error($lng['error_wrong_data']);
23 require('../incfiles/end.php');
24 exit;
33*/
34echo '<div class="phdr"><a href="album.php"><b>' . $lng['photo_albums'] . '</b></a> | <a href="album.php?act=list&user=' . $user['id'] . '">' . $lng['personal_2'] . '</a></div>';
35if ($user['id'] == $user_id || $rights >= 7)
90if ($total > $kmess)
91 echo '<div class="topmenu">' . functions::display_pagination('album.php?act=show&al=' . $al . '&user=' . $user['id'] . '&' . ($view ? 'view&' : ''), $start, $total, $kmess) . '</div>';
92if ($total) {
92if ($total) {
93 $req = mysql_query("SELECT * FROM `cms_album_files` where `website` = '$website' AND `user_id` = '" . $user['id'] . "' AND `album_id` = '$al' ORDER BY `id` DESC LIMIT $start, $kmess");
94 $i = 0;
159}
160echo '<p><a href="album.php?act=list&user=' . $user['id'] . '">' . $lng_profile['album_list'] . '</a></p>';
161?>
index.php https://github.com/michaelmwu/saratogahigh.com.git | PHP | 219 lines
2
3include '../db.php';
4include 'notepad.php';
15 if(is_numeric($_GET['delete']))
16 mysql_query('DELETE FROM NOTEPAGE_LIST WHERE NOTEPAGE_OWNER=' . $userid . ' AND NOTEPAGE_ID=' . $_GET['delete']) or die("Delete failed.");
17 if($_POST['go'] == 'Save')
23 else
24 mysql_query('INSERT INTO NOTEPAGE_LIST (NOTEPAGE_OWNER, NOTEPAGE_CREATED, NOTEPAGE_MODIFIED, NOTEPAGE_VALUE, NOTEPAGE_DIGEST) VALUES (' . $userid . ', "' . date(TIME_FORMAT_SQL, CURRENT_TIME) . '", NOTEPAGE_CREATED, \'' . $_POST['entrytext'] . '\', \'' . makedigest($_POST['entrytext']) . '\')') or die("Insert failed.");
25 }
27 {
28 mysql_query('UPDATE NOTEPAGE_LIST SET NOTEPAGE_MODIFIED="' . date(TIME_FORMAT_SQL, CURRENT_TIME) . '", NOTEPAGE_VALUE=\'' . $_POST['entrytext'] . '\', NOTEPAGE_DIGEST=\'' . makedigest($_POST['entrytext']) . '\' WHERE NOTEPAGE_OWNER=' . $userid . ' AND NOTEPAGE_ID=' . $_GET['id']) or die("Insert failed.");
29 }
50 <body>
51 <? include "../inc-header.php"; ?>
52 <h1>Notepad</h1>
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);
delivery_list.php https://gitlab.com/Henaway/CLFC | PHP | 253 lines
1<?php
2include_once ("config_foodcoop.php");
2include_once ("config_foodcoop.php");
3include_once ("general_functions.php");
4session_start();
25 route_name ASC';
26$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 769302 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
27while ( $row = mysql_fetch_array($result) )
73 last_name ASC';
74$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 769302 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
75$num_orders = mysql_numrows($result);
82 <li> <b>'.(convert_route_code(array_merge ($delcode_array, $member_array))).'</b><br>
83 <a href="show_report.php?type=customer_invoice&delivery_id='.ActiveCycle::delivery_id().'&member_id='.$member_array['member_id'].'">
84 <b>'.$member_array['preferred_name'].' (Mem#'.$member_array['member_id'].')</b></a><!-- - Deliverable Products: '.$product_quantity_of_member.' -->';
145 $display .= '
146 <form action="'.$PHP_SELF.'#'.$member_array['member_id'].'" method="post">
147 <input type="hidden" name="member_id_passed" value="'.$member_array['member_id'].'">
watch_brek_vid.php https://gitlab.com/msdusad/all_ones | PHP | 237 lines
1<?php include('conn.php');?>
2<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
54 <div class="banner"><img src="admin/upload/<?php echo $df['bann_news']; ?>" width="700" height="90px;"/></div>
55 </div><?php } ?>
56</div>
66 <marquee direction="left" scrollamount="4" behavior="scroll">
67 <p style="color:#FFFFFF; font-size:16px; font-weight:bold; padding-top:10px; "><?php
68 $df="select * from brek_news where b_news=1";
69
70 $rf=mysql_query($df);
71 $row=mysql_fetch_array($rf);
72 { ?>
73 <a href="breknews_desc.php?id=<?= $row['id']; ?>" style="text-decoration:none;color:#FFFFFF;"> <?php echo $row['News'];?></a>
74 <?php echo $row['time'];?>
77 <div class="news_content_img">
78 <a href="watch_brek_vid.php?id=<?= $row['id'];?>"><img src="images/Aaj-Tak_live-TV-1.gif" /></a><?php }
79
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);
submit_track.php http://airscore.googlecode.com/svn/trunk/ | PHP | 332 lines
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
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)
log-2016-01-20.php https://gitlab.com/fcupen/PHP | PHP | 44 lines
21ERROR - 2016-01-20 12:37:40 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
22ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
23ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
35ERROR - 2016-01-20 12:43:59 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
36ERROR - 2016-01-20 12:43:59 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
37ERROR - 2016-01-20 12:43:59 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
37ERROR - 2016-01-20 12:43:59 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
38ERROR - 2016-01-20 12:50:24 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
39ERROR - 2016-01-20 12:50:24 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
39ERROR - 2016-01-20 12:50:24 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
40ERROR - 2016-01-20 12:50:24 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
41ERROR - 2016-01-20 12:50:24 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
42ERROR - 2016-01-20 12:50:47 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
43ERROR - 2016-01-20 12:50:47 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
44ERROR - 2016-01-20 12:50:47 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
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'");
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?>
edit.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 122 lines
1<?php
2/**
15 echo "";
16 require_once('../incfiles/end.php');
17 exit;
18 }
19 $req = mysql_query("SELECT * FROM `lib` where `website` = '$website' AND `id` = '" . $id . "'");
20 $ms = mysql_fetch_array($req);
27 if (empty($_POST['name'])) {
28 echo functions::display_error($lng['error_empty_title'], '<a href="index.php?act=edit&id=' . $id . '">' . $lng['repeat'] . '</a>');
29 require_once('../incfiles/end.php');
32 if (empty($_POST['text'])) {
33 echo functions::display_error($lng['error_empty_text'], '<a href="index.php?act=edit&id=' . $id . '">' . $lng['repeat'] . '</a>');
34 require_once('../incfiles/end.php');
44 }
45 mysql_query("UPDATE `lib` SET
46 `name` = '" . mysql_real_escape_string(mb_substr(trim($_POST['name']), 0, 100)) . "',
counters.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 203 lines
1<?php
2/**
23
24 $albumcount = mysql_result(mysql_query("SELECT COUNT(DISTINCT `user_id`) FROM `cms_album_files` WHERE `website` = '$website'"), 0);
25 $photocount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `website` = '$website'"), 0);
25 $photocount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `website` = '$website'"), 0);
26 $newcount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND `time` > '" . (time() - 259200) . "' AND `access` > '1'"), 0);
27 return $albumcount . ' / ' . $photocount . ($newcount ? ' / <span class="red"><a href="' . core::$system_set['homeurl'] . '/users/album.php?act=top">+' . $newcount . '</a></span>' : '');
38
39 $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND `type` = 'file'"), 0);
40 $new = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND `time` > '" . (time() - 259200) . "' AND `type` = 'file'"), 0);
54
55 $total_thm = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND `type` = 't'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0);
56 $total_msg = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND `type` = 'm'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0);
60 if ($new)
61 $out .= ' / <span class="red"><a href="' . core::$system_set['homeurl'] . '/forum/index.php?act=new">+' . $new . '</a></span>';
62 }
phorum.rb https://gitlab.com/Ruwan-Ranganath/discourse | Ruby | 218 lines
30
31 total_count = mysql_query("SELECT count(*) count FROM #{TABLE_PREFIX}users;").first['count']
32
33 batches(BATCH_SIZE) do |offset|
34 results = mysql_query(
35 "SELECT user_id id, username, email, real_name name, date_added created_at,
59
60 categories = mysql_query("
61 SELECT forum_id id, name, description, active
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
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>
DBIMysql.class.php https://gitlab.com/qbarbosa/klindev | PHP | 468 lines
1<?php
2/* vim: set expandtab sw=4 ts=4 sts=4: */
5 *
6 * @package PhpMyAdmin-DBI
7 * @subpackage MySQL
8 */
9if (! defined('PHPMYADMIN')) {
10 exit;
13if (! extension_loaded('mysql')) {
14 // The old MySQL extension is deprecated as of PHP 5.5.0, and will be
15 // removed in the future. Instead, the `MySQLi` or `PDO_MySQL` extension
19
20require_once './libraries/dbi/DBIExtension.int.php';
21
29 *
30 * @package PhpMyAdmin-DBI
31 * @subpackage MySQL
customer_list.php https://gitlab.com/Henaway/CLFC | PHP | 280 lines
1<?php
2include_once('config_foodcoop.php');
2include_once('config_foodcoop.php');
3include_once('general_functions.php');
4session_start();
6
7include_once('func.open_basket.php');
8
56 AND '.NEW_TABLE_PRODUCTS.'.product_version = "'.mysql_real_escape_string ($product_version).'"';
57$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 738102 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
58if ( $row = mysql_fetch_object($result) )
189 AND product_version = "'.mysql_real_escape_string ($product_version).'"';
190 $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 155816 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
191 $bpid= mysql_insert_id();
204 AND product_version = "'.mysql_real_escape_string ($product_version).'"';
205 $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 731034 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
206 }
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>
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>
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);
ref.mysql.html https://bitbucket.org/thncr/manuals.git | HTML | 425 lines
11 <div class="up"><a href="book.mysql.html">Mysql</a></div>
12 <div class="home"><a href="index.html">PHP Manual</a></div>
13</div><hr /><div id="ref.mysql" class="reference">
22 如果没有提供这个参数，则会使用最后一个打开的连接。
23 若不存在这个最后打开的连接，则会尝试用 <var class="filename">php.ini</var> 里定义的默认参数来连接。
24 如果没有成功连接，函数会返回 <strong><code>FALSE</code></strong>。
417
418 <h2>Table of Contents</h2><ul class="chunklist chunklist_reference"><li><a href="function.mysql-affected-rows.html">mysql_affected_rows</a> — 取得前一次 MySQL 操作所影响的记录行数</li><li><a href="function.mysql-client-encoding.html">mysql_client_encoding</a> — 返回字符集的名称</li><li><a href="function.mysql-close.html">mysql_close</a> — 关闭 MySQL 连接</li><li><a href="function.mysql-connect.html">mysql_connect</a> — 打开一个到 MySQL 服务器的连接</li><li><a href="function.mysql-create-db.html">mysql_create_db</a> — 新建一个 MySQL 数据库</li><li><a href="function.mysql-data-seek.html">mysql_data_seek</a> — 移动内部结果的指针</li><li><a href="function.mysql-db-name.html">mysql_db_name</a> — 取得结果数据</li><li><a href="function.mysql-db-query.html">mysql_db_query</a> — 发送一条 MySQL 查询</li><li><a href="function.mysql-drop-db.html">mysql_drop_db</a> — 丢弃（删除）一个 MySQL 数据库</li><li><a href="function.mysql-errno.html">mysql_errno</a> — 返回上一个 MySQL 操作中的错误信息的数字编码</li><li><a href="function.mysql-error.html">mysql_error</a> — 返回上一个 MySQL 操作产生的文本错误信息</li><li><a href="function.mysql-escape-string.html">mysql_escape_string</a> — 转义一个字符串用于 mysql_query</li><li><a href="function.mysql-fetch-array.html">mysql_fetch_array</a> — 从结果集中取得一行作为关联数组，或数字数组，或二者兼有</li><li><a href="function.mysql-fetch-assoc.html">mysql_fetch_assoc</a> — 从结果集中取得一行作为关联数组</li><li><a href="function.mysql-fetch-field.html">mysql_fetch_field</a> — 从结果集中取得列信息并作为对象返回</li><li><a href="function.mysql-fetch-lengths.html">mysql_fetch_lengths</a> — 取得结果集中每个输出的长度</li><li><a href="function.mysql-fetch-object.html">mysql_fetch_object</a> — 从结果集中取得一行作为对象</li><li><a href="function.mysql-fetch-row.html">mysql_fetch_row</a> — 从结果集中取得一行作为枚举数组</li><li><a href="function.mysql-field-flags.html">mysql_field_flags</a> — 从结果中取得和指定字段关联的标志</li><li><a href="function.mysql-field-len.html">mysql_field_len</a> — 返回指定字段的长度</li><li><a href="function.mysql-field-name.html">mysql_field_name</a> — 取得结果中指定字段的字段名</li><li><a href="function.mysql-field-seek.html">mysql_field_seek</a> — 将结果集中的指针设定为制定的字段偏移量</li><li><a href="function.mysql-field-table.html">mysql_field_table</a> — 取得指定字段所在的表名</li><li><a href="function.mysql-field-type.html">mysql_field_type</a> — 取得结果集中指定字段的类型</li><li><a href="function.mysql-free-result.html">mysql_free_result</a> — 释放结果内存</li><li><a href="function.mysql-get-client-info.html">mysql_get_client_info</a> — 取得 MySQL 客户端信息</li><li><a href="function.mysql-get-host-info.html">mysql_get_host_info</a> — 取得 MySQL 主机信息</li><li><a href="function.mysql-get-proto-info.html">mysql_get_proto_info</a> — 取得 MySQL 协议信息</li><li><a href="function.mysql-get-server-info.html">mysql_get_server_info</a> — 取得 MySQL 服务器信息</li><li><a href="function.mysql-info.html">mysql_info</a> — 取得最近一条查询的信息</li><li><a href="function.mysql-insert-id.html">mysql_insert_id</a> — 取得上一步 INSERT 操作产生的 ID</li><li><a href="function.mysql-list-dbs.html">mysql_list_dbs</a> — 列出 MySQL 服务器中所有的数据库</li><li><a href="function.mysql-list-fields.html">mysql_list_fields</a> — 列出 MySQL 结果中的字段</li><li><a href="function.mysql-list-processes.html">mysql_list_processes</a> — 列出 MySQL 进程</li><li><a href="function.mysql-list-tables.html">mysql_list_tables</a> — 列出 MySQL 数据库中的表</li><li><a href="function.mysql-num-fields.html">mysql_num_fields</a> — 取得结果集中字段的数目</li><li><a href="function.mysql-num-rows.html">mysql_num_rows</a> — 取得结果集中行的数目</li><li><a href="function.mysql-pconnect.html">mysql_pconnect</a> — 打开一个到 MySQL 服务器的持久连接</li><li><a href="function.mysql-ping.html">mysql_ping</a> — Ping 一个服务器连接，如果没有连接则重新连接</li><li><a href="function.mysql-query.html">mysql_query</a> — 发送一条 MySQL 查询</li><li><a href="function.mysql-real-escape-string.html">mysql_real_escape_string</a> — 转义 SQL 语句中使用的字符串中的特殊字符，并考虑到连接的当前字符集</li><li><a href="function.mysql-result.html">mysql_result</a> — 取得结果数据</li><li><a href="function.mysql-select-db.html">mysql_select_db</a> — 选择 MySQL 数据库</li><li><a href="function.mysql-set-charset.html">mysql_set_charset</a> — 设置客户端的字符集</li><li><a href="function.mysql-stat.html">mysql_stat</a> — 取得当前系统状态</li><li><a href="function.mysql-tablename.html">mysql_tablename</a> — 取得表名</li><li><a href="function.mysql-thread-id.html">mysql_thread_id</a> — 返回当前线程的 ID</li><li><a href="function.mysql-unbuffered-query.html">mysql_unbuffered_query</a> — 向 MySQL 发送一条 SQL 查询，并不获取和缓存结果的行</li></ul>
419</div>
423 <div class="up"><a href="book.mysql.html">Mysql</a></div>
424 <div class="home"><a href="index.html">PHP Manual</a></div>
425</div></body></html>
interface.php https://github.com/Lithixium/HawkEye.git | PHP | 244 lines
1<?php
2
11 //Include config, lang pack and MySQL connector
12 include("config.php");
13 include("langs/" . $config["langFile"]);
22 //Check if required functions are here
23 if (!function_exists("json_decode")) return error("JSON PHP library not installed! Update to PHP 5.3 or later!");
24
35 $players = array();
36 $res = mysql_query("SELECT * FROM `" . $config["dbPlayerTable"] . "`");
37 if (!$res)
45 $worlds = array();
46 $res = mysql_query("SELECT * FROM `" . $config["dbWorldTable"] . "`");
47 if (!$res)
133 //Run query
134 $res = mysql_query($sql);
135 if (!$res)
camaras_productor.model.php https://gitlab.com/talueses/SIPVE | PHP | 197 lines
1<?php
2/*******************************************************************************\
37?>
38<?php
39/*
43 * - eliminarRegistro()
44 * Escritura de archivos PHP file_put_contents() y asignacion de permisologia chmod()
45 */
45 */
46require_once "dblink.php";
47
53 $link = DbLink::getLink();
54 $result = mysql_query($sql, $link);
55 if (!$result) {
60
61 $str = "<?php\n";
62 $str .= "require_once 'dblink.php';\n";
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 } ?>
_stats_load.php https://gitlab.com/Etern4l/BitcoinDice | PHP | 238 lines
1<?php
2/*
14$included=true;
15include '../../inc/db-conf.php';
16include '../../inc/functions.php';
17
18$settings=mysql_fetch_array(mysql_query("SELECT * FROM `system` LIMIT 1"));
19
23 case 'my_bets':
24 if (empty($_GET['_unique']) || mysql_num_rows(mysql_query("SELECT `id` FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"))==0) exit();
25 $player=mysql_fetch_array(mysql_query("SELECT * FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"));
26
27 $my_bets=mysql_query("SELECT * FROM `bets` WHERE `player`=$player[id] ORDER BY `time` DESC LIMIT 30");
28 if (mysql_num_rows($my_bets)==0) $content.='<br><br><br><i>You haven\'t bet yet.</i>';
44
45 $username=mysql_fetch_array(mysql_query("SELECT `alias` FROM `players` WHERE `id`=$my_bet[player] LIMIT 1"));
46
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);
mysql.dbi.lib.php https://gitlab.com/albert925/lading-ach | PHP | 450 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)) {
printprod_new.php https://gitlab.com/Henaway/CLFC | PHP | 201 lines
1<?php
2include_once ("config_foodcoop.php");
2include_once ("config_foodcoop.php");
3include_once ("general_functions.php");
4session_start();
34 subcategory_name ASC';
35$rs = @mysql_query($sql, $connection) or die("Couldn't execute category query: ".mysql_error());
36while ( $row = mysql_fetch_array($rs) )
98 '.TABLE_MEMBER.'.business_name';
99 $resultp = @mysql_query($sqlp, $connection) or die("Couldn't execute query 2.");
100 while ( $row = mysql_fetch_array($resultp) )
128 unit_price ASC';
129 $result = @mysql_query($sql, $connection) or die("Couldn't execute search query: " . mysql_error());
130 while ( $row = mysql_fetch_array($result) )
195
196include("template_header.php");
197echo '
entry.php https://github.com/kenichiromiya/webwritecms.git | PHP | 253 lines
1<?php
2
13/*
14 $result = mysql_query($sql,$this->db);
15 $archives = array();
28
29// mysql_query($query,$this->db);
30 }
35 $sth->execute(array($param['title'],$param['category_id'],$param['body'],$param['id']));
36 //mysql_query($query,$this->db);
37 }
43
44 // mysql_query($query,$this->db);
45 }
52
53 //$result = mysql_query($query,$this->db);
54 //$entry=mysql_fetch_assoc($result);
Abstract.php https://github.com/hettema/Stages.git | PHP | 325 lines
1<?php
2/**
34 /**
35 * @var Mysql_Query
36 */
314 *
315 * @return Main_Mysql_Query object
316 */
319 if(!$this->_query) {
320 $this->_query = new Main_Mysql_Query();
321 }
data_access.php https://github.com/jroglesby/Test-Reservation-System.git | PHP | 322 lines
1<?php
2 $localhost = "localhost:3306";
11 $_SESSION['message'] = "Please sign in.";
12 header( 'Location: http://troyprog.dyndns.tv/~testres/testres.php' ) ;
13 }
26
27 mysql_query("UPDATE user set password='$newpassword' where fsuid='$fsuid'");
28 }
39
40 $result = mysql_query("SELECT * from user WHERE fsuid='$username' AND password='$password'");
41 $arr=array();
104
105 $result = mysql_query($query);
106 $arr=array();
127
128 $result = mysql_query($query);
129 $arr=array();
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")
index.php https://github.com/d3c0n808/MiningFarm.git | PHP | 276 lines
24 <head>
25 <title><?php echo outputPageTitle();?> - <?php echo gettext("Main Page");?></title>
26 <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
39 <div id="mainbox">
40 <?php
41 //Get credentials
49 $fifteenMinutesAgo -= 60*15;
50 $userHashHistoryQ = mysql_query("SELECT DISTINCT `timestamp` FROM `stats_userMHashHistory` WHERE `username` LIKE '".$getCredientials->username.".%' AND `timestamp` >= '$fifteenMinutesAgo' AND `mhashes` > 0 ORDER BY `timestamp` ASC");
51 $numRows = mysql_num_rows($userHashHistoryQ);
156 }
157 <?php
158 if($userHashArray != ""){
161 name: 'Your Average',
162 data: [<?php echo $userHashArray?>]
163 }
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>
listarUsuarios.php https://github.com/antonioformatic/curso2011.git | PHP | 218 lines
1<?php require_once('../../Connections/conexionEmpresa.php'); ?>
2<?php
50{
51 if (PHP_VERSION < 6) {
52 $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
78
79$currentPage = $_SERVER["PHP_SELF"];
80
178 <td><?php echo $row_usuarios['nivel']; ?></td>
179 <?php if($_SESSION['MM_UserGroup'] == "administrador"){ ?>
180 <td><a href="editarUsuario.php?id=<?php echo $row_usuarios['id']; ?>"><img src="b_edit.png" width="16" height="16" /></a></td>
180 <td><a href="editarUsuario.php?id=<?php echo $row_usuarios['id']; ?>"><img src="b_edit.png" width="16" height="16" /></a></td>
181 <td><a href="borrarUsuario.php?id=<?php echo $row_usuarios['id']; ?>"><img src="b_drop.png" width="16" height="16" /></a></td>
182 <?php } ?>
200 <td><a href="agregarUsuario.php"><img src="agregar.png" width="16" height="16" /></a></td>
201 <?php } ?>
202 </tr>
AddressImportGeocom.php https://github.com/ParveenArora/AddressHunter.git | PHP | 204 lines
1<?php
2/**
41// including the init (ZF bootstrap)
42require_once 'init.php';
43
92}
93mysql_query("SET NAMES UTF8", $dbh);
94
176 );
177 $dbresult = mysql_query($insert, $dbh);
178 if (!$dbresult) {
install.php https://github.com/benbruscella/Grammafone.git | PHP | 424 lines
135<body>
136<?php
137
171// Give instructions for setting permissions and external programs
172// mpg123, lame, Amazon API, php bin
173 case 2:
362 }
363 echo "<a href='install.php?step=3'>Proceed to Step 3 »</a>";
364 }
378 <strong>Path to Lame Encoder</strong><br/>(ex. /usr/bin/lame)<br/><input type='text' size='30' name='lamebin' /><br/><br/>
379 <strong>Path to PHP-CLI Binary</strong><br/>(ex. /usr/bin/php)<br/><input type='text' size='30' name='phpbin' /><br/><br/>
380
395 if(!installed()){
396 $query = "UPDATE mp3act_settings SET invite_mode=$_POST[invite],sample_mode=$_POST[sample_mode],downloads=$_POST[downloads],amazonid=\"$_POST[amazonid]\",mp3bin=\"$_POST[mp3bin]\",lamebin=\"$_POST[lamebin]\",phpbin=\"$_POST[phpbin]\",jukemode=\"$_POST[jukemode]\",mpdserver=\"$_POST[mpdserver]\",mpdport=\"$_POST[mpdport]\" WHERE id=1";
397 mysql_query($query);
todolist.php https://gitlab.com/jonz94/2016NCU_FreshWeb_HW | PHP | 187 lines
1<!-- 會員系統 PHP CODE -->
2<?php
3 header("Content-Type: text/html; charset=utf-8");
4 require_once("connMysql.php");
5 //啟用 SESSION
11 $query_RecUser = "SELECT `nickname`,`permission` FROM `user` WHERE `username`='".$username."'";
12 $RecUser = mysql_query($query_RecUser);
13 $row_RecUser = mysql_fetch_assoc($RecUser);
30 $query_RecLogin = "SELECT * FROM `user` WHERE `username`='".$_POST["username"]."'";
31 $RecLogin = mysql_query($query_RecLogin);
32 //取出帳號密碼的值
41 window.alert("登入成功!");
42 window.location.assign("todolist.php");
43 </script>
43 </script>
44 <?php
45 }else{?>
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 }
homepage.php https://github.com/GE3/GE3.git | PHP | 258 lines
1<?php
2If( $_GET["a"]=='homepage' OR !$_GET["a"] ){
13 $idGalerie = preg_replace('|^.*<img[^>]* alt="galery ([0-9]+)"[^>]*/>.*$|Usi', "\\1", $obsah);
14 $idGalerie = preg_replace("|\s|Usi", "", $idGalerie); //(nevim proč, ale php si tam přidávalo odřádkování)
15
19 //název
20 $radek = mysql_fetch_assoc( Mysql_query("SELECT * FROM $CONF[sqlPrefix]gal_kat WHERE id=$idGalerie AND skryta='ne'") );
21 $tmplGalerie->prirad("id", $radek["id"]);
24 //fotky
25 $dotaz = Mysql_query("SELECT x.id as idKategorie, x.slozka, x.nazev, y.* FROM
26 $CONF[sqlPrefix]gal_kat x JOIN $CONF[sqlPrefix]galerie y ON x.id=y.kategorie
54
55 $dotaz2 = Mysql_query("SELECT * FROM $CONF[sqlPrefix]clanky WHERE typ='novinka' ORDER BY id DESC LIMIT 2");
56 $i = 0;
173 /* -- Přidání hlasu -- */
174 Include_once 'ostatni.php/statistiky.funkce.php'; //umožňuje zjistit, jestli je návštěvník vyhledávací robot
175 If( $_GET["anketa"]==$radek["id"] AND $_GET["odpoved"] ){
database.php https://gitlab.com/billyprice1/b374k | PHP | 343 lines
1<?php
2$GLOBALS['module']['database']['id'] = "database";
80 if(class_exists('mysqli')) return $con->query($query);
81 elseif(function_exists('mysql_query')) return mysql_query($query);
82 }
spo.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 218 lines
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>
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
MySql.php https://github.com/joshbhamilton/todophp.git | PHP | 438 lines
1<?php
2/**
2/**
3 * Lithium: the most rad php framework
4 *
5 * @copyright Copyright 2011, Union of RAD (http://union-of-rad.org)
6 * @license http://opensource.org/licenses/bsd-license.php The BSD License
7 */
89 /**
90 * Check for required PHP extension, or supported database feature.
91 *
319 * sends the SQL query query to MySQL without automatically fetching and buffering the
320 * result rows as `mysql_query()` does (for less memory usage).
321 * @return resource Returns the result resource handle if the query is successful.
332
333 $func = ($options['buffered']) ? 'mysql_query' : 'mysql_unbuffered_query';
334 $resource = $func($sql, $self->connection);
classes.php https://github.com/camlegleiter/Project-Pencl.git | PHP | 378 lines
1<?php
2//Must be on top of everything to function correctly
2//Must be on top of everything to function correctly
3include 'includes/headerbarFunctions.php';
4//Include this inside the <head> tag to require user to be logged in to view the page.
4//Include this inside the <head> tag to require user to be logged in to view the page.
5include 'includes/membersOnly.php';
6
6
7include 'includes/class_functions.php';
8
26 $classid = mysql_real_escape_string($classid);
27 $padRow = mysql_query("SELECT name,description,password,owner FROM classes WHERE id='$classid'");
28 $row = mysql_fetch_assoc($padRow);
54 $classid = mysql_real_escape_string($classid);
55 $padRow = mysql_query("SELECT notebookid FROM classbooks WHERE classid='$classid'");
56 $notepadHTML = "";
weather_xml.php https://github.com/michaelmwu/saratogahigh.com.git | PHP | 334 lines
4+
5+ Weather_xml.php written by
6+ admin@notonebit.com
94 $query = "DELETE FROM weather_xml WHERE last_updated < '$expiredatetime'";
95 $result = mysql_query($query) or die('Invalid query: ' . mysql_error());
96
97 $query = "SELECT * FROM weather_xml WHERE xml_url = '$xml_url'";
98 $result = mysql_query($query) or die('Invalid query: ' . mysql_error());
99 $row = mysql_fetch_array($result);
124 $query = "INSERT INTO weather_xml VALUES ('$xml_url', '$xml', '$datetime')";
125 $result = mysql_query($query) or die('Invalid query: ' . mysql_error());
126 }
277 $location_code = $values[$index[loc][0]][attributes][id];
278 header("Location: weather_xml.php?id=$location_code&length=10"); // Nees html_header because of this redirect.
279 exit();
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");
panel_producer_admin.php https://gitlab.com/Henaway/CLFC | PHP | 308 lines
1<?php
2include_once ('config_foodcoop.php');
2include_once ('config_foodcoop.php');
3include_once ('general_functions.php');
4session_start();
9if (CurrentMember::auth_type('producer_admin')) $producer_admin_true = 1;
10else header("Location: index.php");
11
33 producer_id = "'.mysql_real_escape_string ($_SESSION['producer_id_you']).'"';
34 $resultr = @mysql_query($sqlr,$connection) or die(debug_print ("ERROR: 904933", array ($sqlr,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
35 $message = 'Producer # '.$producer_id.' has been updated.<br>';
48 producer_id = "'.mysql_real_escape_string ($_GET['producer_id_you']).'"';
49 $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 860943 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
50 while ($row = mysql_fetch_object($result))
73// LIMIT 0,1';
74// $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 537557 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
75// while ($row = mysql_fetch_object($result))
xpdomanager.class.php https://github.com/Kleist/xPDO.git | PHP | 296 lines
1<?php
2/*
30 */
31require_once (strtr(realpath(dirname(dirname(__FILE__))), '\\', '/') . '/xpdomanager.class.php');
32
81 if (!$rt= @ mysql_select_db($dsnArray['dbname'], $conn)) {
82 @ mysql_query($sql, $conn);
83 $errorNo= @ mysql_errno($conn);
105 if (@ mysql_select_db($dsnArray['dbname'], $conn)) {
106 if (@ mysql_query($sql, $conn)) {
107 $removed= 1;
home.php https://github.com/budigutama/tes-repo.git | PHP | 304 lines
103 <div class="center_title_bar" style="margin-bottom:20px;"><?php echo $title; ?></div>
104 <div class="sorting"><?php include "inc/menu.php" ?></div>
105 <?php
107 if($_SESSION['string'] == $_POST['code']){
108 $ncari = mysql_num_rows(mysql_query("SELECT *
109 FROM member
238 <div class="center_prod_box">
239 <a href="?page=detail&idb=<?php echo $dproduk['id_produk']; ?>">
240 <div class="product_img">
240 <div class="product_img">
241 <img src="images/product/<?php echo $gbr; ?>" alt="" height="175" width="160" border="0" title="Klik Untuk Melihat detil" /></div>
242 <div class="frame"></div>
252 <div class="prod_price"><?php echo $dproduk['nama_produk']; ?></div>
253 <div class="nama_prod" style="color:<?php echo $col;?>"><?php echo $harga; ?></div></a>
254 </div>
simulador-comparador-pruebas.php https://gitlab.com/fredyteheranto/gestionet | PHP | 332 lines
78 <td>
79 <input type="checkbox" id="check_<?php echo $row['id'];?>" name="check_<?php echo $row['id'];?>" value="<?php echo $row['id']; ?>"/>
80 </td>
93 </tr>
94 <input type="hidden" id="nombreBanco<?php echo $row['id'];?>" value="<?php echo $rowBanco['nombre']; ?>">
95 <input type="hidden" id="nombreProducto<?php echo $row['id'];?>" value="<?php echo $row['producto']; ?>">
99 <input type="hidden" id="anyos<?php echo $row['id'];?>" value="<?php echo $row['anyos']; ?>">
100 <input type="hidden" id="condiciones1_<?php echo $row['id'];?>" value="<?php $texto = $row['condiciones1']; $texto = nl2br(str_replace("-","<br>-", $texto)); echo $texto; ?>">
101 <input type="hidden" id="condiciones2_<?php echo $row['id'];?>" value="<?php $texto = $row['condiciones2']; $texto = nl2br(str_replace("-","<br>-", $texto)); echo $texto; ?>">
101 <input type="hidden" id="condiciones2_<?php echo $row['id'];?>" value="<?php $texto = $row['condiciones2']; $texto = nl2br(str_replace("-","<br>-", $texto)); echo $texto; ?>">
102 <input type="hidden" id="condiciones3_<?php echo $row['id'];?>" value="<?php $texto = $row['condiciones3']; $texto = nl2br(str_replace("-","<br>-", $texto)); echo $texto; ?>">
103 <input type="hidden" id="condiciones4_<?php echo $row['id'];?>" value="<?php $texto = $row['condiciones4']; $texto = nl2br(str_replace("-","<br>-", $texto)); echo $texto; ?>">
104 <input type="hidden" id="avisos1_<?php echo $row['id'];?>" value="<?php $texto = $row['avisos1']; $texto = nl2br(str_replace("-","<br>-", $texto)); echo $texto; ?>">
105 <input type="hidden" id="avisos2_<?php echo $row['id'];?>" value="<?php $texto = $row['avisos2']; $texto = nl2br(str_replace("-","<br>-", $texto)); echo $texto; ?>">
106 <input type="hidden" id="fecha<?php echo $row['id'];?>" value="<?php echo substr($row['f_user'], 0, strpos($row['f_user'], ' ')); ?>">
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
adhesion.php https://gitlab.com/radicalcinema/AnarchistNewsroom | PHP | 369 lines
1<?php
2$private="yes"; // accès réservé
3$private_rule="waiting"; // Page privée mais accessible aux statut user = waiting
4include("inc/variables.php");
5require("inc/login.php"); // Contrôle d'identité :-/
12}
13include("inc/template_top.php"); // template
14
15?>
16<?php
17/////////////// Suppression de ligne
126<p class="cgrey4">Vous avez également le statut d'<span class="">administrateur technique</span>
127<?php if($tresorier==$id_user_online){ ?> et celui de <span class="">trésorier</span><?php } ?>.</p>
128<?php } ?>
307?>
308<td class="cgrey4 small"><a href="payer.php?id=<?php echo $id_cotisation; ?>" class="grey2link"><?php echo $ref_cotisation; ?></a></td>
309<td class="cgrey4 small"><?php
over_forums.php https://github.com/Bigjoos/U-232-V1.git | PHP | 281 lines
1<?php
2/**
29
30require_once(INCL_DIR.'html_functions.php');
31
35
36require_once(INCL_DIR.'class_check.php');
37class_check(UC_ADMINISTRATOR);
41$main_links = '<p><span style="font-weight: bold;">Over Forums</span> ::
42 <a class="altlink" href="staffpanel.php?tool=forum_manage&action=forum_manage">Forum Manager</a> ::
43 <a class="altlink" href="staffpanel.php?tool=forum_config&action=forum_config">Configure Forums</a><br /></p>';
71 sql_query ('DELETE FROM over_forums where id = '.$id);
72 header('Location: staffpanel.php?tool=over_forums');
73 die();
92 sql_query('UPDATE over_forums SET sort = '.$sort.', name = '.sqlesc($name).', description = '.sqlesc($desc).', min_class_view = '.$min_class_view.' WHERE id = '.$id);
93 header('Location: staffpanel.php?tool=over_forums');
94 die();
feedback.php https://bitbucket.org/maxpanzer/cred_katherine.git | PHP | 175 lines
1<?php require "includes/session_inc.php"; ?>
2<!DOCTYPE script PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
5
6<?php
7 require "includes/initialize_inc.php";
28 echo $sql;
29 mysql_query($sql) or die(mysql_error());
30?>
31 <script type="text/javascript">
32 location.href = "https://vlab.decisionsciences.columbia.edu/referrer/V2_resolver.php";
33 </script>
33 </script>
34<?php
35 exit;
68 <br/>
69 <img src="images/RandomDeck<?php echo $_SESSION['deckOrderTraining']['A']?>.jpg">
70 </td></tr>
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();
slip.php https://gitlab.com/msdusad/all_ones | PHP | 324 lines
165 <tr><td><?php echo $registration_date ; ?></td> <td><?php echo $registration_fee ;?></td> <td></td> <td><?php echo $reg_narration ;?></td> </tr>
166 <tr><td><?php echo $date1 ; ?></td> <td><?php echo $ins1 ;?></td> <td><?php echo $du1; ?></td> <td><?php echo $narr1 ;?></td> </tr>
167 <?php }
212 <tr><td><?php echo $date1 ; ?></td> <td><?php echo $ins1 ;?></td> <td><?php echo $du1; ?></td> <td><?php echo $narr1 ;?></td> </tr>
213 <tr><td><?php echo $date2 ;?></td> <td><?php echo $ins2 ;?></td> <td><?php echo $du2; ?></td> <td><?php echo $narr2 ;?></td> </tr>
214
218 <tr><td><?php echo $registration_date ; ?></td> <td><?php echo $registration_fee ;?></td> <td></td> <td><?php echo $reg_narration ;?></td> </tr>
219 <tr><td><?php echo $date1 ; ?></td> <td><?php echo $ins1 ;?></td> <td><?php echo $du1; ?></td> <td><?php echo $narr1 ;?></td> </tr>
220 <tr><td><?php echo $date2 ;?></td> <td><?php echo $ins2 ;?></td> <td><?php echo $du2; ?></td> <td><?php echo $narr2 ;?></td> </tr>
220 <tr><td><?php echo $date2 ;?></td> <td><?php echo $ins2 ;?></td> <td><?php echo $du2; ?></td> <td><?php echo $narr2 ;?></td> </tr>
221 <tr><td><?php echo $date3 ;?></td> <td><?php echo $ins3 ;?></td> <td><?php echo $du3; ?></td> <td><?php echo $narr3 ;?></td> </tr>
222
225 else{
226 ?><tr><td><?php echo $registration_date ; ?></td> <td><?php echo $registration_fee ;?></td> <td></td> <td><?php echo $reg_narration ;?></td> </tr> <?php
227 //echo "No Fees submitted yet";
mysqlnduhconnection.query.html https://bitbucket.org/thncr/manuals.git | HTML | 130 lines
11 <div class="up"><a href="class.mysqlnduhconnection.html">MysqlndUhConnection</a></div>
12 <div class="home"><a href="index.html">PHP Manual</a></div>
13</div><hr /><div id="mysqlnduhconnection.query" class="refentry">
81 <div class="example-contents">
82<div class="phpcode"><code><span style="color: #000000">
83<span style="color: #0000BB"><?php<br /></span><span style="color: #007700">class </span><span style="color: #0000BB">proxy </span><span style="color: #007700">extends </span><span style="color: #0000BB">MysqlndUhConnection </span><span style="color: #007700">{<br /> public function </span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">) {<br /> </span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"%s(%s)\n"</span><span style="color: #007700">, </span><span style="color: #0000BB">__METHOD__</span><span style="color: #007700">, </span><span style="color: #0000BB">var_export</span><span style="color: #007700">(</span><span style="color: #0000BB">func_get_args</span><span style="color: #007700">(), </span><span style="color: #0000BB">true</span><span style="color: #007700">));<br /> </span><span style="color: #0000BB">$query </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT 'How about query rewriting?'"</span><span style="color: #007700">;<br /> </span><span style="color: #0000BB">$ret </span><span style="color: #007700">= </span><span style="color: #0000BB">parent</span><span style="color: #007700">::</span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">);<br /> </span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"%s returns %s\n"</span><span style="color: #007700">, </span><span style="color: #0000BB">__METHOD__</span><span style="color: #007700">, </span><span style="color: #0000BB">var_export</span><span style="color: #007700">(</span><span style="color: #0000BB">$ret</span><span style="color: #007700">, </span><span style="color: #0000BB">true</span><span style="color: #007700">));<br /> return </span><span style="color: #0000BB">$ret</span><span style="color: #007700">;<br /> }<br />}<br /></span><span style="color: #0000BB">mysqlnd_uh_set_connection_proxy</span><span style="color: #007700">(new </span><span style="color: #0000BB">proxy</span><span style="color: #007700">());<br /><br /></span><span style="color: #0000BB">$mysqli </span><span style="color: #007700">= new </span><span style="color: #0000BB">mysqli</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">, </span><span style="color: #DD0000">"root"</span><span style="color: #007700">, </span><span style="color: #DD0000">""</span><span style="color: #007700">, </span><span style="color: #DD0000">"test"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$res </span><span style="color: #007700">= </span><span style="color: #0000BB">$mysqli</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT 'Welcome mysqlnd_uh!' FROM DUAL"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">var_dump</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">-></span><span style="color: #0000BB">fetch_assoc</span><span style="color: #007700">());<br /></span><span style="color: #0000BB">?></span>
117 <li class="member">
118 <span class="function"><a href="function.mysql-query.html" class="function" rel="rdfs-seeAlso">mysql_query()</a> - 发送一条 MySQL 查询</span>
119 </li>
128 <div class="up"><a href="class.mysqlnduhconnection.html">MysqlndUhConnection</a></div>
129 <div class="home"><a href="index.html">PHP Manual</a></div>
130</div></body></html>
FrontlineSMSParser.php https://github.com/rkabir/Swiftriver.git | PHP | 306 lines
1<?php
2namespace Swiftriver\Core\Modules\SiSPS\Parsers;
64
65 $endServerURL = "index.php";
66
287
288 $myResult = mysql_query($sqlQuery, $myConnection);
289 $myArray = array();
form3New.php https://gitlab.com/cesardemora/neaticketwebapphomeEs | PHP | 296 lines
1<?php
2
46
47 <?php
48 $funcion = $campo = $valor = "";
54 $valor = $_GET['fecha_alta'];
55 $result = mysql_query("SELECT * FROM CLIENTES WHERE fecha_alta LIKE '$valor%' LIMIT $init, $limit_end");
56 $count = "SELECT COUNT(*) FROM CLIENTES WHERE fecha_alta LIKE '$valor%'";
62 $valor = $_GET['email'];
63 $result = mysql_query("SELECT * FROM CLIENTES WHERE mail LIKE '%$valor%' LIMIT $init, $limit_end");
64 $count = "SELECT COUNT(*) FROM CLIENTES WHERE mail LIKE '%$valor%'";
107 ?>
108 <td><a href="index_buscarTicketsNew.php?mailCliente=<?php echo $row['mail']; ?>"><?php echo $row['mail']; ?></a></td>
109 <?php
188
189 require_once ("lib/class.phpmailer.php");
190
mysql.php https://gitlab.com/ken3/bluSky | PHP | 443 lines
1<?php defined('SYSPATH') OR die('No direct script access.');
2/**
8 * @copyright (c) 2008-2009 Kohana Team
9 * @license http://kohanaphp.com/license
10 */
18
19 // Identifier for this connection within the PHP driver
20 protected $_connection_id;
32 // Determine if we can use mysql_set_charset(), which is only
33 // available on PHP 5.2.3+ when compiled against MySQL 5.0+
34 Database_MySQL::$_set_names = ! function_exists('mysql_set_charset');
71
72 // \xFF is a better delimiter, but the PHP driver uses underscore
73 $this->_connection_id = sha1($hostname.'_'.$username.'_'.$password);
92
93 mysql_query('SET '.implode(', ', $variables), $this->_connection);
94 }
connection.php https://github.com/abdelm/stationwagon.git | PHP | 447 lines
1<?php
2/**
8 * @copyright (c) 2008-2009 Kohana Team
9 * @license http://kohanaphp.com/license
10 */
29 /**
30 * @var string Identifier for this connection within the PHP driver
31 */
58 // Determine if we can use mysql_set_charset(), which is only
59 // available on PHP 5.2.3+ when compiled against MySQL 5.0+
60 static::$_set_names = ! function_exists('mysql_set_charset');
106
107 // \xFF is a better delimiter, but the PHP driver uses underscore
108 $this->_connection_id = sha1($hostname.'_'.$username.'_'.$password);
167 {
168 // PHP is compiled against MySQL 4.x
169 $status = (bool) mysql_query('SET NAMES '.$this->quote($charset), $this->_connection);
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>
DBMysql.php https://github.com/sergiygladkyy/OEF.git | PHP | 495 lines
1<?php
2
115
116 if (!mysql_query("SET CHARACTER SET ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
117 if (!mysql_query("SET character_set_client = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
117 if (!mysql_query("SET character_set_client = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
118 if (!mysql_query("SET character_set_results = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
119 if (!mysql_query("SET character_set_connection = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
160 /**
161 * (non-PHPdoc)
162 * @see lib/db/mDBManager#fetchRow($res)
169 /**
170 * (non-PHPdoc)
171 * @see lib/db/mDBManager#fetchAssoc($res)
178 /**
179 * (non-PHPdoc)
180 * @see lib/db/mDBManager#fetchArray($res)
nt.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 204 lines
1<?php
2
17if (!$id || !$user_id || isset($ban['1']) || isset($ban['11']) || (!core::$user_rights && $set['mod_forum'] == 3)) {
18 require('../incfiles/head.php');
19 echo functions::display_error($lng['access_forbidden']);
19 echo functions::display_error($lng['access_forbidden']);
20 require('../incfiles/end.php');
21 exit;
37 $thid = abs(intval(preg_replace('/(.*?)id=/si', '', $m[3])));
38 $req = mysql_query("SELECT `text` FROM `soo_forum` where `website` = '$website' AND `id`= '$thid' AND `type` = 't' AND `close` != '1'");
39 if (mysql_num_rows($req) > 0) {
63if ($flood) {
64 require('../incfiles/head.php');
65 echo functions::display_error($lng['error_flood'] . ' ' . $flood . $lng['sec'] . ', <a href="../soo/?mod=forum&id=' . $id . '&start=' . $start . '">' . $lng['back'] . '</a>');
65 echo functions::display_error($lng['error_flood'] . ' ' . $flood . $lng['sec'] . ', <a href="../soo/?mod=forum&id=' . $id . '&start=' . $start . '">' . $lng['back'] . '</a>');
66 require('../incfiles/end.php');
67 exit;
form.php https://github.com/damanlovett/ucc.git | PHP | 263 lines
1<?php require_once('../../Connections/connCareer.php'); ?>
2<?php require_once('includefiles/myfiles.php'); ?>
3<?php
69?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
70<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/second.dwt.php" codeOutsideHTMLIsLocked="false" -->
71<head>
101 <tr>
102 <td align="left" valign="top" bgcolor="#000000" id="topquicklinks"><?php require_once('../../menus/EMPquick.php'); ?></td>
103 <td width="581"><img src="../../images/bannerstudent.jpg" alt="" width="581" height="136" /></td>
115 <td width="195" align="left" valign="top" id="leftnav2"><!-- InstanceBeginEditable name="leftnav" -->
116 <?php require_once('../../menus/STUjobsinterns.php'); ?>
117 <img src="../../images/pageimages/resume.jpg" alt="" width="195" height="165" />
240<div class="skipcontent">
241<a name="site" id="site"></a><a href="/career/students/explore/index.php">Students - Explore</a>
242<a href="/career/students/interviewing/index.php">Students - Interviewing</a>
Index.php https://gitlab.com/ElvisAns/tiki | PHP | 260 lines
1<?php
2
21 $this->table = new Search_MySql_Table($db, $index);
22 $this->builder = new Search_MySql_QueryBuilder($db);
23 $this->tfTranslator = new Search_MySql_TrackerFieldTranslator();
162 return $resultSet;
163 } catch (Search_MySql_QueryException $e) {
164 if (empty($e->suppress_feedback)) {
254 $this->table->ensureHasIndex($indexToRestore['Column_name'], $indexType);
255 } catch (Search_MySql_QueryException $exception) {
256 // Left blank on purpose
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
Installer.class.php https://github.com/prabhupathak/openemr.git | PHP | 372 lines
31
32 $this->gaclSetupScript1 = $this->manualPath . "gacl/setup.php";
33 $this->gaclSetupScript2 = $this->manualPath . "acl_setup.php";
123 $sql_results .= "Creating $title tables...\n";
124 // mysql_query("USE $dbname",$dbh);
125 $fd = fopen($filename, 'r');
170 public function write_configuration_file() {
171 @touch($this->conffile); // php bug
172 $fd = @fopen($this->conffile, 'w');
172 $fd = @fopen($this->conffile, 'w');
173 $string = '<?php
174// OpenEMR
346
347 // http://www.php.net/manual/en/function.include.php
348 private function get_require_contents($filename) {
postdata.php https://github.com/camlegleiter/Project-CyCal.git | PHP | 304 lines
1<?php
2/*
8 $TO_ROOT = "../";
9require $TO_ROOT."includes/membersOnly.php";
10require $TO_ROOT."includes/simple_html_dom.php";
151 $value = mysql_real_escape_string($errorvalue);
152 mysql_query("INSERT INTO panel(userid,rss,posx,posy,sizex,sizey,themeid,minimized) VALUES ('$userid','$value','$posx','$posy','$sizex','$sizey','$themeid','$minimized')");
153 $rows = mysql_affected_rows();
171 $feed = mysql_real_escape_string(urlencode($feed));
172 $rssCheck = mysql_query("DELETE FROM panel WHERE userid='$userid' AND rss='$feed'");
173 $rssCheckTheme = mysql_query("DELETE FROM theme WHERE userid='$userid' AND rss='$feed'");
193 $feed = mysql_real_escape_string(urlencode($rss[0]));
194 if(mysql_query("UPDATE panel SET posx='$posx',posy='$posy', sizex='$sizex' , sizey='$sizey' WHERE userid='$userid' AND rss='$feed'")){
195 successMessage('');
209 }
210 $getRSS = mysql_query("SELECT * FROM panel WHERE userid='$userid' $panelTheme");
211 $rssarr = array();
prueba.php https://gitlab.com/gustCL/syscar | PHP | 268 lines
1<?php
2/**
80 {
81 mysql_query('SET NAMES'.$this->charset);
82 }
95 $tables = array();
96 $result = mysql_query('SHOW TABLES');
97 while($row = mysql_fetch_row($result))
116
117 $result = mysql_query('SELECT * FROM '.$table);
118 $numFields = mysql_num_fields($result);
120 $sql .= 'DROP TABLE IF EXISTS '.$table.';';
121 $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
122 $sql.= "\n\n".$row2[1].";\n\n";
197
198<?php
199require_once './conexion.php';
manager.cpp https://github.com/luizribeiro/smaco.old.git | C++ | 421 lines
26MYSQL_RES* query(const char *q){
27 int q_st = mysql_query(conn, q);
28 MYSQL_RES * r;
107const char *url[2] = {
108 "http://acmicpc-live-archive.uva.es/nuevoportal/status.php",
109 "http://uva.onlinejudge.org/index.php?option=onlinejudge&Itemid=19"
mysql.php https://github.com/2bj/Skolkovo--i-gorod.com-.git | PHP | 491 lines
5* @version $Id$
6* @copyright (c) 2005 phpBB Group
7* @license http://opensource.org/licenses/gpl-license.php GNU Public License
18
19include_once($phpbb_root_path . 'includes/db/dbal.' . $phpEx);
20
55 {
56 @mysql_query("SET NAMES 'utf8'", $this->db_connect_id);
57
106 {
107 $result = @mysql_query('SELECT VERSION() AS version', $this->db_connect_id);
108 $row = @mysql_fetch_assoc($result);
130 case 'begin':
131 return @mysql_query('BEGIN', $this->db_connect_id);
132 break;
mysql.php https://gitlab.com/Goutte/Nacridan | PHP | 372 lines
1<?php
2
10if (!function_exists('mysql_connect'))
11 exit('This PHP environment doesn\'t have MySQL support built in. MySQL support is required if you want to use a MySQL database to run this forum. Consult the PHP documentation for further assistance.');
12
75 else
76 $this->query_result = @mysql_query($sql, $this->link_id);
77
index.php https://bitbucket.org/chadsaun/ifrogz-panel.git | PHP | 134 lines
55 <tr>
56 <td colspan="2" width="100%" align="center"><strong><?php print $yyChsLst?></strong><br /><font size="1">(<?php print $yyVers?>: <?php print $rs["adminVersion"]?>)</font><br />
57 </td>
66 <p><strong><?php print $yyOpSuc?></strong></p><p> </p>
67 <p><font size="1"><?php print $yyNowFrd?><br /><br /><?php print $yyNoAuto?> <a href="/admin/index.php"><?php print $yyClkHer?></a>.</font></td>
68 </tr>
72 <p><strong><?php print $yyOpFai?></strong></p><p> </p>
73 <p><?php print $yyCorCoo?> <?php print $yyCorLI?> <a href="/admin/login.php"><?php print $yyClkHer?></a>.</p></td>
74 </tr>
80 <p><strong>You are being forwarded to iFrogz.com</strong></p><p> </p>
81 <p><?php print $yyNoAuto?> <a href="http://ifrogz.com"><?php print $yyClkHer?></a>.</font></td>
82 </tr>
87 <tr>
88 <td valign="top" width="50%" align="left"> <a href="/admin/orders.php"><strong><?php print $yyVwOrd?> </strong></a><br />
89
videovigilancia_productor.model.php https://gitlab.com/talueses/SIPVE | PHP | 199 lines
1<?php
2/*******************************************************************************\
37?>
38<?php
39/*
45 * Modificado por David Concepcion 20-09-2010 CENIT
46 * Escritura de archivos PHP file_put_contents() y asignacion de permisologia chmod()
47 */
47 */
48require_once "dblink.php";
49
55 $link = DbLink::getLink();
56 $result = mysql_query($sql, $link);
57 if (!$result) {
62
63 $str = "<?php\n";
64 $str .= "require_once 'dblink.php';\n";
index.php https://github.com/damanlovett/SEAHO.git | PHP | 193 lines
6// technocurve arc 3 php bv block1/3 end
7?><?php require_once('../../Connections/Directory.php'); ?>
8<?php require_once('../includefiles/init.php'); ?>
8<?php require_once('../includefiles/init.php'); ?>
9<?php require_once('../includefiles/AdminLogin.php'); ?>
10<?php
127 <tr>
128 <td colspan="3" nowrap="nowrap" class="tableTop"><?php echo ($startRow_rsBallot + 1) ?> to <?php echo min($startRow_rsBallot + $maxRows_rsBallot, $totalRows_rsBallot) ?> of <?php echo $totalRows_rsBallot ?> </td>
129 <td class="tableTop"> </td>
157?> >
158 <td nowrap="nowrap"><a href="details.php?recordID=<?php echo $row_rsBallot['ballot_id']; ?>"><?php echo $row_rsBallot['title']; ?></a></td>
159 <td> </td>
186</div>
187<div id="footer"><?php require_once('../includefiles/footer.php'); ?>
188</div>
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);
image_upload.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 108 lines
1<?php
2defined('_IN_JOHNCMS') or die('Error: restricted access');
3
4require('../incfiles/head.php');
5// if(!$website)
16
17// require('../incfiles/head.php');
18
24// if ($al && $user['id'] == $user_id || $rights >= 7) {
25 // $req_a = mysql_query("SELECT * FROM `cms_album_cat` where `website` = '$website' AND `id` = '$al' AND `user_id` = '" . $user['id'] . "'");
26 // if (!mysql_num_rows($req_a)) {
27 // echo functions::display_error($lng['error_wrong_data']);
28 // require('../incfiles/end.php');
29 // exit;
31 // $res_a = mysql_fetch_assoc($req_a);
32 // require('../incfiles/lib/class.upload.php');
33 // echo '<div class="phdr"><a href="album.php?act=show&al=' . $al . '&user=' . $user['id'] . '"><b>' . $lng['photo_album'] . '</b></a> | ' . $lng_profile['upload_photo'] . '</div>';
index.php https://github.com/chacha13/runningmate.git | PHP | 399 lines
1<?php
2
55
56include dirname(dirname(dirname(__FILE__))).DIRECTORY_SEPARATOR."plugins.php";
57
82
83 $query = mysql_query($sql);
84
133 </script>
134 <div class="chatbar"><div style="float:left">Chat Conversation with $requester ($lines lines)<br> on $time</div><div style="float:right;padding-right:7px;"><a href="index.php$history">Back</a></div><div style="clear:both"></div></div>
135 $chatdata
167
168 $query = mysql_query($sql);
169
install.php https://bitbucket.org/nanomites_webdev/heroframework.git | PHP | 285 lines
72 // read in current config
73 $config_file = read_file(APPPATH . 'config/config.php');
74
80 // write config file
81 write_file(APPPATH . 'config/config.php',$config_file,'w');
82
96 $structure = read_file(APPPATH . 'updates/install.php');
97 $structure = str_replace('<?php if (!defined(\'BASEPATH\')) exit(\'No direct script access allowed\'); ?>','',$structure);
98
112 // this query is finished, execute it
113 if (@mysql_query($query, $dbh))
114 {
272 // write the file that disables the installer - they can't even refresh this page now
273 write_file(APPPATH . 'config/installed.php', '<?php /* App is installed */ ?>','w');
274
video.php https://github.com/Airzign/Shiksha-Sankalp.git | PHP | 264 lines
18 <h1> Video Admin </h1>
19 <?php include('menu.php'); ?>
20 <div class="admin_link">
22 </div>
23 <?php
24 /*
143 }
144 if(mysql_query("INSERT INTO video VALUES (default,'$heading','$description','$small_img_filename','$link',default);"))
145 $message .= 'New video created successfully.';
186 <div class="admin_label"><label for="id_description">Description:</label></div>
187 <textarea name="description" id="id_description"><?php echo $row['description']; ?></textarea>
188 </p>
190 <p>Small Img File:
191 <a href="<?php echo $video_img_dir,$row['smallimgurl']; ?>"><?php echo $row['smallimgurl']; ?></a>
192 <input type="checkbox" name="delete_old_small_img" value="Yes" id="id_delete_old_small_img"/><label for="id_delete_old_small_img">Delete</label>
contactus.php https://github.com/AvinashMudunuri/Modernize.git | PHP | 92 lines
1<?php
2 require_once('Connections/powermigrate.php');
2 require_once('Connections/powermigrate.php');
3 require_once("includes/common.php");
4?>
4?>
5<?php
6$editFormAction = $_SERVER['PHP_SELF'];
20 mysql_select_db($database_powermigrate, $powermigrate);
21 $Result1 = mysql_query($insertSQL, $powermigrate) or die(mysql_error());
22 SendContactUsMail($_POST['company_name'], $_POST['contact_name'], $_POST['job_title'], $_POST['telephone'], $_POST['email'], $_POST['comments']);
30?>
31<?php include("header.php");?>
32<script type="text/javascript">
91</div>
92<?php include("footer.php");?>
CMySQL.php https://github.com/stargazers/CMySQL.git | PHP | 401 lines
1<?php
2
3 /*
4 Class for using MySQL database with PHP.
5 Copyright (C) 2008, 2009, 2011 Aleksi Räsänen <aleksi.rasanen@runosydan.net>
97 // Execute query
98 $ret = @mysql_query( $query, $this->_connection );
99
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))
cronplus.php https://github.com/b123400/Auto-readdaily.git | PHP | 309 lines
76
77<?php
78include 'do_function.php';
100
101$result=mysql_query("SELECT * FROM ".$db_table_name);
102$i=0;
294 or die("Could not select examples");
295 $result=mysql_query("SELECT * FROM ".$db_table_name." WHERE activated=1");
296 while($row = mysql_fetch_array($result)){
index.php https://github.com/damanlovett/SEAHO.git | PHP | 202 lines
1<?php require_once('../../Connections/Directory.php'); ?>
2<?php require_once('../includefiles/initEmails.php'); ?>
3<?php require_once('../includefiles/init.php'); ?>
3<?php require_once('../includefiles/init.php'); ?>
4<?php require_once('../includefiles/AdminLogin.php'); ?>
5<?php
116<div id="header">
117 <?php require_once('../includefiles/userInfo.php'); ?></div>
118<div id="sidebar"><?php require_once('../includefiles/navPage.php'); ?></div>
170 <td><div align="center"><?php echo $row_rsEditorsTwo['order']; ?></div></td>
171 <td><a href="#"><img src="../images/imgUpdate.gif" alt="Edit" border="0" onclick="MM_openBrWindow('update.php?recordID=<?php echo $row_rsEditorsTwo['editor_id']; ?>','update','width=500,height=400')" /></a></td>
172 </tr>
191</div>
192<div id="footer"><?php require_once('../includefiles/footer.php'); ?>
193</div>
actions.class.php https://github.com/rmoralesm/FONDEF-D08I1205.git | PHP | 291 lines
1<?php
2
8 * @author Gustavo Lacoste <gustavo@lacosox.org>
9 * @version SVN: $Id: actions.class.php 23810 2009-11-12 11:07:44Z Kris.Wallsmith $
10 */
41 $sql_borrarcheckbooks="DELETE FROM IRNC_respuestas WHERE `IRNC_respuestas`.`id_user` = '{$idUser}' AND `IRNC_respuestas`.`id_encuestado` = '{$this->idEncuestado}' AND `IRNC_respuestas`.`id_pregunta_IRNC` >= 43";
42 mysql_query($sql_borrarcheckbooks);
43
44 $sql_borrarCOMENTARIOScheckbooks="DELETE FROM IRNC_respuestas_fixed_comxbloque WHERE `IRNC_respuestas_fixed_comxbloque`.`id_user` = '{$idUser}' AND `IRNC_respuestas_fixed_comxbloque`.`id_encuestado` = '{$this->idEncuestado}'";
45 mysql_query($sql_borrarCOMENTARIOScheckbooks);
46
60 `id_pregunta_IRNC`='{$id_preg}'";
61 $respExiste = mysql_query($sql_chequear_siexisterespuesta);
62 $respExiste = mysql_fetch_array($respExiste);
91 // echo $this->sql_regustrar_respuesta;
92 mysql_query($this->sql_regustrar_respuesta);
93 } // <| fiiiin>
extprofile_mysql.h https://github.com/github-ivan/hiphop-php.git | C Header | 321 lines
2 +----------------------------------------------------------------------+
3 | HipHop for PHP |
4 +----------------------------------------------------------------------+
5 | Copyright (c) 2010- Facebook, Inc. (http://www.facebook.com) |
6 | Copyright (c) 1997-2010 The PHP Group |
7 +----------------------------------------------------------------------+
7 +----------------------------------------------------------------------+
8 | This source file is subject to version 3.01 of the PHP license, |
9 | that is bundled with this package in the file LICENSE, and is |
10 | available through the world-wide-web at the following url: |
11 | http://www.php.net/license/3_01.txt |
12 | If you did not receive a copy of the PHP license and are unable to |
13 | obtain it through the world-wide-web, please send a note to |
14 | license@php.net so we can mail you a copy immediately. |
15 +----------------------------------------------------------------------+
view.php https://gitlab.com/jonz94/2016NCU_FreshWeb_HW | PHP | 240 lines
1<!DOCTYPE html>
2<!-- 會員系統 PHP CODE -->
3<?php
4 header("Content-Type: text/html; charset=utf-8");
5 require_once("connMysql.php");
6 //啟用 SESSION
12 $query_RecUser = "SELECT `nickname`, `permission` FROM `user` WHERE `username`='".$username."'";
13 $RecUser = mysql_query($query_RecUser);
14 $row_RecUser = mysql_fetch_assoc($RecUser);
54 window.alert("登入成功!");
55 window.location.assign("view.php?id=<?php echo $id;?>");
56 </script>
210 <?php if ( $lv=="admin" || $row_RecComment["username"]==$username) { ?>
211 <a class="btn btn-lg btn-primary" href="edit.php?id=<?php echo $id;?>" role=button>修改 »</a>
212 <a class="btn btn-lg btn-danger" href="delete.php?id=<?php echo $id;?>" role=button>刪除 »</a>
ARC2_StoreTableManager.php https://github.com/mterenzio/FollowThis.git | PHP | 287 lines
1<?php
2/**
85 ";
86 return mysql_query($sql, $this->getDBCon());
87 }
97 ";
98 return mysql_query($sql, $this->getDBCon());
99 }
110 ";
111 return mysql_query($sql, $this->getDBCon());
112 }
119 ";
120 return mysql_query($sql, $this->getDBCon());
121 }
134 ";
135 return mysql_query($sql, $this->getDBCon());
136 }
listGridCMS_PUBLISH_HISTORY.php https://github.com/juddy/GIP.git | PHP | 285 lines
1<?php
2include_once("../common/dbConnection.php");
2include_once("../common/dbConnection.php");
3include_once("../common/header.php");
4?>
20 $sqlUpdate = "UPDATE CMS_PUBLISH_HISTORY SET HISTORY_ID = '$thisHISTORY_ID' , PUBLISH_TAG = '$thisPUBLISH_TAG' , STRUCTURE_ID = '$thisSTRUCTURE_ID' , RESOURCE_ID = '$thisRESOURCE_ID' , RESOURCE_PATH = '$thisRESOURCE_PATH' , RESOURCE_STATE = '$thisRESOURCE_STATE' , RESOURCE_TYPE = '$thisRESOURCE_TYPE' , SIBLING_COUNT = '$thisSIBLING_COUNT' WHERE HISTORY_ID = '$thisHISTORY_ID'";
21 $resultUpdate = MYSQL_QUERY($sqlUpdate);
22 echo "<b>Record with Id ".$thisHISTORY_IDFromForm." has been Updated<br></b>";
38 $sqlInsert = "INSERT INTO CMS_PUBLISH_HISTORY (HISTORY_ID , PUBLISH_TAG , STRUCTURE_ID , RESOURCE_ID , RESOURCE_PATH , RESOURCE_STATE , RESOURCE_TYPE , SIBLING_COUNT ) VALUES ('$thisHISTORY_ID' , '$thisPUBLISH_TAG' , '$thisSTRUCTURE_ID' , '$thisRESOURCE_ID' , '$thisRESOURCE_PATH' , '$thisRESOURCE_STATE' , '$thisRESOURCE_TYPE' , '$thisSIBLING_COUNT' )";
39 $resultInsert = MYSQL_QUERY($sqlInsert);
40 echo "<b>Record has been inserted in Database<br></b>";
56 $sqlDelete = "DELETE FROM CMS_PUBLISH_HISTORY WHERE HISTORY_ID = '$thisHISTORY_ID'";
57 $resultDelete = MYSQL_QUERY($sqlDelete);
58
96$sql = "SELECT * FROM CMS_PUBLISH_HISTORY".$orderByQuery.$limitQuery;
97$result = MYSQL_QUERY($sql);
98$numberOfRows = MYSQL_NUM_ROWS($result);
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
mysql.idl.php https://github.com/zsj888/hiphop-php.git | PHP | 203 lines
1<?php
2
2
3include_once 'base.php';
4
94
95f('mysql_query', Variant,
96 array('query' => String,
user.php https://github.com/meltingice/Osimo-Forum-System-v1.git | PHP | 381 lines
1<?php
2/*
86 $query = "UPDATE users SET username_clean='$displayName',email='$email',time_zone='$timeZone' WHERE id='{$user['ID']}' LIMIT 1";
87 $result = mysql_query($query);
88
237 <div id="memberlist-wrap">
238 <p><?php echo $numMembers; ?> Members | Page <span id="osimo_memberlist-curpage"><?php echo $page; ?></span> of <span id="osimo_memberlist-totpage"><?php echo $osimo->getPagination('table=users', 'num=15'); ?></span></p>
239 <table cellpadding='4' cellspacing='0' id="memberlist">
248
249 <?php
250 foreach($memberlist as $member)
269 </ul>
270 <?php
271}
281 $query = "SELECT COUNT(*) FROM users WHERE username='$data' LIMIT 1";
282 $result = mysql_query($query);
283 if(reset(mysql_fetch_row($result))==1)
home.php https://github.com/codyaustun/PASS.git | PHP | 305 lines
1<?php // Home page to process login, signup, show html
2
2
3require_once 'info.php'; //database access information
4
35 email = '$useremail' AND password = '$hash'";
36$result = mysql_query($query);
37if (!$result) die("Database access failed: " . mysql_error());
45$query = "UPDATE `kwadwo+IAP`.`auth_user` SET `last_login`='$date' WHERE `auth_user`.`id`='$row[0]'";
46mysql_query($query);
47echo "You have logged in!";
47echo "You have logged in!";
48header("Location: dashboard.php");
49
86$query = "INSERT INTO `kwadwo+IAP`.`users` (`id`, `first_name`, `last_name`, `email`, `password`, `status`, `last_login`, `created_on`) VALUES (NULL, '$firstName', '$lastName', '$useremail', '$hash', 'F', NULL, '$date')";
87mysql_query($query);
88echo "you have successfully signed up!";
quan_ly.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 168 lines
18</style>
19<?php
20 function xuat_link($st)
89 ?>
90 <a href="<?php echo $lpt_1; ?>" class="pt3"><?php echo $i;?> </a>
91 <?php
126 $tv="select * from hoadon order by id desc limit $vtbd,$sd";
127 $tv_1=mysql_query($tv);
128?>
138 </tr>
139 <?php
140 while($tv_2=mysql_fetch_array($tv_1))
145 <tr>
146 <td ><a href="<?php echo $link_xem; ?>" class="thua__link_1"><?php echo $tv_2['ho_ten']; ?></a></td>
147 <!--<td ><a href="#" class="thua__link_1"><?php //echo $tv_2['ky_danh']; ?></a></td>-->
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
questions_add.php https://github.com/web-gpambrosio/VMC.git | PHP | 281 lines
6if ((!isset($_GET['empno']) || trim($_GET['empno']) == ''))
7{ header("location:../../index.php"); }
8$empno=$_GET['empno'];
8$empno=$_GET['empno'];
9include('includes/myname.php');
10include('includes/inc.php');
12$xttt = $_GET['Exam_Name'];
13$vav=mysql_query("select id, type from type where id='$xttt'");
14if (mysql_num_rows($vav) != "0")
142 <tr>
143 <td colspan="3" height="22" align="left"><div><span style="float:RIGHT"><a href='questions_setting.php?empno=<?php echo $empno; ?>' style="color:#0000FF; text-decoration:underline">SEARCH QUESTION</a></span> </div></td>
144 </tr>
227 </div>
228 <div><?php echo $msg3; ?></div>
229 <div>(Optional)</div></td>
test.php https://github.com/UniBus/Server.git | PHP | 282 lines
1<?php
2function openDB($dbServer, $dbUser, $dbPass, $dbName)
22 $query = 'SELECT agency_name FROM agency';
23 $result = mysql_query($query, $cityDBLink) or die('Query failed: '. mysql_error());
24 $totalRows= mysql_num_rows($result);
63 $query = 'SELECT service_id,start_date,end_date FROM calendar ORDER BY end_date DESC';
64 $result = mysql_query($query, $cityDBLink) or die('Query failed: '. mysql_error());
65 $totalRows= mysql_num_rows($result);
78 $query = 'SELECT service_id, date FROM calendar_dates ORDER BY date DESC';
79 $result = mysql_query($query, $cityDBLink) or die('Query failed: '. mysql_error());
80 $totalRows= mysql_num_rows($result);
100 $query = 'SELECT * FROM cities ORDER BY country, state, name';
101 $result = mysql_query($query, $link) or die('Query failed: '. mysql_error());
102 $totalRows= mysql_num_rows($result);
123 $query = 'SELECT * FROM stops ORDER BY RAND() LIMIT 1';
124 $result = mysql_query($query, $link) or die('Query failed: '. mysql_error());
125 $totalRows= mysql_num_rows($result);
producer_orders_byproduct.php https://gitlab.com/Henaway/CLFC | PHP | 332 lines
1<?php
2include_once ('config_foodcoop.php');
2include_once ('config_foodcoop.php');
3include_once ('general_functions.php');
4
53 business_name ASC';
54$resultp = @mysql_query($sqlp, $connection) or die(mysql_error() . "<br><b>Error No: </b>" . mysql_errno());
55while ( $row = mysql_fetch_array($resultp) )
63 <td colspan="6" align="right">
64 Click for invoice sorted by <a href="orders_prdcr_cust.php?delivery_id='.$delivery_id.'&producer_id='.$producer_id.'">customer</a><br>
65 Click for invoice sorted by <a href="orders_prdcr_cust_storage.php?delivery_id='.$delivery_id.'&producer_id='.$producer_id.'">storage/customer</a><br>
65 Click for invoice sorted by <a href="orders_prdcr_cust_storage.php?delivery_id='.$delivery_id.'&producer_id='.$producer_id.'">storage/customer</a><br>
66 Click for invoice with <a href="orders_prdcr_multi.php?delivery_id='.$delivery_id.'&producer_id='.$producer_id.'">multi-sort/mass-update</a><br>
67 Click for <a href="producer_labels.php?delivery_id='.$delivery_id.'&producer_id='.$producer_id.'">labels (one per product/customer)</a><br>
67 Click for <a href="producer_labels.php?delivery_id='.$delivery_id.'&producer_id='.$producer_id.'">labels (one per product/customer)</a><br>
68 Click for <a href="producer_labelsc.php?delivery_id='.$delivery_id.'&producer_id='.$producer_id.'">labels (one per storage/customer)</a>
69 </td>
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]");
flag.php https://github.com/enjrolas/personal-DJ.git | PHP | 342 lines
1<?php
2/*
94 $sql .= ")";
95 $result = mysql_query($sql, dbh());
96 while ($row = mysql_fetch_array($result))
123 $sql .= " ORDER BY date";
124 $result = mysql_query($sql, dbh());
125
156 }
157 $result = mysql_query($sql, dbh());
158 $user = $_SESSION['userdata']['username'];
171 " VALUES ('$val','$flagid','$comment','$user','".time()."')";
172 $result = mysql_query($sql, $dbh);
173 }
180 $sql = "SELECT * FROM flagged_song WHERE song = '".$flagdata['song']."'";
181 $result = mysql_query($sql, dbh());
182 $newtag = mysql_fetch_array($result);
b3kicks.php https://github.com/xlr8or/echelon.git | PHP | 251 lines
111 added
112 <a href="<?php echo $navThisPage; ?>?game=<?php echo $game; ?>&orderby=time_add&order=ASC">
113 <img src="img/asc.gif" alt="ascending" width="11" height="9" border="0" align="absmiddle"></a>
120 expires
121 <a href="<?php echo $navThisPage; ?>?game=<?php echo $game; ?>&orderby=time_expire&order=ASC">
122 <img src="img/asc.gif" alt="ascending" width="11" height="9" border="0" align="absmiddle"></a>
139
140 <a href="<?php echo $navThisPage; ?>?game=<?php echo $game; ?>&orderby=reason&order=DESC">
141 <img src="img/desc.gif" alt="descending" width="11" height="9" border="0" align="absmiddle"></a>
146 <td title="penalty id : <?=$row_rs_activebans['id']?>">
147 <a href="clientdetails.php?game=<?php echo $game; ?>&id=<?php echo $row_rs_activebans['target_id']; ?>">
148 <?php echo htmlspecialchars($row_rs_activebans['target_name']); ?></a>
244 </table>
245 <?php include "footer.php"; ?>
246 </div>