form issue

laxi · September 13, 2013

Hello everyone,

I am building up a site and I have a form that is kind off tricky.

I have 3 depenendable select boxes in my form for category,first-subcategory,second-subcategory that been written in using javascript.

But the form itself has other elements that needs to be parsed to a php scripts.

The 3 dependable select boxes has no action attribute, ie action=" " for it to work according to the written javascript and I have copied this script from a forum help section. I had to integrate this 3 dependable select boxes into my original form which parses to a action="inventory.php" script.

When I integrate the 3 dependable boxes into my form that parses to action="inventory.php" the dependable boxes dont work for first-subcategory,second-subcategory as the javascript requires action=" " and not action="inventory.php".

However i need the form to be parsed to the "inventory.php" script.

below is my code..Can somebody advise and make this work for me..

<?php

session_start();

if (!isset($_SESSION["manager"])){

header("location:admin_login.php");

exit();

}

?>

<?php

/* checking if this is a valid session in database */

$managerID=preg_replace('#[^0-9]#','',$_SESSION["id"]);

$username=preg_replace('#[^0-9a-z]#i','',$_SESSION["manager"]);

$password=preg_replace('#[^0-9a-z]#i','',$_SESSION["password"]);

include "../storescripts/connect_to_mysql.php"; /* connect to database */

/* do a query on database */

$sql=mysql_query("SELECT * FROM admin WHERE id='$managerID' AND username='$username' AND password='$password'");

$row=mysql_num_rows($sql);/* counting the number of rows returned from above query */

if($row==0)

{ echo "You are not authorised to enter this region as your credentials are not valid on our database";

exit(); }

?>

<?php

/* list all the products for viewing*/

$product_list="";

$sql=mysql_query("SELECT * FROM products");

$count=mysql_num_rows($sql);

if ($count>0)

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

$id=$row["id"];

$product_name=$row["product_name"];

$price=$row["price"];

$List1=$row["List1"];

$List2=$row["List2"];

$List3=$row["List3"];

$date_added=$row["date_added"];

$product_list .= "$id- $product_name- $price- $List1- $List2- $List3-$date_added <a href='#'>edit</a> •<a href='#'>delete</a> <br>";

}

else

