Category: PHP-MYSQL TIPS
How to convert date in string to date in date datatype in PHP
- 0
I was working on a Web portal, where there was a use case to import the csv or xls to a MySql database. In the database there was a field for date with the date data type. And from the xls or csv when we are importing , it imports as the string. So when…
Read MoreDirectory Separators Ignored on Inserting into mySQL
- 0
Hi, I faced a problem while inserting the file path to mysql database. You can also encounter similar problem when you work with Mysql. So thought of adding this info for your information. While inserting a file path to my mysql table, I noticed that the slashes in the path are missed once they added…
Read MoreParagraph Retrieval from Mysql
- 0
Greetings of the Day!!! When I was working with one of the website Designing, I noticed a strange problem. May be it’s not a problem. But for a developer it looks like a problem. Many of us can come across such issue. So I thought of penning down the known solution for it. When you…
Read MoreSending Sqlite data of Android APP to Mysql database in PC
- 0
While I was working on a project which includes the transfer of data stored in sqlite database of Android APP to a Mysql database in PC, I searched over the web about how to do it. I could find some info about it here and there. But nothing concrete. So I thought I will put…
Read More