PHP - Create A Menu And Select Details For Each Link

Hi. I will try and explain simply.   I have a list of item codes eg.  size1 Acolor1 size1 Bcolor3 size1 Bcolor1 size1 Acolor3 size1 Acolor4 size2 Acolor1 size3 Bcolor1 size3 Bcolor2 size3 Bcolor2 size3 Acolor1   I want to take these and split them into parts:   size1 Acolor2 size1 Bcolor3 etc.   Then I want to create a form with 2 dropdowns. The first option would just have all unique sizes so: size1 size2 size3   Then when one is selected, option 2 would show the colours available in that size.   Is there a standard way of doing this? Can I use PHP to create the array and then jquery to display and hide the options?   I'm totally stuck and i'm not just looking for somebody to code it all for me. any help would be greatly appreciated   thanks Sam

Hi all

I haven't used PHP for a while so I'm stuck on something that seems simple.

I have a list of nav links created in a while loop, I want to add an id="selected" to the <a> link that is selected.

I can check that it's selected with

Code: [Select]
if( $row[1] == $pageName['words']){
     id=''selected"
}

How can I use this to set the id

[code]
<ul>
         <?php
             while($row = mysql_fetch_array($result1)){ 
                //if($row[1] != $pageName['words']){// this will take out the gallery that is showing form the list
                   ?>
                  <li><a href="gallery.php?photo_id=<?php echo $row[0]?>" id=""><?php echo $row[1];?></a></li>
            <?php            
                //}
             }
          ?>
       </ul>
[/code]

Hi I have tried the mysql forum but have had no joy with an answer to my problem so wondered if php would be better.

I want my users to be able to select from 5 different drop down lists where they can chose any combination from 1 up to all 5,  I have attached the front end.  These lists are being populated from mysql tables.

Code for the drop down lists is as follows
Code: [Select]
  <form action="horse-events-devon.php?url_countyid=<?php echo  urlencode ($url_countyid ['url_countyid'])  ; ?>&go" method="POST">
    <table id="searchtable">
      <tr>
        <th>Find By Discipline</th>
        <th>Find By Venue</th>
        <th>Find By Championship</th>
        <th>Find By Organiser</th>
        <th>Equine Association</th>
        <th>Submit Your Selections</th>
        </tr>
      <tr>
        <td><select name="dis_id">
                                    <?php 
                                        $upcomingdis = upcomingdis($url_countyid);
                                        $upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_dis_bycounty ['dis_id']; ?>" >
<?php echo $upcoming_dis_bycounty ['dis_description']; ?></option>
<?php 
                                    } while ($upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis)); 
                                    ?></select></td>
        <td><select name="ven_id">
                                    <?php 
                                        $upvenbycounty_set = upcoming_venevents_bycounty($url_countyid);
                                        $upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_ven_bycounty ['ven_id']; ?>" >
<?php echo $upcoming_ven_bycounty ['ven_name']; ?></option>
<?php 
                                    } while ($upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set)); 
                                    ?></select></td>
        <td><select name="champ_id">
                                    <?php 
                                        $championship_set = findchampionships();
                                        $champlist = mysql_fetch_assoc ($championship_set);
                                    ?>
                                    <?php 
do { 
?>   <option value="<?php echo $champlist ['champ_id']; ?>" >
<?php echo $champlist ['champ_description']; ?></option>
<?php 
} while ($champlist = mysql_fetch_assoc ($championship_set)); 
?></select></td>
        <td>
        <select name="org_id">
                        <?php 
                            $uporgbycounty_set = upcoming_organevents_bycounty($url_countyid);
                            $upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set);
                        ?>
                        <?php 
                        do { 
                        ?>   <option value="<?php echo $upcoming_org_bycounty ['org_id']; ?>" ><?php echo $upcoming_org_bycounty ['org_name']; ?></option>
                        <?php 
                        } while ($upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set)); 
                        ?></select>
       
        </td>
        <td><select name="ass_id">
                                    <?php
                                        $upassbycounty_set = upcoming_assevents_bycounty($url_countyid);
                                        $upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
                                    ?>   <option value="<?php echo $upcoming_assbycounty ['ass_id']; ?>" >
