Registration form in php


<html>

<head>


<title>test</title>

</head>

<body>

<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post" >

<table width="400" border="1">

<tr>

<td>name</td>

<td><input type="text" name="user"/> </td>

</tr>

<tr>

<td>address</td>

<td><input type="text" name="address" /></td>

</tr>

<tr>

<td>pi</td>

<td><input type="text" name="pin" /></td>

</tr>

<tr>

<td>&nbsp;</td>

<td> <input type="submit" name="11"/> </td>

</tr>

</table>

</form>


<?php


if (isset($_POST['11']))

{


mysql_connect("localhost","root","");

mysql_select_db("test1");

$query="INSERT INTO `tablename` (`field1`, `field2`, `field3`) VALUES ('".$_POST['user']."', '".$_POST['address']."', '".$_POST['pin']."')";

mysql_query($query);

echo "Data inserted";

}

else

{


}

?>

</body>

</html>

1 comments

Read function in php

<?php

mysql_connect("localhost","root","");

mysql_select_db("test1");

?>

<table width="400" border="1">

<tr>

<td>sl number</td>

<td>field_name </td>

<td>field_pass </td>

<td>field_address </td>

</tr>

<?php

$i=1;

$query="Select * from tablename ";

$RES=mysql_query($query);

while($ROW=mysql_fetch_array($RES))

{

?>

<tr>

<td><?php echo $i ?></td>

<td><?php echo $ROW[1]; ?></td>

<td><?php echo $ROW[2]; ?></td>

<td><?php echo $ROW[3]; ?></td>

</tr>

<?php

$i=$i+1;

}

?>

</table>
0 comments

Registration form in php

Frist page reg.php(Registration page)


<form action="insert1.php" method="post" target="LoadData">

<table width="400" border="1">

<tr>

<td>Name</td>

<td> <input type="text" name="name" /></td>

</tr>

<tr>

<td>Password</td>

<td> <input type="password" name="name1" /> </td>

</tr>



<tr>

<td>Email</td>

<td ><label>

<textarea name="text"></textarea>

</label></td>

</tr>

<tr>

<td>&nbsp;</td>

<td > <input name="Rest" type="reset" id="Rest" value="Reset" /> <input type="submit" /> </td>

</tr>

</table></form>


Second form insert1.php(insert function page)


<?php

$name=$_REQUEST['name'];

$anu=$_REQUEST['name1'];


$text=$_REQUEST['text'];

mysql_connect("localhost","root",""); //Connecton String (database,usename,password)

mysql_select_db("test1");

$query="INSERT INTO tablename ( `field_name`, `field_pass`, `field_address`) VALUES ( '$name','$anu', '$text')";

echo $query;

mysql_query($query);

echo "value insert into database";

?>

0 comments

INSERT FUNCTION FOR PHP

INSERT FUNCTION FOR PHP

<?php
mysql_connect("localhost","root",""); //Connecton String (database,usename,password)
mysql_select_db("test1");
$query="INSERT INTO tablename ( `field_name`, `field_pass`, `field_address`) VALUES ( 'anurajs',' anu', 'address')";
mysql_query($query);
echo "value insert into database"
?>


0 comments

Mysql query for date format

if you wanted to change the format of a MySQL date from YYYY-MM-DD to MM/DD/YYYY or DD/MM/YYYY format you can use the DATE_FORMAT() function as shown in the example below:

SELECT DATE_FORMAT(field name, '%d/%m/%Y') FROM tablename

SELECT DATE_FORMAT(column_name, '%m/%d/%Y') FROM tablename
0 comments

Custom date Format in vb.net

Format specifier

Description

Examples

"d"

The day of the month, from 1 through 31.

6/1/2009 1:45:30 PM -> 1

6/15/2009 1:45:30 PM -> 15

"dd"

The day of the month, from 01 through 31..

6/1/2009 1:45:30 PM -> 01

6/15/2009 1:45:30 PM -> 15

"ddd"

The abbreviated name of the day of the week.

6/15/2009 1:45:30 PM -> Mon (en-US)

6/15/2009 1:45:30 PM -> Пн (ru-RU)

