can we pass values bw php and table

Question

ankit1122 -3 Junior Poster in Training

9 Years Ago

hello,

i want to show mysql query results into a table on a web page...but can i pass variable values from html tp php script i wanna show as it is important for my project

php

3 Contributors
9 Replies
213 Views
1 Day Discussion Span
Latest Post 9 Years Ago Latest Post by mattster

All 9 Replies

mattster 195 Practically a Master Poster

9 Years Ago

You can pass HTML into PHP by submitting forms or using $_GET (ie. idx.php?var1=XYZ).

You would then do something along the lines of:

<table>

    <?php  
    foreach(...) {
        echo "<tr><td>".$row['col_name']."</td></tr>";
    } ?>

</table>

You need to tweak this snippet to work inline with your code.

mattster 195 Practically a Master Poster

9 Years Ago

Why didn't you post your code streight away?

my code is below not working

'Not working' can mean alot of things. How is it not working? Any error messages? Explain what bits you know work and the areas you think the problem are.

Firstly you need a <body> tag, and a <html> tag if you haven't already got one. You need to open the <table> tag as well.

urtrivedi 276 Nearly a Posting Virtuoso

9 Years Ago

Embeding is something empower html
http://www.w3schools.com/php/default.asp

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

ankit1122 -3 Junior Poster in Training · Answer 1 · 2014-09-09T03:38:52+00:00

