PHP - How To Create A Menu List From Mysql Data

I'm pulling data from an xml file and I'm getting a lot of duplicates. How can I remove the duplicates from the query?

Code: [Select]
foreach($xml->category->subcategory as $category){
echo $category[id];
}//end foreach

Hi, I have a chunk of text I am pulling from a mysql db like below.
                           
Air conditioning in rooms
24 Hour Reception
Smoking rooms available

How can I write this into -

<ul>                           
<li>Air conditioning in rooms</li>
<li>24 Hour Reception</li>
<li>Smoking rooms available</li>
</ul>

Many thanks.

How to create Dependent Dropdown List?

 

                    <div class="form-group">
                            <label class="control-label col-sm-2" for="i_have">I have :</label>
                            <div class="col-sm-10">  
                                <select id="old" class="form-control" placeholder="Select I have" name="i_have">
        
                                    <option value = "select_option">Select Option</option>
                                    <option value = "three_compact">3 Compact</option>
                                    <option value = "three_regular">3 Regular</option>
                                    <option value = "three_triple">3 Triple</option>
                                    <option value = "five_compact">5 Compact</option>
                                    <option value = "five_regular">5 Regular</option>
                                    <option value = "five_triple">5 Triple</option>
                                    <option value = "seven_compact">7 Compact</option>
                                    <option value = "seven_regular">7 Regular</option>
                                    <option value = "seven_triple">7 Triple</option>
                                    <option value = "nine_compact">9 Compact</option>
                                    <option value = "nine_regular">9 Regular</option>
                                    <option value = "nine_triple">9 Triple</option>   
                                </select>
                            </div>
                        </div>
        
        
        
        
                        <div class="form-group">
                            <label class="control-label col-sm-2" for="i_want">I want :</label>
                            <div class="col-sm-10">  
                                <select id="new" class="form-control" placeholder="Select I want" name="i_want">
        
                                    <option value = "select_option">Select Option</option>
                                    <option value = "three_compact">3 Compact</option>
                                    <option value = "three_regular">3 Regular</option>
                                    <option value = "three_triple">3 Triple</option>
                                    <option value = "five_compact">5 Compact</option>
                                    <option value = "five_regular">5 Regular</option>
                                    <option value = "five_triple">5 Triple</option>
                                    <option value = "seven_compact">7 Compact</option>
                                    <option value = "seven_regular">7 Regular</option>
                                    <option value = "seven_triple">7 Triple</option>
                                    <option value = "nine_compact">9 Compact</option>
                                    <option value = "nine_regular">9 Regular</option>
                                    <option value = "nine_triple">9 Triple</option>   
                                </select>
                            </div>
                        </div>
                    

 

If the first dropdown "3 Compact " is selected second dropdown should not be able to select "3 Compact" & if first dropdown "5 Regular" is selected second dropdown should not be able to select below values of 5 Regular  like "3 Compact, 3 Regular, 3 Triple, 5 Compact.

The logic is, if first dropdown value selects like 5, second dropdown value must select above 5 not 4 or 3 or 2 or 1.

I have the following code which works (thanks to PHP Freaks members)

    foreach ($swap["sims"] as $swap) 
    		{
                    echo $swap['voice'] . "</br>";
			}

But I can't figure out why the following doesn't work

<select name="sim_for_swap[]">
<?php
    foreach ($swap["sims"] as $swap)  
    		{
?>
<option value="<?php echo $swap['voice'];?>"><?php echo $swap['voice'];?></option>
<?php
}
?>

I am wanting to create a basic product listing page for a product category called "Belts".

My latest attempt was this, but I got an error:
PHP Code:
Code: [Select]
$query = "select * from products";
$result = mysql_query($query);
while($row=mysql_fetch_assoc($result)) {
    print ".$row['name'] where category = 'Belts'.$row['colour'] where category = 'Belts'";
}

Quote

PHP Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING


This is what my MySQL table looks like:
http://i54.tinypic.com/2j1si8w.png

I image what I am trying to do will print "Somename Black, ProductName2 Brown"?

I'm not really interested in styling at the moment, I just want to see the PHP-MySQL work at the most basic level.

I am unsure what the error cosde means. Can anyone see a fault in my code?

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

Hello to all,

I have problem figuring out how to properly display data fetched from MySQL database in a HTML table.

In the below example I am using two while loops, where the second one is nested inside first one, that check two different expressions fetching data from tables found in a MySQL database. The second expression compares the two tables IDs and after their match it displays the email of the account holder in each column in the HTML table.

The main problem is that the 'email' row is displayed properly while its while expression is not nested and alone(meaning the other data is omitted or commented out), but either nested or neighbored to the first while loop, it is displayed horizontally and the other data ('validity', 'valid_from', 'valid_to') is not displayed.'

Can someone help me on this, I guess the problem lies in the while loop?
Here is part of the HTML code:

<thead>
 <tr>
 <th data-column-id="id" data-type="numeric">ID</th>
 <th data-column-id="email">Subscriber's Email</th>
 <th data-column-id="validity">Validity</th>