6/15/2009 1:45:30 PM -> lun. (fr-FR)

"dddd"

The full name of the day of the week.

6/15/2009 1:45:30 PM -> Monday (en-US)

6/15/2009 1:45:30 PM ->

6/

"f"

The tenths of a second in a date and time value..

6/15/2009 13:45:30.617 -> 6

6/15/2009 13:45:30.050 -> 0

"ff"

The hundredths of a second in a date and time value.

6/15/2009 13:45:30.617 -> 61

6/15/2009 13:45:30.005 -> 00

"fff"

The milliseconds in a date and time value.

6/15/2009 13:45:30.617 -> 617

6/15/2009 13:45:30.0005 -> 000

"ffff"

The ten thousandths of a second in a date and time value..

6/15/2009 13:45:30.6175 -> 6175

6/15/2009 13:45:30.00005 -> 0000

"fffff"

The hundred thousandths of a second in a date and time value.

6/15/2009 13:45:30.61754 -> 61754

6/15/2009 13:45:30.000005 -> 00000

"ffffff"

The millionths of a second in a date and time value.

6/15/2009 13:45:30.617542 -> 617542

6/15/2009 13:45:30.0000005 -> 000000

"fffffff"

The ten millionths of a second in a date and time value.

6/15/2009 13:45:30.6175425 -> 6175425

6/15/2009 13:45:30.0001150 -> 0001150

"F"

If non-zero, the tenths of a second in a date and time value.

6/15/2009 13:45:30.617 -> 6

6/15/2009 13:45:30.050 -> (no output)

"FF"

If non-zero, the hundredths of a second in a date and time value.

6/15/2009 13:45:30.617 -> 61

6/15/2009 13:45:30.005 -> (no output)

"FFF"

If non-zero, the milliseconds in a date and time value.

.

6/15/2009 13:45:30.617 -> 617

6/15/2009 13:45:30.0005 -> (no output)

"FFFF"

If non-zero, the ten thousandths of a second in a date and time value.

.

6/1/2009 13:45:30.5275 -> 5275

6/15/2009 13:45:30.00005 -> (no output)

"FFFFF"

If non-zero, the hundred thousandths of a second in a date and time value.

6/15/2009 13:45:30.61754 -> 61754

6/15/2009 13:45:30.000005 -> (no output)

"FFFFFF"

If non-zero, the millionths of a second in a date and time value.

6/15/2009 13:45:30.617542 -> 617542

6/15/2009 13:45:30.0000005 -> (no output)

"FFFFFFF"

If non-zero, the ten millionths of a second in a date and time value.

6/15/2009 13:45:30.6175425 -> 6175425

6/15/2009 13:45:30.0001150 -> 000115

"g", "gg"

The period or era.

6/15/2009 1:45:30 PM -> A.D.

"h"

The hour, using a 12-hour clock from 1 to 12.

6/15/2009 1:45:30 AM -> 1

6/15/2009 1:45:30 PM -> 1

"hh"

The hour, using a 12-hour clock from 01 to 12.

.

6/15/2009 1:45:30 AM -> 01

6/15/2009 1:45:30 PM -> 01

"H"

The hour, using a 24-hour clock from 0 to 23.

6/15/2009 1:45:30 AM -> 1

6/15/2009 1:45:30 PM -> 13

"HH"

The hour, using a 24-hour clock from 00 to 23.

6/15/2009 1:45:30 AM -> 01

6/15/2009 1:45:30 PM -> 13

"K"

Time zone information.

With DateTime values:

6/15/2009 1:45:30 PM, Kind Unspecified ->

6/15/2009 1:45:30 PM, Kind Utc -> Z

6/15/2009 1:45:30 PM, Kind Local -> -07:00 (depends on local computer settings)

With DateTimeOffset values:

6/15/2009 1:45:30 AM -07:00 --> -07:00

6/15/2009 8:45:30 AM +00:00 --> +00:00

"m"

The minute, from 0 through 59.

6/15/2009 1:09:30 AM -> 9

6/15/2009 1:09:30 PM -> 9

