Difference between revisions of "Genesetdb"
Seung Park (talk | contribs) |
|||
| Line 1: | Line 1: | ||
<syntaxhighlight lang="php"> | <syntaxhighlight lang="php"> | ||
<?php | <?php | ||
| − | $con= mysqli_connect("localhost", " | + | $con= mysqli_connect("localhost", "ooga", "booga", "genesetdb"); |
if(mysqli_connect_errno()) | if(mysqli_connect_errno()) | ||
{ | { | ||
Revision as of 02:39, 26 October 2013
<syntaxhighlight lang="php"> <?php $con= mysqli_connect("localhost", "ooga", "booga", "genesetdb"); if(mysqli_connect_errno()) { die( "could not connect: " . mysqli_connect_error()); } echo' <html>
<head> <title>genetable</title> </head> <body>
Genetable
'; $sql="SELECT * FROM `workaround`;"; $result= mysqli_query($con,$sql); $pid=1; $genes=0; while ($row=mysqli_fetch_array($result)) { for($i=0; $i<200; $i++) { mysqli_query($con,"INSERT INTO TABLE `finalgeneset` VALUES(BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY" . $pid . ",". $row[$genes] . ");"); echo ' '; $genes++; } $pid++; $genes = 0; } echo'| Experiment Number | Gene ID |
|---|---|
| ' . $pid . ' | ' . $row[$genes] . ' |
</body>
</html> '; ?> </syntaxhighltight>
