Dynamic include from variable

davieboy

how do i do an include from a variable

my page which is showing results from db
i want to include a page which will get info from db using thw ID number from that page

include 'thispage.php?id=2

in getting file not found, assume since its looking for a page called thispage.php?id=2

Any ideas

David

coldwerturkey

doesn't work like that.

how about defining a $var prior to the include that thispage.php will use? or possibly sessions?

davieboy

im trying to include a vote result (ie in percentage) which will call the id's from the database.

im a wee bit baffled at it

David

coldwerturkey

...in main file...
$amount = 6;
include('file.php');

...in file.php...
$result = $amount;
//$result will == 6

davieboy

this is my vote_result script its not the most advanced

<?php

// votes results
// and sort the database
include "config.php";
$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
// We are now connected to the database
$id = $id;
$query = "SELECT * FROM coupons WHERE id = '$id'";
$result = mysql_query($query); 
while ($r=mysql_fetch_array($result)) 
{     

    $id=$r["id"]; 
	$yes=$r["yes"];
	$no=$r["no"];

}
$yes = $yes;
$no = $no;
$totalno = ($yes+$no);

// % yes 
$yespercent = ($yes / $totalno) * 100;
// %no
$nopercent = ($no / $totalno) * 100;
echo "Yes: $yespercent%"; echo " | No: $nopercent%";


// calculation (result (yes no) / totalnumber) * 100
?>

and my dispaypage

<?php $host = $_GET['host'];
include "config.php";

$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
//We are now connected to the database

$query = "SELECT * FROM coupons WHERE registrar = '".$_GET['registrar']."' AND approved = 'yes'";
$result = mysql_query($query); 
while ($r=mysql_fetch_array($result)) 
{     

    $id=$r["id"]; 
	$discount=$r["discount"];
	$coupon=$r["coupon"];
	$expires=$r["expires"];
	$registrar=$r["registrar"];
	$webaddress=$r["webaddress"];
	$webname=$r["webname"];

?>
<p>Coupon Code: <strong><?php echo $coupon;?></strong><br />
  Discount: <?php echo $discount;?><br />
  Expires: <?php echo $expires;?><br />
  Link: <?php echo "<a href=\"$webaddress\">$webname</a>";?><br />
  <a href="vote.php?id=<?php echo $id;?>&action=yes" onclick="window.open(this.href, 'child', 'scrollbars,width=250,height=250'); return false"><img src="img/accept.png" alt="This Works" width="16" height="16" border="0" /></a> <a href="vote.php?id=<?php echo $id;?>&action=no" onclick="window.open(this.href, 'child', 'scrollbars,width=250,height=250'); return false"><img src="img/delete.png" alt="Does Not Work" width="16" height="16" border="0" /></a>
<?php 
include "vote_results.inc"; }?>

davieboy

coldwerturkey;10910717 wrote:
...in main file...
$amount = 6;
include('file.php');

...in file.php...
$result = $amount;
//$result will == 6

Ok have got it working with that but limited to only one result from the main file

David

coldwerturkey

davieboy;10910722 wrote:
Ok have got it working with that but limited to only one result from the main file

David

....then make more vars.. for more results...

davieboy

coldwerturkey;10910723 wrote:
....then make more vars.. for more results...

Sorry, how would one create the variable for each result from the db?

coldwerturkey

use an array

$result = mysql_query($query) or die(mysql_error());
$array = mysql_fetch_array($result);

//...on other page

foreach($array as $key => $value) {
  //do something with the results
}

//...or even

while ($row = mysql_fetch_array($result)) {
  //do something for each row
}

davieboy

somethinkg like

include "config.php";
$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
// We are now connected to the database
$id = $amount;
$query = "SELECT * FROM coupons WHERE id = '$id'";
$result = mysql_query($query) or die(mysql_error());
$array = mysql_fetch_array($result);

//...on other page

while ($row = mysql_fetch_array($result)) {
	$id=$r["id"]; 
	$yes=$r["yes"];
	$no=$r["no"];

}
$yes = $yes;
$no = $no;
$totalno = ($yes+$no);

// % yes 
$yespercent = ($yes / $totalno) * 100;
// %no
$nopercent = ($no / $totalno) * 100;
echo "Yes: $yespercent%"; echo " | No: $nopercent%";
?>

