Category: MySql
-
how to copy data from godaddy to aws instance
How to migrate Files from Godaddy to AWS Pretend Domain is laughingadda.com on Godaddy. Login to your GoDaddy account and access cpanel, go to File Manager. Compress your website files (all your files in public_html folder). Now, your filename is example.com.zip Connect to your AWS SSH via Putty or any command terminal. Go to the…
-
Storing and displaying unicode string (हिन्दी) using PHP and MySQL
Sample Script The dump for my database storing hindi utf strings is charset in the HTML Head section set content type in your php script using Mysql Example
-
Insert data into mysql table in php using mysqli method
Create File first.php using form Create file second.php to insert data into table this example show only two fields, you can add more field in php code to insert.
-
convert varchar to int in select query order by
Sql Server query varchar data sort like int MySQL ABS() returns the absolute value of a number.
-
how to add auto_increment in mysql existing table
I have a pre-existing table, containing ‘fname’, ‘lname’, ’email’, ‘password’ and ‘ip’. But now I want an auto-increment column id. However, when I enter:
-
Top 20 Hybrid Mobile App Frameworks
Hybrid Apps Frameworks Introduction : A Hybrid Mobile Application is like any other application that you should be found on your phone or on your hand-held device. A hybrid mobile application can be viewed as the best (or the worst) of both the Native and HTML5 worlds together. The frameworks are neither numbered in order…
-
change mysql password
Stop the MySQL service (Ubuntu and Debian) Run the following command: (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command: Start MySQL without a password Run the following command. The ampersand (&) at the end of the command is required. Connect to MySQL Run the following command: Set a new MySQL root password…
-
Problem with phpMyAdmin and PHP 7.2: “Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable”
It’s possible that when you installed phpMyAdmin, the version in the repository (phpMyAdmin v4.6.6) was not fully compatible with PHP 7.2. There is a newer version available on the official website (v4.8 as of writing), which fixes these compatibility issues with PHP 7.2. sql.lib.php This error is caused by a line of code in /usr/share/phpmyadmin/libraries/sql.lib.php. If you…
-
Complete Web Server Setup(Apache2, php, mysql, phpmyadmin)
Manage the Apache Process How to install PHP How To Install MySQL How To Install and Secure phpMyAdmin If Error After phpmyadmin installation Grant Permissions in MySQL Enabling mod_rewrite Install and Secure Redis on Ubuntu 18.04 Testing Redis enable/disable site in ubuntu a2ensite, a2dissite – enable or disable an apache2 site / virtual host DESCRIPTION…
-
Problem with phpMyAdmin and PHP 7.2: “Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable”
It’s possible that when you installed phpMyAdmin, the version in the repository (phpMyAdmin v4.6.6) was not fully compatible with PHP 7.2. There is a newer version available on the official website (v4.8 as of writing), which fixes these compatibility issues with PHP 7.2. sql.lib.php This error is caused by a line of code in /usr/share/phpmyadmin/libraries/sql.lib.php. If you…