How a Spyware Search Will Protect Your Computer From Threats

Posted by forcescript on March 3, 2009 0 comments

What will a spyware search do for your computer, and why would you need to do it? A spyware search is necessary for just about all of the computers out there. It is believed that nine out of every ten PC’s that have an internet connection are infected with some type of spyware, so there is a good chance you are in that group.

Query create database

Posted by forcescript on August 26, 2008 3 comments

Starting with 70-270 and then going on to 646-204 followed by 70-620 is advisable for those who have done their 220-601 or 70-649 and are therefore exempted from SY0-101.

This is most use for create database from php

mysql_query( “CREATE TABLE database_name
( code to be executed )
TYPE=MyISAM;
“) or error( mysql_error() );

example in php

mysql_query( “CREATE TABLE reseller (
`user_id` smallint(5) unsigned NOT NULL auto_increment,
`username` varchar(30) NOT NULL default ”,
`passwd` varchar(30) NOT NULL default ”,
`name` varchar(30) NOT NULL default ”,
`email` varchar(50) NOT NULL default ”,
PRIMARY KEY (`user_id`)
) TYPE=MyISAM;
“) or error( mysql_error() );

That code will create database table that contain :

  • user_id         -  small integer 5 digit
  • username    – variable character 30 chr
  • passwd        – variable character 30 chr
  • name           – variable character 30 chr
  • email           -  variable character 50 chr

with user_id as primary key that can not contain same value.