Web Development with PHP and MySQL: creating connection with mysql database in php

Showing posts with label creating connection with mysql database in php. Show all posts

Saturday, June 2, 2012

Remove 'Add to Cart ' Button from Product Description in osCommerce

To remove 'Add to Cart' Button from Product Description in osCommerce v2.3.1
Open File 'Product_info.php' and comment out the echo statement at around line no. 194 as below.


<?php //echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_draw_button(IMAGE_BUTTON_IN_CART, 'cart', null, 'primary'); ?>

Remove 'Buy Now' Button while browsing categories in osCommerce

To remove the 'Buy Now' button from osCommerce v2.3.1

GoTo Admin Panel/configuration/Product Listing

select the line 'Display Buy Now Column' edit it and set the value '0'

Sunday, December 4, 2011

Server side validation

Code Example

registration.html

<html>
    <head>
        <title>Registration</title>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    </head>
    <body>
        <form action="registration.php">
            <table border="0" cellspacing="14">
                <tr>
                    <th colspan="2">Registration form</th>
                </tr>
                    <tr>
                        <td>First Name</td>
                        <td><input type="text" name="fname" value="" /></td>
                    </tr>
                    <tr>
                        <td>Last Name</td>
                        <td><input type="text" name="lname" value="" /></td>
                    </tr>
                    <tr>
                        <td>Email ID</td>
                        <td><input type="text" name="email" value="" /></td>
                    </tr>
                    <tr>
                        <td>Date Of Birth</td>
                        <td><input type="text" name="dob" value="" /></td>
                    </tr>
                    <tr>
                        <td>Phone no: </td>
                        <td><input type="text" name="phone" value="" /></td>
                    </tr>
                    <tr>
                        <td>Address</td>
                        <td><input type="text" name="address" value="" /></td>
                    </tr>
                     <tr>
                        <td>Gender</td>
                        <td><input type="radio" name="gender" value="male" />Male<input type="radio" name="gender" value="female" />Female</td>
                    </tr>
                    <tr>
                        <td colspan="2" align="center"><input type="submit" value="   Submit  " /></td>                    
                    </tr>                
            </table>
        </form>
    </body>
</html>

registration.php

<?php
//accessing form data
    $fname=$_GET['fname'];
    $lname=$_GET['lname'];
    $email=$_GET['email'];
    $dob=$_GET['dob'];
    $phone=$_GET['phone'];
    $address=$_GET['address'];
    $gender=$_GET['gender'];
    if(!empty($fname) && !empty ($lname) && !empty ($email) && !empty ($dob) && !empty ($phone) && !empty ($address) && !empty ($gender))
    {
        if(!is_numeric($fname) && !is_numeric($lname) && !is_numeric($email) && !is_numeric($address) && is_numeric($phone))
        {
            // creating connection
            $conection = mysqli_connect('localhost','root','','php_training') or die();
            $query = "INSERT INTO registrationch03 VALUES(0,'$fname','$lname','$email','$dob','$phone','$address','$gender')";
            $data=  mysqli_query($conection,$query);
    
            echo 'registration successfull.';
  
            mysqli_close($conection);
        }
        else {
            echo 'please enter proper data';
        }
    }
    else{
        echo 'Please enter all details';
    }
?>

Simple Registration form

Code Example

Registration.html


<html>
    <head>
        <title>Registration</title>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    </head>
    <body>
        <form action="Registration.php">
            <table border="0" cellspacing="14">
                <tr>
                    <th colspan="2">Registration form</th>
                </tr>
                    <tr>
                        <td>First Name</td>
                        <td><input type="text" name="fname" value="" /></td>
                    </tr>
                    <tr>
                        <td>Last Name</td>
                        <td><input type="text" name="lname" value="" /></td>
                    </tr>
                    <tr>
                        <td>Email ID</td>
                        <td><input type="text" name="email" value="" /></td>
                    </tr>
                    <tr>
                        <td>Date Of Birth</td>
                        <td><input type="text" name="dob" value="" /></td>
                    </tr>
                    <tr>
                        <td>Phone no: </td>
                        <td><input type="text" name="phone" value="" /></td>
                    </tr>
                    <tr>
                        <td>Address</td>
                        <td><input type="text" name="address" value="" /></td>
                    </tr>
                     <tr>
                        <td>Gender</td>
                        <td><input type="radio" name="gender" value="male" />Male<input type="radio" name="gender" value="female" />Female</td>
                    </tr>
                    <tr>
                        <td colspan="2" align="center"><input type="submit" value="   Submit  " /></td>
                    
                    </tr>
                
            </table>

        </form>
    </body>
</html>

Registration.php


<?php
    //accessing data from form 

    $fname=$_GET['fname'];
    $lname=$_GET['lname'];
    $email=$_GET['email'];
    $dob=$_GET['dob'];
    $phone=$_GET['phone'];
    $address=$_GET['address'];
    $gender=$_GET['gender'];
    
    // creating connection

    $conection = mysqli_connect('localhost','root','','php_training') or die();
    $query = "INSERT INTO registrationch03 VALUES(0,'$fname','$lname','$email','$dob','$phone','$address','$gender')";
    $data=  mysqli_query($conection,$query);
    
    echo 'registration successfull.';
  
    mysqli_close($conection);
      
?>