CSV is a very important file types to save mass amount of similar types data. Sometime to save those data from CSV file in PHP is an important task. So I am sharing a complete script to read data from CSV and save it in your data with PHP & PDO. Write your comments if this works for you.
Tag: mysql
Firstly, You need to install Google Cloud SDK and check if you have gcloud command available in terminal. After installing gcloud you need to configure gcloud sdk by running gcloud init command. Secondly, I am assuming, you have configured your Google Cloud SQL instance for your project. If yes, then continue, otherwise you need to read “Google Cloud SQL Quickstarter Guide“. Now Download cloud_sql_proxy.linux.amd64 package in your local machine with "sudo wget https://dl.google.com/cloudsql/cloud_sql_proxy.linux.amd64" this command. Thirdly, Rename by mv cloud_sql_proxy.linux.amd64 cloud_sql_proxy …