php - How to get output in table fromat in html page , using phpscript and extracted from mysql database? -


i trying fetch data mysql database , print on new web page. need display output in table format.
below php script, me out so.
in advance.

<?php     $userinput = $_post['sample_name'];     $servername = "localhost";     $username = "root";     $password = "";     $dbname = "processtrackingsystem";      // create connection     $conn = new mysqli($servername, $username, $password, $dbname);     // check connection     if ($conn->connect_errno) {         printf("connect failed: %s\n", $conn->connect_error);         exit();     }      $result = mysqli_query($conn, "select * processtrackingsystem.processdetails                                    sample_name = '$userinput'") or die(mysqli_error($conn));      while ($row=mysqli_fetch_assoc($result))     {         printf("sample_name:->");         printf($row['sample_name']);         printf("<br>\r\n");         printf("<br>\r\n");         printf("so_id:->");         printf($row['so_id']);         printf("<br>\r\n");         printf("<br>\r\n");     }      mysqli_free_result($result);     $conn->close(); ?>

i need output in tabular format.

you can create table following way.

echo "<table border='1'>     <tr>         <th>sample_name</th>         <th>so_id</th>     </tr>";     while($row = mysqli_fetch_assoc($result))    {        echo "<tr>";            echo "<td>" . $row['sample_name'] . "</td>";            echo "<td>" . $row['so_id'] . "</td>";        echo "</tr>";    }    echo "</table>";

Comments

Post a Comment

Popular posts from this blog

javascript - Google App Script ContentService downloadAsFile not working -

i have web app developed using google app script htmlservice , html form, populating excel sheet in google drive using spreadsheetapp . , 1 section calling contentservice download data excel file. function doget(e) { // read excel sheet //getappfile(); // render application html template return htmlservice.createtemplatefromfile('index').evaluate() .settitle('go smart') .setsandboxmode(htmlservice.sandboxmode.iframe); } function downloaddoublequatecsvfile() { var sheetid = propertiesservice.getscriptproperties().getproperty('sheetid'); var ss = spreadsheetapp.openbyid(sheetid).getactivesheet(); //var ss = spreadsheetapp.getactivespreadsheet().getactivesheet(); var maxcolumn = ss.getlastcolumn(); var maxrow = ss.getlastrow(); var data = ss.getrange(1, 1, maxrow, maxcolumn).getvalues(); if (data.length > 1) { var csv = ""; (var row = 0; row < data.length; row++) { (var c...
Read more

javascript - Function overwritting -

is there way overwrite function or event handling in function? using addeventlistener, can have many event handlers on element want var test=document.getelementbyid("div"); test.addeventlistener("click",function(){alert("im first");},false); test.addeventlistener("click",function(){alert("im second");},false); // alerts "im first" , after "im second" but if want overwrite function/event example based on client width example this function one() { alert("first"); } function two() { alert("second"); } window.onresize = function() { var test = document.getelementbyid("div"); if (window.innerwidth > 500) { test.onclick = 1 } else { test.onclick = two; } } is possible in javascript? in case use effective little known approach. addeventlistener can accept object property handleevent event handler. in case it's easy overwr...
Read more

php - Find a regex to take part of Email -

i have following emails need extract part from: bestellnummer xxx: 1 von xxx, 1er pack ------------- anfang der nachricht ------------- foo bar baz foo bar baz // <<<<< need text here ------------- ende der nachricht ------------- ------------- anfang der nachricht ------------- foo bar baz foo bar baz ------------- ende der nachricht ------------- there 0 unlimited occurences of ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- and i'm able extract first part regex: $re = "/------------- .*? -------------.?(.*?).?------------- .*? -------------/s"; but, i'm quite new on learning regex, i'm pretty sure there must better regex extract part (foo bar baz foo bar baz) of text between ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- as can in different languages, i'm using .? to match between hyphens. i...
Read more