PHP - Building Website Need Help

Hi Guys

I am trying to build a menu sing the code below, I can get the main headings, the problem arises when I try and produce the sub menus.

Can someone please tell me where I am going wrong, or a better way of getting the desired result
Code: [Select]
<?php
 function submenu()
 {
     $submenu_sql=mysql_query("SELECT * FROM `tbl_menu` where `parent_menu_id` = '$menu_row[menu_id]'");
     if(mysql_num_rows($submenu_sql)>0)
     {
         echo('<ul>');
         while
         ($submenu_row=mysql_fetch_assoc($submenu_sql))
         {
             echo('<li><a href="'.$submenu_row['link'].'">'.$submenu_row['menu_display'].'</a></li>');
             }
             echo('</ul>');
             };
             }

$menu_sql=mysql_query("SELECT * FROM `tbl_menu` where `parent_menu_id` = '0'");
if (mysql_num_rows($menu_sql)>0)
{
    echo('<div id="accordian">');
    while ($menu_row=mysql_fetch_assoc($menu_sql))
    {
        echo('<div class="panel_container">
        <h3><a href="'.$menu_row['link'].'">'.$menu_row['menu_display'].'</a></h3>
        <div class="panel_body">');
        submenu();
        echo('</div>
        </div>');
        }
        echo('</div>');
        }
        ?>

I am getting the following error
Notice: Undefined variable: menu_row in /home/sites/j-slink.co.uk/public_html/includes/menu.php on line 4


The desired result is to produce a menu with the following layout
Code: [Select]
<div id="accordion">



<div class="panel_container" id="panel1">
    <h3 id="visible">Home</h3>
    <div id="panel1-body" class="panel_body">
    </div>
</div>

<div class="panel_container" id="panel2">

    <h3>Music</h3>
    <div id="panel2-body" class="panel_body">
        <div>
        <ul>
<li>Calling Card Mixing Tape</li>
</ul>
        </div>
    </div>

</div>

<div class="panel_container" id="panel3">
    <h3>Panel 3</h3>
    <div id="panel3-body" class="panel_body">
        <div>
        This is the contents of this panel.
        </div>
    </div>
</div>

<div class="panel_container" id="panel4">
    <h3>Panel 4</h3>
    <div id="panel4-body" class="panel_body">
        <div>
        This is the contents of this panel.
        </div>
    </div>
</div>

<div class="panel_container" id="panel5">
    <h3>Panel 5</h3>
    <div id="panel5-body" class="panel_body">
        <div>
        This is the contents of this panel.
        </div>
    </div>
</div>

</div>

Thanks in advance

If I use this code:
$values = range(0, 10);
echo "<select name=\"my_field\">\n";
foreach($values as $v) {   
echo "<option value=\"$v\">$v</option>\n";
}echo "</select>\n";

to generate a dropdown, it will offer options from 1 thru 10. 

Is there any way to make them increment by .50 (ie: 0.0, 0.5, 1.0, 1.5, 2.0, 2.5, etc.?

Greetings freaks,

I am trying to figure out how to build an array for the following purpose, and have just been spinning my wheels as it's a very new topic to me.

I have a database with a table and the following important rows:  ID, Parent, and Name.  In this table, Parents are given the value 0 for 'Parent' and a unique 'ID' & 'Name' - children are given all unique 'ID' and 'Name' with the value for Parent being 'ID' of the Parent they belong to.

Example: ( as 'ID', 'Parent', 'Name') 1, 0, John & 2, 1, Jane / 3, 0, Mark & 4, 3, Mary & 5, 3, Mindy.

As you can see, the second names in each example (the children) are connected to their parents by the 'Parent' row, whereas the first names (the parents) are not associated with anybody else.

What I would like to do is build an array that associates every child to the parent ([Parent] => child1 ).  Simple MySQL grants me an array for the parents:

$parent_pull = mysql_query('SELECT * FROM `table` WHERE Parent = 0')
while($row = mysql_fetch_array($parent_pull)){
$name[] = $row['Name'];
$id[] = $row['ID'];
}


Now, I want to be able to use the $id[]s to build arrays WHERE Parent = $id[].

I have tried in loops with $id[$i] & $i++ to cycle the array values, but PHP tells me there mysql_fetch_array() expects parameter 1 to be resource, boolean given ... on line 32.

$i = 0

while($i < 10){
$child_pull = mysql_query('SELECT * FROM `table` WHERE Parent = $id[$i] ');
$child = mysql_fetch_array($child_pull);
$child[] = $child['Name'];  <-- Line 32
$i++;
}


How would I go about pulling all the children and associating them with their parents?

Hi people.
I'm building a quiz with one correct answer out of possible 4.
My problem is that after I choose a random answer (which is the correct one) I have problems with choosing random 3 wrong answers which are not the same as answer 1 (they all come from the same table).

My first mysql query gives me back 1 row
my second mysql query gives me back 15 row (there were 16 - 1 which is the correct one).
How can take only 3 rows out of that second query and output them into variables that I can later echo into a form?

Can you help me understand this problem or can you propose an alternative method to deal with this?

Here are my two queries:
Code: [Select]
// Fetch random answer (correct)
 $query = "SELECT * FROM psychofarm_brand WHERE `id`=".$randomNumber;
    $result = mysql_query($query);
    $row = mysql_fetch_array($result);

// Fetch wrong answer

    $query2 = "SELECT * FROM psychofarm_gen WHERE `id`!=".$randomNumber;
    $result2 = mysql_query($query2);
    $row2 = mysql_fetch_array($result2);


I hope this is clear.
Thanks

I was thinking how can I make a script that will build strings incrementing through each letter starting with "a" and ending with "zzzzzz" or what ever ending length I want such as 12.

So if your were to output everything, you could find the words:
"dog"
"spider"
"superman"
"hippo"
etc

What would be the best way to do this, so I don't have to have a loop that is 500 blocks deep to show a word that is 500 letters

example
Quote

a
...
z
aa
ab
ac
...
az
ba
bb
bc
...
...
aaa
aab
aac

Why is the proper way to call a class is to call a method at the same time?

For example
Code: [Select]
$class = new SomeClass();
$class->some_method();

I understand why you would do this but lets say you just have a simple class that you pass some data.  The class than processes the data in some way than returns it.  It is my understanding if you were to make a class likes this.

Code: [Select]
class SomeClass{

     function __construct($data){
          //process data//
          return $data;
    }
}

That this code is considered an improper way of doing this because you should never return data from the __construct.  So would this follow code be the proper way to handle this?

Code: [Select]
class SomeClass{

     function __construct($data){
          $this->some_method($data);
    }

     function some_method($data){
          //process data//
          return $data;
    }
}

Any good explanation on the proper way to handle this would be greatly appreciated.  When I am making simple classes to do a specific task it would seem more efficient not having to know about any particular method inside the class. 

Here's my build a querty code...
Code: [Select]
$sql = "UPDATE $tablename SET
DIST_PART_NUM = '$dist_part_num',
DIST_PUB = '$dist_pub',
MFR_PART_NUM = '$mfr_part_num',
MFR_PUB = '$mfr_pub',
ITEM_DESC = '$item_desc',
ITEM_STD_DESC = '$item_std_desc',
ITEM_COPY = '$item_copy',
COST = '$cost',
GP_MULT = '$gp_mult',
ITEM_IMAGE = '$item_image',
ITEM_URL = '$item_url',
COUNTRY_OF_ORIG = '$country_of_orig',
CATEGORY_ID = '$category_id',
PICGROUP_KEY = '$picgroup_key',
UPC_CODE = '$upc_code',
LEADTIME = '$leadtime',
UNITS = '$units',
LENGTH = '$length',
WIDTH = '$width',
HEIGHT = '$height',
WEIGHT = '$weight',
FLAG_HAZARDOUS = '$flag_haz',
FLAG_LTL = '$flag_ltl',
FLAG_NON_RETURNABLE = '$flag_non',
CAMPAIGN_KEY = '$campaign_key', ";
foreach($atr as $key => $value)
{
$sql .= $value . "='" . addslashes($_POST[$value]) . "',";
}

$sql2 = rtrim($sql,",");

$sql2 .= " WHERE DIST_PART_NUM = '$partnumber' OR MFR_PART_NUM = '$partnumber'";

Now the query get's built 100% fine that's not the issue... my issue is that sine if the table fields are named something like #_of_shelves... and the # sign causes a MySQL error...
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 26

How can i allow for the # sign, or any other character that can cause issues like () . , * ~ etc....

i tried encompassing the field name with single quotes 'fieldname' and with those slanted ones `tablename` but that did not help.

Any ideas?

Thanks!

I am building a shopping cart with PHP and working with a tutorial
(http://jameshamilton.eu/content/simple-php-shopping-cart-tutorial)

I am putting together the cart and there is some coding
$sql = sprintf("SELECT name, description, price FROM php_shop_products WHERE id = %d;",
                        $product_id);
That i do not understand. Here it is "WHERE id = %d;"
I have never seen this before and am wondering what it means or how to work with this syntax

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=352102.0

Hello i try to explain my situation,

I have a dynamic table so i need to build a dynamic radiobutton list and build a dynamic sql req.
First of all i build my table with radio button in a while

So the radio button is named rdYanViau ( in the html it's working no prob with that )
Quote

$name = $row2['FirstName'].$row2['LastName'];

Quote

<input type="radio" name="rd<?php echo $name; ?>" value="1">

Quote

<input type="radio" name="rd<?php echo $name; ?>" value="2">


And in the same while i build a portion of my dynamic sql like that
Quote

$valueDeclare .= $row2['FirstName'].$row2['LastName'].', ';

So in my insert this variable give me the FieldName

and in the same while i build my $_POST variable for my sql sentence
Quote

$valueRadio .= "'".'".$_POST['."'".'rd'.$row2['FirstName'].$row2['LastName']."'".']."'."', ";

This value is '".$_POST['rdYanViau']."'

After that i build my sql with those 2 variables, the problem is when i execute my sql insert where he's supose to insert my rdButton value ... it's insert the string '".$_POST['rdYanViau']."' who give me a 0 in the table, he's not getting the value of '".$_POST['rdYanViau']."' he's inserting the string in the table.

Here's the echo of my sql sentence :
Quote

INSERT INTO sondage (idSondage, username, idMatch, YanViau, YanViau2, YanViau3) VALUES (NULL , 'admin', '1', '".$_POST['YanViau']."', '".$_POST['YanViau2']."', '".$_POST['YanViau3']."')


my echo should look like :
Quote

INSERT INTO sondage (idSondage, username, idMatch, YanViau, YanViau2, YanViau3) VALUES (NULL , 'admin', '1', '1', '2', '1')


How i can build this dynamic sentence and have the radiobutton value and not the string value ...

I hope you can understand my problem.
Yan.

Hi,

I was trying to build a chat room and tried the code given he http://www.codingmix.com/2010/12/privat ... mment-form

but when i try to go to chat , sending is disabled and I cant chat
Can anyone help?

Also I want to create a room for chat like:
based on a topic
some more features like
Adding a topic........and while chat choose the category
like speaking for the topic, against or neutral and with option to post a point while chatting

please help
pooja_dubey12
Forum Newbie
 
Posts: 3
Joined: Fri Jul 03, 2009 8:29 am

Hello,

I would like to build a php search engine against a mysql database. I am looking for a tutorial but haven't been able to find any good ones. Any ideas of where I can find one? I need one where I can search with several words and if it has the stemmer.class.inc and so on would be great also.

thanks, df

I'm trying to build a tree to display product groups, but I can't achieve what I want.

There is a hierarchy for the tree which I need to follow:

1H
  1HS
    1HSMP

I want to list all the categories (1H) with its subcategories(1HS), and it's subcategories (1HSMP).

This is the code I'm currently using:

<ul>
                                                            <?php
                                                            //Here we fetch category
                                                            $categories_list = array();
                                                            if($stmt = $conn -> prepare("SELECT a.category, a.subcategory, a.subcategory1, a.category_description, a.subcategory_description, a.subcategory_description1,  SUM(nsq.sales_amount) AS sales, SUM(nsq.sales_amount+nsq.cost_amount) AS RUC
                                                                                                FROM dpb.articles a
                                                                                                LEFT JOIN dpb.nav_sales_qty nsq
                                                                                                ON nsq.article_no = a.article_no
                                                                                                WHERE nsq.entry_type_desc = 'Prodaja'
                                                                                                GROUP BY a.subcategory1")) {
                                                               $stmt -> execute();
                                                               $stmt -> store_result();
                                                               $stmt -> bind_result($category, $subcategory, $subcategory1, $category_description, $subcategory_description, $subcategory_description1, $total_sales, $total_profit);
                                                               while($stmt -> fetch()) {
                                                                   $categories_list[] = array('category' => $category,
                                                                                               'subcategory' => $subcategory,
                                                                                               'subcategory1' => $subcategory1,
                                                                                               'category_description' => $category_description,
                                                                                               'subcategory_description' => $subcategory_description,
                                                                                               'subcategory_description1' => $subcategory_description1,
                                                                                               'total_profit' => $total_profit,
                                                                                               'total_sales' => $total_sales);
                                                               }
                                                               $stmt -> close();
                                                            }

                                                            foreach($categories_list as $key => $value) {
                                                            ?>
                                                                <li><?php echo $value['category'].' - '.$value['category_description']; ?>
                                                                    <ul>
                                                                        <?php
                                                                        //Here we filter subcategory
                                                                        if(strpos($value['subcategory'], $value['category']) === 0) {
                                                                            //Iterate over subcategory
                                                                            foreach ($value as $key2 => $value2) {
                                                                                debugVar($value2);
                                                                        ?>

                                                                                <li data-jstree='{"opened":true}'><?php echo $value2['subcategory'] . ' - ' . $value2['subcategory_description']; ?>
                                                                                    <ul>

                                                                                        <?php
                                                                                        //Here we filter subcategory2
                                                                                        if (strpos($value['subcategory1'], $value['subcategory']) !== false) {
                                                                                            ?>

                                                                                            <li data-jstree='{"type":"file"}'>
                                                                                                <?php echo $value['subcategory1']; ?>
                                                                                            </li>

                                                                                            <?php
                                                                                            //Here we close subcategory1 if statement
                                                                                        }
                                                                                        ?>

                                                                                    </ul>
                                                                                </li>
                                                                                <?php
                                                                                //Here we close subcategory if statement
                                                                            }
                                                                        }
                                                                        ?>
                                                                    </ul>
                                                                </li>

                                                            <?php
                                                            //Close foreach loop
                                                            }
                                                            ?>
                                                            </ul>

  The result I'm getting is attached in the photo, and it's not what I want!

The result I need is the following:

I find a category (1H), and then I find all of its subcategories which are 1H% (all that start with 1H) and display them bellow 1H. Then I iterate over all of these subcategories (example 1HS%, 1HP%, 1HRD%) and I find all of their subcategories which are starting with (1HS, 1HP, 1HRD) and display them.

Example:

1H
  1HS
    1HSMP
    1HSTR
    1HSKT
  1HP
    1HPSD
    1HPDD
    1HPSA
  1HRD
    1HRDA
    1HRDBV
   1HRDTE
   1HRDEF

Can you please help me how to achieve that? I spent a lot of time, and I can't get the proper result.

 

hello,
I am trying to create a form that will log items. Say I have a list of fruits and I want to log the fruit and its color. I don't know how many fruits I have so I need the form to start with one row first then add rows after I hit enter.

I then need to insert the fruits into mysql

any ideas or links? anyone?

He,

I am builing some kind of quiz script.
I got 10 images people see and they have to say if they agree or not.
Simply by clicking yes / no. First i used a submit button, but now i want it to submit whem people click yes/no.
tried some stuff already but cant find the correct way.

Please help

here is the code:

<?php

session_start();

$thispage = 'test.php';
$img = array( '1','2','3','4','5','6','7','8','9','10' );

function getQuestion( $q ) {
    global $img;
    $curImg = $img[$q];
    return "Do you agree? <br> <img src=\"images/{$curImg}.jpg\">";
}

 
if ( isset( $_GET['reset'] ) ) {
    unset( $_SESSION['q'] );
    unset( $_SESSION['answer'] );
    header("Location: {$thispage}");
}

if ( !isset( $_SESSION['q'] ) ) {
    $_SESSION['q'] = 0;
}
if ( !isset( $_SESSION['answer'] ) ) {
    $_SESSION['answer'] = array();
}


if ( isset( $_POST['answer'] ) ) {
    $answer = $_POST['submit'];
    if ( $answer == '1' || $answer == '2' ) {
        $next =  $_SESSION['q'] + 1 ;
        if ( array_key_exists( $next,$img ) ) {
            $_SESSION['answer'][$_SESSION['q']] = $answer;
        }
        $_SESSION['q'] = $next ;
    }
}

if ( $_SESSION['q'] >= count( $img ) ) {
    $html = '';
    foreach( $_SESSION['answer'] as $q => $value ) {
        $html .= getQuestion( $q ) . " Answer: {$value}<br />";
    }
    $html .= "<br /><br /><a href=\"{$thispage}?reset=Y\">Reset Quiz</a>";
}
else {
    $question = getQuestion( $_SESSION['q'] );
    $html =<<<HTML

<html>
<body>
<h1>{$question}</h1>
    <input type="submit" value="Yes" name="answer"  />Yes<br />
    <input type="submit" value="No" name="answer"  />No<br />
</form>
</body>
</html>
HTML;
}

echo $html;


?>