Import excel file which includes multiple sheets using PHP into Mysql Database
In this project we are uploading an Excel file with multiple sheets to MySQL database. We are reading the PHP file with the help of PHPExcel class. The project Structure is as shown below. You can download the complete project here. UploadExcelmysql 1. Create the MySQL table inside be DB. As we are saving the …
PHP Read CSV file and insert 10 million record into MySQL table
Here we are trying to read a CSV file with 10 million records with PHP and insert the values in MySQL table. In the video I have shown step by step how do I added this much records instantly. It took only 15 minutes to insert 10 million rows to the DB. 1. So first …
note: previous implicit declaration of ‘point_forward’ was here [SOLVED]
In this video I have shown how you can solve ‘note: previous implicit declaration of ‘point_forward’ was here’ Also the issue ‘incompatible types when assigning to type’. As shown in the video, The error was thrown on compiling the code. #include “stdio.h” struct mystruct { int item1; int item2; }; void main() { struct …
MySQL server is running with the –secure-file-priv [SOLVED]
In this video I have shown how you can solve the error “MySQL server is running with the –secure-file-priv”. This example is shown in Windows 10 PC. 1. How to see the default MySQL uploads folder. The error comes because MySQL is limiting the upload file from only one specific folder. To see the current …
Export MySQL table To Excel or CSV without any Software
In this video I have shown how you can export a MySQL table to excel or CSV without any third party software. All you can use CMD prompt to export export the table. 1. First login to your MySQL database through command prompt. You can check below link to see the steps for that. https://chillyfacts.com/connect-remote-mysql-database-using-command-prompt/ …
Best Mysql Client for Windows
In this video I have shown the Best MySQL client for windows PC. Please see the video to see how to manage the databases. Download the 32 bit here HeidiSQL_11.3_32_Portable.zip Download the 64 bit here HeidiSQL_11.3_64_Portable.zip Login screen will look like below screenshot, Enter the username and password to login. After Login you can see …
Earn Money by adding captchas in websites
In this video I have shown how you can earn money by adding captchas in your website. In this example I have shown with JAVA JSP as my webpage. You can use the same method for any front end technologies. You can download the source code I have shown in the video here solvemedia.zip
How to create a CSV file using PHP easily
In this video I have shown how to create a CSV file using PHP. The example is shown with the help of XAMPP server installed in windows 10 PC. The below code can be used to create a CSV file. <?php header(“Content-type: text/plain”); header(“Content-Disposition: attachment; filename=jinu.csv”); echo ‘”jinu”,”jawad”,”one”,”two”‘.”\n”; echo ‘”jinu”,”jawad”,”one”,”two”‘.”\n”;; echo ‘”jinu”,”jawad”,”one”,”two”‘.”\n”;; for ($x = …
Read a CSV file using PHP
In this video,I have shown how to read a CSV file using PHP. 1. Below code can be used to read the CSV file and show it exactly as a table in the PHP page. <?php echo ‘<table border=”1″>’; $start_row = 1; if (($csv_file = fopen(“F:\\readcsv\\country.csv”, “r”)) !== FALSE) { while (($read_data = fgetcsv($csv_file, 1000, …
How to open any File in Java
In this video, I have shown how you can open any type of file using java. Code is shown below. package test; import java.io.File; public class open_file { public static void main(String[] args) { String path = “E:\\jinu.txt”; File file = new File(path); try { if (file.exists()) { Process pro = Runtime.getRuntime().exec(“rundll32 url.dll,FileProtocolHandler ” …