Vrienden,
Ik ben bezig met mijn web-site, nu heb ik een vraag, hoe kan je een variabelen uitlezen, die in een PHP-script is gevuld, en in een ander PHP-script wilt gebruiken.
Ik weet dat bv in Visual Basic een commande bestaat zoals Public en Private, waarmee je variabelen in elke of in 1 sorce code kan uitlezen.
Ik doe het script, waar ik de variabelen vul en waar ik de variabelen wilt uitlezen erbij.
VULLEN:
<div align="center">
<?php
include ("dbconnect.php");
$id = $_GET['id'];
if(!isset($_GET['page'])){
$page = 1;
}else{
$page = $_GET['page'];
}
$max_results = 1;
?>
<span class="kop">
<?php
$totalRows = 0;
$query = "SELECT * FROM artist WHERE art_naam LIKE '%$search%'";
$result = mysql_query($query) or die("Error in query: $query . " . mysql_error());
$Zoek=$search;
echo "DataBase: <strong>Artist,</strong> You searched for: <strong>$Zoek</strong>";?>
</span>
<p></p><?php
$ar = 0;
$idar = array();
$artnaam = array();
$adddate = array();
$totalbums = array();
$totsize = array();
$picture = array();
while($row = mysql_fetch_row($result)){
$query1 = "SELECT * FROM artist WHERE id = '".$row[0]."'";
$result1 = mysql_query($query1) or die ("Error in query: $query1. " . mysql_error());
$row2 = mysql_fetch_object($result1);
$idar[$ar] = $row2->id;
$artnaam[$ar] = $row2->art_naam;
$artiest = $artnaam[$ar];
echo "Artiest: $artiest";
$adddate[$ar] = $row2->add_date;
$totalbums[$ar] = $row2->tot_albums;
$totsize[$ar] = $row2->tot_size;
$picture[$ar] = $row2->avatar;
$ar++;
}
?>
<?php
if(mysql_num_rows($result) > 0){ // Alleen tabel laten zien als er iets gevonden is
mysql_free_result($result1);
$totalRows = ($totalRows + count($idar));
?>
<br />
<table border="0" cellspacing="3">
<tr>
<td><p class="header">Artist name</p></td>
<td><p class="header">Total albums</p></td>
<td><p class="header">Total size</p></td>
<td><p class="header">Add date</p></td>
<td><p class="header">Link</p></td>
<td> </td>
</tr>
<?php for ($ar=0; $ar<count($idar); $ar++) {?>
<tr>
<td><p class="value"><?php echo "$artnaam[$ar]"; ?></p></td>
<td><p class="value1"><?php echo "$totalbums[$ar]"; ?></p></td>
<td><p class="value"><?php echo "$totsize[$ar]"; ?></p></td>
<td><p class="value1"><?php echo "$adddate[$ar]"; ?></p></td>
<td><p class="value"><a href='index.php?section=searchtest'>Details</a></p></td>
<td> </td>
</tr><?php }?>
</table>
<?php
// teken een lijn
?>
<hr>
<?php
}else{?>
<span class="kop"><?php
echo "Sorry, no results found.";?>
<?php
// teken een lijn
?>
<hr> <?php
}
?>
</span>
UITLEZEN:
<?php
//require ("search.php");
echo "Artiest ID: $idar";?><p></p><?php
echo "Zoekwoord: $search";?><p></p><?php
include ("dbconnect.php");
$totalRows = 0;
$query = "SELECT * FROM artist WHERE id = '".$row[0]."'";
$result = mysql_query($query) or die("Error in query: $query . " . mysql_error());
while($row = mysql_fetch_row($result)){
$query1 = "SELECT * FROM artist WHERE id = $idar[$ar]";
$result1 = mysql_query($query1) or die ("Error in query: $query1. " . mysql_error());
$row2 = mysql_fetch_object($result1);
$artiest = $row2->art_naam;
$picture = $row2->avatar;
echo "Avatar: $picture";
}
?>
<table width="136" border="0" cellspacing="0">
<tr>
<td width="110"><img src="<?php echo "$picture" ?>" /></td>
</tr>
<tr>
<td><p class="style3"><?php echo "$artiest" ?></p></td>
</tr>
</table>
<table width="108" border="0" cellspacing="3">
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
Ik hoop dat jullie een oplossing hebben, alvast bedankt.
307 views