my code is below not working:--

    <head>
        <title>Main Page</title>


    </head>

        <?php

        if($_POST["csv"])
        {
    $db=$_POST["db"];

$skills = explode(",", $_POST["skills"]);
$table = explode(",", $_POST["table"]);
$city = explode(",", $_POST["city"]);
$region = explode(",", $_POST["region"]);
$country = explode(",", $_POST["country"]);

$latitude=$_POST["lat"];
$longitude=$_POST["long"];

$distance=$_POST["dist"];

$latitude*=0.01745;
$longitude*=0.01745;
//print_r($skills);

$filename=  strtotime("now").".csv";

/* @var $table type */
$f="SELECT 'first','last','email' UNION";
$s=$f." select first,last,email from $table[0] where skills regexp \"$skills[0]\"";


for($i=1;$i<count($skills);$i++)
{
    $s.=" and skills regexp \"$skills[$i]\"";

    }
    $s.=" and deposit>=bid";

    for($i=0;$i<count($region);$i++)
if(!$region[$i]=="")
    {
    $s.=" and region regexp \"$region[$i]\"";

    }

    for($i=0;$i<count($city);$i++)
if(!$city[$i]=="")
    {
    $s.=" and city regexp \"$city[$i]\"";

    }


    for($i=0;$i<count($country);$i++)
if(!$country[$i]=="")
    {
    $s.=" and country regexp \"$country[$i]\"";

    }
    if(!$latitude=="")
    {

   $s.=" and acos(sin($latitude) * sin(Lati) + cos($latitude) * cos(Lati) * cos(Longi - ($longitude))) * 6371 <= $distance";
    }


    $s.=" INTO OUTFILE '/var/tmp/$filename'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\\n';";



    $con=mysqli_connect("localhost","root","cutiepie_100",$db);
    if (mysqli_connect_errno()) 
        {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
//print_r($s);
$abc=mysqli_query($con, $s) or die('cannot show tables');
echo $filename;
        }

        else if ($_POST["update"])
        {
             $db=$_POST["db"];
$skills = explode(",", $_POST["skills"]);
$table = explode(",", $_POST["table"]);
$city = explode(",", $_POST["city"]);
$region = explode(",", $_POST["region"]);
$country = explode(",", $_POST["country"]);

$latitude=$_POST["lat"];
$longitude=$_POST["long"];

$distance=$_POST["dist"];

$latitude*=0.01745;
$longitude*=0.01745;
//print_r($skills);



/* @var $table type */
$s="update $table[0] set deposit=deposit-bid where skills regexp \"$skills[0]\"";

$s.=" and deposit>=bid";
for($i=1;$i<count($skills);$i++)
{
    $s.=" and skills regexp \"$skills[$i]\"";

    }

    for($i=0;$i<count($region);$i++)
if(!$region[$i]=="")
    {
    $s.=" and region regexp \"$region[$i]\"";

    }

    for($i=0;$i<count($city);$i++)
if(!$city[$i]=="")
    {
    $s.=" and city regexp \"$city[$i]\"";

    }


    for($i=0;$i<count($country);$i++)
if(!$country[$i]=="")
    {
    $s.=" and country regexp \"$country[$i]\"";

    }
    if(!$latitude=="")
    {

   $s.=" and acos(sin($latitude) * sin(Lati) + cos($latitude) * cos(Lati) * cos(Longi - ($longitude))) * 6371 <= $distance;";
    }
    $s.=";";

     print_r($s);

    $con=mysqli_connect("localhost","root","cutiepie_100",$db);
    if (mysqli_connect_errno()) 
        {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$abc=mysqli_query($con, $s) or die('cannot show tables');

        }

 else if ($_POST["deposit"])
        {
            $db1=$_POST["db1"];
            $sno=$_POST["sno"];
            $amount=$_POST["amount"];
            $t=$_POST["table1"];

            $f="update $t set deposit=deposit+$amount where sno=$sno;";
            print_r($f);            

            $con=mysqli_connect("localhost","root","cutiepie_100",$db1);
    if (mysqli_connect_errno()) 
        {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$abc=mysqli_query($con, $f) or die('cannot show tables');

        }
 else if($_POST["results"])
        {

             $db=$_POST["db"];

$skills = explode(",", $_POST["skills"]);
$table = explode(",", $_POST["table"]);
$city = explode(",", $_POST["city"]);
$region = explode(",", $_POST["region"]);
$country = explode(",", $_POST["country"]);

$latitude=$_POST["lat"];
$longitude=$_POST["long"];

$distance=$_POST["dist"];

$latitude*=0.01745;
$longitude*=0.01745;



$s="select sno from $table[0] where skills regexp \"$skills[0]\"";


for($i=1;$i<count($skills);$i++)
{
    $s.=" and skills regexp \"$skills[$i]\"";

    }
    $s.=" and deposit>=bid";

    for($i=0;$i<count($region);$i++)
if(!$region[$i]=="")
    {
    $s.=" and region regexp \"$region[$i]\"";

    }

    for($i=0;$i<count($city);$i++)
if(!$city[$i]=="")
    {
    $s.=" and city regexp \"$city[$i]\"";

    }


    for($i=0;$i<count($country);$i++)
if(!$country[$i]=="")
    {
    $s.=" and country regexp \"$country[$i]\"";

    }
    if(!$latitude=="")
    {

   $s.=" and acos(sin($latitude) * sin(Lati) + cos($latitude) * cos(Lati) * cos(Longi - ($longitude))) * 6371 <= $distance";
    }
    $s.=";";



    $con=mysqli_connect("localhost","root","cutiepie_100",$db);
    if (mysqli_connect_errno()) 
        {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
//print_r($s);
$abc=mysqli_query($con, $s) or die('cannot show tables');

while ($row = mysql_fetch_row($abc))
{
 echo "<tr>";
  echo "<td>" . $row['sno'] . "</td>";
   echo "</tr>";
} 
echo "</table>";
        }   
  ?>

ankit1122 -3 Junior Poster in Training · Answer 2 · 2014-09-10T04:09:47+00:00

actually;
in post(results)i'm showing the data out from mysql onto webpage...in the above complete code

while ($row = mysql_fetch_row($abc))
{
echo "<tr>";
echo "<td>" . $row['sno'] . "</td>";
echo "</tr>";
}
echo "</table>";
}
?>

this code does not show anything on page....else it has to show output from mysql in tabular form

ankit1122 -3 Junior Poster in Training · Answer 3 · 2014-09-10T04:11:34+00:00

ankit1122 -3 Junior Poster in Training

9 Years Ago

can i place php code inside body and html tags?

ankit1122 -3 Junior Poster in Training · Answer 4 · 2014-09-10T04:46:50+00:00

i mean can i access php variables after closing up

<?php
$a=10?>

echo $a;

??

urtrivedi 276 Nearly a Posting Virtuoso · Answer 5 · 2014-09-10T05:34:27+00:00

<table>
<tr>
<td> VALUE OF A</td>
<td>

<?php
    $a=10 ;
    echo $a;
?>
</td>

</tr>
</table>

mattster 195 Practically a Master Poster Featured Poster · Answer 6 · 2014-09-10T06:20:13+00:00

after closing up

Yes, if you reopen:

<?php
    $a = "XYZ";
?>
<html>
<body>

<?php
    echo $a;
?>

</body>
</html>

can we pass values bw php and table

Recommended Answers Collapse Answers

All 9 Replies

Recommended Answers