Forums - All Forums

lakers

Mon, 30 Jan 2012 05:17:21 +0000

hi team

Newegg's Power Supply Calculator

Thu, 15 Oct 2009 02:33:14 +0000

Try out this new power supply calculator from Newegg.

LINK

MYSQL Insert Record - This Works!

Sat, 06 Jun 2009 17:19:06 +0000

http://www.phpeasystep.com/mysql/5.html

Create MYSQL Table

CREATE TABLE `test_mysql` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(65) NOT NULL default '',
`lastname` varchar(65) NOT NULL default '',
`email` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=0 ;

HTML FORM

PHP CODE

$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="test_mysql"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Get values from form
$name=$_POST['name'];
$lastname=$_POST['lastname'];
$email=$_POST['email'];

// Insert data into mysql
$sql="INSERT INTO $tbl_name(name, lastname, email)VALUES('$name', '$lastname', '$email')";
$result=mysql_query($sql);

// if successfully insert data into database, displays message "Successful".
if($result){
echo "Successful";
echo "
";
echo "Back to main page";
}

else {
echo "ERROR";
}

// close connection
mysql_close();
?>

MYSQL/PHP Code To View Tables

Sat, 06 Jun 2009 16:00:50 +0000

Here is another example to display all rows in a table. Replace the connection and table variables with your own.

viewall.php
PHP Code:

Your Page Title

$database="yourdbname";
mysql_connect ("localhost", "yourusername", "yourpassword");
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query( "SELECT * FROM yourtable" )
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
print "There are $num_rows records.

";
print "

\n";
while ($get_info = mysql_fetch_row($result)){
print "\n";
foreach ($get_info as $field)
print "\t\n";
print "\n";
}
print "

$field

\n";
?>

Here is some more code to select only rows from a table.

viewcertainfields.php
PHP Code:

Your Page Title

$database="yourdbname";
mysql_connect ("localhost", "yourusername", "yourpassword");
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query( "SELECT field1, field2, field3 FROM yourtable" )
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
print "There are $num_rows records.

";
print "

\n";
while ($get_info = mysql_fetch_row($result)){
print "\n";
foreach ($get_info as $field)
print "\t\n";
print "\n";
}
print "

$field

\n";
?>

You can also add limit and order to the query.

PHP/MYSQL Test Script

Sat, 06 Jun 2009 07:20:42 +0000

This is a test script to see your connection with php/mysql,

test7.php (Size: 4.12 KB / Downloads: 3)