PHP - Building Strings

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.?

In php how could I build a .net application?
So I have a source that I want to build in .net, but i'm not sure how...

     Hey guys, I'm currently trying to make a tutorial website, and I'd like to have a fairly simple blog / news page that I can update with pictures and news stories.  I would also like people to be able to comment on these postings.  I'm pretty new to PHP but i made a simple blog using a php handler and a database table, but I was just wondering is there some 3rd party application I can use to manage my website with like users and articles and such without having to use their website layout? Like, programs such as WordPress and PHP-Fusion, Joomla etc, dont let you use your own html and css pages do they?
     I want to keep my website but have something purely in the background for me to manage the content and maybe like paste some script to my actual pages or whatever.  Im just lost is all I need a little guidance =]  Thanks a bunch.

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

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!

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. 

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.

This topic has been moved to Application Design.

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

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

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 want to know first, how to start new pages or small windows    Next, how to temporarily store data and then delete upon exit of chat so that memory can be saved    How to embed objects like images (objects?)    How to have resizable or set the size of input field for the message   Show a sign like "person is typing" when other person is inputting data    I'll probably get yelled at, I'm trying to amass all the information I need I'll research each subject as I accomplish a task    Right now I could really use a download script that saves a photo, gets url of photo and searches the document for "By Name" and cuts out / stores the Name part and then renames the file with an increment of one, instead I have to do 300 clicks with my mouse. = ineptitude or ignorance    That is theoretically the ideal case but I have to sift through photos, see which ones are good eg. face is covered by watermark    Thanks for any help 
Edited by greenace92, 02 December 2014 - 07:52 PM.

I'm trying to convert a one dimensional array into a multidimensional array by grouping matching parts of the keys, i.e. array('onetwothreefour'=>'value',                 'onetwothreesix'=>'value2') would become array('onetwothree'=>array('four'=>'value',                                              'six'=>'value2'));   Essentially I'm trying to convert XML to YML and have a one dimensional array of the XML with index => value.   I've been staring at it for a while now and have tried a few recursive functions to build it though I've come to a few dead ends and would appreciate any words of wisdom if someone can spot the answer easier than I
Edited by joel24, 23 May 2014 - 09:51 AM.

I'm a newbie and want to explore on the use of php.I want to create a transcript system but do not know how to go about it.please where should i start from?

This topic has been moved to mod_rewrite.

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