Google
  Web www.spinics.net

database query advise

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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].value;
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



[PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Plagiarism Notes]     [Postgresql]     [Yosemite News]

Powered by Linux