Here we show how you can drop a column from table in MySQL. Sometime, we not need a particular column of table. So, we delete this column from the table. Syntax: ALTER TABLE table_name DROP COLUMN column_name; First we create a sample table with data. CREATE TABLE `employees` ( `employee_id` int(11) NOT NULL, `employee_name` varchar(100) …
Here we show how you remove N characters from last of the column value help of SUBSTRING() and CHAR_LENGTH() methods. Below is sample table with data — — Table structure for table `user_info` — CREATE TABLE `user_info` ( `id` int(11) NOT NULL, `name` varchar(20) DEFAULT NULL, `email` varchar(255) NOT NULL, `age` int(11) NOT NULL ) …
Here we show how you can convert text to image help of PHP built-in functions. First we need to check GD library extension in our current PHP version. If not enable go to the php.ini configuration file and enable GD library . We submit a text input via a HTML form to the PHP code. …
Here we show how you can display only even or odd values rows in MySql. Sometime we need to display alternative records from MySql table. Below is a sample table with data CREATE TABLE `student` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `subject` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `gender` varchar(255) NOT …
Here we will show how can live check email exists and not using Ajax, JQuery , PHP and MySql. This is a common feature in most of website available online. The PHP script matches the user input against the database and returns the reponse. Below is a sample table. — — Table structure for table …
Check Email Already Exists Using JQuery Ajax PHP MySql Read More »
Here we show how you can transform a string in an array and an array change in a string. PHP provide to built in functions for these purpose implode() and explode() . Implode() – implode() built in function use to change an array into a string. Below is syntax implode (separator, array) We can transform …
Here we show how you can display current date and time in your web page with the help of simple java script code. Sometime we need to display current date and time in our html code, it is a very common task to show current date and time in your website. Create the Date Object …
Display Current Date And Time In HTML By JavaScript Read More »
Sometime we need to copy one table data to another table. Here we show how you can copy one table data to another table using MYSQL Query. First, we create two tables one table populated with data and other table is empty. Below are sample tables. /* First table with data */ — — Table …
Add two textbox values and display the addition of values in a third textbox needed to use onfocusout Event, it executed if the user leaves an input field then call the addition function. The function will add values and display the result in third textbox. Below a sample code inflay.com | Add two textbox values and …
Add two textbox values and display the sum in a third textbox in Javascript Read More »
Here, we are going to see how to retrieve and display nth records from a MySql database table using an SQL query. MySQL provides OFF SET value allows us to specify which row to start from retrieving data, like if we want to get records starting from 4th row, then the offset will be 3. …
