Here we will show how you can create a Dynamically Text File using PHP. In this code can create a text file with content dynamically when user submit the form inputs. The code use PHP POST method that create a text using PHP functions fopen() to open an existing file and if not exist it …
Here we will show how you can pass PHP variables to JavaScript and use it into JavaScript function. To do that, you can simply use echo() function into JavaScript variable value. PHP is server side language which retrieves server and show in client side. JavaScript is client side language which manipulate HTML and data receives …
Here we will show how you can submit form without page refresh. For submitting form we use JQuery and Ajax with PHP and MySQl. First we create a table where we store user input data. Below we create a table user_data — — Table structure for table `user_data` — CREATE TABLE `user_data` ( `id` int(11) …
Here we will show how you can get the last inserted id of a MySQL table using different ways. First we are preparing the sample data. We will be creating a table user_info with some data. Below is sample table . — — Table structure for table `user_info` — CREATE TABLE `user_info` ( `id` int(11) NOT …
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 …
