lopis
-
Posts
9 -
Joined
-
Last visited
Never
Posts posted by lopis
-
-
Keeps not working
-
Yeah they are!!
[attachment deleted by admin]
-
I want to display the images that i have uploaded, and they are stored in my database, but when i try to display them, they dont show very well, need help!!
<html>
<title>
Produtos
</title>
<body bgcolor="#99CCCC">
<center><font face = "Agency FB" size="6"> Listar Porto </font> <br><br>
<?php
$ligacao=mysql_connect('localhost','root','') or die("Problema na ligação ao MySQL");
mysql_select_db("site");
$sql = "select * from productos";
$result = mysql_query($sql) or die ("Nao consegui ligar a db");
while($row=mysql_fetch_assoc($result))
{
echo "<div class=\"Image\">";
echo "<p>";
// Note that we are building our src string using the filename from the database
echo "<img src=\"Image/" . $row['imagelocation'] . "\" alt=\"\" height='100' width='100' />";
echo $row['nome'] . " " . $row['marca'] . "";
echo "</p>";
echo "</div>";
}
mysql_close();
?>
</body>
</html>
[attachment deleted by admin]
-
I fixed that problem, but now its keep saying that user does not exist, and i already inserted users in my db
<?php
session_start();
$username=$_POST['user'];
$password=$_POST['password'];
if($username&&$password)
{
$ligacao=mysql_connect('localhost','root','') or die("Problema na ligacao ao servidor MySql");
mysql_select_db("site")or die("Problema na ligacao ao servidor MySql");
$query = mysql_query("SELECT * FROM login WHERE user = '$username' and password = '$password'");
$numrows = mysql_num_rows($query);
if($numrows!=0)
{
// codigo para login
while($row = mysql_fetch_assoc($query))
{
$dbusername=$row['user'];
$dbpassword=$row['password'];
}
// verificar se coicidem
if($username==$dbusername&&md5($password)==$dbpassword)
{
echo"Benvindo!<a href='member.php'>Click</a> aqui para ir para a sua página";
$_SESSION['user']=$username;
}
else
echo"Username ou Password erradas!";
}
else
die("Esse utilizador nao existe!");
}
else
die("Por favor insira um username e password!");
?>
i think the problem its comming from the num rows
-
Ok, i already fixed that errors, but then other one appeared :s
Notice: Undefined index: user in C:\xampp\htdocs\login\login.php on line 33
<?php
session_start();
$username=$_POST['user'];
$password=$_POST['password'];
if($username&&$password)
{
$ligacao=mysql_connect('localhost','root','') or die("Problema na ligacao ao servidor MySql");
mysql_select_db("site")or die("Problema na ligacao ao servidor MySql");
$query = mysql_query("SELECT * FROM login WHERE user = '$username' and password = '$password'");
$numrows = mysql_num_rows($query);
if($numrows!=0)
{
// codigo para login
while($row = mysql_fetch_assoc($query))
{
$dbusername=$row['user'];
$dbpassword=$row['password'];
}
// verificar se coicidem
if($username==$dbusername&&$password==$dbpassword)
{
echo"Benvindo!<a href='member.php'>Click</a> aqui para ir para a sua página";
$_SESSION['user']==$dbusername; <--- Line 33
}
else
echo"Username ou Password erradas!";
}
else
die("Esse utilizador nao existe!");
}
else
die("Por favor insira um username e password!");
?>
how can i fix it help please
-
But now its giving me a stupid error
Notice: Undefined index: user in C:\xampp\htdocs\login\login.php on line 3
$username=$_POST['user']; <--- Line 3
-
Already fixed, sry for this post guys
-
my php is giving me this error
Notice: Undefined index: username in C:\xampp\htdocs\login\login.php on line 23
here is the code from login.php
<?php
$username=$_POST['username'];
$password=$_POST['password'];
if($username&&$password)
{
$ligacao=mysql_connect('localhost','root','') or die("Problema na ligacao ao servidor MySql");
mysql_select_db("site")or die("Problema na ligacao ao servidor MySql");
$query = mysql_query("SELECT * FROM login WHERE user = '$username' and password = '$password'");
$numrows = mysql_num_rows($query);
if($numrows!=0)
{
// codigo para login
while($row = mysql_fetch_assoc($query))
{
$dbusername=$row['username']; <---- Line 23
$dbpassword=$row['password'];
}
// verificar se coicidem
if($username==$dbusername&&$password==$dbpassword)
{
echo"Benvindo!";
}
else
echo"Username ou Password erradas!";
}
else
die("Esse utilizador nao existe!");
}
else
die("Por favor insira um username e password!");
?>
Display Uploaded Images
in PHP Coding Help
Posted
Thanks mate its fixed :D