I have a csv file and I am not sure how to set dates on it... For example, if somebody submits a form and its information shows up in the csv but has a date that shows when it was submitted... Can someone help me with this?
**@<MICHAEL>** >For example, if somebody submits a form and its information shows up in the csv but has a date that shows when it was submitted... Can someone help me with this? You need to used this `STR_TO_DATE(str,format)` function to get the date: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_str-to-date Then you can Select yourDateColumn from … Read More
**@<MICHAEL>** >Is there a way to do this purely out of php because for some odd reason I can't connect to mysql with DreamWeaver? NO Here is a link to connect to DreamWeaver: http://helpx.adobe.com/dreamweaver/kb/connect-mysql-database-dreamweaver.html and another example: http://kb.mediatemple.net/questions/29/Dreamweaver+-+PHP%7B47%7DMySQL+Configuration#gs Read More
Work through your problem with DW - or simply stop using it - there are plenty of great free-to-use editors/IDEs out there. Using php without a DB but still needing storage is v.difficult. You have to rely on CSVs, textfiles, XMLs etc. Highly inconvenient. Have you searched the php manual … Read More
Do you have a cPanel setup? If so, there should be a way to connect to your DB remotely as you can provide your own IP addresses. Read More
Edited by diafol
Are you able to help answer this sponsored question?
Questions asked by members who have earned a lot of community kudos are featured in order to give back and encourage quality replies.