Currently I am booked, so unable to take on new projects, but I do not mind discussing issues and such here in the forums.
I watched the video on youtube, and it looked promising. Particularly when it comes to using Woocommerce within Livecode. At the same time, I am not a big fan of writing external applications to integrate tightly with a CMS like Wordpress or Joomla. The reason is that CMS's are updated on a regular basis and it can happen that an update might break the external application....so now I amhaving to track down the changes and update the external app to match recent WP updates..
A slightly different approach I have been taking is to add my own tables to a Wordpress database, and then access those tables from within the Wordpress website when I need to pull out some data. Wordpress makes this fairly easy to do if the data is in the same database, using global $wpdb. Wordpress handles the authentication, so you just have to write a query like:
Code: Select all
global $wpdb;
/*Query the database and get the data from your tables */
$results = $wpdb->get_results(
"YOUR QUERYYOURTABLE.field
FROM whatever AS SOMETHING
INNER JOIN SOMETHINGS
LIMIT 12",
ARRAY_A
); ?>
<ul class="data">
<?php //echo $results[0]['field']; //can grab data outside of loop ?>
<?php //or loop through the results to get a string to return
foreach($results as $result) :
//id of the record
$data_id= $result['id'];
bla bla ?>
..so, with some tables that are not part of the main Wordpress environment, I can store and retrieve data in the Wordpress website. I can even relate these tables to existing wp_users if I need, while still keeping them outside of the Wordpress structure.
Now I can use Livecode to access those external tables, and write whatever app is needed ( for example, an admin app to manage that data)....without fear of a Wordpress update breaking my external app. In fact, I could even ditch Wordpress entirely and use some other web application...or ditch Livecode and use something else to manage the data.
Keeping the database tables you will be using separated from Wordpress tables, and then working directly with those tables in your app can be a manageable way to integrate Livecode and Wordpress without having to manipulate Wordpress overly much.
..in my opinion.