<th data-column-id="valid_from">Valid From</th>
 <th data-column-id="valid_to">Valid To</th>
</tr>
</thead>

Here is part of the PHP code:

 

    <?php
    while($row = $stmt->fetch(PDO::FETCH_ASSOC))
    {
        echo '
            <tr>
                <td>'.$row["id"].'</td>
        ';
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) {
        echo '
                <td>'.$row1["email"].'</td>
        ';
        }
        if($row["validity"] == 1) {
            echo '<td>'.$row["validity"].' month</td>';
        }else{
            echo '<td>'.$row["validity"].' months</td>';
        }
        echo '  <td>'.$row["valid_from"].'</td>
                <td>'.$row["valid_to"].'</td>
        </tr>';
    }
    ?>

P.S. Please know that I have purposely omitted the connection part and the methods in the class that are used in this code to keep the spot of the problem as clean as possible. If you need me to rephrase the question, please ask.

Thank you.

This could be PHP or MySql so putting it in PHP forum for now...
I have code below (last code listed) which processes a dynamically created Form which could have anywhere from 0 to 6 fields.  So I clean all fields whether they were posted or not and then I update the mySQL table.

The problem with this code below is that if, say, $cextra was not posted (i.e. it wasnt on the dynamically created form), then this code would enter a blank into the table for $cextra (i.e. if there was already a value in the table for $cextra, it gets overwritten, which is bad).

What is the best way to handle this?  I'm thinking i have to break my SQL query into a bunch of if/else statements like this...

Code: [Select]
$sql = "UPDATE cluesanswers SET ";
if (isset($_POST['ctext'])){
echo "ctext='$ctext',";
} else {
//do nothing
}
and so on 5 more times....

That seems horribly hackish/inefficient.  Is there a better way?

Code: [Select]
if (isset($_POST['hidden']) && $_POST['hidden'] == "edit") {

$cimage=trim(mysql_prep($_POST['cimage']));
$ctext=trim(mysql_prep($_POST['ctext']));
$cextra=trim(mysql_prep($_POST['cextra']));
$atext=trim(mysql_prep($_POST['atext']));
$aextra=trim(mysql_prep($_POST['aextra']));
$aimage=trim(mysql_prep($_POST['aimage']));


//update the answer edits
$sql = "UPDATE cluesanswers SET ctext='$ctext', cextra='$cextra', cimage='$cimage', atext='$atext', aextra='$aextra', aimage='$aimage'";
$result = mysql_query($sql, $connection);
if (!$result) {
die("Database query failed: " . mysql_error());
} else {
}

hi guys, im new to this forum

I'm new also to php, I need help from you guys:

I want to display personal information from a certain person (the data is on the mysql database) using his name as a link:

example:
               (index.php)
               names
                          1. Bill Gates
                          2. Mr. nice Guy
           
i want to click Bill Gates
 
   (output.php)
     Name: Bill Gates
     Country:xxxx
     Age: xx   
                 etc.

How can i make this or how to learn this?
   
                 

             
               

   
       

Hi I am trying to select and order data/numbers from a colum in a mysql data base however i run the code and it returns no value just a blank page no errors or any thing so i think the code is working right but then it returns no result? Please help thanks

Here is the code:

<?php
$host= "XXXXXX";
$mysql_user = "XXXXXX";
$mysql_password = "XXXXXX";
$mysql_database = "XXXXXXX";

$connection = mysql_connect("$host","$mysql_user","$mysql_password") or die ("Unable to connect to MySQL server.");
mysql_select_db($mysql_database) or die ("Unable to select requested database.");

$row = mysql_fetch_assoc( mysql_query( "SELECT XP FROM Game ORDER BY number DESC LIMIT 1" ) );
$number = mysql_result(mysql_query("SELECT XP FROM Game ORDER BY number DESC LIMIT 1"), 0);

echo "The the highest XP is $number";

?>

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

This question is part PHP, part MySQL.

I have a survey_responses table...

	- id
	- survey_id
	- question_id
	- member_id
	- response
	

 

For satisfaction questions (i.e. 1 = Strongly Disagree, 2 = Disagree, 3 = Neither, 4 = Agree, 5 = Strongly Agree), I'm trying to figure out how to get the counts for each of those responses into PHP so I can then feed them to a Bar Chart I hope to create with HTML/CSS.

1.) Should I create some kind of loop in PHP, and look for each value (e.g. 1 = Strongly Disagree) and one at a time plug them into variables called: $stronglyDisagree, $disagree, $neighter, $agree, $stronglyAgree?

 

2.) Or do I first need a "cross-tab" query in MySQL?

 

3.) Would this be easier if the database values were in a PHP array?

 

Not sure where to begin with this, and more importantly, I want to make sure that my data model in MySQL is sufficient so i can do reporting like this!!

 

Thanks.

 

I have a variable and it contains a lot of strong data would I want to convert the string data into an array. What's the best way of doing because I know older versions of php will be slightly different?

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
    
}