|
PHP - Click Name From One Mysql Table To Show Report On Other Page
Hi,
How can I get others informations on another page by clicking on one row's value I have this code, but it doesn't work: while($row = mysql_fetch_array($result)) { echo "<tr><p>"; echo "<th><p>" . $row['fname'] . " " . $row['lname'] . "</p></th>"; echo"<th><p><a href='student.php?id='".$row['topic']."'\'>".$row['topic']."</p></a></th>"; echo "</tr>"; } echo "</table>"; Student.php <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("college", $con); $result = mysql_query("SELECT * FROM students"); $topic = $_Get['topic']; while($row = mysql_fetch_array($result)) { echo "<tr><p>"; echo "<th><p>" . $row['month']." " .$row['datetime']."</p></th>"; echo"<th><p>". $row['topic'] ."</p></th>"; echo "<th><p>" . $row['gender'] . "</p></th>"; echo "<th><p>" . $row['fname'] . " " . $row['lname'] . "</p></th>"; echo "<th ><p>" . $row['id'] . "</p></th>"; echo "</tr>"; echo "</table>"; mysql_close($con); } ?> Similar Tutorials
create table mimi (mimiId int(11) not null, mimiBody varchar(255) );
<?php
//connecting to database
include_once ('conn.php');
$sql ="SELECT mimiId, mimiBody FROM mimi";
$result = mysqli_query($conn, $sql );
$mimi = mysqli_fetch_assoc($result);
$mimiId ='<span>No: '.$mimi['mimiId'].'</span>';
$mimiBody ='<p class="leading text-justify">'.$mimi['mimiBody'].'</p>';
?>
//what is next?
i want to download pdf or text document after clicking button or link how to do that I'm using a woocommerce order report plugin, some customers order multiple products but order report shows only number of order and one product name: I want to see all product names: also I want to see customer notes it doesn't show up
<?php
/**
* Plugin Name: Custom Order Report
* Description: Generates a report on individual WooCommerce products sold during a specified time period.
* Version: 1.4.8
*/
// Add the Product Sales Report to the WordPress admin
add_action('admin_menu', 'hm_psrf_admin_menu');
function hm_psrf_admin_menu() {
add_submenu_page('woocommerce', 'Custom Order Report', 'Custom Order Report', 'view_woocommerce_reports', 'hm_sbpf', 'hm_sbpf_page');
}
function hm_psrf_default_report_settings() {
return array(
'report_time' => '30d',
'report_start' => date('Y-m-d', current_time('timestamp') - (86400 * 31)),
'report_end' => date('Y-m-d', current_time('timestamp') - 86400),
'order_statuses' => array('wc-processing', 'wc-on-hold', 'wc-completed'),
'products' => 'all',
'product_cats' => array(),
'product_ids' => '',
'variations' => 0,
'orderby' => 'quantity',
'orderdir' => 'desc',
'fields' => array('product_id', 'product_sku', 'product_name', 'quantity_sold', 'gross_sales'),
'limit_on' => 0,
'limit' => 10,
'include_header' => 1,
'exclude_free' => 0
);
}
// This function generates the Product Sales Report page HTML
function hm_sbpf_page() {
$savedReportSettings = get_option('hm_psr_report_settings');
if (isset($_POST['op']) && $_POST['op'] == 'preset-del' && !empty($_POST['r']) && isset($savedReportSettings[$_POST['r']])) {
unset($savedReportSettings[$_POST['r']]);
update_option('hm_psr_report_settings', $savedReportSettings);
$_POST['r'] = 0;
echo('<script type="text/javascript">location.href = location.href;</script>');
}
$reportSettings = (empty($savedReportSettings) ?
hm_psrf_default_report_settings() :
array_merge(hm_psrf_default_report_settings(),
$savedReportSettings[
isset($_POST['r']) && isset($savedReportSettings[$_POST['r']]) ? $_POST['r'] : 0
]
));
// For backwards compatibility with pre-1.4 versions
if (!empty($reportSettings['cat'])) {
$reportSettings['products'] = 'cats';
$reportSettings['product_cats'] = array($reportSettings['cat']);
}
$fieldOptions = array(
'order_id' => 'Order ID',
/*'product_id' => 'Product ID',*/
'customer_name' => 'Customer Name',
/*'variation_id' => 'Variation ID',*/
'city' => 'City',
'address' => 'Address',
'product_name' => 'Product Name',
'quantity_sold' => 'Quantity Sold',
/*'product_sku' => 'Product SKU',*/
'gross_sales' => 'Gross Sales',
'product_categories' => 'Schools',
/*'variation_attributes' => 'Variation Attributes',*/
/*'gross_after_discount' => 'Gross Sales (After Discounts)'*/
'ceremony_date' => 'Ceremony Date',
'ceremony_time' => 'Ceremony Time',
);
include(dirname(__FILE__).'/admin.php');
}
// Hook into WordPress init; this function performs report generation when
// the admin form is submitted
add_action('init', 'hm_sbpf_on_init', 9999);
function hm_sbpf_on_init() {
global $pagenow;
// Check if we are in admin and on the report page
if (!is_admin())
return;
if ($pagenow == 'admin.php' && isset($_GET['page']) && $_GET['page'] == 'hm_sbpf' && !empty($_POST['hm_sbp_do_export'])) {
// Verify the nonce
check_admin_referer('hm_sbpf_do_export');
$newSettings = array_intersect_key($_POST, hm_psrf_default_report_settings());
foreach ($newSettings as $key => $value)
if (!is_array($value))
$newSettings[$key] = htmlspecialchars($value);
// Update the saved report settings
$savedReportSettings = get_option('hm_psr_report_settings');
$savedReportSettings[0] = array_merge(hm_psrf_default_report_settings(), $newSettings);
update_option('hm_psr_report_settings', $savedReportSettings);
// Check if no fields are selected or if not downloading
if (empty($_POST['fields']) || empty($_POST['hm_sbp_download']))
return;
// Assemble the filename for the report download
$filename = 'Product Sales - ';
if (!empty($_POST['cat']) && is_numeric($_POST['cat'])) {
$cat = get_term($_POST['cat'], 'product_cat');
if (!empty($cat->name))
$filename .= addslashes(html_entity_decode($cat->name)).' - ';
}
$filename .= date('Y-m-d', current_time('timestamp')).'.csv';
// Send headers
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="'.$filename.'"');
// Output the report header row (if applicable) and body
$stdout = fopen('php://output', 'w');
if (!empty($_POST['include_header']))
hm_sbpf_export_header($stdout);
hm_sbpf_export_body($stdout);
exit;
}
}
// This function outputs the report header row
function hm_sbpf_export_header($dest, $return=false) {
$header = array();
foreach ($_POST['fields'] as $field) {
switch ($field) {
case 'order_id':
$header[] = 'Order ID';
break;
case 'product_name':
$header[] = 'Product Name';
break;
case 'quantity_sold':
$header[] = 'Quantity Sold';
break;
case 'gross_sales':
$header[] = 'Gross Sales';
break;
case 'product_categories':
$header[] = 'Schools';
break;
case 'customer_name':
$header[] = 'Customer Name';
break;
case 'city':
$header[] = 'City';
break;
case 'address':
$header[] = 'Address';
break;
case 'ceremony_date':
$header[] = 'Ceremony Date';
break;
case 'ceremony_time':
$header[] = 'Ceremony Time';
break;
}
}
if ($return)
return $header;
fputcsv($dest, $header);
}
// This function generates and outputs the report body rows
function hm_sbpf_export_body($dest, $return=false) {
global $woocommerce, $wpdb;
$product_ids = array();
if ($_POST['products'] == 'cats') {
$cats = array();
foreach ($_POST['product_cats'] as $cat)
if (is_numeric($cat))
$cats[] = $cat;
$product_ids = get_objects_in_term($cats, 'product_cat');
} else if ($_POST['products'] == 'ids') {
foreach (explode(',', $_POST['product_ids']) as $productId) {
$productId = trim($productId);
if (is_numeric($productId))
$product_ids[] = $productId;
}
}
// Calculate report start and end dates (timestamps)
switch ($_POST['report_time']) {
case '0d':
$end_date = strtotime('midnight', current_time('timestamp'));
$start_date = $end_date;
break;
case '1d':
$end_date = strtotime('midnight', current_time('timestamp')) - 86400;
$start_date = $end_date;
break;
case '7d':
$end_date = strtotime('midnight', current_time('timestamp')) - 86400;
$start_date = $end_date - (86400 * 6);
break;
case '1cm':
$start_date = strtotime(date('Y-m', current_time('timestamp')).'-01 midnight -1month');
$end_date = strtotime('+1month', $start_date) - 86400;
break;
case '0cm':
$start_date = strtotime(date('Y-m', current_time('timestamp')).'-01 midnight');
$end_date = strtotime('+1month', $start_date) - 86400;
break;
case '+1cm':
$start_date = strtotime(date('Y-m', current_time('timestamp')).'-01 midnight +1month');
$end_date = strtotime('+1month', $start_date) - 86400;
break;
case '+7d':
$start_date = strtotime('midnight', current_time('timestamp')) + 86400;
$end_date = $start_date + (86400 * 6);
break;
case '+30d':
$start_date = strtotime('midnight', current_time('timestamp')) + 86400;
$end_date = $start_date + (86400 * 29);
break;
case 'custom':
$end_date = strtotime('midnight', strtotime($_POST['report_end']));
$start_date = strtotime('midnight', strtotime($_POST['report_start']));
break;
default: // 30 days is the default
$end_date = strtotime('midnight', current_time('timestamp')) - 86400;
$start_date = $end_date - (86400 * 29);
}
// Assemble order by string
$orderby = (in_array($_POST['orderby'], array('product_id', 'gross', 'gross_after_discount')) ? $_POST['orderby'] : 'quantity');
$orderby .= ' '.($_POST['orderdir'] == 'asc' ? 'ASC' : 'DESC');
// Create a new WC_Admin_Report object
include_once($woocommerce->plugin_path().'/includes/admin/reports/class-wc-admin-report.php');
$wc_report = new WC_Admin_Report();
$wc_report->start_date = $start_date;
$wc_report->end_date = $end_date;
//echo(date('Y-m-d', $end_date));
$where_meta = array();
if ($_POST['products'] != 'all') {
$where_meta[] = array(
'type' => 'order_item_meta',
'meta_key' => '_product_id',
'operator' => 'in',
'meta_value' => $product_ids
);
}
if (!empty($_POST['exclude_free'])) {
$where_meta[] = array(
'meta_key' => '_line_total',
'meta_value' => 0,
'operator' => '!=',
'type' => 'order_item_meta'
);
}
// Get report data
// Avoid max join size error
$wpdb->query('SET SQL_BIG_SELECTS=1');
// Prevent plugins from overriding the order status filter
add_filter('woocommerce_reports_order_statuses', 'hm_psrf_report_order_statuses', 9999);
// Based on woocoommerce/includes/admin/reports/class-wc-report-sales-by-product.php
$sold_products = $wc_report->get_order_report_data(array(
'data' => array(
'_product_id' => array(
'type' => 'order_item_meta',
'order_item_type' => 'line_item',
'function' => '',
'name' => 'product_id'
),
'_qty' => array(
'type' => 'order_item_meta',
'order_item_type' => 'line_item',
'function' => 'SUM',
'name' => 'quantity'
),
'_line_subtotal' => array(
'type' => 'order_item_meta',
'order_item_type' => 'line_item',
'function' => 'SUM',
'name' => 'gross'
),
'_line_total' => array(
'type' => 'order_item_meta',
'order_item_type' => 'line_item',
'function' => 'SUM',
'name' => 'gross_after_discount'
),
/*usama*/
'order_id' => array(
'type' => 'order_item',
'order_item_type' => 'line_item',
'function' => '',
'name' => 'order_id'
)
/*usama*/
),
'query_type' => 'get_results',
'group_by' => 'order_id',
'where_meta' => $where_meta,
'order_by' => $orderby,
'limit' => (!empty($_POST['limit_on']) && is_numeric($_POST['limit']) ? $_POST['limit'] : ''),
'filter_range' => ($_POST['report_time'] != 'all'),
'order_types' => wc_get_order_types('order_count'),
'order_status' => hm_psrf_report_order_statuses()
));
// Remove report order statuses filter
remove_filter('woocommerce_reports_order_statuses', 'hm_psrf_report_order_statuses', 9999);
if ($return)
$rows = array();
// Output report rows
foreach ($sold_products as $product) {
$row = array();
/*usama*/
$order = wc_get_order($product->order_id);
$customerName = $order->get_billing_first_name().' '.$order->get_billing_last_name();
$billingCity = $order->get_billing_city();
$billingAddress1 = $order->get_billing_address_1();
//echo $product->order_id;
//echo $customerName.$city.$billingAddress1;
//echo '<pre>';print_r($order);exit;
/*usama*/
foreach ($_POST['fields'] as $field) {
switch ($field) {
case 'order_id':
$row[] = $product->order_id;
break;
case 'product_name':
$row[] = html_entity_decode(get_the_title($product->product_id));
break;
case 'quantity_sold':
$row[] = $product->quantity;
break;
case 'gross_sales':
$row[] = $product->gross;
break;
/*case 'variation_id':
$row[] = (empty($product->variation_id) ? '' : $product->variation_id);
break;
case 'product_sku':
$row[] = get_post_meta($product->product_id, '_sku', true);
break;*/
case 'product_categories':
$terms = get_the_terms($product->product_id, 'product_cat');
if (empty($terms)) {
$row[] = '';
} else {
$categories = array();
foreach ($terms as $term)
$categories[] = $term->name;
$row[] = implode(', ', $categories);
}
break;
case 'customer_name':
$row[] = $customerName;
break;
case 'city':
$row[] = $billingCity;
break;
case 'address':
$row[] = $billingAddress1;
break;
/*case 'gross_after_discount':
$row[] = $product->gross_after_discount;
break;*/
/*usama*/
case 'ceremony_date':
$row[] = $order->get_meta( '_billing_myfield12', true );
break;
case 'ceremony_time':
$row[] = $order->get_meta( '_billing_myfield13', true );
break;
}
}
if ($return)
$rows[] = $row;
else
fputcsv($dest, $row);
}
if ($return)
return $rows;
}
add_action('admin_enqueue_scripts', 'hm_psrf_admin_enqueue_scripts');
function hm_psrf_admin_enqueue_scripts() {
wp_enqueue_style('hm_psrf_admin_style', plugins_url('css/hm-product-sales-report.css', __FILE__));
wp_enqueue_style('pikaday', plugins_url('css/pikaday.css', __FILE__));
wp_enqueue_script('moment', plugins_url('js/moment.min.js', __FILE__));
wp_enqueue_script('pikaday', plugins_url('js/pikaday.js', __FILE__));
}
// Schedulable email report hook
add_filter('pp_wc_get_schedulable_email_reports', 'hm_psrf_add_schedulable_email_reports');
function hm_psrf_add_schedulable_email_reports($reports) {
$reports['hm_psr'] = array(
'name' => 'Product Sales Report',
'callback' => 'hm_psrf_run_scheduled_report',
'reports' => array(
'last' => 'Last used settings'
)
);
return $reports;
}
function hm_psrf_run_scheduled_report($reportId, $start, $end, $args=array(), $output=false) {
$savedReportSettings = get_option('hm_psr_report_settings');
if (!isset($savedReportSettings[0]))
return false;
$prevPost = $_POST;
$_POST = $savedReportSettings[0];
$_POST['report_time'] = 'custom';
$_POST['report_start'] = date('Y-m-d', $start);
$_POST['report_end'] = date('Y-m-d', $end);
$_POST = array_merge($_POST, array_intersect_key($args, $_POST));
if ($output) {
echo('<table><thead><tr>');
foreach (hm_sbpf_export_header(null, true) as $heading) {
echo("<th>$heading</th>");
}
echo('</tr></thead><tbody>');
foreach (hm_sbpf_export_body(null, true) as $row) {
echo('<tr>');
foreach ($row as $cell)
echo('<td>'.htmlspecialchars($cell).'</td>');
echo('</tr>');
}
echo('</tbody></table>');
$_POST = $prevPost;
return;
}
$filename = get_temp_dir().'/Product Sales Report.csv';
$out = fopen($filename, 'w');
if (!empty($_POST['include_header']))
hm_sbpf_export_header($out);
hm_sbpf_export_body($out);
fclose($out);
$_POST = $prevPost;
return $filename;
}
function hm_psrf_report_order_statuses() {
$wcOrderStatuses = wc_get_order_statuses();
$orderStatuses = array();
if (!empty($_POST['order_statuses'])) {
foreach ($_POST['order_statuses'] as $orderStatus) {
if (isset($wcOrderStatuses[$orderStatus]))
$orderStatuses[] = substr($orderStatus, 3);
}
}
return $orderStatuses;
}
/* Review/donate notice */
register_activation_hook(__FILE__, 'hm_psrf_first_activate');
function hm_psrf_first_activate() {
$pre = 'hm_psr';
$firstActivate = get_option($pre.'_first_activate');
if (empty($firstActivate)) {
update_option($pre.'_first_activate', time());
}
}
if (is_admin() && get_option('hm_psr_rd_notice_hidden') != 1 && time() - get_option('hm_psr_first_activate') >= (14*86400)) {
add_action('admin_notices', 'hm_psrf_rd_notice');
add_action('wp_ajax_hm_psrf_rd_notice_hide', 'hm_psrf_rd_notice_hide');
}
function hm_psrf_rd_notice() {
$pre = 'hm_psr';
$slug = 'product-sales-report-for-woocommerce';
echo('
<div id="'.$pre.'_rd_notice" class="updated notice is-dismissible"><p>Do you use the <strong>Product Sales Report</strong> plugin?
Please support our free plugin by <a href="" target="_blank">making a donation</a>!product-sales-report-for-woocommerce
Thanks!</p></div>
<script>jQuery(document).ready(function($){$(\'#'.$pre.'_rd_notice\').on(\'click\', \'.notice-dismiss\', function(){jQuery.post(ajaxurl, {action:\'hm_psrf_rd_notice_hide\'})});});</script>
');
}
function hm_psrf_rd_notice_hide() {
$pre = 'hm_psr';
update_option($pre.'_rd_notice_hidden', 1);
}
?>
Hi all, For a logging tool I need to make some automated reports. On 1 page it needs to give for 4 clients the amount of calls per month for the last 12 months. Also it needs to give the amount of calls for the employees per month for the last 12 months. I was hoping you could help me with a better solution than seperate queries. Gr Ryflex Hi all, I am trying to make a members details section that can be updated. I want to be able to "SELECT * FROM users WHERE email='$email'" and then show the values that can be changed in a html drop down box with the selection that was made when the user registered already selected="selected"; You will be able to see what I am attempting to do below. <?php $sql = "SELECT manufacturer FROM table1 WHERE email=$'email'"; $result = mysqli_query($cxn,$sql); $row = mysqli_fetch_assoc($result); foreach manufacturer in table1 { if table1.manufacturer = table2.manufacturer { echo '<option name="manufacturer" selected="selected" value"$row['manufacturer']"</option>'; } else { echo '<option name="manufacturer" value"$row['manufacturer']"</option>'; } } ?> Hi again PhpFreaks, yet again I got a problem regarding coding. I'm trying to show the same data, but updated right away. For example. I want to update my coords on a map and refresh a div to show the new data, but as the code now, it keeps the same data until I reload the page. Here is the code I have now. if ($north) { $ylocation = $users['y'] + 1; if ($ylocation > 5) { $ylocation = 0; } $locationyupdate = ("UPDATE players SET y = '$ylocation' WHERE name='$users[name]'"); mysql_query($locationyupdate) or die("could not register");?> <script type="text/javascript"> $('#npc').load('npc.php'); $('#description').load('description.php'); </script><?} The update code is before the reload script for the two div's. The data DOES change in the database, but the two div's won't display the new data until it is refreshed again. Do I need to reactivate fetch to get the new data? Hi, okee so I'm new to everything that has to do with scripting, especially when it comes to PHP and stuff, but what is the best way to display information from a table on a page? I'm creating this site where users can post their events, but I want the Location to be based on the Location they inserted during the registration process, so that the location will be displayed directly. How am I able to do that? I've already got an login script, it looks like this: Code: [Select] <?php ob_start(); $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="whats_happening_db"; // Database name $tbl_name="members"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // Define $myusername and $mypassword $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("myusername"); session_register("mypassword"); header("location:membersarea.php?user=$myusername"); } else { echo "Wrong Username or Password"; } ob_end_flush(); ?> Sorry if my English is terrible haha. Dante. I need to email this report but I don't know where to start
I have included the report code.
<html>
<head>
<title>Customer Load Report</title>
</head>
<body>
<h1>Customer Load Report</h1>
<?php
$custid=$_POST["Cust_ID"];
$connect =odbc_connect("removed");
if(!$connect) {
exit("Connection Failed: " . $connect);
}
$sql="SELECT m1_DC.dbo.organizationlocations.cmlName
,m1_DC.dbo.SalesOrders.OMPSHIPPINGMETHODID
,m1_DC.dbo.SalesOrders.UOMPTRUCKNUMBER
,m1_DC.dbo.SalesOrders.ompCustomerPO
,m1_DC.dbo.SalesOrders.UOMPTOTALBOXCOUNT
,m1_DC.dbo.SalesOrders.UOMPVOLUMETOTAL
,m1_DC.dbo.organizationlocations.CMLADDRESSLINE1
,m1_DC.dbo.organizationlocations.CMLADDRESSLINE2
,m1_DC.dbo.organizationlocations.CMLCITY
,m1_DC.dbo.organizationlocations.CMLSTATE
,m1_DC.dbo.organizationlocations.CMLPOSTCODE
,m1_DC.dbo.SalesOrders.OMPREQUESTEDSHIPDATE
,m1_DC.dbo.SalesOrders.ompSalesOrderID
,convert(varchar(10),m1_DC.dbo.SalesOrders.ompRequestedShipDate,110) as ShipDate
FROM m1_DC.dbo.SalesOrders
LEFT OUTER JOIN m1_DC.dbo.organizationlocations ON ompshiporganizationid = cmlorganizationid
AND ompshiplocationid = cmllocationid
WHERE
m1_DC.dbo.SalesOrders.ompCustomerOrganizationID='$custid' and (ompOrderDate>=CONVERT(VARCHAR(10),DATEADD(day, -7, getdate()),110) or
convert(varchar(10),m1_DC.dbo.SalesOrders.ompRequestedShipDate,110) >=getdate())";
$result =odbc_exec($connect,$sql);
if(!$result){
exit("Error in SQL");
}
$data= '';
while (odbc_fetch_row($result)) {
$cmlName=odbc_result($result,"cmlName");
$ompCustomerPO=odbc_result($result,"ompCustomerPO");
$UOMPTOTALBOXCOUNT=odbc_result($result,"UOMPTOTALBOXCOUNT");
$UOMPVOLUMETOTAL=odbc_result($result,"UOMPVOLUMETOTAL");
$CMLADDRESSLINE1=odbc_result($result,"CMLADDRESSLINE1");
$CMLADDRESSLINE2=odbc_result($result,"CMLADDRESSLINE2");
$CMLCITY=odbc_result($result,"CMLCITY");
$CMLSTATE=odbc_result($result,"CMLSTATE");
$CMLPOSTCODE=odbc_result($result,"CMLPOSTCODE");
$ompSalesOrderID=odbc_result($result,"ompSalesOrderID");
$ompRequestedShipDate=odbc_result($result,"ShipDate");
$data .= "<td style='text-align:left' > $ompCustomerPO</td>";
$data .= "<td style='text-align:left'> $UOMPTOTALBOXCOUNT</td>";
$data .= "<td style='text-align:left'> $UOMPVOLUMETOTAL</td>";
$data .= "<td style='text-align:left'> $CMLADDRESSLINE1</td>";
$data .= "<td style='text-align:left'> $CMLADDRESSLINE2</td>";
$data .= "<td style='text-align:left'> $CMLCITY</td>";
$data .= "<td style='text-align:left'> $CMLSTATE</td>";
$data .= "<td style='text-align:left'> $CMLPOSTCODE</td>";
$data .= "<td style='text-align:left'> $ompSalesOrderID</td>";
$data .= "<td style='text-align:left'> $ompRequestedShipDate</td></tr>";
}
echo "<table><tr>";
echo "<th>PO</th>";
echo "<th>Box_count</th>";
echo "<th>Cubes</th>";
echo "<th>ADDRESSLINE</th>";
echo "<th>ADDRESS2</th>";
echo "<th>CITY</th>";
echo "<th>STATE</th>";
echo "<th>ZIP</th>";
echo "<th>Order_ID</th>";
echo "<th>Ship Date</th></tr>";
echo $data;
odbc_close($connect);
?>
</body>
</html>
Hey all I'm working on an auction website. I've added a new column to the 'Auctions' table, however the 'sell.php' page now does not work with this new column (I've deleted the column and tested again and it works, so that's definitely the cause). The new column can not be in a separate table as it needs to pull 'id' values from the 'Auctions' table for various functions. My question to you is, is there any PHP snippet I can use to tell sell.php to stop reading the 'Auctions' table once it reaches the column I've added? The new column is called 'shipped' if that's of any relevance. Below is some of the PHP I'm working on on the sell.php page. #//Populate arrays $UPLOADED_PICTURES[] = $file; $UPLOADED_PICTURES_SIZE[] = filesize($image_upload_path.session_id()."/".$file); } } } $_SESSION["UPLOADED_PICTURES"] = $UPLOADED_PICTURES; $_SESSION["UPLOADED_PICTURES_SIZE"] = $UPLOADED_PICTURES_SIZE; $_SESSION["GALLERY_UPDATED"]=true; if($sessionVars['SELL_action']=='edit') { $sessionVars["OLD_GALLERYFEE"] = $SETTINGS["picturesgalleryvalue"] * count($UPLOADED_PICTURES); } else { $sessionVars["OLD_GALLERYFEE"] = 0; } } } } $with_reserve = $sessionVars["SELL_with_reserve"]; $reserve_price = $sessionVars["SELL_reserve_price"]; $minimum_bid = $sessionVars["SELL_minimum_bid"]; $duration_hours = $sessionVars["SELL_duration_hours"]; $duration_minutes = $sessionVars["SELL_duration_minutes"]; $pict_url=$sessionVars["SELL_pict_url"]; $imgtype = $sessionVars["SELL_file_uploaded"]; $title = $sessionVars["SELL_title"]; $description = stripslashes($sessionVars["SELL_description"]); $pict_url = $sessionVars["SELL_pict_url"]; $atype = $sessionVars["SELL_atype"]; $adultonly = $sessionVars["SELL_adultonly"]; $TPL_item_value = $item_value = $sessionVars["SELL_item_value"]; $TPL_number_of_bids =$number_of_bids=$sessionVars["SELL_number_of_bids"]; $TPL_bid_value = $bid_value = $sessionVars["SELL_bid_value"]; $iquantity = $sessionVars["SELL_iquantity"]; $buy_now = $sessionVars["SELL_with_buy_now"]; $buy_now_price = $sessionVars["SELL_buy_now_price"]; $duration = $sessionVars["SELL_duration"]; $duration_second = $sessionVars["SELL_duration_second"]; $minimum_users = $sessionVars["SELL_minimum_users"]; $relist = $sessionVars["SELL_relist"]; $increments = $sessionVars["SELL_increments"]; $customincrement = $sessionVars["SELL_customincrement"]; $international = ($sessionVars["SELL_international"])?"on":""; $sellcat = $_SESSION['sellcat']; $private = $sessionVars["SELL_private"]; if($private != 'y') $private = 'n'; $sendemail = $sessionVars["SELL_sendemail"]; $txt = $sessionVars["SELL_txt"]; $num = $sessionVars["SELL_num"]; $buy_now_only = $sessionVars["SELL_buy_now_only"]; and... $auction_id=$sessionVars['SELL_auction_id']; } elseif ($sessionVars["SELL_action"] == "reopen") { $query = "UPDATE BPLA_auctions set title = '".addslashes($sessionVars["SELL_title"])."', starts = '".$a_starts."', starts_second = '".$a_starts_second."', description = '".addslashes($sessionVars["SELL_description"])."', pict_url = '".addslashes($sessionVars["SELL_pict_url"])."', category = ".$sessionVars["SELL_sellcat"].", minimum_bid = '".$sessionVars["SELL_minimum_bid"]."', reserve_price = '".(($sessionVars["SELL_with_reserve"]=="yes")?$sessionVars["SELL_reserve_price"]:"0")."', buy_now = '".(($sessionVars["SELL_with_buy_now"]=="yes")?$sessionVars["SELL_buy_now_price"]:"0")."', bn_only = '".$sessionVars["SELL_buy_now_only"]."', auction_type = '".$sessionVars["SELL_atype"]."', adultonly = '".$sessionVars["SELL_adultonly"]."', duration = '".$sessionVars["SELL_duration"]."', duration_second = '".$sessionVars["SELL_duration_second"]."', minimum_users = ".intval($sessionVars["SELL_minimum_users"]).", increment = ".doubleval($sessionVars["SELL_customincrement"]).", international = '".(($sessionVars["SELL_international"])?"1":"0")."', ends = '".$a_ends."', ends_second = '".$a_ends_second."', photo_uploaded = ".(($sessionVars["SELL_file_uploaded"])?"1":"0").", quantity = ".$sessionVars["SELL_iquantity"].", relist=".intval($sessionVars["SELL_relist"]).", relisted=0, closed='0', private='n', item_value = '".$sessionVars["SELL_item_value"]."', number_of_bids = '".$sessionVars["SELL_number_of_bids"]."', bid_value = '".$sessionVars["SELL_bid_value"]."', suspended='".$SUSPENDED."',"; $query .= "current_bid=0, num_bids=0, WHERE id = '".$sessionVars["SELL_auction_id"]."'"; $backtoclosed=true; if($BPLowbidAuction_TESTMODE == 'yes'){ echo $ERR = $ERR_9999; }else{ $res=mysql_query($query); if (!$res) { MySQLError($query); exit; } $auction_id=$sessionVars['SELL_auction_id']; $sessionVars["SELL_auction_id_old"]=$auction_id; $query = "DELETE FROM BPLA_bids WHERE auction='$auction_id'"; $res = @mysql_query($query); if(!$res) { MySQLError($query); exit; } Thanks in advance for any help and replies! So I have a jobs database with the following columns: id, jobtext, jobdate, and id. This is how it looks right now: http://prahan.com/jobs/display.html.php I have another table called author. In the authorid column in need the results of this query, SELECT name FROM author WHERE id = (SELECT authorid FROM job) , to be displayed for each row. I also want to be able to customize the header title for each column. Thanks in advance! I am creating a stream page that updates automatically without the page reloading by reloading a div on the page using a timer. However, I only want it to run the update and fade in/fade out when there is a new status in the table. I tried doing it through PHP getting the number of rows in the table on the page itself and then checking the number of rows on an action page, however, the number of rows didnt update when the div was reloaded. I then tried doing it using jquery/javscript but had the same problem. How can I acheive this? Thanks in advance Quesion: Show each movie in the database on its own page, and give the user links in a "page 1, Page 2, Page 3" - type navigation system. Hint: Use LIMIT to control which movie is on which page. I have provided 3 files: 1st: configure DB, 2nd: insert data, 3rd: my code for the question. I would appreciate the help. I am a noob by the way. First set up everything for DB: <?php //connect to MySQL $db = mysql_connect('localhost', 'root', '000') or die ('Unable to connect. Check your connection parameters.'); //create the main database if it doesn't already exist $query = 'CREATE DATABASE IF NOT EXISTS moviesite'; mysql_query($query, $db) or die(mysql_error($db)); //make sure our recently created database is the active one mysql_select_db('moviesite', $db) or die(mysql_error($db)); //create the movie table $query = 'CREATE TABLE movie ( movie_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, movie_name VARCHAR(255) NOT NULL, movie_type TINYINT NOT NULL DEFAULT 0, movie_year SMALLINT UNSIGNED NOT NULL DEFAULT 0, movie_leadactor INTEGER UNSIGNED NOT NULL DEFAULT 0, movie_director INTEGER UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (movie_id), KEY movie_type (movie_type, movie_year) ) ENGINE=MyISAM'; mysql_query($query, $db) or die (mysql_error($db)); //create the movietype table $query = 'CREATE TABLE movietype ( movietype_id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT, movietype_label VARCHAR(100) NOT NULL, PRIMARY KEY (movietype_id) ) ENGINE=MyISAM'; mysql_query($query, $db) or die(mysql_error($db)); //create the people table $query = 'CREATE TABLE people ( people_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, people_fullname VARCHAR(255) NOT NULL, people_isactor TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (people_id) ) ENGINE=MyISAM'; mysql_query($query, $db) or die(mysql_error($db)); echo 'Movie database successfully created!'; ?> ******************************************************************** *********************************************************************** second file to load info into DB: <?php // connect to MySQL $db = mysql_connect('localhost', 'root', '000') or die ('Unable to connect. Check your connection parameters.'); //make sure you're using the correct database mysql_select_db('moviesite', $db) or die(mysql_error($db)); // insert data into the movie table $query = 'INSERT INTO movie (movie_id, movie_name, movie_type, movie_year, movie_leadactor, movie_director) VALUES (1, "Bruce Almighty", 5, 2003, 1, 2), (2, "Office Space", 5, 1999, 5, 6), (3, "Grand Canyon", 2, 1991, 4, 3)'; mysql_query($query, $db) or die(mysql_error($db)); // insert data into the movietype table $query = 'INSERT INTO movietype (movietype_id, movietype_label) VALUES (1,"Sci Fi"), (2, "Drama"), (3, "Adventure"), (4, "War"), (5, "Comedy"), (6, "Horror"), (7, "Action"), (8, "Kids")'; mysql_query($query, $db) or die(mysql_error($db)); // insert data into the people table $query = 'INSERT INTO people (people_id, people_fullname, people_isactor, people_isdirector) VALUES (1, "Jim Carrey", 1, 0), (2, "Tom Shadyac", 0, 1), (3, "Lawrence Kasdan", 0, 1), (4, "Kevin Kline", 1, 0), (5, "Ron Livingston", 1, 0), (6, "Mike Judge", 0, 1)'; mysql_query($query, $db) or die(mysql_error($db)); echo 'Data inserted successfully!'; ?> ************************************************************** **************************************************************** MY CODE FOR THE QUESTION: <?php $db = mysql_connect('localhost', 'root', '000') or die ('Unable to connect. Check your connection parameters.'); mysql_select_db('moviesite', $db) or die(mysql_error($db)); //get our starting point for the query from the URL if (isset($_GET['offset'])) { $offset = $_GET['offset']; } else { $offset = 0; } //get the movie $query = 'SELECT movie_name, movie_year FROM movie ORDER BY movie_name LIMIT ' . $offset . ' , 1'; $result = mysql_query($query, $db) or die(mysql_error($db)); $row = mysql_fetch_assoc($result); ?> <html> <head> <title><?php echo $row['movie_name']; ?></title> </head> <body> <table border = "1"> <tr> <th>Movie Name</th> <th>Year</th> </tr><tr> <td><?php echo $row['movie_name']; ?></td> <td><?php echo $row['movie_year']; ?></td> </tr> </table> <p> <a href="page.php?offset=0">Page 1</a>, <a href="page.php?offset=1">Page 2</a>, <a href="page.php?offset=2">Page 3</a> </p> </body> </html> I want to show a cookie of a referral's username on a sign up page. The link is like this, www.mysite.com/signup?ref=johnsmith. The cookie doesn't show if I go to that url page. But it does show up once I reload the page. So I'm wondering if it's possible to show the cookie the first time around, instead of reloading the page? Here is my code.
// This is in the header
$url_ref_name = (!empty($_GET['ref']) ? $_GET['ref'] : null);
if(!empty($url_ref_name)) {
$number_of_days = 365;
$date_of_expiry = time() + 60 * 60 * 24 * $number_of_days;
setcookie( "ref", $url_ref_name, $date_of_expiry,"/");
} else if(empty($url_ref_name)) {
if(isset($_COOKIE['ref'])) {
$user_cookie = $_COOKIE['ref'];
}
} else {}
// This is for the sign up form
if(isset($_COOKIE['ref'])) {
$user_cookie = $_COOKIE['ref'];
?>
<fieldset>
<label>Referred By</label>
<div id="ref-one"><span><?php if(!empty($user_cookie)){echo $user_cookie;} ?></span></div>
<input type="hidden" name="ref" value="<?php if(!empty($user_cookie)){echo $user_cookie;} ?>" maxlength="20" placeholder="Referrer's username" readonly onfocus="this.removeAttribute('readonly');" />
</fieldset>
<?php
}
Can someoneplease help, I need to setup an error page like IF Username and Password are wrong then show an error also if there is no username or password in the fields and I just click LOGIN, I get a blank page?! Can someone please help me here or point me to a relevant tutorial? thanks here is my page: http://www.retroandvintage.co.uk/default.php here is my code: Code: [Select] <?php session_start(); include_once("config.php"); $ebits = ini_get('error_reporting'); error_reporting($ebits ^ E_NOTICE); /* Login script: This script does the following: Checks that the user is NOT already logged in - if they are they are redirected to the members page by the 'checkLoggedIn()' function. Checks if the login form has been submitted - if so, the 'login' and 'password' fields are checked to ensure they are of the correct format and length. If there are any problems here an error is added to the $messages array and then the script executes the 'doIndex()' function - this function basically outputs the main 'index' page for this script - ie the login form. If there are no problems with the previous step, the 'login' and 'password' field data is passed to the 'checkPass' function to check that an entry exists in the 'users' table for that login/password pair. If nothing is returned from the 'checkPass()' function, an error is added to the $messages array and the 'doIndex()' function is called as above. If a row of data is returned from the 'users' table, the data is passed to the 'cleanMemberSession()' function - which initializes session variables and logs the user in. The user is then forwarded to the members page. If the form hasn't yet been submitted, then the 'doIndex()' function is called and the login page is displayed. */ // Check user not logged in already: checkLoggedIn("no"); // Page title: $title="Member Login Page"; // if $submit variable set, login info submitted: if(isset($_POST["submit"])) { // // Check fields were filled in // // login must be between 4 and 15 chars containing alphanumeric chars only: field_validator("rsUser", $_POST["rsUser"], "alphanumeric", 4, 15); // password must be between 4 and 15 chars - any characters can be used: field_validator("rsPass", $_POST["rsPass"], "string", 4, 15); // if there are $messages, errors were found in validating form data // show the index page (where the messages will be displayed): if($messages){ doIndex(); // note we have to explicity 'exit' from the script, otherwise // the lines below will be processed: exit; } // OK if we got this far the form field data was of the right format; // now check the user/pass pair match those stored in the db: /* If checkPass() is successful (ie the login and password are ok), then $row contains an array of data containing the login name and password of the user. If checkPass() is unsuccessful however, $row will simply contain the value 'false' - and so in that case an error message is stored in the $messages array which will be displayed to the user. */ if( !($row = checkPass($_POST["rsUser"], $_POST["rsPass"])) ) { // login/passwd string not correct, create an error message: $messages[]="Incorrect login/password, try again"; } /* If there are error $messages, errors were found in validating form data above. Call the 'doIndex()' function (which displays the login form) and exit. */ if($messages){ doIndex(); exit; } /* If we got to this point, there were no errors - start a session using the info returned from the db: */ cleanMemberSession($row["rsUser"], $row["rsPass"]); // and finally forward user to members page (populating the session id in the URL): header("Location: main.php"); } else { // The login form wasn't filled out yet, display the login form for the user to fill in: doIndex(); } /* This function displays the default 'index' page for this script. This consists of just a simple login form for the user to submit their username and password. */ function doIndex() { /* Import the global $messages array. If any errors were detected above, they will be stored in the $messages array: */ global $messages; /* also import the $title for the page - note you can normally just declare all globals on one line - ie: global $messages, $title; */ global $title; } // drop out of PHP mode to display the plain HTML: ?> <!doctype html> <html> <head> <title>List of Pubs and Bars in the UK</title> <meta name="description" content="Pubs and bars in the UK, nightlife for food and drink" /> <meta name="keywords" content="Pubs, bars, List, uk, nightlife, drinking, drinks, beer, lager, food" /> <meta name="Content-Language" content="en-gb" /> <meta name="robots" content="FOLLOW,INDEX" /> <meta name="revisit-after" content="2 days" /> <meta name="copyright" content="jbiddulph.com" /> <meta name="author" content="John Biddulph - Professional web site design and development in the south of england mainly worthing and brighton" /> <meta name="distribution" content="Global" /> <meta name="resource-type" content="document" /> <link rel="stylesheet" type="text/css" href="css/reset.css" /> <link rel="stylesheet" type="text/css" href="css/ui-lightness/jquery-ui-1.8.6.custom.css" title="default" /> <link rel="alternate stylesheet" type="text/css" href="css/south-street/jquery-ui-1.8.6.custom.css" title="1" /> <link rel="alternate stylesheet" type="text/css" href="css/redmond/jquery-ui-1.8.6.custom.css" title="2" /> <script type="text/javascript" src="js/stylechanger.js"></script> <script type="text/javascript" src="js/jquery-1.4.2.min.js"></script> <script type="text/javascript" src="js/jquery-ui-1.8.6.custom.min.js"></script> <script type="text/javascript"> $(function(){ // Accordion $("#accordion").accordion({ header: "h3" }); // Tabs $('#tabs').tabs(); // Dialog $('#dialog').dialog({ autoOpen: false, width: 600, buttons: { "Ok": function() { $(this).dialog("close"); }, "Cancel": function() { $(this).dialog("close"); } } }); // Dialog Link $('#dialog_link').click(function(){ $('#dialog').dialog('open'); return false; }); // Datepicker $('#datepicker').datepicker({ inline: true }); //hover states on the static widgets $('#dialog_link, ul#icons li').hover( function() { $(this).addClass('ui-state-hover'); }, function() { $(this).removeClass('ui-state-hover'); } ); }); </script> <script type="text/javascript"> function lookup(inputString) { if(inputString.length == 0) { // Hide the suggestion box. $('#suggestions').hide(); } else { $.post("rpc.php", {queryString: ""+inputString+""}, function(data){ if(data.length >0) { $('#suggestions').show(); $('#autoSuggestionsList').html(data); } }); } } // lookup function fill(thisValue) { $('#inputString').val(thisValue); setTimeout("$('#suggestions').hide();", 200); } </script> </head> <body> <?php if($messages) { displayErrors($messages); }?> <header> <div id="title"> <h1>My Pub Space <a href="#" onClick="setActiveStyleSheet('default'); return false;"><img src="images/0.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('1'); return false;"><img src="images/1.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('2'); return false;"><img src="images/2.gif" width="15" height="15" border="0" alt="css style" /></a> <span> <form method="post" class="textbox" action="search.php"> Town/City: <input type="text" size="26" class="searchbox" value="" name="rsTown" id="inputString" onKeyUp="lookup(this.value);" onBlur="fill();" /> <div class="suggestionsBox" id="suggestions" style="display: none;"> <img src="images/upArrow.png" style="position: relative; top: -36px; left: 105px; z-index:1;" alt="upArrow" /> <div class="suggestionList" id="autoSuggestionsList"> </div> </div> <input type="image" src="images/go.png" height="30" with="30" value="GO" /> </form> </span> </h1> </div> </header> <nav> <ul> <li class="selected"><a href="default.php">Home</a></li> <li><a href="#">Pubs</a></li> <li><a href="#">Members</a></li> <li><a href="#">Events</a></li> <li><a href="register.php">Register</a></li> </ul> </nav> <section id="intro"> <header> <h2>Your social guide to going down the pub, online!</h2> </header> <p>Stuck in town with nowhere to go? Not sure if up the road or down the street is best? Need to be somewhere warm, cosy and friendly. Need a drink?....<br />You've come to the right place, mypubspace has it all!</p> <img src="images/pub.jpg" alt="pub" /> </section> <div id="content"> <div id="mainContent"> <section> <article class="blogPost"> <header> <h2>Pubs and Bars UK Listing</h2> </header> <?php $tableName="pubs"; $targetpage = "default.php"; $limit = 20; $query = "SELECT COUNT(*) as num FROM $tableName"; $total_pages = mysql_fetch_array(mysql_query($query)); $total_pages = $total_pages['num']; $stages = 3; $page = mysql_escape_string($_REQUEST['page']); if( isset($_REQUEST['page']) && ctype_digit($_REQUEST['page']) ) { $page = (int) $_GET['page']; $start = ($page - 1) * $limit; }else{ $start = 0; } // Get page data $query1 = "SELECT * FROM $tableName LIMIT $start, $limit"; $result = mysql_query($query1); // Initial page num setup if ($page == 0){$page = 1;} $prev = $page - 1; $next = $page + 1; $lastpage = ceil($total_pages/$limit); $LastPagem1 = $lastpage - 1; $paginate = ''; if($lastpage > 1) { $paginate .= "<div class='paginate'>"; // Previous if ($page > 1){ $paginate.= "<a href='$targetpage?page=$prev'>previous</a>"; }else{ $paginate.= "<span class='disabled'>previous</span>"; } // Pages if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";} } } elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few? { // Beginning only hide later pages if($page < 1 + ($stages * 2)) { for ($counter = 1; $counter < 4 + ($stages * 2); $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";} } $paginate.= "..."; $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>"; $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>"; } // Middle hide some front and some back elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2)) { $paginate.= "<a href='$targetpage?page=1'>1</a>"; $paginate.= "<a href='$targetpage?page=2'>2</a>"; $paginate.= "..."; for ($counter = $page - $stages; $counter <= $page + $stages; $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";} } $paginate.= "..."; $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>"; $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>"; } // End only hide early pages else { $paginate.= "<a href='$targetpage?page=1'>1</a>"; $paginate.= "<a href='$targetpage?page=2'>2</a>"; $paginate.= "..."; for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";} } } } // Next if ($page < $counter - 1){ $paginate.= "<a href='$targetpage?page=$next'>next</a>"; }else{ $paginate.= "<span class='disabled'>next</span>"; } $paginate.= "</div>"; } echo $total_pages.' Results'; // pagination echo $paginate; ?> <div id="accordion"> <?php while($row = mysql_fetch_array($result)) { echo '<div><h3><a href=\"#\">'.$row['rsPubName'].'</a></h3><div>'.$row['rsAddress'].'<br />'.$row['rsTown'].', '.$row['rsCounty'].'<br />'.$row['rsPostCode'].'<br /><br />Region: '.$row['Region'].'<br /><br />Telephone: '.$row['rsTel'].'</div></div>'; } ?> </div> </article> </section> </div> <aside> <section> <header> <h3>Members Login Area</h3> </header> <form method="post" class="textbox" action="<?php print $_SERVER["PHP_SELF"]; ?>"> Username: <br /> <input type="text" class="textbox" name="rsUser" value="<?php print isset($_POST["rsUser"]) ? $_POST["rsUser"] : "" ; ?>"> Password: <br /> <input type="password" class="textbox" name="rsPass"> <br /> <br /> <input name="submit" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-text-only" type="submit" value="Login"> <br /> </form> <ul> <li><button id="button" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-text-only" role="button" aria-disabled="false"><span class="ui-button-text"><a href="register.php">Sign up</a></span></button></li> <li><button id="button" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-text-only" role="button" aria-disabled="false"><span class="ui-button-text"><a href="forgot.php">Forgot Password</a></span></button></li> </ul> </section> <section> <header> <h3>Quick Search</h3> </header> <ul> <li><a href="#">Coming Soon!</a></li> </ul> </section> </aside> </div> <footer> <div> <section id="about"> <header> <h3>About</h3> </header> <p>My Pub Space is one of the largest and newest UK Pubs and Bars Listing sites online. It is not just a list of pubs, we have added a touch of interactive social pubbing experience online! Once registered, you can view information on pubs in your area, write reviews, organise your evenings out!</p> </section> <section id="blogroll"> <header> <h3>Links</h3> </header> <ul> <li><a href="#">Coming Soon!</a></li> </ul> </section> <section id="popular"> <header> <h3>Popular</h3> </header> <ul> <li><a href="#">Coming Soon!</a></li> </ul> </section> </div> </footer> </body> </html> Hi, I would like to do the following but not sure how. If the you/user is on index.php of http://www.domain.com/ show one page If not show another How would I do this? Thanks okay so for my final project for my php class we have to build a video management system. I've got video upload, viewing, and user registration working, and the videos display themselves in my playlist using this code posted below. What I want to do is add a hyperlink above the code that when clicked by the user can sort the videos by a column in my mysql database and then display them in the format shown below (sort by views, or data posted, or alphabetically by title) Code: [Select] <div id="videoList"> <?php require_once('config.php'); $con = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db(DB_DATABASE, $con); $result = mysql_query("SELECT * FROM video_list"); while($row = mysql_fetch_array($result)) { echo "<div title=\"<b>title: </b>" . $row['title'] . "<br />"; echo "<b>user: </b>" . $row['username'] . "\">"; echo "<p title=\"description\"><span class=\""title\">" . $row['title'] . "</span><br/>"; echo "<br/>" . $row['info'] . "<br/>"; echo "<br/><a href=\"users/" . $row['username'] . "\" target=\""_blank\">visit my page</a></p>"; echo "<ul title=\"preview\"><li title=\"video/preview/" . $row['ogv_preview'] . "\">video/ogg</li>"; echo "<li title=\"video/preview/" . $row['mp4_preview'] . "\">video/mp4</li></ul>"; echo "<ul title=\"main\"><li title=\"video/main/" . $row['ogv_filename'] . "\">video/ogg</li>"; echo "<li title=\"main/preview/" . $row['mp4_filename'] . "\">video/mp4</li></ul>"; echo "<ul title=\"thumb\"><li title=\"video/thumb/" . $row['thumb'] . "\"></li></ul>"; echo "<ul title=\"poster\"><li title=\"video/poster/" . $row['poster'] . "\"></li></ul></div>"; } mysql_close($con); ?> </div> this generates a piece of html code that looks like this. 1 block of code for each video in the mysql database. i just need to be able to sort this code, can anyone help me out?? THANKS! Code: [Select] <div title="<b>title: </b>funny video<br /> <b>user: ijmcg</b>"> <p title="description"> <span class=""title">funny video</span><br/><br/>blah blah blah blah<br/><br/> <a href="users/ijmcg" target=""_blank">visit my page</a> </p><ul title="preview"> <li title="video/preview/01.ogv">video/ogg</li> <li title="video/preview/01.mp4">video/mp4</li></ul> <ul title="main"><li title="video/main/01.ogv">video/ogg</li> <li title="main/preview/01.mp4">video/mp4</li></ul> <ul title="thumb"><li title="video/thumb/01.jpg"></li></ul> <ul title="poster"><li title="video/poster/01.jpg"></li></ul> </div> Hi all, I'm just wondering what the best solution to my current problem would be. Ive created a website where users can upload photos to a database, the photos are then shown in the admin section as a list. My DB structure is as such.. PHOTO SRC THEME 1.jpg images/1.jpg 1 2.jpg images/2.jpg 0 3.jpg images/3.jpg 0 4.jpg images/4.jpg 1 This is then reflected in the admin page, I need a button which will alter all photo's with the theme '1' and change them to '0', like a reconcile button, is this possible? How would you go about it? Thanks everyone This topic has been moved to JavaScript Help. http://www.phpfreaks.com/forums/index.php?topic=347058.0 Hi guys, I have page where it echos out the image url from mysql in a MAMP Server, however when i echo the image url out it seems to be fine but as soon as i put in a img scr it wont show the image but it shows the container. I have the code here Code: [Select] <div id="maincontentholderbottom"> <div id="maincontentholderbottom-index-left"> <div id="news-container"><ul> <?php $select=mysql_query("SELECT * FROM news"); while($get_news=mysql_fetch_array($select)){ $newsid=$get_news['id']; $title=$get_news['title']; $text=$get_news['text']; $newsdate=$get_news['date']; $newstime=$get_news['time']; $imagelink=$get_news['newsimagelink']; $newstext=substr($text, 0, 420); echo"<li><div id='title'>$title</div><div id='newsblock'>$newstext... <a href='http://localhost/mycomputer/create/news/index.php?id=$newsid'>Read More</a></div> <div id='newsimage'><img src='$imagelink' width='150' height='70'/></div> </li>"; } ?> </ul> </div> </div> </div> Do u know why is it like this? I appreciate your help in advance. Thanks! Hi all I have created a mySQL query and assigned it to a string: Code: [Select] $getjobs = mysql_query (" SELECT * FROM jobs WHERE from_date >= '".substr($newdate, 0, 10)."' $keyword_search $sector_search $salary_search $location_search $type_search ORDER BY job_refno DESC ") or die (mysql_error()); Is there any way to output the actual query to the browser to check it? |
|||||||