Here we are going to show how you can use FIND_IN_SET in where clause for searching records. Sometime we store comma separated data in column and want to get records where particular value exist in column. In this situation we use Search Records Using FIND_IN_SET. Below is sample table with data CREATE TABLE `student` ( …
Here, we will show how you can allow only characters and space to be typed in a textbox. This is some time requirement to only need characters and space in textbox. First we create html for enter characters and space in textbox. Allow only characters and space in textbox javascript Allow only characters and space …
Here, we will show how you can allow only numbers to be typed in a textbox. This is some time requirement to only need numbers in textbox. First we create html for enter number in textbox. Allow only numbers to be typed in a textbox using html, javascript Allow only numbers to be typed in …
Here we show how you can use multiple count() with different conditions in single MySql query. Below is sample table with data — — Table structure for table `student` — 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 NULL, `class` …
Multiple Counts With Different Conditions In Single MySQL Query Read More »
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 …