<?php echo $upcoming_assbycounty ['ass_description']; ?></option>
                                    <?php 
                                    } while ($upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set)); 
                                    ?></select></td>
      <td><input name="submit" type="submit" /><input name="countyid" type="hidden" value="<?php echo $url_countyid ['url_countyid']; ?>" /></td>
        </tr>
      </table>
  </form>
My search processing is as follows

Code: [Select]
  <?php
if (isset($_POST['submit'])){
if (isset($_GET['go'])){
$countyid = $_POST['countyid'];
$ven_id = $_POST['ven_id'];
$dis_id = $_POST['dis_id'];
$champ_id = $_POST['champ_id'];
$org_id = $_POST['org_id'];
$event_id = $row['event_id'];

$sql = "SELECT DATE_FORMAT (events.startdate, '%a, %d, %b') 
   AS stdate, events.event_id, events.title, events.ven_id, events.org_id,
   venue.county_id, venue.ven_id, eventdisciplines.event_id, eventdisciplines.dis_id, county.county_id, discipline.dis_id \n"
. "FROM events \n"
. "LEFT OUTER JOIN eventdisciplines \n"
. "ON events.event_id = eventdisciplines.event_id \n"
. "LEFT OUTER JOIN discipline \n"
. "ON eventdisciplines.dis_id = discipline.dis_id \n"
. "LEFT OUTER JOIN venue \n"
. "ON events.ven_id = venue.ven_id \n"
. "LEFT OUTER JOIN county \n"
. "ON venue.county_id = county.county_id \n"
. "WHERE events.ven_id = ({$ven_id} OR events.org_id = {$org_id})\n"
. "AND events.startdate > NOW()\n"
. "AND venue.county_id = {$countyid}  \n"
. "ORDER BY startdate ASC";

$result = mysql_query ($sql, $connection);
?>
How am I best to do this please?  my OR within the mysql does not work, should I not be doing this with php in the search processing?  someones help would really be appreciated, just to point me in the right direction.

[attachment deleted by admin]

Hey guys,

Currently Im using the code:

while($row=mysql_fetch_array($nt)){

echo"
$row[user_login],$row[user_email],$row[CallHistoryTimes],$row[CallHistoryInfo],$row[CallHistoryLastOp]$row[CallHistoryLastDate],<br>";
}

To list a mysql array; what I am trying to do is to use the mysql row ID and turn the entire string above into a list.

So for example, the database would get the ID information & create a link of edit.php/?id=3

If someone could help me on this it would be mega appreciated.

Thanks

Hi,

Just looking how to create a link to download a file located on the server, it will be files like .doc etc.

Cant seem to find anything on the net so i think i need php but may be html.

Can anyone point me in the right direction?

Thanks

p.s. it will be used for more than one file so im looking for a small ish amount of code.

I know with a submit button I can have a new record created when clicking it, but is it possible to do with a text link?

In this output table, I would like to be able to click on any number in the ama row, add .html to that value and then execute the link.

Example: If the ama number in row 3 is 890543, add .html to the number = 890543.html, then click on it to link to that web page.


<?php // Connect to database =========================================

include("connect_db.php");
$table1='passwords';
$table2='airplanes';

// send query ===================================================

$result = mysql_query("SELECT * FROM $table2") or die(mysql_error());  

if (!$result) {
    die("Query to show fields from table failed");
}

echo "<table border='10' cellpadding='3' cellspacing='2'>";
echo "<p>View All Airplanes</p>";

echo "<tr> <th>ID</th> <th>AMA #</th> <th>Model Name</th> <th>Model MFG</th><th>Wingspan</th><th>Engine</th><th>Decibels</th></tr>";

// keeps getting the next row until there are no more to get ================

while($row = mysql_fetch_array( $result )) {

// Print out the contents of each row into a table ==========================

echo "<tr><td>";

echo $row['id'];

echo "</td><td>"; 

echo $row['ama']; // Append .html to this number

echo "</td><td>"; 

echo $row['model_name'];

echo "</td><td>"; 

echo $row['model_mfg'];

echo "</td><td>"; 

echo $row['wingspan'];

echo "</td><td>"; 

echo $row['engine'];

echo "</td><td>"; 

echo $row['decibels'];

echo "</td></tr>"; 
} 

echo "</table>";

?>

Hello,

I hope someone can help me with this as I really cant seem to get it to work!

I am wanting to create a navigation menu from data on a SQL database table, I know how I need to present the data to create the menu but I can not get it to work.

Here is an example of what I need:

//get the top menu
$sql = "SELECT name, link FROM menu WHERE category = 'none'";
$result = mysql_query($sql,$conn);
while($row=mysql_fetch_assoc($result))
{
  $topmenu[] = $row['name'];
}

//go through the top menu names
foreach($topmenu as $top)
{
       //echo the current top meny name
echo $top."<br />\n";

//get menu name and link if it matched the current top menu name
$sql = "SELECT name, link FROM menu WHERE category = ".$top."";
$result2 = mysql_query($sql,$conn);
while($row2=mysql_fetch_assoc($result2))
{
                //show the menu name and link
echo $row2['name']."<br />\n";
echo $row2['link']."<br />\n";
}
     
        //create space between top menu names
        echo "<br /><br />";
}

This was my first attempt which did not work at all but since then I have tried multiple things such as putting all the data into multiple arrays, in to one array etc but I couldnt get anything to produce the result that I need.

what I am hoping to produce is something like:

Home
Information
    Info1
    Info2
    Info3
About us
    About us1
    About us1
etc
etc

Once I can produce the data in this way I can then add the html, css etc to create the menu.

I will be very greateful for any help and advice that you can provide.

Kind Regards
Ben

how do i this? i have no idea....i need to incorporate it on an html form
pleas help?

i will get the data from this line and must be able to select one from the dropdown and get the id/name from the one selected

[COLOR="Red"]$supplier_names = LpmAdnetworkPeer::getByName($catcher_id);[/COLOR]

thank you

Hi guys.. 1st post here.  I'm pretty new to php.. just a few weeks in.  I've gotten pretty decent at making mysql connections and extracting data, but now I'm wanting to take one of my urls that I echo to my page and create a new page.  Hoping someone can help...  Here's the pictu

MY MySQL Setup:
I have 1 table called table1. It has 2 columns which a 'Title' & 'Description'

My Index.php Page:
I connect to mysql. I pull the 'Title' from MySQL and loop it to produce 100 rows of data that fill my index page, as expected.

My Problem:
I now want to be able to click one of those rows and dynamically create a new page (description.php) that includes the 'Title' & 'Description'.

My Progress:
I've managed to click a row and create a hyperlink to mysite.com/$title (where 'title' is pulling the 'title' from the mysql db) but I all I get is page not found.

My Question:
How do I tell description.php to pull the 'Title' and 'Description' and link to it from index.php?

My Gratitude:
Thanks in advance!

  Hello and looking for some help please..

I have already read this : http://www.phpfreaks.com/forums/index.php?topic=120619.0

  What I am after to do, is to after a successful Paypal payment from paypal, generate a link in a wordpress site (or external even) that will expire after 3 days to a video.

  I hope that makes sense please?

Thanks in advance,

Jim

I'm attempting to create a dropdown hover menu by following the instructions on the Suckerfish site. The list that is supposed to dropdown simply stays visible all the time. Is there anything in the code that seems to be the apparent cause of the problem? You will be able to tell that I'm new to PHP. Any suggestions would be appreciated.

The following is my CSS and PHP code:

CSS:

Code: [Select]
#nav, #nav ul{
padding: 0;
margin: 0;
list-style: none;
}

#nav a{
display: block;
width: 10em;
}

