# Problem with Flash/PHP Webstore

**URL:** <https://forum.kirupa.com/t/problem-with-flash-php-webstore/87504>\
**Category:** programming\
**Created:** [April 21, 2005, 3:30pm UTC](https://forum.kirupa.com/t/problem-with-flash-php-webstore/87504 "2005-04-21T15:30:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tiauguinho](https://avatars.discourse-cdn.com/v4/letter/t/c6cbf5/32.png) [@Tiauguinho](https://forum.kirupa.com/u/Tiauguinho)\
**Post date:** [April 21, 2005, 3:30pm UTC](https://forum.kirupa.com/t/problem-with-flash-php-webstore/87504/1 "2005-04-21T15:30:18Z")

</div>

Hello to you all!

First post on Kirupa, so I’ll try to make it as good as possible!

I’ve been developing a webstore for my own tiny business. I’ve decided to go with Flash as the frontend and PHP/MySQL making all the stuff behind it. It all works, products are stored on MySQL, all pretty and neat… until I hit the wall of session\_id (Mind you, im not a professional developer/webdesigner).

I’ve done all my code without even thinking on the user side itself… That is, when I went to try the store and it all worked it passed my mind that if another user would be on it, he would see my cart and I would see his… MAJOR mistake…

I did a search around and found that session\_id would be the answer to my problems. But then I got to another problem related to this… how do I integrate it on my flash?

Currently all the logic of it is:

1. User goes to store, loads one product section and selectes add products:

This code is then sent via AS:

loadVariables(“[http://www.sanum.com.pt/addcart.php?ref="+ref+"&desc="+desc+"&price=](http://www.sanum.com.pt/addcart.php?ref=%22+ref+%22&desc=%22+desc+%22&price=)”+price,this);

1. addcart.php contains this:

\<?php  
include “common.php”;  
$query=“INSERT INTO cart (ref, desc, price, user) VALUES (’$ref’,’$desc’,’$price’,’$user’)”;

$result = mysql\_query($query);  
?\>

1. Lets Imagine that this product is everything that the user has and he procedes to finalize his order, so he clicks the cart (which will show the product list)

Cart is called:

loadVariables(“[http://www.sanum.com.pt/cart.php](http://www.sanum.com.pt/cart.php)”,this);

Displayed via:

// Function for Cart, attaches nest movie clips with the products  
nextX = 0;  
nextY = 0;  
alien = 70;  
special = -1;  
function getMembers() {  
loader.removeMovieClip();  
//resets variables of \_x and \_y locations and depth (alien)  
nextX = 0;  
nextY = 0;  
alien = 70;  
//rotates depth  
alien++;  
for (count=0; count\<countHigh; count++) {  
content\_mc[“member” add count].removeMovieClip();  
}

```
//everything loads into members MC
//loop starting, countHigh=number of entries, received through PHP
for (count=0; count&lt;countHigh; count++) {
	// Attach a member MC to the canvas
	content_mc.attachMovie("nest", "member" add count, alien++);
	// Set X and Y positions for memberclip MC
	content_mc["member" add count]._x = nextX;
	content_mc["member" add count]._y = nextY;
	//set variables, textfield values on memberclip button MC
	//on the left is path to text fields, on the right is variable received from PHP
	content_mc["member" add count].desc = this["member" add count add "desc"];
	content_mc["member" add count].ref = this["member" add count add "ref"];
	content_mc["member" add count].price = this["member" add count add "price"];
	content_mc["member" add count].userID = this["user" add count add "ID"];
	finalprice += Number(this["member" add count add "price"]);
	content_mc["member" add count].quantity = this["member" add count add "quantity"];
	//adds _y value for nextY so other MC's can be nested
	nextY += Math.round(content_mc["member" add count]._height+special);
	alien++;
}

```

}  
getMembers();

I’m sincerely lost… Any help on applying session\_id to all this would be an amazing help. I already asked some friends for some help, but none of them are PHP masters.

Mind you that im a total newbie… Anything that I left out that might be relevant for solving this problem, please dont hesitate to ask.

Thank you so much to you all in advance,

Regards,

Tiago
