Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF, 078274121, info0a ip, should prodicers of software_based services be held liable or not liable for economic injuries

Links

XODOX
Impressum

#1: database query advise

Posted on 2011-04-05 21:18:03 by Chris Stinemetz

Hello All,

I am fairly new to the PHP and MySQL world and I was wondering if you
could offer some advise or tutorials that may help me achieve my
objectives.

My code is pasted on the far bottom.

I currently have a form page and results page.
The first thing I would like to do is combine the form page with the
results so that a new page isn't opened when the end user hits the
submit.
The second is how do I change my javascript form script so that the
second and third menu is hidden until the prior menu is selected.
The third is: How can I use PHP ternary instead of my current if else
on the form page?
The fourth is: How can I alter my results page so that the records can
me edited. For example once the query is submitted and the results are
displayed. I would like to edit any field in any record and submit the
changes back to the database. Is this possible??

Thank you in advance!

Chris

form page below:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<?php
require "../PHP_Scripts/config.php"; // Your Database details
?>
<head>
<title>KCRF Dashboard</title>
<meta http-equiv="content-type" content="application/xhtml+xml;
charset=utf-8" />

<link rel="stylesheet" type="text/css" href="../css/style.css" />
<script type='text/javascript' src='../js/jquery-1.2.3.js'></script>
<script type='text/javascript' src='../js/menu.js'></script>



</head>
<body>
<div id="boundary">
<h1>type something</h1>
<ul id="nav">
<li><a href="#">Home</a></li>
<li><a href="#">EVDO PCMD</a></li>
<li><a href="#">Voice PCMD </a>
<ul>
<li><a href="#">3.1 jQuery</a>
<ul>
<li><a href="#">3.1.1 Download</a></li>
<li><a href="#">3.1.2 Tutorial</a></li>
</ul>
</li>
<li><a href="#">3.2 Mootools</a></li>
<li><a href="#">3.3 Prototype</a></li>
</ul>
</li>
</ul>
<div id="content">
</div>
</div>
<p id="footer">type something</a>, type something</a></p>


<SCRIPT language=JavaScript>
function reload(form)
{
var val=form.term.options[form.term.options.selectedIndex].value ;
self.location='kpiForm.php?term=' + val ;
}
function reload2(form)
{
var val=form.term.options[form.term.options.selectedIndex].value ;
var val2=form.term2.options[form.term2.options.selectedIndex].va lue;
self.location='kpiForm.php?term=' + val + '&term3=' + val2 ;
}
</script>

