PHP - Saving To A Sql Database Using Php And Wamp

Hi, I'm still new to php and having some problems. Sorry about the code not being formatted properly. The snippet I posted has both the code intend to work but it is commented out and a test version that has an array already set thus getting rid of the need of setting up every thing like I have.

Ok this is basically my problem. I'm building a store like website. Its suppose to be very basic for now Part of the website is an RMA system where the customer enters an order number and then pulls up all items in the order on a different page in a table format with check boxes next to each item found in the database.  Each item that is checked off is then saved to an array rma[] which posts to another page when submitted. What this page(copied down below) does is it pulls values from the cookie already made and creates new variables which is not a problem. After that it does a foreach loop for the array of the items into a mysql query which then is suppose to insert it into a database.

When the code runs it only inserts the first item in the array into the database no matter how many items are in the array. When I echo the $insert statement I get this(using the test code) like I expect I'm suppose to. I would assume that because I'm doing a foreach loop that it is doing an INSERT for the number of items in the array.

Quote

INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','Saab','123')
INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','Volvo','123')
INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','BMW','123')
INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','Toyota','123')


Code: [Select]
<?php

//connects to the data base
 mysql_connect("localhost", "root", "") or die(mysql_error()); 
 mysql_select_db("project") or die(mysql_error()); 

/* //retrieving rma array from previous page
$rmarequest = $_POST['rma'];

//retieves using name from cookie
$username = $_COOKIE['ID_my_site'];

//retrieves order number from cookie
$ordernumber = $_COOKIE['order'];


//creates rma number
$rmanumber = rand(1000, 999999);

//retrieves accountid from database using the username
$getid = mysql_query("SELECT AccountID FROM users WHERE username = '$username'");
$id = mysql_fetch_array( $getid );

//takes the value of $id
$final = $id['AccountID'];


//suppose to loop through all values for the array created by $request on the previous page and insert into database

foreach($rmarequest as $key){


// $insert = "INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('".$rmanumber."', '".$AccountID."','".$key."','".$ordernumber."')";
//mysql_query($insert) OR die(mysql_error());


//this is test to see what is being passed to mysql server
$insert = "INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('".$rmanumber."', '1','".$key."','123')";
 //mysql_query($insert) OR die(mysql_error());

//to view what $insert is passing to the data base.
echo $insert;}
*/


//THIS SECTION IS TEST ONLY

//test array
$cars[0]="Saab";
$rmarequest[1]="Volvo";
$rmarequest[2]="BMW";
$rmarequest[3]="Toyota";


//creates rma number
$rmanumber = rand(1000, 999999);


foreach($rmarequest as $key){

//this is test to see what is being passed to mysql server
$insert = "INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('".$rmanumber."', '1','".$key."','123')";
 mysql_query($insert) OR die(mysql_error());

//to view what $insert is passing to the data base.
echo $insert."<br />";
}

?>

Included is a copy of the table and the php code above.

(I looked at the appropriate forums to put this in, but it seems I couldn't find a forum section specifically for this problem)

Yesterday PHP on WAMP was working perfectly. So I shutdown the computer, go to sleep, and wake up and turn WAMP on. But for some odd reason, when none of my PHP files are loading properly. It just shows all the code as if it were a .txt file.

Any reasons for this?

I keep trying to install every wordpress, or php web server software I can find, the lastest being WAMP. Nothing ever works. I feel like a complete retard here being that I can't even set up a stupid program, to be ABLE to program myself. Everything I install gives me a 404 not found error when I try to load the admin index page to a browser. I honestly have no friggn clue what is going on, I know syntax pretty decently for a lot of these languages, but as far as setting them up, I might as well just shoot myself. I know they can't make it any easier with these step by step tutorials, but it just doesn't seem to work on my comp.

Each time i try to open WAMP's phpmyadmin so i can create a database it has this ERROR


#1045 - Access denied for user 'root'@'localhost' (using password: NO)

how do i fix it

Code: [Select]
<?php
exec('java -jar/MicroChatServer.jar',$output);
print_r($output);
?>
Hello frds.........
I have chat prg. jar file and I have to integrate this chat in a PHP website uses Wampserver....
I try above code but it display "Array()" instead of execute jar file.

What should I do????
Any idea?????????????//