PHP & AJAX shopping cart

Shopping cart based on the free script:

[url removed, login to view]

The cart shall be built in php, but be able to include into my site though ssi (server side include)

The script shall work together with our existing sql database witch contains product names and SKU.

When the user have filled out the information the info shall be sent to us and a confirmation to the client. The info shall be stored in the mysql database.

Further more we will need a php script, that will read out these info from the database.

Please see below :

Script for extracting qoutes from mysql. Further more there shall be coded a script that will be able to take the stored info from the mysql database and make a xml file that can be downloaded by our software. See below info : Per our conversation yesterday I’m sending a sample XML file that we could use to import web requests into Quotation section in the software The file can contain one or more requests. Each request consists of customer and event sections nodes as well as list of nodes for products requested. You can add mode fields to this format if you collect more information from the web users. The web script that will work with the software will have the following functionality 1. Software will send a request to the server such as [url removed, login to view] (the actual link can be anything) 2. The server will connect to your mySQL database and return XML output with the list of last 10 requests listed in descending order 3. If Software sends requests with LIMIT parameter [url removed, login to view] then the server will return the last 100 requests from the database

4. If Software sends requests with LIMIT & RID parameters [url removed, login to view];limit=5 then the server will return 5 requests from the database starting from request id 1234 (each request has unique id stored in rid field) This should be fairly easy to implement. Please ask the IT person to contact me if he has any questions or need more details. We need to prevent access to this script by sending out secure authentication key with every request or he can configure the server to accept requests to this web script only from your office if you have dedicated IP address in your office.

XML file :

<?xml version='1.0' standalone='yes'?>

<RentalRequest>

<Q6969>

<Customer>

<name>carolyn anastasio</name> // Kontaktperson (Step3)

<company></company> // Firma / Forening (Step3)

<b_address>PO Box 12233</b_address> // Adresse (Step3)

<b_city>Los Angeles</b_city> // By (Step3)

<b_zipcode>12345</b_zipcode> // Post nr. (Step3)

<b_state>CA</b_state> // Land (Step3)

<s_name>Hotel main </s_name> // Navn (Step2)

<s_address>1553 S Main St</s_address> // Adresse (Step2)

<s_city>Glendale</s_city> // By (Step2)

<s_state>CA</s_state> // land (Step2)

<s_zipcode>43222</s_zipcode> // post nr (Step2)

<phone> 60202015 </phone> // telefon (Step3)

<cellphone>20202015</cellphone> // mobil (Step3)

<email></email> // email (Step3)

</Customer>

<Event>

<date>6/30/2008</date> // start dato ( step1 )

<start_date>6/30/2008</start_date> // start dato ( step1 )

<start_time>04:14 PM</start_time> // start tidspunkt ( step1 )

<end_date>6/30/2008</end_date> // start dato + antal dage ( add number of days in Antal dage to Start date = End date, if 1 in antal dage end date is same as start date, if Slut tid (end time) is before 23.59)

<end_time>05:14 PM</end_time> // slut tidspunkt ( step1 )

<RequestNo>Q6969</RequestNo> // Q6000+1 each new qoute

<comment></comment> // Bemærkninger textbox ( step 4 )

<user> Funtastic .dk</user>

<adendums> (Ring kunden op) (Send tilbud på mail ) </adendums> // Ring kunden op ( add this text if selected in Step 4)

</Event>

<Product>

<sku>PPPS1</sku> // Rent_ID in database

<product>Party Supply 1</product> //Product name

<qty>4</qty> // qty

</Product>

<Product>

<sku>PPPS2</sku> // Rent_ID in database

<product>Party Supply 2</product> //Product name

<price>$2.75</price> // qty

</Product>

</ Q6969>

</RentalRequest>

See attached pdf document for full info.

When accepted i will sent the sql file, the ajax script that shall be modified, the design files etc.

AJAX PHP

Proje NO: #625945

Proje hakkında