Sourcegeek

Sourcegeek supports this item

Supported

37 comments found.

Hi,

Why use your script and not directly json_encode ?

Thanks! Mick

Hi,
The Item Details page explains the functions that this Class has, which json_encode don’t :)

Thanks

hello,
  I have a classifieds site, I need to generate a JSON with ads.   This JSON will be for mobile applications view the ads.

  It really is this class that I need? I understand that it creates a JSON with the fields of a table.  

  I’m sorry, I’m noob in PHP and JS Errado?

I thought the class generates the .json file (and not only the text in standard json).

  Still going to help me, thank you.

Do you know how do I create a file .json that updates content automatically?   Currently I use your script to generate the code and I need to create a file manually to enter the content.

  Thank U!

Hi
Please send me an email at support@sglancer.com, I’d be glad to help you.

Thanks :)

Hi, this would be what I’m looking for. As for examples I do understand I can use a query on SQLtoJSON, but is the class capable to execute a query even for POST requests (JSONtoSQL)? Example I would like to rewrite a Sold-out flag, or decrease the stock amount on a single product page.

Hi
Unfortunately, I think this won’t work for you. This class is not capable of making MySQL Queries like that, it works more like a import/export class.

Thanks

Hi,
If you remove the first 4 parameters (page, limit, explicit and has_more) yes, MyJSON would be able to import that JSON.

Does your code has logic to omit 4 parameters? or skip them

Hi
Please send me an email at support@sglancer.com. I’ll help you to make the code work :)

Hi,

Can your script loads JSON of a key that hast a list of objects as values ? if yes, how should be the structure of the sql table ?

Thanks in advance

Hi.
Please send me an email at support@sglancer.com.

Thanks.

Warning: Invalid argument supplied for foreach() in /home/mednl/domains/xxxxxxxx/public_html/xx/json/myjson.class.php on line 108 Something went wrong:

Send

Hi,
Does your script support MySQLi and PDO ??

Hi,
Currently doesn’t support none of them. But please stay tuned, as it will be updated to MySQLi shortly :)

Best Regards,
Ricardo.

Hi would this product be able to import large and complex json to mysql like this http://konklone.io/json/?id=bd5e4b07c7f66bd91412

if so does it require complex configuration to enable

Hi.

Unfortunately, your JSON syntax is not compatible with MyJSON.

Best Regards,
Ricardo.

get the following error Fatal error: Call to a member function SQLtoJSON() on a non-object <

for

echo $json->SQLtoJSON(“SELECT * FROM dbname”, true);

and

echo $json->SQLtoJSON(“SELECT * FROM dbname”, true);

echo $json->SQLtoJSON(“SELECT * FROM dbname”);

Hi,
That error means that the var $json is not an object of any class.
Please read the documentation to learn how to initialize MyJSON’s object.

Best Regards,
Ricardo.

Hello there, Can we have the created JSON from MySQL to be on a link something like :
http://MyDomainName.com/JSONfiles/data.json
If possible, please tell me how !
Best regards,

Still waiting for a reply … hope that one day, it will finally come !!!

Hi :)
I’m so sorry, I didn’t see your comment

Now, for the question. No, with MyJSON that cannot be done. However, using PHP you have two ways to do it depending on how you want the data to be generated.
  1. If you want to manually generate the data once, you can save it into a file named data.json using the PHPfopen() and fwrite() functions.
  2. If you want to automatically generate the data everytime you go to that link, you can have a PHP file with the needed code to generate the JSON from MySQL, and use a .htaccess file to redirect every data.json request to your PHP file.
Best Regards,
Ricardo.

hello, I can usually a dynamic xml wordpress, to pass this XML data to app in Json?

Hi
This system is designed to export data from MySQL as a JSON code and vice versa. XML to JSON cannot be done, sorry.

Best Regards,
Ricardo.

Am interested in buying this item. My application is built using CodeIgniter, can it work? Thanks

Hi,

Yes, it will work. However, this is not CodeIgniter-ready, so you’ll have to make the integration by yourself.

Best Regards,
Ricardo.

can you integrate it for me?

Hi,

Please send me an email at support@sglancer.com so we can discuss your request and my hourly rate for customizations.

Best Regards,
Ricardo.

I have a pre-sale question, if i understand you… i can extract x form fields to json object and grabbed only passing your function and the other side

Hi.

Could you please be more explicit with your question?

Best Regards,
Ricardo.

Is help .sql data into json format it

Hi.

Could you please be more explicit?

Best Regards,
Ricardo

  • .sql Files can be converted to the * .json

Hi.

No, with MyJSON you can’t convert a .sql file into a .json file. You can convert a result from a MySQL query into a json-formatted code.

Best Regards,
Ricardo.

can i used this to parse json data from mysql to an android app

Hi.

Yes, but it depends on the syntax you’re going to use for your JSON file.
Please send an email to support@sglancer.com for further assistance.

Best Regards,
Ricardo.

hello

i bought the source and i thought its mysqli why u don’t update it ?!

this code is usless

by
by
by
by
by
by