100+ results results for 'php mysql_query' (165 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>
edit_event.php https://bitbucket.org/anneivycat/california-tour.git | PHP | 326 lines
13
14 include ("../sqlfuncs.php");
15
29
30 $mysql_result_update = mysql_query($query_update, $mysql_link);
31 }
41 $query_check_cat = "SELECT category_id from CATEGORIES where category_name = '$NewCategoryName'";
42 $mysql_result_cat_check = mysql_query($query_check_cat,$mysql_link);
43
49
50 $mysql_result_cat_insert = mysql_query($query_cat_insert, $mysql_link);
51 $CategoryId = $NewCategoryId;
65// print($query_get_info);
66 $mysql_result_get_info = mysql_query($query_get_info, $mysql_link);
67
tracker_stats.inc.php https://github.com/harriswong/ATutor.git | PHP | 487 lines
67 course_id='$_SESSION[course_id]'";
68 if(!$result7 = mysql_query($sql7, $db)){
69 require(AT_INCLUDE_PATH.'footer.inc.php');
184 <th><?php echo _AT('page_title'); ?></th>
185 <th><?php echo _AT('hit_count'); ?></th>
186 <th><?php echo _AT('avg_duration'); ?></th>
291 <p>
292 [<a href="<?php echo $_SERVER['PHP_SELF'].'?stats=summary';?>#show_pages"><?php echo _AT('back_to_summary'); ?></a>]
293 </p>
294
295 <h3><?php echo _AT('access_stats'); ?>: <?php echo $current['title']; ?></h3>
296
449 $sql13 = "select *, timestamp as t from ".TABLE_PREFIX."g_click_data where to_cid='0' AND g='$_GET[g_id]' AND course_id='$_SESSION[course_id]'";
450 $result13 = mysql_query($sql13, $db);
451 echo '<a name="show_pages"></a>';
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)
monitorremoto_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 }
qmigo_sendsms.php https://github.com/deviltry/qmigo.git | PHP | 266 lines
1<?php
2
3// Get our DB info
4require "info.php";
5
5
6// Include the PHP TwilioRest library
7require "twilio.php";
35# Get the LATEST OFFER INFO query on the database through the connection
36$result = mysql_query($SqlStatement,$connection);
37if (!$result)
67# Get the LATEST OFFER INFO query on the database through the connection
68$result1 = mysql_query($SqlStatement1,$connection);
69if (!$result1)
86
87 $result2 = mysql_query($SqlStatement2,$connection);
88 if ($row2 = mysql_fetch_array($result2, MYSQL_ASSOC))
tests.inc.php https://github.com/harriswong/ATutor.git | PHP | 214 lines
70 $sql_sub = "SELECT COUNT(*) AS sub_cnt FROM ".TABLE_PREFIX."tests_results WHERE status=1 AND test_id=".$row['test_id'];
71 $result_sub = mysql_query($sql_sub, $db);
72 $row_sub = mysql_fetch_assoc($result_sub);
131
132 <input type="radio" name="allow_test_export" id="allow_test_export" value="1" <?php //echo $test_export_y_checked; ?>/>
133 <label for="allow_test_export"><?php //echo _AT('yes'); ?></label>
157 <small>· <?php echo _AT('about_pretest'); ?></small><br />
158 <?php echo _AT('applies_to_all_sub_pages');?>
159</div>
162
163<?php function print_test_table($results, $post_tids, $id_prefix='') {?>
164 <div>
186 <tr onmousedown="toggleTestSelect('<?php echo $id_prefix; ?>r_<?php echo $row['test_id']; ?>');rowselect(this);" id="<?php echo $id_prefix; ?>r_<?php echo $row['test_id']; ?>">
187 <td><input type="checkbox" name="<?php echo $id_prefix; ?>tid[]" value="<?php echo $row['test_id']; ?>" id="<?php echo $id_prefix; ?>t<?php echo $row['test_id']; ?>" <?php echo $checkMe; ?> onmouseup="this.checked=!this.checked" /></td>
188 <td><?php echo $row['title']; ?></td>
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) {
SocialGroup.class.php https://github.com/harriswong/ATutor.git | PHP | 486 lines
76 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_groups_members WHERE group_id='.$this->group_id;
77 $result = mysql_query($sql, $db);
78 if ($result){
174 if (!empty($this->logo)) {
175 $str = '<a href="'.url_rewrite(AT_SOCIAL_BASENAME.'groups/view.php?id='.$this->getID()).'"><img border="0" src="'.AT_SOCIAL_BASENAME.'groups/get_sgroup_logo.php?id='.$this->getID().'" alt="'.$this->getName().'" title="'.$this->getName().'"/></a>';
176 } else {
249 .$_SESSION['member_id'].', '.$this->getUser().', '.$this->getID().')';
250 $result = mysql_query($sql, $db);
251 return $result;
277 $sql = 'UPDATE '.TABLE_PREFIX."social_groups SET logo='$logo' WHERE id=".$this->getID();
278 $result = mysql_query($sql, $db);
279 return $result;
296 $sql = 'UPDATE '.TABLE_PREFIX."social_groups_board SET body='$body' WHERE id=$id";
297 $result = mysql_query($sql, $db);
298 return $result;
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();
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"] ){
install.php https://github.com/gburca/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);
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>
op-name.php https://github.com/micheleberg/Calontir-OP.git | PHP | 283 lines
1<?php
2
51
52$awardRS = mysql_query("SELECT AwardDate FROM Awards ORDER BY AwardDate DESC");
53$numAward = mysql_num_rows($awardRS);
138
139 $kListRS = mysql_query("SELECT * FROM Kingdoms ORDER BY KingdomInd");
140 $numKList = mysql_num_rows($kListRS);
164
165 $countRS = mysql_query("SELECT count(PopInd) as recCount FROM Populace WHERE $whereClause ORDER BY Name");
166 $numPop = mysql_num_rows($countRS);
174 {
175 $popRS = mysql_query("SELECT * FROM Populace WHERE $whereClause ORDER BY Name");
176 $numPop = mysql_num_rows($popRS);
191# echo " <SPAN STYLE=\"font-weight: bold;\">$popName</SPAN> ($ind)\n";
192 echo " <SPAN STYLE=\"font-weight: bold;\"><A HREF=\"op-name.php?search=^$linkName\$\">$popName</A></SPAN>\n";
193 }
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 = "";
MySQLTableInfo.php https://bitbucket.org/ferOnti/processmaker.git | PHP | 252 lines
1<?php
2/*
2/*
3 * $Id: MySQLTableInfo.php,v 1.20 2006/01/17 19:44:39 hlellelid Exp $
4 *
18 * and is licensed under the LGPL. For more information please see
19 * <http://creole.phpdb.org>.
20 */
21
22require_once 'creole/metadata/TableInfo.php';
23
35 {
36 include_once 'creole/metadata/ColumnInfo.php';
37 include_once 'creole/drivers/mysql/MySQLTypes.php';
48
49 $res = mysql_query("SHOW COLUMNS FROM `" . $this->name . "`", $this->conn->getResource());
50
Database.php https://github.com/durand54/caresite.git | PHP | 395 lines
1<?php
2
95 //$this->queries[] = $query;
96 return mysql_query($query);
97 }
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'], ' ')); ?>">
login.processor.php https://github.com/gunf/novo-isaak.local.git | PHP | 301 lines
1<?php
2require_once(strtr(realpath(dirname(__FILE__)), '\\', '/').'/../includes/protect.inc.php');
4// set the include_once path
5if(version_compare(phpversion(), "4.3.0")>=0) {
6 set_include_path(get_include_path() . PATH_SEPARATOR . "../includes/");
13// include the database configuration file
14include_once "config.inc.php";
15
23 mysql_select_db($dbase);
24 @mysql_query("{$database_connection_method} {$database_connection_charset}");
25}
27// get the settings from the database
28include_once "settings.inc.php";
29
30// include version info
31include_once "version.inc.php";
32
mysqlquery.php https://bitbucket.org/deditec/finoplaner.git | PHP | 562 lines
1<?php
2namespace Core;
179 #echo '<!--'.$this->_query.'-->';
180 $this->_result = mysql_query($this->_query, $this->_dbHandle);
181 $result = array();
211 #echo '<!--'.$queryChild.'-->';
212 $resultChild = mysql_query($queryChild, $this->_dbHandle);
213
263 #echo '<!--'.$queryChild.'-->';
264 $resultChild = mysql_query($queryChild, $this->_dbHandle);
265
316
317 $this->_result = mysql_query($query, $this->_dbHandle);
318
374 $query = 'DESCRIBE '.$this->_table;
375 $this->_result = mysql_query($query, $this->_dbHandle);
376 while ($row = mysql_fetch_row($this->_result)) {
LanguageManager.class.php https://github.com/harriswong/ATutor.git | PHP | 377 lines
1<?php
2/************************************************************************/
13
14require_once(dirname(__FILE__) . '/Language.class.php');
15
25* @author Joel Kronenberg
26* @see Language.class.php
27* @package Language
70 $sql = 'SELECT * FROM '.TABLE_PREFIX.'languages ORDER BY native_name';
71 $result = mysql_query($sql, $db);
72 while($row = mysql_fetch_assoc($result)) {
116 * _GET, _POST, _SESSION, HTTP_ACCEPT_LANGUAGE, HTTP_USER_AGENT. If no match can be made
117 * then it tries to detect a default setting (defined in config.inc.php) or a fallback
118 * setting, false if all else fails.
275
276 require_once(AT_INCLUDE_PATH.'classes/pclzip.lib.php');
277 require_once(AT_INCLUDE_PATH.'../mods/_core/languages/classes/LanguagesParser.class.php');
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
create_question_likert.php https://github.com/harriswong/ATutor.git | PHP | 203 lines
115?>
116<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="form">
117<input type="hidden" name="required" value="1" />
167<div class="input-form">
168 <fieldset class="group_form"><legend class="group_form"><?php echo _AT('test_lk'); ?></legend>
169 <div class="row">
171 <select name="category_id" id="cats">
172 <?php print_question_cats($_POST['category_id']); ?>
173 </select>
176 <div class="row">
177 <span class="required" title="<?php echo _AT('required_field'); ?>">*</span><label for="question"><?php echo _AT('question'); ?></label>
178 <?php print_VE('question'); ?>
190 <?php echo _AT('choice'); ?> <?php echo ($i+1); ?></label><br />
191 <input type="text" id="choice_<?php echo $i; ?>" size="40" name="choice[<?php echo $i; ?>]" value="<?php echo htmlspecialchars(stripslashes($_POST['choice'][$i])); ?>" />
192 </div>
202
203<?php require (AT_INCLUDE_PATH.'footer.inc.php'); ?>
sqlite.php https://github.com/yourhty/hypervm.git | PHP | 635 lines
1<?php
2
131 //print($string . "\n");
132 $res = mysql_query($string, $res);
133 if (!$res) {
136 $this->reconnect();
137 $res = mysql_query($string, $res);
138 }
333 if ($sgbl->__var_database_type === 'mysql') {
334 $result = mysql_query("SHOW COLUMNS FROM $this->__sqtable", $gbl->$fdbvar);
335 if (!$result) {
337 $this->reconnect();
338 $result = mysql_query("SHOW COLUMNS FROM $this->__sqtable", $gbl->$fdbvar);
339 }
mysql.php https://gitlab.com/nacridan/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
searchresult2.php https://bitbucket.org/ayudh_das/khaugali.com.git | PHP | 412 lines
1<?php
2 require_once 'session.php';
2 require_once 'session.php';
3 require_once '../include/util_functions.php';
4 require_once '../include/db_functions.php';
8 && isset($_GET['submit']))){
9 redirectTo('home.php');
10 }
19 $query = "select * from restaurant";
20 $resultset = mysql_query($query,$connection);
21 confirmQuery($resultset);
38 on cuisines.cuisine_id=cid.cuisine_id";
39 $res = mysql_query($q2, $connection);
40 confirmQuery($res);
46 on city.city_id=cityid.city_id";
47 $res = mysql_query($q2, $connection);
48 confirmQuery($res);
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();
import.php https://github.com/atutor/scorm_packages.git | PHP | 490 lines
1<?php
2/*
2/*
3 * mods/scorm_packages/scorm-1.2/import.php
4 *
25if (!isset ($_POST['type'])) {
26 require(AT_INCLUDE_PATH.'vitals.inc.php');
27}
31
32require(AT_INCLUDE_PATH.'../mods/_core/file_manager/filemanager.inc.php');
33require(AT_INCLUDE_PATH.'classes/pclzip.lib.php');
74 $msg->addFeedback('IMPORT_CANCELLED');
75 header('Location: ../index.php');
76 exit;
108if ($_FILES['file']['error'] == 1) {
109 require(AT_INCLUDE_PATH.'header.inc.php');
110 $errors = array('FILE_MAX_SIZE', ini_get('upload_max_filesize'));
edit_post.php https://github.com/harriswong/ATutor.git | PHP | 104 lines
57$_pages['mods/_standard/blogs/post.php?ot='.BLOGS_GROUP.SEP.'oid='.$_REQUEST['oid'].SEP.'id='.$_REQUEST['id']] = $_pages['mods/_standard/blogs/post.php'];
58$_pages['mods/_standard/blogs/post.php?ot='.BLOGS_GROUP.SEP.'oid='.$_REQUEST['oid'].SEP.'id='.$_REQUEST['id']]['children'] = array('mods/_standard/blogs/edit_post.php', 'mods/_standard/blogs/delete_post.php?ot='.BLOGS_GROUP.SEP.'oid='.$_REQUEST['oid'].SEP.'id='.$_REQUEST['id']);
59
61$_pages['mods/_standard/blogs/post.php?ot='.BLOGS_GROUP.SEP.'oid='.$_REQUEST['oid'].SEP.'id='.$_REQUEST['id']]['title'] = $post_row['title'];
62$_pages['mods/_standard/blogs/post.php?ot='.BLOGS_GROUP.SEP.'oid='.$_REQUEST['oid'].SEP.'id='.$_REQUEST['id']]['children'] = array('mods/_standard/blogs/edit_post.php', 'mods/_standard/blogs/delete_post.php?ot='.BLOGS_GROUP.SEP.'oid='.$_REQUEST['oid'].SEP.'id='.$_REQUEST['id']);
63
64$_pages['mods/_standard/blogs/view.php?ot='.BLOGS_GROUP.SEP.'oid='.$_REQUEST['oid']]['title'] = blogs_get_blog_name(BLOGS_GROUP, $_REQUEST['oid']);
65$_pages['mods/_standard/blogs/view.php?ot='.BLOGS_GROUP.SEP.'oid='.$_REQUEST['oid']]['parent'] = 'mods/_standard/blogs/index.php';
66$_pages['mods/_standard/blogs/view.php?ot='.BLOGS_GROUP.SEP.'oid='.$_REQUEST['oid']]['children'] = array('mods/_standard/blogs/add_post.php');
88 <div class="row">
89 <a href="<?php echo htmlspecialchars($_SERVER['REQUEST_URI'], ENT_QUOTES); ?>#jumpcodes" title="<?php echo _AT('jump_codes'); ?>"><img src="images/clr.gif" height="1" width="1" alt="<?php echo _AT('jump_codes'); ?>" border="0" /></a><?php require(AT_INCLUDE_PATH.'html/code_picker.inc.php'); ?>
90
98 <div class="row buttons">
99 <input type="submit" name="submit" value="<?php echo _AT('save'); ?>" accesskey="s" /> <input type="submit" name="cancel" value="<?php echo _AT('cancel'); ?>" />
100 </div>
103
104<?php require(AT_INCLUDE_PATH.'footer.inc.php'); ?>
confirm.php https://github.com/harriswong/ATutor.git | PHP | 170 lines
30 $sql = "SELECT creation_date FROM ".TABLE_PREFIX."members WHERE member_id=$id";
31 $result = mysql_query($sql, $db);
32 if ($row = mysql_fetch_assoc($result)) {
36 $sql = "UPDATE ".TABLE_PREFIX."members SET email='$e', last_login=NOW(), creation_date=creation_date WHERE member_id=$id";
37 $result = mysql_query($sql, $db);
38
82 echo "<div class=\"input-form\">";
83 require(AT_INCLUDE_PATH.'html/auto_enroll_list_courses.inc.php');
84 echo '<p style="text-align:center"><a href="'. $_SERVER['PHP_SELF'] . '?auto_login=1&member_id='. $id .'">' . _AT("go_to_my_start_page") . '</a></p>';
85 echo "</div>";
86 require(AT_INCLUDE_PATH.'footer.inc.php');
87 exit;
119 /* send the email confirmation message: */
120 require(AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php');
121 $mail = new ATutorMailer();
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>
new_account.php https://github.com/atutor/mahara.git | PHP | 244 lines
1<?php
2
3/*
4 This belongs to the ATutor+Mahara module. It is called from index.php when
5 the user does not have a Mahara account associated with ATutor. This script
10
11 Most of the necessary code is copied and modified from init.php and
12 register.php of Mahara.
22$sql = 'SELECT * FROM '.TABLE_PREFIX.'members WHERE member_id="'.$_SESSION['member_id'].'"';
23$result = mysql_query($sql, $db);
24$row = mysql_fetch_assoc($result);
33
34/******************from init.php*************************/
35define('INTERNAL', 1);
52// Set up error handling
53require(MAHARA_PATH.'lib/errors.php');
54
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 }
agent_calendar_2007.php https://bitbucket.org/anneivycat/california-tour.git | PHP | 313 lines
29<HEAD>
30<TITLE>Tours from <?php echo $myCities[$city]; ?></TITLE>
31<?php if($languageUsed == "JP") { ?>
32<meta http-equiv=\"Content-Type\" content="text/html; charset=x-sjis">
33<?php
34} else {
213<a href="?city=<?php echo $city; ?>&year=2006&month=3">mar</a>
214<a href="?city=<?php echo $city; ?>&year=2006&month=4">apr</a>
215<a href="?city=<?php echo $city; ?>&year=2006&month=5">may</a>
229<font face="Verdana, Arial, Helvetica, sans-serif" color="#006699">
230<strong><font size="2" color="#FF6600"><?php echo getMonthName($month); ?> <?php echo $year ?></font></strong>
231</font>
265// echo "<span style='font-size: 70%;'>$query</span><br />\n";
266 $mysql_result = mysql_query($query);
267 $totalnumrows = mysql_num_rows($mysql_result);
page_class.php https://github.com/dariostric/CMS.git | PHP | 238 lines
1<?php
2
2
3include("../definitions/definitions.php");
4
11 if ($language==0) {
12 $response1=mysql_query("SELECT * FROM languages");
13 $row1=mysql_fetch_array($response1, MYSQL_ASSOC);
13 $row1=mysql_fetch_array($response1, MYSQL_ASSOC);
14 $response=mysql_query("SELECT * FROM pages where underpage='0' ORDER BY id");
15 while ($row=mysql_fetch_array($response, MYSQL_ASSOC)) {
18 } else {
19 $response1=mysql_query("SELECT * FROM languages where id='".$language."'");
20 while ($row1=mysql_fetch_array($response1, MYSQL_ASSOC)) {
20 while ($row1=mysql_fetch_array($response1, MYSQL_ASSOC)) {
21 $response=mysql_query("SELECT * FROM pages where underpage='0' ORDER BY id");
22 while ($row=mysql_fetch_array($response, MYSQL_ASSOC)) {
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) {
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';
RecordModule.class.php https://bitbucket.org/rkandpal/nustechgmgitfork.git | PHP | 346 lines
1<?php
2
27
28 $get_module = mysql_query("SELECT * FROM `modules` WHERE `id` = '".mysql_real_escape_string($this->getId(), $config->db->con)."'", $config->db->con);
29 $this->meta = mysql_fetch_assoc($get_module);
38
39 $get_fields = mysql_query("SELECT * FROM `modules_fields` WHERE `module_id` = '".mysql_real_escape_string($this->getId(), $config->db->con)."' ORDER BY `order` ASC", $config->db->con);
40 while($res_fields = mysql_fetch_assoc($get_fields)){
63
64 $get_records = mysql_query("SELECT * FROM `".$this->getTable()."`".(count($sql_where) > 0 ? " WHERE ".implode(" AND ", $sql_where) : '').(count($sql_orderby) > 0 ? " ORDER BY ".implode(", ", $sql_orderby) : ''), $config->db->con);
65
119 if($paginator){
120 $get_total_records = mysql_query("SELECT COUNT(`id`) as 'total' FROM `".$this->getTable()."`", $config->db->con);
121 $res_total_records = mysql_fetch_assoc($get_total_records);
179
180 $get_records = mysql_query("SELECT * FROM `".$this->getTable()."`".($sql_parts ? " WHERE ".implode(' AND ', $sql_parts) : '').( !empty($options['orderby']) ? ' ORDER BY `'.$options['orderby']['field'].'` '.$options['orderby']['direction'] : "" ).( $paginator ? " LIMIT ".$paginator->getRecordStart().", ".$paginator->getPerPage() : ""), $config->db->con);
181 if($paginator){
developerProfile.php https://bitbucket.org/jasonrogena/fulcrum-dqs.git | PHP | 195 lines
1<?php include "../phpScripts/adminAccessConfirmation.php";?>
2<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
7<?php
8 include '../phpScripts/dbConnect.php';
9 $adminUsername=$_COOKIE['administratorUsername'];
13 {
14 header("location:administration.php");
15 }
18 $query="SELECT * FROM developer WHERE username='$devUsername'";
19 $result=mysql_query($query) or die(mysql_error());
20 $fetchedResults=mysql_fetch_array($result);
136<div style="height:25px"><a href="" class="links" style="color:#333"><?php echo $_COOKIE['administratorUsername'];?></a></div>
137<div><a href="../phpScripts/logout.php" class="links">logout</a></div>
138</td></tr>
143<tr><td class="optionCells" id="applicationOpt" onmouseover="JavaScript:optionOn(this);" onmouseout="JavaScript:optionOff(this);">
144<a class="links" href="applications.php">Questionnaires</a>
145</td></tr>
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://bitbucket.org/pastor399/newcastleunifc.git | PHP | 413 lines
1<?php
2/**
77
78 // Make sure the MySQL extension for PHP is installed and enabled.
79 if (!function_exists('mysql_connect'))
90 // Set sql_mode to non_strict mode
91 mysql_query("SET @@SESSION.sql_mode = '';", $this->connection);
92
270 // Execute the query. Error suppression is used here to prevent warnings/notices that the connection has been lost.
271 $this->cursor = @mysql_query($query, $this->connection);
272
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>';
assetfunctions.php https://github.com/iitgrad/cellarworxiPhoneApp.git | PHP | 751 lines
258
259 $result=mysql_query($query);
260
432
433 mysql_query($query);
434
446
447 mysql_query($query);
448
510
511 $result=mysql_query($query) ;
512
720
721 echo '<a href='.$PHP_SELF.'?action=delete'.$times.'&assettype='.$assettype.'&resid='.$res['id'].'>'.$res['name'].'<br>['.$res['clientcode'].'] '.$res['lot'].'</a> <a href=showassetschedule.php?caldate='.strtotime($date).'&assetid='.$id.'>(ASSET SCHEDULE)</a>';
722
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
lib.inc.php https://github.com/harriswong/ATutor.git | PHP | 143 lines
1<?php
2/***********************************************************************/
126 $sql = 'SELECT p.* FROM '.TABLE_PREFIX.'pa_photos p LEFT JOIN '.TABLE_PREFIX."pa_course_album ca ON p.album_id=ca.album_id WHERE member_id=$member_id AND ca.course_id IS NULL";
127 $result = mysql_query($sql, $db);
128 if ($result){
offer.php https://github.com/deviltry/qmigo.git | PHP | 279 lines
10//session_save_path(); // see if dreamhost can do something...
11require "info_session.php";
12session_name($mySessionName);
17# Get our DB info
18require "info.php";
19
22# Get our site info
23require "offersiteinfo.php";
24
40if (empty($member_id))
41{ header("Location: member404.php"); //steer them to an ERROR page...design one
42 exit;
67
68$result = mysql_query($SqlStatement,$connection);
69if (!$result) die("Error " . mysql_errno() . " : " . mysql_error());
PatchCreator.class.php https://github.com/harriswong/ATutor.git | PHP | 386 lines
1<?php
2/************************************************************************/
24define('AT_INCLUDE_PATH', '../../../../include/');
25require_once (AT_INCLUDE_PATH.'vitals.inc.php');
26
26
27require_once(AT_INCLUDE_PATH. "../mods/_standard/patcher/include/patch_xml_template.inc.php");
28
57 * (
58 * [file_name] => script1.php
59 * [action] => add
60 * [directory] => admin/
61 * [upload_tmp_name] => C:\xampp\tmp\php252.tmp
62 * )
65 * (
66 * [file_name] => script2.php
67 * [action] => delete
crop_finder.php https://github.com/caponelpalo/Travianx.git | PHP | 359 lines
19 } elseif($_POST['type'] == 9) {
20 header("Location: ".$_SERVER['PHP_SELF']."?s=2&x=" . $_POST['x'] . '&y=' . $_POST['y']);
21 } elseif($_POST['type'] == 'both') {
21 } elseif($_POST['type'] == 'both') {
22 header("Location: ".$_SERVER['PHP_SELF']."?s=3&x=" . $_POST['x'] . '&y=' . $_POST['y']);
23 }
105<br /><br />
106<form action="<?php echo $_SERVER['PHP_SELF']; ?>?s" method="post">
107 <table>
117 <td>Startposition:</td>
118 <td>x: <input type="text" name="x" value="<?php print $coor2['x']; ?>" size="3" /> y: <input type="text" name="y" value="<?php print $coor2['y']; ?>" size="3" />
119 </tr>
128 define('PREFIX', TB_PREFIX);
129 $type15 = mysql_query("SELECT id,x,y,occupied FROM ".PREFIX."wdata WHERE fieldtype = 6");
130 $type9 = mysql_query("SELECT id,x,y,occupied FROM ".PREFIX."wdata WHERE fieldtype = 1");
sqlquery.lib.php https://github.com/akash6190/pragyan.git | PHP | 256 lines
1<?php
2if(!defined('__PRAGYAN_CMS'))
36 $sqlQueryQuery = 'SELECT `sqlquery_title`, `sqlquery_query` FROM `sqlquery_desc` WHERE `page_modulecomponentid` = \'' . $this->moduleComponentId."'";
37 $sqlQueryResult = mysql_query($sqlQueryQuery);
38 if(!$sqlQueryResult) {
88 $query="SHOW TABLES";
89 $res=mysql_query($query);
90 while($row=mysql_fetch_row($res))
102 $query="SELECT * FROM '$tablename'";
103 $res=mysql_query($query);
104 $numfields=mysql_num_fields($res);
137 $query="SELECT * FROM '$tablename' LIMIT 1";
138 $res=mysql_query($query);
139 for($i=0;$i<mysql_num_fields($res);$i++)
161 $defaultValueQuery = 'SELECT `sqlquery_title`, `sqlquery_query` FROM `sqlquery_desc` WHERE `page_modulecomponentid` = \'' . $this->moduleComponentId."'";
162 $defaultValueResult = mysql_query($defaultValueQuery);
163 if(!$defaultValueResult) {
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)) {