#nav li{
float: left;
width: 10em;
}

#nav li ul{
position: absolute;
width: 10em;
left: -999em;
}

#nav li: hover ul{
left: auto;
}

#nav li:hover ul, #nav li.sfhover ul{
left: auto;
}

PHP/JavaScript:



Code: [Select]
function draw_app_menu() {
    // draw the application menu
?>
    <!-- left - background-color: #cdeb8b - lime -->
[color=blue]<script type="text/javascript">
shHover = function() {
  var sfEls = document.getElementByID("nav").getElementsByTagName("LI");
  for (var i=0; i<sfEls.length;i++) {
      sfEls[i].onmouseover=function() {
        this.className+=" sfhover";
      }
      sfEls[i].onmouseout=function() {
        this.className=this.className.replace(new RegExp(" sfhover\\b"), "");
      }
    }
  }
 
  if (window.attachEvent) window.attachEvent("onload",sfhover);

</script>[/color]
   
   
[color=green]<ul id = "nav">[/color]   

<?php
    
    session_start();
    if (isset($_SESSION['selected_app']))
    {
      // echo '<p> selected_app was set </p>';  
      foreach ($_SESSION['application_list'] as $app_list)
      {
         if (($app_list[5] == 'A') && ($app_list[0] == $_SESSION['selected_app']))
         {
           $_SESSION['current_link'] = $app_list[2];
         }   
         if (($app_list[0] == $_SESSION['selected_app']) && (($app_list[5] == 'M') || ($app_list[5] == 'S')))
         {
           if ($app_list[5] == 'M')
           { 
             ?>
             [color=green]<li><a href="<?php echo $_SESSION['current_link'].'?id='.$_SESSION['selected_app'].'&modid='.$app_list[3].'&func='.$app_list[6];?>"><?php echo $app_list[1];?></a></li>[/color]             
<?php
            $_SESSION['selected_mod'] = $_GET['modid'];
            $_SESSION['app_function'] = $_GET['func'];
            }
           ?>
          [color=green] <ul>[/color]         
 <?php
           if ($app_list[5] == 'S')
           {
                ?>
              [color=green]<li><a href="<?php echo $_SESSION['current_link'].'?id='.$_SESSION['selected_app'].'&modid='.$app_list[3].'&submodid='.$app_list[4].'&func='.$app_list[6];?>"><?php echo $app_list[1];?></a></li>[/color]              <?php
            $_SESSION['selected_mod'] = $_GET['modid'];
            $_SESSION['selected_submod'] = $_GET['submodid'];
            $_SESSION['app_function'] = $_GET['func'];
            }
            ?>
            [color=green]</ul>
            </li>[/color]           
<?php
         } 
      }
    }
    ?>
    [color=green]</ul>[/color]    <script src="sfhover.js" type="text/javascript"></script>
    <?php
    
}

