sql alter table query You can modify the mysql table using ALTER TABLE statement, It is used to add, modify or delete columns in an existing table. It is also used to rename a table. You can also use SQL ALTER TABLE command to add and drop various constraints on an existing table. SQL ALTER […]
difference between DBMS and RDBMS There are mainly 3 differences between DBMS and RDBMS that is given below: 1. A DBMS has to provide some uniform methods for accessing the information that is stored while RDBMS adds the additional condition that the system supports a tabular structure of the data with relationship between the tables. […]
how to Create table in mysql SQL CREATE TABLE statement is used to create table in a database. If you want to create a table, you should set the name of table and define its column and data type of each column’s. Syntax to create the table. create table “tablename” (“column1” “data type”, “column2” “data […]
How to send HTML email in php When you send a text message using PHP then all the content will be treated as simple text. Even if you will include HTML tags in a text message, it will be displayed as simple text and HTML tags will not be formatted according to HTML syntax. But […]
How to send simple plain text email using php PHP use the mail() function to send an email. PHP Mail() function requires three mandatory parameters and two optional parameters. First Three parameters specify the email address, the subject of the mail and the actual message of mail. mail( to, subject, message, headers, parameters ); Here […]
How to send and retrieve multiple query string using php Here I Am writing tutorial on how to send or get multiple or more the one query string in php with the help of example so let we start. Here I am creating a query string with query string sending multiple values in a single […]
PHP Script for perform query string, query string in php PHP query string use for reduce amount of code, using this we can call multiple data on a single page it means if you have same data pages so you have need create a single page then call them using query string. You have to […]
PHP Script to create calendar <?php $monthNames = Array(“January”, “February”, “March”, “April”, “May”, “June”, “July”, “August”, “September”, “October”, “November”, “December”); ?> <?php if (!isset($_REQUEST[“month”])) $_REQUEST[“month”] = date(“N”); if (!isset($_REQUEST[“year”])) $_REQUEST[“year”] = date(“Y”); ?> <?php $cMonth = $_REQUEST[“month”]; $cYear = $_REQUEST[“year”]; $prev_year = $cYear; $next_year = $cYear; $prev_month = $cMonth-1; $next_month = $cMonth+1; if ($prev_month == […]
how upload multiple images using one form in php? Here am writing tutorial or php script code for inserting into database and uploading multiple images using single form or submit button you can use this code for uploading multiple images into the folder as well as database. You just have need copy and past this […]