Bloomberg LP Interview Question
Software Engineer / DevelopersPHP
<?
$user="username";
$password="password";
$database="database";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
mysql_query($query);
mysql_close();
?>
$query="SELECT * FROM contacts";
$result=mysql_query($query);
$i=0;
while ($i < $num) {
CODE
$i++;
}
Perl DBI/DBD or ODBC Manager/ODBC Driver. The ODBC Manager is analogous to the DBI (Database Interface); an ODBC Driver is similar to a DBD (Database Driver).
- Srihari December 21, 2006