php

im beginner to php. i faced problem with creating form and data stored into mysql


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 
Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd">
<html>

<head>
<title>Form Input Data</title>
</head>

<body>
<table border="1">
  <tr>
    <td align="center">Form Input Employees Data</td>
  </tr>
  <tr>
    <td>
      <table>
        <form method="post" action="input.php">
        <tr>
          <td>Name</td>
          <td><input type="text" name="name" size="20">
          </td>
        </tr>
        <tr>
          <td>User name</td>
          <td><input type="text" name="username" size="20">
          </td>
        </tr>
        <tr>
          <td>Password</td>
          <td><input type="Password" name="pwd" size="20">
          </td>
        </tr>
         <tr>
          <td>Email</td>
          <td><input type="text" name="email" size="20">
          </td>
        </tr>
          <td></td>
          <td align="right"><input type="submit" 
          name="submit" value="Register"></td>
        </tr>
        </table>
      </td>
    </tr>
</table>
</body>
</html>


i have created table in mysql 
create table data_employees(name char(20),username char(20),pwd char(20),email char(20),PRIMARY KEY(username));

<?
//the example of inserting data with variable from HTML form
//input.php
mysqli_connect("localhost","root","","test");

//inserting data order
$order = "INSERT INTO data_employees
            (name,username,pwd,email)
            VALUES
            ('$name',
            '$username'.'$pwd','$email')";

//declare in the order variable
$result = mysql_query($order);    //order executes
if($result){
    echo("<br>Input data is succeed");
} else{
    echo("<br>Input data is fail");
}
?>


but the out put will displayed like this and dosnt insert the data into table

      Input data is succeed");
          Input data is fail");?>

View Answers

Ads

Advertisements

php
php using javasript how to set timer in php using javasript

php
php i want to know about php and php plateform required software to make php program and database that used in php program? Please visit the following link: PHP database

php
php show the constructor overloading in php

PHP
PHP How to work in drupal with PHP

PHP
PHP hii, Define PHP? Hello, The PHP Hypertext Preprocessor is a programming language that allows web developers to create dynamic content that interacts with databases. PHP is basically used for developing web

php
php what is php PHP is one of the most used open source server-side scripting language, which runs on almost all the platform. PHP... and Solaris. To know more about PHP, Visit Here

php
php how to write a program in php to create pdf file

php
php plz tell me code for PHP SQL Insert,delete,update,view is used to insert the record from HTML page to Mysql database using in single PHP form

php
php retrieve data from mysql in php Please visit the following links: http://www.roseindia.net/sql/mysql-table/mysql-php-select.shtml http://www.roseindia.net/sql/mysql-example/select-where.shtml

php
php How to catch a image and link click counters using Ajax php can any one help me

php
php how to set email remainder in php?can you help me pls

PHP
PHP I want to create Calendar Event in PHP. Could u help me

PHP
PHP How to check whether a username exists on a website using php and cURL and not MySQL

php
Write a simple PHP program that display the days of week as per the system date using switch case statement. Write a simple PHP program that display the days of week as per the system date using switch case statement

PHP
PHP I would love to do PHP project with the title of "Hospital Management System". I want to know how to make validation using jquery

php
can learn php mysql connectivity examples from the given link: PHP Mysql Connectivity

php
shortcut method in php like in javscript seletedIndex

php
php im beginner to php. i faced problem with creating form and data stored into mysql <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <

PHP Property Management - PHP
PHP Property Management PHP Property Management.. any idea

rotate image in php - PHP
rotate image in php Function to rotate image in PHP

php means
php means php means

PHP duplicate file - PHP
PHP duplicate file i wanted to duplicate a PHP file resides in different directory on submission

PHP MVC Framework - PHP
PHP MVC Framework Which is the best & latest PHP MVC Framework... and where can i download it. Thanks

php generate link - PHP
php generate link How can i generate links in PHP for my photo gallery app

php text encoding - PHP
php text encoding How to encode the text editor text in PHP...how can it be done

$_get php example - PHP
$_get php example Explain the $_get method in php with a simple example. m a beginner

php a href
php a href How to use php a href to pass the value in PHP

Ads