External SQL Query

[bittyboy]

Hi,

We have been using zen cart for a few years now and always been happy with it. As we use it to book events alot of our pages that advertise each event are outside of the zen cart enviroment.

What im hoping to be able to do is show or echo the places / prodcuts remaining for each ID within each external page. Im happy that I would have to add this eash time I made a event page but would be so much better than me having to knock the places off each time manually.

I know it's a case of connecting to the database but not 100% sure of the sql or php query. Can anyone help me on this please ?

Thanks
Nick

[yellow1912]

It really depend. If the other sites are on a different servers, for security purpose most hosts often lock down external access to mysql server. You can add your external sites to the "safe list" but this is not recommended.

Let us know if these sites are on the same server or not. We have different solutions for different cases.

[bittyboy]

Hi yellow1912 and thank you for the quick response.

Yes it is all on the same server. Had dealings myself in the past trying to get info from another domain and our hosts do have that locked down but I can see why.

Thanks again
Nick

[yellow1912]

Great. There is one thing I forgot to ask, you say you want to "show or echo the places / prodcuts remaining for each ID", what does it mean? Something like: product 127 has 2 items left?

[bittyboy]

Hi again yellow1912,

I hope you don't mind but im going to send you a PM as I don't really want to publicise the domain and directories, I do hope anyone else reading this is not offended.

Basically all we need is for it to echo the number available for that ID and nothing else.

Thanks again for your time in this matter
Nick

[yellow1912]

Sure, PM me.

Regards

[bittyboy]

PM Sent ;)

[bittyboy]

I sent a private message to yellow1912 and he was very very helpful.

He basically ended up creating the script for me and spent the a good part of the day doing so.

For anyone that might be interested in a similar script to show the amount of products available outside of Zen Cart here it is.

<?php
define('IS_ADMIN_FLAG', true);
define('ZC_ABSOLUTE_PATH','/your/path/here/to/includes');
require(ZC_ABSOLUTE_PATH.'includes/configure.php');
require(ZC_ABSOLUTE_PATH.'includes/database_tables.php'); // set your path here
require(ZC_ABSOLUTE_PATH.'includes/classes/class.base.php'); // set your path here
require(ZC_ABSOLUTE_PATH.'includes/classes/db/mysql/query_factory.php'); // set your path here

$db = new queryFactory();
$db->connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE, USE_PCONNECT, false);

function get_quantity($id){
global $db;
$row= $db->Execute("SELECT products_quantity FROM ".TABLE_PRODUCTS." WHERE products_id =".$id);

return $row->fields['products_quantity'];
}

echo get_quantity (12); //product id in here
?>

Thank you for your time once again yellow1912