Adding products from website form (not from admin)

Hi,

I have zencart installed in a subdirectory (public_html/trades/) of a domain, I also have a website on public_html/.

I want to use the website to collect data using a form which will post the data to zencart as a product.

I have been struggling with it for a while and am having a problem with a few things and hoped that someone maybe able to help me.

Whats happening is when the form is processed it runs a mysql statement:

Code:

---

$query = "INSERT INTO zen_products (products_model, products_quantity, products_image, products_date_added, products_status) VALUES ('$model','3','product.jpg', NOW(), '1')";
$query = "INSERT INTO zen_categories_description (categories_name) VALUES('$county')";

---

What im having dificulty with is the categories bit. It will put put the data into the categories_name, but it will duplicate the category name and it doesnt show in admin > categories/products either.

I am presuming that I need to post the categories_id instead of the categories_name, but I have no idea how to set that up on my form processor.

I have tried using an array but thats not working either:

Example:

Code:

---

$county[Dublin]='1';
$county[Roscommon]='2';
$county[Galway]='3';
$county[Westmeath]='4';

---

I have no idea where to go from here. I will keep trying, but if anyone has a solution or can point me in the right direction, i will be their best friend :)

dropbop

OK, so i have managed to get this kinda working to an extent where in admin you can see that x category has x number of products, but when you open the category in admin, it doesn't show the products.

I know im getting closer, but I think I need a little help from here. Is there another entry to the database needed to make the products show on the website?

Here is where i am at so far:

Code:

---

<?php
$dbhost = "localhost";
$dbname = "xxxxxxx";
$dbuser = "xxxxxxxx";
$dbpass = "xxxxxxxx";

mysql_connect ($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

$name=$_POST['name'];
$email=$_POST['email'];
$telephone=$_POST['telephone'];
$address=$_POST['address'];
$size=$_POST['size'];
$material=$_POST['material'];
$handrail=$_POST['handrail'];
$description=$_POST['description'];
$timeframe=$_POST['timeframe'];
$budget=$_POST['budget'];
$termsagree=$_POST['termsagree'];
$date= date("F j, Y");
$model = time();
$processed=$POST['processed'];
$county=$POST['Dublin']='1';
$county=$POST['Roscommon']='2';
$county=$POST['Galway']='3';
$county=$POST['Westmeath']='4';

$query = "INSERT INTO zen_products (products_id, products_model, products_quantity, products_image, products_date_added, products_status, master_categories_id, products_price, manufacturers_id) VALUES ('$model', '$model','3','product.jpg', NOW(), '1','1', '4', '0')";
//$query = "INSERT INTO zen_products_description (products_id, language_id, products_name, products_description) VALUES ('$model', '1', 'Decking Quote Request', '$description')";
//$query = "INSERT INTO zen_products_to_categories (categories_id) VALUES ('$county')";
mysql_query($query) or die(mysql_error());
mysql_close();
?>
<?php

mysql_connect ($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

$query = "INSERT INTO zen_products_to_categories (products_id, categories_id) VALUES ('$model', '$county')";
//$query = "INSERT INTO zen_products_description (products_id, language_id, products_name, products_description) VALUES ('$model', '1', 'Decking Quote Request', '$description')";
//$query = "INSERT INTO zen_products_to_categories (categories_id) VALUES ('$county')";
mysql_query($query) or die(mysql_error());
mysql_close();
?>

---

I really could use a few pointers here :cry::cry:

:D All fixed now!

The problem was, I had a sql statement that was INSERTing to the categories_description table, but took it out earlier while troubleshooting, but put it back in and it seems to work fine now.

So now I can use a public php/html form to add products to my zen cart...

If I get some time later I might make a post on how I did it. Not sure if anyone is even interested in this way of adding products, but you never know.

Actually, is you are interested, hit the reply button to me to show your interest and I will then create a test site showing what happens and will post a how-to on this forum too.

That would be an amazing option I would love to use it, Please please post.

Glad your interested in it shanesoine :)

I will do up a post in a few days for it.

Basically, what I was trying to achieve is to be able to let people add their own products to my cart using a web form which inserts the results to my zencart database.
I am using it for a service where people post their details about a project they want to get a quote for, the details are posted on the zen cart site where the details of the job are shown to service providers who are interested in quoting for the job. When a service provider purchases the details to quote (the product) the full details, including contact details will be available to them so they can contact the potienial client and provide them with a quote. Each "product" has a quantity or 3 so only 3 service providers can purchase the full details.

Im still workign on it, but you can have a test of it here before I add the captcha:
This is the main site where people add details of the work they want done: http://timberdecks.ie
Then go here http://www.timberdecks.ie/trades/ this is the zen cart site where service providers will purchase quote requests.

Like I said its still not complete, but should let you have a glimps of it working.

Hopefully I will find some time to get back here in a few days and post some sort of how-to.

Anyway, I better get back to it or I will never get anywaywhere LOL

Oh and Happy Mothers Day to all the Mothers on here!! :) (Dont know about the rest of the world, but its mothers day here in Ireland)

I'm interested in that. Can you show how it's done?


Thanks

Kevin

Hi Kevin,

I will be psoting a how-to here in a few days.

