Mi scuso in anticipo con la mia somma ignoranza in materia di php e myphpadmin.
Sono alle prime armi.
Ho creato una semplicissima tabella e l'ho collegata ad una pagina php. Ecco il risultato e devo dire la verita' tutto mi funziona.
http://www.slmty.com/members.php
Pero' ho un piccolo problemino, come faccio a far apparire l'immagine vera e propria, invece dell'url?
ecco il mio codice php:
<?php
//Variables for connecting to your database.
//These variable values come from your hosting account.
$hostname = "slmty.db.10874451.hostedresource.com";
$username = "slmty";
$dbname = "slmty";
//These variable values need to be changed by you before deploying
$password = "ciao ciao ciao";
$usertable = "members";
$id = "id";
$user = "user";
$firstname = "firstname";
$lastname = "lastname";
$dob = "dob";
$mobile = "mobile";
$email = "email";
$info = "info";
$photo = "photo";
//Connecting to your database
mysql_connect($hostname, $username, $password) OR DIE ("Unable to
connect to database! Please try again later.");
mysql_select_db($dbname);
//Fetching from your database table.
$query = "SELECT * FROM $usertable";
$result = mysql_query($query);
if ($result) {
while($row = mysql_fetch_array($result)) {
$name = $row["$id"];
echo "ID: $name
";
$name = $row["$user"];
echo "Username: $name
";
$name = $row["$firstname"];
echo "Firstname: $name
";
$name = $row["$lastname"];
echo "Lastname: $name
";
$name = $row["$dob"];
echo "Date of birth: $name
";
$name = $row["$mobile"];
echo "Mobile: $name
";
$name = $row["$email"];
echo "Email: $name
";
$name = $row["$info"];
echo "Info: $name
";
$name = $row["$photo"];
echo "Photo: $name
";
}
}
Rispondi quotando
