Another interesting article on that how to insert or store an image or any file (pdf preferably) into a database or at server location. Let’s begin! First need to create an HTML File uploading image save file as upload.html <hhtml> <head> <title> Upload files to server </title> <style> #tab{background-image: linear-gradient(to right, white, lightgreen); border: solid; …
What is a full-stack developer? An Information Technology (IT) expert who can work both on a user interface (UI)or client-side and user experience (UX) or server-side technologies and this person knows the 3-tire model of an application. Presentation tier [UI] Business Logic [programming /UX] Database layer [Database server] Now a day’s full-stack developer is in …
Stored Procedure in MYSQL using PHPMYADMIN Pre-compiled collection of T-SQL statements stored with a name Written by database developers or DBAs Used to perform administrative tasks, or apply complex business rules Contain DML statements Benefits of Stored Procedures —————————————- Increased execution speed Faster access to data Modular programming Consistency Enhanced security Types of Stored …
Maintaining the Database [MS Access] Database Security is essential Security can be administered in the form of: -A database Password -User-Level Security Compacting a Database -Backing up a Database -Importing and Linking external data Database Password —————————– -Simplest mode of securing a database. -Not very fool proof. -Database password to be used for opening database …
In this post you’ll be able to create DSN [Data Source Naming] for establishing database connection. How to Create DSN for MS Access Here are the steps to create Data Source Naming or DSN for MS Access database. step1: Click on “Start” Menu and click on “Settings” step2: Go to “Control Panel” step3: click on …
Database connections using PHP and MS Access 1. Display list of records from MS Access database to PHP web page. (for this example you need to create a DSN from control panel, to create DSN click here) <html> <body> <h1> Connecting to Ms Access using PHP </h1> <hr> <?php $conn=odbc_connect(‘acc_php’,”,”); if (!$conn) { exit(“Connection Failed: ” …
PHP Session Variables 1. Login page program using PHP and MySQL DB a) first create a html page as following. <html> <body > <form method=”post” action=”userLogin.php” > <table border=”1″ > <tr> <td> <B>User-Id</B> </td> <td><input type=”text” name=”userid”> </tr> <tr> <td><B>Password</B></td> <td><input name=”password” type=”password”></input></td> </tr> <tr> <td><input type=”submit” value=”Submit”> <td><input type=”reset” value=”Reset”> </tr> </table> </form> </body> …
In this tutorials, you will be able to understand how form validation are done using php syntax. Step1 : Create a file called “Validation.php” and copy the following code and paste into it. <!DOCTYPE HTML> <html> <head> <style> .error {color: #FF00FF;} </style> </head> <body> <?php $nameErr = $emailErr = $genderErr = $websiteErr = “”; $name …
Here are some basic programs using PHP 1. Arithmetic operation program using PHP <?php $str=” Arithmetic operation”; $a=4; $b=5; $c=$a+$b; echo “Sum=”, $c; $c=$a-$b; echo “<br>Sub=”, $c; $c=$a*$b; echo “<br>Mul=”, $c; $c=$a/$b; echo “<br>Div=”, $c; ?> 2. PHP program to print person name and age. <?php $name=”John”; $age=20; echo “Person name=”, $name; echo “<br>Age=”, $age; …
How to run PHP programs using WAMP server on Windows operating system? First, Download WAMP server from http://www.wampserver.com/en/ Here are the steps to install WAMP server on your PC and run your first PHP program. 1.Double click on WAMP server set up file 2.Click on Run 3. Click “Next” 4. Click on “Accept” 5. Click …
PHP = Pre-processor Hypertext PHP, a server side scripting languages widely (nearly 82% of the worlds websites are developed using PHP!) used in developing dynamic and interactive webpages. Advantages of PHP ——Dynamic content. —Computational capability. —Database and file system access. —Network access (from the server only). —Built-in libraries and functions. —Known platform for execution (as opposed …
