Press enter to see results or esc to cancel.

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/ …

Continue reading

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 = …

Continue reading

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, …

Continue reading

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 ” …

Continue reading