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

Run command prompt commands from PHP page

In this video I have shown how you can run command prompt commands from PHP page. shell_exec(‘ ‘) can be used for executing cmd commands from php page. The below image shows the ipconfig/all command executed from my pc. We can run the same command from PHP page. The code is as below. <?php $out=shell_exec(‘ipconfig/all’); …

Continue reading

Download Youtube Videos using Command Prompt CMD

Now you can download youtube videos using command line commands. This will work in any platform like unix, linux and windows. To demonstrate the downloader in windows we have to download an executable exe file from below link or their website. Download youtube-dl here. youtube-dl.rar Steps to Download youtube Videos 1. Download the youtube-dl and …

Continue reading

Connect to remote MySql database using Command Prompt

In this video I have shown how to create an online free MySQL database for testing. How to create remote MySQL database. How to connect to remote MySQL database. As per in this example. We can connect to MySQL with the below command line argument. Open CMD and First navigate to location where you have …

Continue reading