I have the php which can import the csv files into mysql. But how to avoid the wrong data replace the data database. What is the code in php for checking before insert into the database? Thanks!
cliffcc
0
Junior Poster
Recommended Answers
Jump to PostYou can use mysql_real_escape_string function before inserting data in mysql.
http://in2.php.net/manual/en/function.mysql-real-escape-string.php
All 3 Replies
vibhaJ
126
Master Poster
You can use mysql_real_escape_string function before inserting data in mysql.
http://in2.php.net/manual/en/function.mysql-real-escape-string.php
cliffcc
0
Junior Poster
I still have no idea? any example? Since it is csv file, how can i extract the data and check?
vibhaJ
126
Master Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.