Skip to main content

Links

Comments

Popular posts from this blog

Web Development

                         Web development means creating websites. Websites can be accessible on Internet. Website is collection of web pages. It may contain any information, images, videos, forms. Web pages can be created by using a programming languages.  There are 3 main parts of web development 1. Client side scripting - It includes code which runs at browser side. It is user interface. What will user see and how will he interact with system is designed here. Languages includes in client side scripting : HTML CSS Javascript JQuery 2. Server side scripting - It includes code which runs at server side. User sends a request to server, server will process on it and send response to browser. Server side scripting allows the database on the web server to communicate with the web browser of the end user’s computer. Languages includes in server side scripting : PHP JAVA Python ASP.NET Ruby 3. Database - A database is used to store user's data, code, images,

Database handling in PHP

There are three method for handling database in PHP 1. MySQLi-  object-oriented 2. MySQLi -  procedural -oriented 3. PDO - PHP Database Objec t First create variable required $servername = "localhost"; $username = "root"; $password = "password"; $dbname = "sample_db"; Method 1 : -  MySQLi -  object-oriented Create connection : - $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) {     die("Connection failed: " . $conn->connect_error); } Fetch the records from table  : - $sql = "SELECT * FROM users"; $result = $conn->query($sql); get rows count  : - $count = $result->num_rows; iterate through records  : - while($row = $result->fetch_assoc()) { //print single row details print_r($row); } close connection  : - $conn->close(); Method 2 :-  MySQLi -  procedural -oriented Create connection $conn = mysqli_con

Send SMS using cURL in PHP

function sendSMS($mobile,$msg) {      // configuration according to SMS gateway        $postData= array(             'user' => 'usrename',             'password' => 'password',             'mobiles' => $mobile,             'sender_id' => 'sender id',             'message' => $msg         );     // initialization       $ch = curl_init();       curl_setopt_array($ch, array(             CURLOPT_URL => 'url of sms gateway',             CURLOPT_RETURNTRANSFER => true,             CURLOPT_POST => true,             CURLOPT_POSTFIELDS => $postData         ));         //Ignore SSL certificate verification         curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);         curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);         //get response         $output = curl_exec($ch);         //Print  the error if any         if (curl_errno($ch)) {             echo 'error:' . cur