Topic: mysqli_query php funkcijoje?
Sveiki, jauciu kad strigau lygioje vietoje.
Ar galima daryti uzklausa i sql lentele is php funkcijos? Nes man kazkodel tas dalykas neveikia.
Jeigu darau paprastai, tada viskas veikia:
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$variable = 10;
$query = "SELECT field FROM table WHERE field2= '".$variable."'";
$result = mysqli_query($dbc, $query) or die ('Error');
while ($row = mysqli_fetch_array($result))
{
echo $row['field'];
}
Taciau jeigu ta pati siunciu per funkcija, pareina errorai.
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
function selection($variable)
{
$query = "SELECT field FROM table WHERE field2= '".$variable."'";
$result = mysqli_query($dbc, $query) or die ('Error');
while ($row = mysqli_fetch_array($result))
{
echo $row['field'];
}
}
if (paspausta knopke) then:
selection(10);
Kame reples? Cia kazkaip prisijungimas prie db neivyksta pacioje funkcijoje...
Dekui