Home \ Files \ PHP Scripts \ Project Management Tools \ Export CSV \

Export CSV

Has been a member for 3-4 years
Bought between 100 and 499 items

Bernhard says

Very good idea. Why not also import with csv ??

Bernhard:-))

3 years ago

Author

robertbanh replied

That’s a good point. But importing data would only work on simple database systems. Once you start adding foreign keys and dependencies, then it becomes impossible to do track… a standard script would add the necessary logic, which is beyond the purpose of these simple small apps.

3 years ago

Has been a member for 2-3 years
Bought between 10 and 49 items

rjjacob says

Purchased

Great, simple and adaptable! And excellent support, too! Kudos to you Robert.

3 years ago

Has been a member for 3-4 years
Exclusive Author
Bought between 1 and 9 items

PHPerfect says

When I export something, it does not looks nice… There is no table displayed, only alle the information behind eachother separated by komma’s.

3 years ago

Author

robertbanh replied

Yes, that’s what a CSV file is… comma separated value. If you have MS Excel installed on your system, then you can open the CSV and it will display the data in nice table format… else it’s just raw data text file.

3 years ago

Has been a member for 3-4 years
Bought between 1 and 9 items

JohnsBeharry says

Looks good man

3 years ago

Has been a member for 3-4 years
Bought between 50 and 99 items

scandic says

Purchased

Hi Robert

Love this script simple to install and execute – Question : can I preview the entire table instead of just 5 columns?

Thanks for an excellent script – I encourage others to buy this!

Scandic

3 years ago

Author

robertbanh replied

Yeah, I think you can preview the full table… there isn’t a limit setting… maybe in the sql query but nothing in the php code that limits the results or columns.

3 years ago

Has been a member for 2-3 years
Bought between 1 and 9 items
Germany

Q24-Design says

Purchased

Nice Script. But i dont get it to work with a sql query like “SELECT * FROM mytable WHERE id = “1”

Please help.

2 years ago

Author

robertbanh replied

I believe you have to use single quote in mysql… so select * from mytable where id = ‘1’

2 years ago

Has been a member for 2-3 years
Bought between 1 and 9 items

mariegale says

Purchased

This was the best $7 I’ve spent in a long time. Thanks so much for the clean, clear, easy to use code.

2 years ago

Author

robertbanh replied

Thanks! If you need any help, shoot me an email: robertbanh [at] gmail [dot] com

2 years ago

Has been a member for 2-3 years
Bought between 1 and 9 items

sanne says

Very good idea. Why not also export to xml, rss ?

2 years ago

Has been a member for 2-3 years
Bought between 100 and 499 items
United Kingdom

cfoinfo says

Purchased

Can you provide an example of the csvaction.php code that does not require the front-end form to be filled in?

e.g.

1. I have a page in my app with a link/button that calls csvaction.php when clicked.

2. All the connection info and the query sql have been preset in the csvaction.php page.

3. So the result is that onClick the user just downloads the CSV file and doesn’t need to know/fill in the data in the front-end form.

This way your script can be called from any page where I want to add a CSV download function, making the script more useful.

2 years ago

Has been a member for 2-3 years
Bought between 100 and 499 items
United Kingdom

cfoinfo says

Purchased

Rob

Thanks for your help by email, your answer below solves my problem.

In csvAction.php, you can fill out line 9-14… and remove line 18-29.

2 years ago

Has been a member for 4-5 years
Bought between 100 and 499 items

datoshway says

Purchased

Getting an error when using this. Parse error: syntax error, unexpected ‘{’ in xxxx/export-csv/csvAction.php on line 39

2 years ago

Has been a member for 2-3 years
Exclusive Author
Bought between 10 and 49 items

eberswine says

Purchased

ERROR ! Please fix!

Getting an error when using this. Parse error: syntax error, unexpected ‘{’ in xxxx/export-csv/csvAction.php on line 39

1 year ago

Has been a member for 2-3 years
Exclusive Author
Sold between 1 000 and 5 000 dollars
Bought between 1 and 9 items

robertbanh says

Author

Sorry, I noticed the error only exist for users running PHP4 . I have a patch for it… just shoot me an email by submitting a form on this page: http://codecanyon.net/user/robertbanh

I don’t get notify of new comments on this thread (a feature lacking from CodeCanyon). Sorry.

1 year ago