I was wondering if there was any way in which I could create a link which would direct to a paypal payment page and the amount to be paid could be specifed in the URL (GET method) as I have multiple products at differnt prices and would like to redirect the user to a page with a price I specify to be paid.
 
Anyone have ideas?
 
Hope someone can respond soon - thanks in advance for any help!
 
Jake

I have a mysql table with the structure of
Code: [Select]
ID  Menu_Name   Parent_ID
1   Finance     NULL
2   Business    NULL
3   Investment  1
4   Trading     2
How can I create a html <ul><li> list based on the parent?

Hi

I want to add student from a dropdown list to database but I have some problem.

This is my select dropdown menu code
<form name ="student" method = "POST" action ="confirmation.php">
<select name="name">
                                    <option selected>Select Student</option>
                                    <?php
                                    $arrStudent = executeSelectQuery("select * FROM user ");

                                    for ($i = 0; $i < count($arrStudent); $i++) {
                                        $student_result = $arrStudent[$i]['student_id'];
                                        $name_result = $arrStudent[$i]['student_name'];
                                    ?>
                                        <option value="<?php echo $id_result; ?>"><?php echo $id_result; ?>, <?php echo $name_result; ?></option>
                                    <?php
                                    }
                                    ?>
                                </select>
</form>

The output in the dropdown menu look something like this:
1, Alvin
2, Benny
3, Charles
4, Daniel
5, Eva
and so on...

After submitting the form, it will proceed to confirmation.php page.

At the confirmation page, I have the following variable:
$student_result = $_REQUEST['student_id'];
$name_result = $_REQUEST['student_name'];

I want to insert to database with the following insert query
$sql = "INSERT INTO student(student_id, student_name)
    VALUES ('". $student_result . "', '". $name_result ."')";
$insert = executeInsertQuery($sql);

It can insert successfully but, it will not insert the student_name.

May I know where I did wrongly?

Thanks
Ben Chew