sorry be very confused with it thats all

David

davieboy

getting somewhere

but the script is still a bit off

include "config.php";
$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");


// We are now connected to the database
$query = "SELECT * FROM coupons WHERE registrar = '".$_GET['registrar']."' AND approved = 'yes'";
$result = mysql_query($query) or die(mysql_error());
$array = mysql_fetch_array($result); 

foreach($array as $key => $value) {

        $r=mysql_fetch_array($result);   
        // Display the information 


echo "<p>Coupon Code: <strong>".$val. "". $r['productname']. "</strong><br />
  Discount: ". $r['discount']. "<br />
  Expires: ". $r['expires']. "<br />
  Link: \"<a href=\"". $r['webaddress']. "\">". $r['webname']. "</a>\"<br />
  <a href=\"vote.php?id=$id&action=yes\" onclick=\"window.open(this.href, 'child', 'scrollbars,width=250,height=250'); return false\"><img src=\"img/accept.png\" alt=\"This Works\" width=\"16\" height=\"16\" border=\"0\" /></a> <a href=\"vote.php?id=$id&action=no\" onclick=\"window.open(this.href, 'child', 'scrollbars,width=250,height=250'); return false\"><img src=\"img/delete.png\" alt=\"Does Not Work\" width=\"16\" height=\"16\" border=\"0\" /></a><br />";
$id = "". $r['id']."";
$query = "SELECT * FROM coupons WHERE id = '$id'";
$result = mysql_query($query); 
while ($r=mysql_fetch_array($result)) 
{     

    $id=$r["id"]; 
	$yes=$r["yes"];
	$no=$r["no"];

}
$yes = $yes;
$no = $no;
$totalno = ($yes+$no);

// % yes 
$yespercent = ($yes / $totalno) * 100;
// %no
$nopercent = ($no / $totalno) * 100;
$yesinclude = round($yespercent,2);
$noinclude = round($nopercent,2);
echo "Yes: $yesinclude% | No: $noinclude%";}

coldwerturkey

<?php
include "config.php";

//connect to database
$db = mysql_connect($db_host,$db_user,$db_pass); 
mysql_select_db ($db_name) or die ("Cannot connect to database"); 

// get coupons and loop
$query = "SELECT * FROM coupons WHERE registrar = '".mysql_real_escape_string($_GET['registrar'])."' AND approved = 'yes'"; 
$result = mysql_query($query) or die(mysql_error()); 
while($r = mysql_fetch_array($result)) { 

// Display the information 
echo "<p>Coupon Code: <strong>".$val. "". $r['productname']. "</strong><br /> 
  Discount: ". $r['discount']. "<br /> 
  Expires: ". $r['expires']. "<br /> 
  Link: \"<a href=\"". $r['webaddress']. "\">". $r['webname']. "</a>\"<br /> 
  <a href=\"vote.php?id=$id&action=yes\" onclick=\"window.open(this.href, 'child', 'scrollbars,width=250,height=250'); return false\"><img src=\"img/accept.png\" alt=\"This Works\" width=\"16\" height=\"16\" border=\"0\" /></a> <a href=\"vote.php?id=$id&action=no\" onclick=\"window.open(this.href, 'child', 'scrollbars,width=250,height=250'); return false\"><img src=\"img/delete.png\" alt=\"Does Not Work\" width=\"16\" height=\"16\" border=\"0\" /></a><br />"; 

//get id of row
$id = $r['id']; 
$couponquery = "SELECT * FROM coupons WHERE id = '$id'"; 
$couponresult = mysql_query($couponquery); 
$coupon = mysql_fetch_array($couponresult));

$id 	= $coupon["id"]; 
$yes 	= $coupon["yes"]; 
$no 	= $coupon["no"]; 

$totalno = ($yes+$no); 

// % yes 
$yespercent = ($yes / $totalno) * 100; 

// %no 
$nopercent = ($no / $totalno) * 100; 
$yesinclude = round($yespercent,2); 
$noinclude = round($nopercent,2); 

echo "Yes: $yesinclude% | No: $noinclude%";
} 
?>

I think you may have to fix your logic a little, I tried to clean it up a bit, but it doesn't make much scene.

davieboy

coldwerturkey,

thank yo so much, that has fixed/the script!

Legend!

David