{"id":19,"date":"2018-06-01T17:41:26","date_gmt":"2018-06-01T17:41:26","guid":{"rendered":"https:\/\/www.randolphtubing.com\/technical-documents\/?page_id=19"},"modified":"2018-06-01T18:27:33","modified_gmt":"2018-06-01T18:27:33","slug":"table-dynamic","status":"publish","type":"page","link":"https:\/\/www.randolphtubing.com\/technical-documents\/table-dynamic\/","title":{"rendered":"table dynamic "},"content":{"rendered":"

[insert_php]
\n$conn = new mysqli(“localhost”, “montagne_techdoc”, “UXToIw9hFR7i”, “montagne_library”);<\/p>\n

\/* check connection *\/
\nif ($conn->connect_errno) {
\n printf(“Connect failed: %s\\n”, $conn->connect_error);
\n exit();
\n}<\/p>\n

$selected = $_REQUEST[‘selected’];
\necho “<\/p>\n

\n

Randolph Tubing Technical Documents<\/span><\/h1>\n<\/div>\n

“;<\/p>\n

echo “<\/p>\n“;<\/p>\n

$id_counter = 0;<\/p>\n

$result = mysqli_query($conn,”SELECT * FROM series WHERE series = ‘$selected'”);
\nwhile($newArray = mysqli_fetch_array($result)){
\n$series = $newArray[‘series’];<\/p>\n

\tif ( wpmd_is_phone() ) {
\n\t\techo “<\/p>\n

\\n<\/p>\n\\n<\/p>\n\\n”;
\n\t\techo “<\/p>\n
$series SERIES:<\/b>

<\/td>\n

\\n<\/tr>\n

“;
\n\t} else {
\n\t\techo “<\/p>\n

$series SERIES:<\/b>

<\/td>\n

\\n<\/tr>\n

“;
\n\t}<\/p>\n

\t$result2 = mysqli_query($conn,”SELECT * FROM items WHERE series = ‘$selected’ ORDER BY item_number”);
\n\twhile($newArray2 = mysqli_fetch_array($result2)){\t<\/p>\n

\t\t$id = $newArray2[‘id’];
\n\t\t$item_number = trim($newArray2[‘item_number’]);
\n\t\t$item_name = $newArray2[‘item_name’];<\/p>\n

\t\t$id_counter++;<\/p>\n

\t\t$pdf = $newArray2[‘pdf’];
\n\t\t$manual = $newArray2[‘manual’];
\n\t\t$cad = $newArray2[‘cad’];
\n\t\t$video = $newArray2[‘video’];
\n\t\t$youtube_video_id = $newArray2[‘youtube_video_id’];<\/p>\n

\t\techo “<\/p>\n

$item_number<\/td>\n

\\n”;<\/p>\n

\t\techo “<\/p>\n

$item_name<\/td>\n

\\n”;<\/p>\n

\t\t\/\/pd
\n\t\tif($pdf == “on”){
\n\t\t\techo “<\/p>\n

“;
\n\t\t} else {
\n\t\t\techo “<\/p>\n		“;
\n\t\t}<\/p>\n

\t\techo “PDF”;
\n\t\tif($pdf == “on”){
\n\t\t\techo “<\/a>“;
\n\t\t}
\n\t\techo “<\/td>\n

\\n”;<\/p>\n

\t\t\/\/manual
\n\t\techo “<\/p>\n

“;
\n\t\tif($manual == “on”){
\n\t\t\techo “<\/p>\n		“;
\n\t\t} else {
\n\t\t\techo “<\/p>\n		“;
\n\t\t}<\/p>\n

\t\techo “Manual”;
\n\t\tif($manual == “on”){
\n\t\t\techo “<\/a>“;
\n\t\t}
\n\t\techo “<\/td>\n

\\n”;<\/p>\n

\t\t\/\/cad
\n\t\techo “<\/p>\n

“;
\n\t\tif($cad == “on”){
\n\t\t\techo “<\/p>\n		“;
\n\t\t} else {
\n\t\t\techo “<\/p>\n		“;
\n\t\t}<\/p>\n

\t\techo “CAD”;
\n\t\tif($cad == “on”){
\n\t\t\techo “<\/a>“;
\n\t\t}
\n\t\techo “<\/td>\n

\\n”;<\/p>\n

\t\tif ( wpmd_is_phone() ) {
\n\t\t\techo “<\/p>\n

 <\/td>\n

“;
\n\t\t}<\/p>\n

\t\techo “<\/tr>\n

\\n”;<\/p>\n

\t}\t<\/p>\n

}
\necho “<\/table>\n

“;<\/p>\n

if($id_counter < 1){\n\techo \"No data found for this series.<\/strong>

“;
\n}<\/p>\n

echo “<\/a>“;<\/p>\n

[\/insert_php]<\/p>\n","protected":false},"excerpt":{"rendered":"

[insert_php] $conn = new mysqli(“localhost”, “montagne_techdoc”, “UXToIw9hFR7i”, “montagne_library”); \/* check connection *\/ if ($conn->connect_errno) { printf(“Connect failed: %s\\n”, $conn->connect_error); exit(); } $selected = $_REQUEST[‘selected’]; echo “ Randolph Tubing Technical Documents “; echo “ “; $id_counter = 0; $result = mysqli_query($conn,”SELECT * FROM series WHERE series = ‘$selected’”); while($newArray = mysqli_fetch_array($result)){ $series = $newArray[‘series’]; if ( […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-19","page","type-page","status-publish"],"_links":{"self":[{"href":"https:\/\/www.randolphtubing.com\/technical-documents\/wp-json\/wp\/v2\/pages\/19","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.randolphtubing.com\/technical-documents\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.randolphtubing.com\/technical-documents\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.randolphtubing.com\/technical-documents\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.randolphtubing.com\/technical-documents\/wp-json\/wp\/v2\/comments?post=19"}],"version-history":[{"count":11,"href":"https:\/\/www.randolphtubing.com\/technical-documents\/wp-json\/wp\/v2\/pages\/19\/revisions"}],"predecessor-version":[{"id":45,"href":"https:\/\/www.randolphtubing.com\/technical-documents\/wp-json\/wp\/v2\/pages\/19\/revisions\/45"}],"wp:attachment":[{"href":"https:\/\/www.randolphtubing.com\/technical-documents\/wp-json\/wp\/v2\/media?parent=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}