"mm"

The minute, from 00 through 59.

6/15/2009 1:09:30 AM -> 09

6/15/2009 1:09:30 PM -> 09

"M"

The month, from 1 through 12.

6/15/2009 1:45:30 PM -> 6

"MM"

The month, from 01 through 12.

6/15/2009 1:45:30 PM -> 06

"MMM"

The abbreviated name of the month.

6/15/2009 1:45:30 PM -> Jun (en-US)

6/15/2009 1:45:30 PM -> juin (fr-FR)

6/15/2009 1:45:30 PM -> Jun (zu-ZA)

"MMMM"

The full name of the month.

6/15/2009 1:45:30 PM -> June (en-US)

6/15/2009 1:45:30 PM -> juni (da-DK)

6/15/2009 1:45:30 PM -> uJuni (zu-ZA)

"s"

The second, from 0 through 59.

6/15/2009 1:45:09 PM -> 9

"ss"

The second, from 00 through 59.

6/15/2009 1:45:09 PM -> 09

"t"

The first character of the AM/PM designator.

.

6/15/2009 1:45:30 PM -> P (en-US)

6/15/2009 1:45:30 PM -> 午 (ja-JP)

6/15/2009 1:45:30 PM -> (fr-FR)

"tt"

The AM/PM designator.

6/15/2009 1:45:30 PM -> PM (en-US)

6/15/2009 1:45:30 PM -> 午後 (ja-JP)

6/15/2009 1:45:30 PM -> (fr-FR)

"y"

The year, from 0 to 99.

1/1/0001 12:00:00 AM -> 1

1/1/0900 12:00:00 AM -> 0

1/1/1900 12:00:00 AM -> 0

6/15/2009 1:45:30 PM -> 9

"yy"

The year, from 00 to 99.

1/1/0001 12:00:00 AM -> 01

1/1/0900 12:00:00 AM -> 00

1/1/1900 12:00:00 AM -> 00

6/15/2009 1:45:30 PM -> 09

"yyy"

The year, with a minimum of three digits.

1/1/0001 12:00:00 AM -> 001

1/1/0900 12:00:00 AM -> 900

1/1/1900 12:00:00 AM -> 1900

6/15/2009 1:45:30 PM -> 2009

"yyyy"

The year as a four-digit number.

1/1/0001 12:00:00 AM -> 0001

1/1/0900 12:00:00 AM -> 0900

1/1/1900 12:00:00 AM -> 1900

6/15/2009 1:45:30 PM -> 2009

"yyyyy"

The year as a five-digit number.

1/1/0001 12:00:00 AM -> 00001

6/15/2009 1:45:30 PM -> 02009

"z"

Hours offset from UTC, with no leading zeros.

6/15/2009 1:45:30 PM -07:00 -> -7

"zz"

Hours offset from UTC, with a leading zero for a single-digit value.

6/15/2009 1:45:30 PM -07:00 -> -07

"zzz"

Hours and minutes offset from UTC.

.

6/15/2009 1:45:30 PM -07:00 -> -07:00

":"

The time separator.

6/15/2009 1:45:30 PM -> : (en-US)

6/15/2009 1:45:30 PM -> . (it-IT)

6/15/2009 1:45:30 PM -> : (ja-JP)

"/"

The date separator.

6/15/2009 1:45:30 PM -> / (en-US)

6/15/2009 1:45:30 PM -> - (ar-DZ)

6/15/2009 1:45:30 PM -> . (tr-TR)

"string"

'string'

Literal string delimiter.

6/15/2009 1:45:30 PM ("arr:" h:m t) -> arr: 1:45 P

6/15/2009 1:45:30 PM ('arr:' h:m t) -> arr: 1:45 P

%

Defines the following character as a custom format specifier.

6/15/2009 1:45:30 PM (%h) -> 1

\

The escape character.

6/15/2009 1:45:30 PM (h \h) -> 1 h

Any other character

The character is copied to the result string unchanged.

6/15/2009 1:45:30 AM (arr hh:mm t) -> arr 01:45 A

0 comments
Subscribe to: Posts (Atom)