The code will be from the way I have it set up, so it will need to be altered slightly for different set-ups. For example, I dont use the Auto increasment to set the ProductID in the database, My form sends a unique priductid every time its submitted - my productID is also the same as my model field. I wont ever have to add a product from the admin (it is all works as it should) so i dont need to use the auto increasement on the productID. But im sure with a little tweeking, I could set the admin side to post the productid as the form on my website does.

Anyway, ill be back soon with the how-to :)

Quote:

---

Originally Posted by dropbop

Hi Kevin,

I will be psoting a how-to here in a few days.

The code will be from the way I have it set up, so it will need to be altered slightly for different set-ups. For example, I dont use the Auto increasment to set the ProductID in the database, My form sends a unique priductid every time its submitted - my productID is also the same as my model field. I wont ever have to add a product from the admin (it is all works as it should) so i dont need to use the auto increasement on the productID. But im sure with a little tweeking, I could set the admin side to post the productid as the form on my website does.

Anyway, ill be back soon with the how-to :)

---

Hey dropbop, I just thought about something. If you have it set to send a "unique or random" id along, then depending on how you have the unique field setup, you'll need to be certain that it wouldn't generate a product id that already exists.

Now, I can see that if you start after the "highest number" id count and set it for after that point, but it has to somehow do a validation back to the id field.

I can see this being very useful as it has been constructed so far by you. If I can help out in any way, just me know and I'll see what I can do. But I definitely want to check it out once you're completed your starting point.

Kevin

thats great news - sure tweeking will challenge me I want clients to be able to use their used books on our site and track their credits.Looked at the affiliates program but could not see a way to fit it to our needs looking forward to your post. OO and thanks for the Mothers Day greeting:smile:

Shane

I wonder if this would be vulnerable to SQL injection or other hacks... If you used some of the built-in Zen Cart db functions, you could probably be sure of safety.

Quote:

---

Originally Posted by TesterServers

Hey dropbop, I just thought about something. If you have it set to send a "unique or random" id along, then depending on how you have the unique field setup, you'll need to be certain that it wouldn't generate a product id that already exists.

Kevin

---

Its actually very easy, i use the php time() which generates a unique 10 digit number every second (or maybe every millisecond, who knows).

Code:

---

$model = time();

$query = "INSERT INTO zen_products (products_id, products_model) VALUES ('$model', '$model')";
mysql_query($query) or die(mysql_error());
mysql_close();
?>

---

So, to give an example: at 21:44 I submitted and form and got the product_id and products_model of '1301949811'
at 20:45 i got 1301946292
at 20:33 i got 1301945598
etc etc

As you can see here, to make things easier on myself, I also use the time() to generate my model numbers which is very handy and keeps things nice and neat for me.

What I have also just added to the whole thing is a downloadable txt file which is also named by

Code:

---

$model.'.txt'

---

and saved to a downloads folder which contain the full details of the quote request (not just the few basics you see on the zen site).

So now when a form is submitted, it will 1) create a product, 2)create the attribute (download), 3) create the download txt file for the attribute. 4)Send an email to the person who filled in the form with the details they submitted & 4) send me an email with the details.

Ive never done anything like this before, mainly just templates so this is all a first for me. But I can tell you, I have learned so much and I dont think I have ever been on as many php forums in my life trying to figure stuff out. lol Well worth hte effort though.

DB

Quote:

---

Originally Posted by gjh42

I wonder if this would be vulnerable to SQL injection or other hacks... If you used some of the built-in Zen Cart db functions, you could probably be sure of safety.

---

The way it is now, it would be.
Once I get it working the way i want, then I can start adding any safety features... probably a good captcha should do the trick and place a database connect file in a different location.

I will say tho to anyone who does try this out (when i get it up here) not to overlook security one bit. It doesnt take alot of effort to make things secure, and there are plenty of different methods of doing it. So be warned, use it or loose it sister!! :lamo:

Quote:

---

Originally Posted by TesterServers

I can see this being very useful as it has been constructed so far by you. If I can help out in any way, just me know and I'll see what I can do. But I definitely want to check it out once you're completed your starting point.

Kevin

---

Give it a test if you like :)

Form is on www.timberdecks.ie

Submit that, then go on over to www.timberdecks.ie/trades/ (remember what 'county' you choose on the form because it will also be the category its in on zen)

If you want to properly see how it works, choose the product named the same as yours (will be in the email you get after submitting the form), purchase it, then open the download from the order history page in my account.

I have the cheque payment method active for testing and is set to 'delivered' so download should be available straight after you complete checkout.

Sorry i have not gotten back to this yet, been very busy, but will update soon :)

DB

Sorry to anyone who was waiting on an update here about the above... I got side-tracked (very side-tracked)..

I have been working on the script again adding some protection against sql injection and the likes, and will hopefully have some sort of package put together which can be downloaded. The package will not be just the form on the home page as it was, it will more than likely be a full website package for starting your own quoting service.

The demo site is no longer available on the url I posted in previous posts, but I will upload the project to a new domain at some stage for people to play around with.

If anyone has any ideas they would like to see put into it, i would love to hear them and consider adding them to it where possible.

Cheers,

Droppy!