{

$product_list = "You dont have any products listed in your store yet";

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Manage Inventory</title>

/*

Triple Combo Script Credit

By Philip M: http://www.codingforums.com/member.php?u=186

Visit http://javascriptkit.com for this and over 400+ other scripts

*/

var categories = [];

categories["startList"] = ["CLOTHING","ELECTRONICS","AUTOMOBILES"]

categories["CLOTHING"] = ["MEN","WOMEN","KIDS", "FEATURED STORES CLOTHING","OFFERS CLOTHING"];

categories["ELECTRONICS"] = ["CAR/AUTO ELECTRONICS & GPS","CAMERA AND PHOTO","CELL PHONES AND ACCESSORIES","MP3 PLAYERS AND ACCESSORIES","TV,HOME THEATRE,AUDIO/VIDEO","MUSICAL INSTRUMENTS AND ACCESSORIES","VIDEO GAMES"];

categories["AUTOMOBILES"] = ["CAR","MOTORCYCLE"];

categories["MEN"] = ["T-shirts","Casual & Party Wear Shirts","Formal Shirts","Jeans","Cargos, Shorts & 3/4ths","Trousers","Inner & Sleep Wear","Rainwear","Sports Wear","Accessories & Combo Sets","Suits & Blazers","BRANDS MEN"];

categories["WOMEN"] = ["Dresses & Skirts","Ethnic Wear","Shirts, Tops & Tunics","Polos & T-shirts","Jeans & Shorts", "Leggings & Jeggings","Trousers & Capris","Lingerie & Sleepwear","Accessories","BRANDS WOMEN"];

categories["KIDS"] = ["BOYS","GIRLS","INFANTS"];

categories["FEATURED STORES"] = ["For Men", "For Women", "For Kids"];

categories["OFFERS"] = ["Featured Deals", "SALE"];

categories["CAR/AUTO ELECTRONICS & GPS"] = ["Car Audio","Car Stereo", "Car Speakers", "Car Amplifiers","Car Subwoofers","Car Video", "Satellite Radio", "CB Radio","OTHER Car Audio & Video ","Alarm Systems", "Key-less entry", "Remote Starters", "Vehicle Back-Up Cameras","Steering Wheel Locking ","Radar Detectors", "OTHER Car Safety & Security", "Vehicle GPS" ,"GPS Mapping Software", "GPS Trackers", "GPS Systems Accessories", "Sport & Handheld GPS", "Boating GPS","OTHER GPS & Navigation",];

categories["CAMERA AND PHOTO"] = ["Digital SLR","Point & Shoot","Advanced Point & Shoot", "Camcorder", "Mirrorless ","Brands", "SLR ACCESSORIES", "Lenses by brands", "Lens Cleaners","Lens Caps ","Filters", "Flashes", "Memory Cards" , "Tripods", "Camera Bags", "Binoculars & Optics", "Digital Photoframes", "FEATURED STORES","OFFERS"];

categories["CELL PHONES AND ACCESSORIES"] = ["Brand cell phones","Samsung","Micromax", "Nokia", "Sony ","HTC", "Apple", "BlackBerry", "FEATURED STORES CELL PHONES AND ACCESSORIES","OFFERS CELL PHONES AND ACCESSORIES ","SERVICES"];

categories["MP3 PLAYERS AND ACCESSORIES"] = ["Under 1GB","1 to 4 GB","5 to 24 GB", "25 to 60 GB","61 to 120 GB", "Over 120 GB","ipod", "MP3 PLAYERS","SPEAKER SYSTEMS","MP3 ACCESSORIES","HEADPHONES", "CASES"];

categories["TV,HOME THEATRE,AUDIO/VIDEO"] = ["Home Theater Systems","Compact & Portable Audio","Speakers", "Home Audio Accessories","Headphones", "HDTVs","Blu-ray Players and Projectors", "OTHER HOME THEATER EQPMTS "];

categories["MUSICAL INSTRUMENTS AND ACCESSORIES"] = ["Guitars","Bass Guitars","Drums & Percussion", "Keyboards", "Band & Orchestra","Folk & World Instruments","Instrument Accessories", "Studio Recording Equipment ","Top Deals"];

categories["VIDEO GAMES"] = ["PlayStation 4","PlayStation 3", "Xbox One", "Xbox 360","Sony PSP","Mac","Sony PSP", "Digital Games", "Best-Selling Video Games","OTHER GAMES AND ACCESSORIES", ];

categories["CAR"] = ["MAKE","NEW","USED", "OTHERS"];

categories["MOTORCYCLE"] = ["Ducati","BMW", "Shop by Type"]

var nLists = 3; // number of select lists in the set

function fillSelect(currCat,currList){

var step = Number(currList.name.replace(/\D/g,""));

for (i=step; i<nLists+1; i++) {

document.forms['tripleplay']['List'+i].length = 1;

document.forms['tripleplay']['List'+i].selectedIndex = 0;

}

var nCat = categories[currCat];

for (each in nCat) {

var nOption = document.createElement('option');

var nData = document.createTextNode(nCat[each]);

nOption.setAttribute('value',nCat[each]);

nOption.appendChild(nData);

currList.appendChild(nOption);

}

function init() {

fillSelect('startList',document.forms['tripleplay']['List1'])

}

navigator.appName == "Microsoft Internet Explorer" ? attachEvent('onload', init, false) : addEventListener('load', init, false);

</script>

</head>

<?php include_once("../template_header.php");?>

<h1 align="center"> Manage Inventory</h1>

<div align= "right" style=" margin: 50px" ><a href="inventory_list.php#inventoryForm">+Click here to add inventory to the store </a></div>

<h2 align="center"> Add Inventory Items to the store</h2>

<tr>

<td align="right" width="29%">Product Name </td>

</tr>

<tr>

<td align="right">Price </td>

</tr>

<tr>

<td align="right">Category </td>

<option selected>Make a selection</option>

</select></td>

</tr>

<tr>

<td align="right">First-Subcategory </td>

<option selected>Make a selection</option>

</select></td>

</tr>

<tr>

<td align="right">Second-Subcategory </td>

<td><select name='List3' onchange="getValue(this.value, this.form['List2'].value,

this.form['List1'].value)">

<option selected >Make a selection</option>

</select></td>

</tr>

<tr>

<td align="right">Details </td>

</tr>

<tr>

<td align="right">Upload Product Image </td>

</tr>

<tr>

</tr>

</table></form>

</div>

<?php include_once("../template_footer.php");?>

</div>

</body>

</html>

Thanks in advance

mac_gyver · September 14, 2013

in case the OP revisits this thread. there are several reasons why no one attempted to reply to this thread -

1) it is in the wrong forum section. it has nothing to do with Php Math Help.

2) it is the same task/problem as your previous thread and your follow-on thread. you seem to be just trying different things, throwing code and forum threads away. no one is going to try and understand what your code is doing in order to help you with it if you don't stick to the same thread for your task.

3) you didn't post the code using the forum's

bbcode tags (the edit form's <> button).

4) i doubt anyone can understand the statement of the question/problem. you need to just post the relevant facts.

AbraCadaver · September 16, 2013

You're missing a ;

Sign In

form issue

Recommended Posts

laxi

Link to comment

Share on other sites

mac_gyver

Link to comment

Share on other sites

AbraCadaver

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information