Forums - All Forums

Newegg's Power Supply Calculator

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

Try out this new power supply calculator from Newegg.

LINK

DISABLE INDEXING SERVICES

Wed, 17 Jun 2009 16:52:47 +0000

Indexing Services is a small little program that uses large amounts of RAM and can often make a computer endlessly loud and noisy. This system process indexes and updates lists of all the files that are on your computer. It does this so that when you do a search for something on your computer, it will search faster by scanning the index lists. If you don't search your computer often, or even if you do search often, this system service is completely unnecessary. To disable do the following:

1. Go to Start
2. Click Settings
3. Click Control Panel
4. Double-click Add/Remove Programs
5. Click the Add/Remove Window Components
6. Uncheck the Indexing services
7. Click Next

SPEEDUP FOLDER BROWSING IN WINDOWS

Wed, 17 Jun 2009 16:50:57 +0000

SPEEDUP FOLDER BROWSING

You may have noticed that everytime you open my computer to browse folders that there is a slight delay. This is because Windows XP automatically searches for network files and printers everytime you open Windows Explorer. To fix this and to increase browsing significantly:

1. Open My Computer
2. Click on Tools menu
3. Click on Folder Options
4. Click on the View tab.
5. Uncheck the Automatically search for network folders and printers check box
6. Click Apply
7. Click Ok
8. Reboot your computer

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: 0)