<?PHP
///////// Getting the data from Mysql table for first list box//////////
$market=mysql_query("SELECT DISTINCT market FROM sector_list ORDER BY
market DESC");

/////// for second drop down list we will check if market is selected
else we will display all the cell_sectors/////
$term=$_GET['term']; // This line is added to take care if your global
variable is off
if(isset($term) and strlen($term) > 0)
{
$cellSect=mysql_query("SELECT DISTINCT cell_sect FROM sector_list
where market like '%$term' order by cell_sect");
}
else
{
$cellSect=mysql_query("SELECT DISTINCT cell_sect FROM sector_list
order by cell_sect"); }
////////// end of query for second subcategory drop down list box
///////////////////////////


$term3=$_GET['term']; // This line is added to take care if your
global variable is off
/////// for Third drop down list we will check if cell_sect is
selected else we will display all the dates/////
if(isset($term3) and strlen($term3) > 0)
{
$date=mysql_query("SELECT DISTINCT date FROM evdo WHERE market LIKE
'%$term' ORDER BY date DESC");
}
else
{
$date=mysql_query("SELECT DISTINCT date FROM evdo ORDER BY date");
}
////////// end of query for third subcategory drop down list box
///////////////////////////

echo "<form method=post name=f1 action='PHP_Scripts/search.php'>";

////////// Starting of first drop downlist /////////
echo "<select name='term' onchange=\"reload(this.form)\">
<option value=''>Market</option>";
while($menu1 = mysql_fetch_array($market))
{
if($menu1['market']==@$term)
{
echo "<option selected value='$menu1[market]'>$menu1[market]</option>"."<BR>";
}
else
{
echo "<option value='$menu1[market]'>$menu1[market]</option>";
}
}
echo "</select>";

////////// Starting of second drop downlist /////////
echo "<select name='term2' onchange=\"reload2(this.form)\">
<option value=''>Cell_Sector</option>";
while($menu2= mysql_fetch_array($cellSect))
{
if($menu2['cell_sect']==@$term2)
{
echo "<option selected
value='$menu2[cell_sect]'>$menu2[cell_sect]</option>"."<BR>";
}
else
{
echo "<option value='$menu2[cell_sect]'>$menu2[cell_sect]</option>";
}
}
echo "</select>";

////////// Starting of third drop downlist /////////
echo "<select name='term3'>
<option value=''>Timestamp</option>";
while($menu3 = mysql_fetch_array($date))
{
if($menu3['date']==@$term3)
{
echo "<option selected value='$menu3[date]'>$menu3[data]</option>"."<BR>";
}
else
{
echo "<option value='$menu3[date]'>$menu3[date]</option>";
}
}
echo "</select>";
////////////////// This will end the third drop down list ///////////

echo "<input type=submit value='Submit'></form>";
?>

</body>

</html>

results page below:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<?php
require ("config.php"); // Your Database details
?>

<head>
<title>PCMD KPI</title>
<style type="text/css" >
TABLE {
margin-left: auto;
margin-right: auto;
border: 1px solid #98bf21;
border-collapse:collapse;
}

TH {
border: 1.5px solid #000000;
padding-bottom: 2px;
padding-left: 7px:
padding-right: 7px;
padding-top: 2px;
font-size: 1.0em;
background-color:limegreen;
color: white;
text-align: center;
}

TD {
border: 1px solid #98bf21;
padding-bottom: 2px;
padding-left: 7px:
padding-right: 7px;
padding-top: 2px;
font-size: 1.0em;
text-align: center;

}

TR.alt TD {
background-color: #eaf2d3;
text-align: center;
}
#navbar ul {
margin: 0;
padding: 5px;
list-style-type: none;
text-align: center;
background-color: #000;
}

#navbar ul li {
display: inline;
}

#navbar ul li a {
text-decoration: none;
padding: .2em 1em;
color: #fff;
background-color: #000;
}

#navbar ul li a:hover {
color: #000;
background-color: #fff;
}

-->
</style>
</head>
<fieldset style="border: 1px ridge limegreen; color: limegreen;">
<legend style="color: #000; font-family: verdana; font-size:
14pt;">PCMD KPI</legend>
<body>
<div id="navbar">
<ul>
<li><a href="/php/drop_down/index.php">Home</a></li>
<li><a href="/php/drop_down/dd3.php">PCMD KPI</a></li>
<li><a href="/php/drop_down/banding.php">EVDO Distance
Banding</a></li>
<li><a href="#">LinkHere</a></li>
<li><a href="#">LinkHere</a></li>
</ul>
</div>
</fieldset>

<?php
$term=$_POST['term'];
$term2=$_POST['term2'];
$term3=$_POST['term3'];

# your orignal that just pulls the market data
#$result = mysql_query("select * FROM evdo WHERE Market like '%$term'
LIMIT 20");

#this pulls the cell_sect assigned to market
$result = mysql_query("select * FROM evdo WHERE Market like '%$term'
and Cell_Sect = '$term2' ORDER BY date desc LIMIT 96");

#This pulls the cell_sect on given date and market
#$result = mysql_query("select * FROM evdo WHERE Market like '%$term'
and Cell_Sect = '$term2' and Date = '$term3'");

# you need to modify the first page to autopopulate the cell_sect and
date option boxes
# so it only list the cells applicable to a market on a given day

$firstRow=1;
$rowNum = 0;
echo "<table>";
while($row = mysql_fetch_assoc($result)) {
if($firstRow == 1) {
echo "<tr>";

foreach($row as $key => $value) {
echo "<th>" . $key . "</th>";
}
echo "</tr><tr>";
$firstRow=0;
$rowNum++;
}
else {
if( ($rowNum++ % 2) == 1) {
echo "<tr class=\"alt\">";
} else {
echo "<tr>";
}
}
foreach($row as $key => $value ) {
echo "<td>" . $value . "</td>" ;
}
echo "</tr>";
}
echo "</table>";

echo "You Selected the following:<br>Market = $term <br>Cell_Secter =
$term2<br>Timestamp = $term3";


?>


</body>

</html>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Report this message