izvilkt aaraa no db

[djmartins]

kaa lai izvelku visu info aaraa no datu baazes?

 

<?

$host == "**"; //te mums buus MySQL hosts

$port == "***"; //te mums buus MySQL ports

$user == "*****"; //te mums buus MySQL users

$pass == "******"; //te mums buus MySQL parole

$database == "guestbook"; //te mums buus MySQL database

$db = mysql_connect("$host:$port", "$user", "$pass"); //ievadam vajadziigo database ...

$result = mysql_query("SELECT * FROM gbook;", $db); //saakam ciklu , kas no table gbook izvelk aaraa visus ierakstus ...

?>

 

man te kaads gluks vai netaa kaut ko uzrakstiijis???

[hu_ha]

1. tev nav noraadiita datu baaze, kuru izmantoto -> ar $database == "guestbook" nepietiks :)

2. kas taas par divaam "ir" ziimeem -> $host == "**";

3. cikls ir nevis uz query bet uz mysql_fetch_... -> $row = mysql_fetch_assoc($result)

karoche skatīt shamo piem iz php.net http://lv.php.net/manual/en/function.mysql-fetch-assoc.php

 

<?php

$conn = mysql_connect("localhost", "mysql_user", "mysql_password");

if (!$conn) {
  echo "Unable to connect to DB: " . mysql_error();
  exit;
}
 
if (!mysql_select_db("mydbname")) {
  echo "Unable to select mydbname: " . mysql_error();
  exit;
}

$sql = "SELECT id as userid, fullname, userstatus
      FROM  sometable
      WHERE  userstatus = 1";

$result = mysql_query($sql);

if (!$result) {
  echo "Could not successfully run query ($sql) from DB: " . mysql_error();
  exit;
}

if (mysql_num_rows($result) == 0) {
  echo "No rows found, nothing to print so am exiting";
  exit;
}

// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
//      then create $userid, $fullname, and $userstatus
while ($row = mysql_fetch_assoc($result)) {
  echo $row["userid"];
  echo $row["fullname"];
  echo $row["userstatus"];
}

mysql_free_result($result);

?>

[djmartins]

echo $row["userid"];

echo $row["fullname"];

echo $row["userstatus"];

 

kas tas?Tur kaut kas jaaraksta ieksaa?

[hu_ha]

es domāju, ka atbildot uz šo jautājumu, es liegšu tev iespēju izmantot gūgli, tāpēc to nedarīšu.

[djmartins]

ok paldies viss aizgaaja tikai es tur drusku savaadaak taakaa saakumaa raadiiju tik biski tur paaris lietas piesteleet vajadzeeja.