dbtest
[insert_php]
$conn = new mysqli(“localhost”, “q4j8e5j1_vito”, “OO.c,Tefw,{2”, “q4j8e5j1_library”);
/* check connection */
if ($conn->connect_errno) {
printf(“Connect failed: %s\n”, $conn->connect_error);
exit();
} else {
echo “connection successful
“;
}
echo “
“;
$hr_counter = 0;
$result = mysqli_query($conn,”SELECT * FROM series ORDER BY series”);
while($newArray = mysqli_fetch_array($result)){
$series = $newArray[‘series’];
$hr_counter++;
if($hr_counter != 1){
echo “
|
“;
}
echo “
\n
$series Series:
|
\n
“;
$result2 = mysqli_query($conn,”SELECT * FROM items WHERE series = ‘$series’ ORDER BY item_number”);
while($newArray2 = mysqli_fetch_array($result2)){
$id = $newArray2[‘id’];
$item_number = trim($newArray2[‘item_number’]);
$item_name = $newArray2[‘item_name’];
$pdf = $newArray2[‘pdf’];
$manual = $newArray2[‘manual’];
$cad = $newArray2[‘cad’];
$video = $newArray2[‘video’];
$youtube_video_id = $newArray2[‘youtube_video_id’];
echo “
\n”;
echo “
$item_number |
\n”;
echo “
|
“;
echo “
$item_name |
\n”;
echo “
|
“;
//pdf
echo “
“;
if($pdf == “on”){
echo ““;
}
echo “PDF View”;
if($pdf == “on”){
echo ““;
}
echo “ |
\n”;
echo “
|
“;
//manual
echo “
“;
if($manual == “on”){
echo ““;
}
echo “Manual”;
if($manual == “on”){
echo ““;
}
echo “ |
\n”;
echo “
|
“;
//cad
echo “
“;
if($cad == “on”){
echo ““;
}
echo “CAD”;
if($cad == “on”){
echo ““;
}
echo “ |
\n”;
echo “
\n”;
echo “
|
“;
}
}
echo “
“;
[/insert_php]
