Pathology Education Instructional Resource - User contributions [en]

Genesetdb

2013-10-26T02:26:04Z

Jrsinger:

<syntaxhighlight lang="php">
<?php
$con= mysqli_connect("localhost", "jrsinger", "U6d19lrBFC48z2fpF1K5PcRy80XS17QC", "genesetdb");
if(mysqli_connect_errno())
{
die( "could not connect: " . mysqli_connect_error());
}
echo'
<html>
<head>
<title>genetable</title>
</head>
<body>
<h1> Genetable</h1>
<table border="1">
<tr>
<th>Experiment Number</th>
<th>Gene ID</th>
</tr>
';
$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 '
<tr>
<td>' . $pid . '</td>
<td>' . $row[$genes] . '</td>
</tr>
';
$genes++;
}
$pid++;
$genes = 0;
}
echo'
</table>
</body>
</html>
';
?>
</syntaxhighltight>

Genesetdb

2013-10-26T02:25:03Z

Jrsinger: Created page with "<?php $con= mysqli_connect("localhost", "jrsinger", "U6d19lrBFC48z2fpF1K5PcRy80XS17QC", "genesetdb"); if(mysqli_connect_errno()) { die( "could not connect: " . mysqli_connect..."

<?php
$con= mysqli_connect("localhost", "jrsinger", "U6d19lrBFC48z2fpF1K5PcRy80XS17QC", "genesetdb");
if(mysqli_connect_errno())
{
die( "could not connect: " . mysqli_connect_error());
}
echo'
<html>
<head>
<title>genetable</title>
</head>
<body>
<h1> Genetable</h1>
<table border="1">
<tr>
<th>Experiment Number</th>
<th>Gene ID</th>
</tr>
';
$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 '
<tr>
<td>' . $pid . '</td>
<td>' . $row[$genes] . '</td>
</tr>
';
$genes++;
}
$pid++;
$genes = 0;
}
echo'
</table>
</body>
</html>
';
?>

This Is Your Brain On Informatics: PHP

2013-10-26T02:24:33Z

Jrsinger: /* Example Codes */

===Example Codes===

*[[HTML/PHP Database Dump]]
*[[PHP: Nucleotide Fun|Nucleotide Fun]]

*[[genesetdb]]

{{This Is Your Brain On Informatics}}

This Is Your Brain On Informatics

2013-10-22T16:19:36Z

Jrsinger: /* This Is Your Brain On Informatics */

== This Is Your Brain On Informatics ==
Testing out the fluids.

Sudo su = allows you super user privileges

^k = delete line

^w = find

^u = undoes one typo

'''Ls –a''' = list all files in the folder

'''Tar –xzvf *.tar.gz''' = unzip the .tar.gz file

'''Mkdir''' = make directory

'''/etc/init.d''' = initiate daemon (it does something but it stays in memory?!)

'''find / -name foo'''
This will search the whole system for any files named foo and display their pathnames. Here we are using the criterion -name with the argument foo to tell find to perform a name search for the filename foo.

If you get locked out of your server, enter pico /etc/hosts.deny Once you are in that file, delete the IP address (your IP address) that has been blocked at the bottom of the file.