Ver Mensaje Individual
  #1 (permalink)  
Antiguo 19/09/2010, 10:24
montanianevada
 
Fecha de Ingreso: agosto-2010
Mensajes: 13
Antigüedad: 13 años, 8 meses
Puntos: 0
agregar form de upload y tabla mysql !!

hola amigos del foro, necesitaria un pequeño ayudin encontre un script de los tantos que andan en la net, que funciona todo bien, solamente me faltaria agregarle el form de upload y lo que iria en la parte de sql.
-----------------
perfil.php (de aca se modifican los datos de perfil una ves logueado el usuario)

Código:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title></title>
</head>

<body>

<?php
$username = $_COOKIE['loggedin'];
if (!isset($_COOKIE['loggedin'])) die("You are not logged in, <a href=../login.html>click here</a> to login.");
echo "You are logged in $username";
?> | <a href="index.php">Return to members home</a>
<p>
<br />
<form action="update.php" method="post" >
  <p>Username: 
    <input type="text" name="username" disabled="disabled" value="<?php
include "../config.php";
mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
$result = mysql_db_query($database, "select * from $table WHERE username = '$username'") or die (mysql_error()); 

   while ($qry = mysql_fetch_array($result)) { 
      echo "$qry[username]"; 
   } 
?>" />
</p>
  <p>Change your password</p>
  <p> Old Password:
    <input type="password" name="oldpass" />
    <br />
    New Password:
    <input type="password" name="newpass" />
    <br />    
  </p>
	  Your Personal Details
    <p>First Name: 
      <input type="text" name="name1" value="<?php
include "../config.php";
mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
$result = mysql_db_query($database, "select * from $table WHERE username = '$username'") or die (mysql_error()); 

   while ($qry = mysql_fetch_array($result)) { 
      echo "$qry[name1]"; 
   } 
?>" />
</p>
    <p>Second Name: 
      <input type="text" name="name2" value="<?php
include "../config.php";
mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
$result = mysql_db_query($database, "select * from $table WHERE username = '$username'") or die (mysql_error()); 

   while ($qry = mysql_fetch_array($result)) { 
      echo "$qry[name2]"; 
   } 
?>" />
</p>
    <p>Email Address: 
      <input type="text" name="email" value="<?php
include "../config.php";
mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
$result = mysql_db_query($database, "select * from $table WHERE username = '$username'") or die (mysql_error()); 

   while ($qry = mysql_fetch_array($result)) {
      echo "$qry[email]"; 
   } 
?>" />
</p>
    <p>Your website (URL): 
      <input type="text" name="website" value="<?php
include "../config.php";
mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
$result = mysql_db_query($database, "select * from $table WHERE username = '$username'") or die (mysql_error()); 

   while ($qry = mysql_fetch_array($result)) {
      echo "$qry[website]"; 
   } 
?>" />
</p>


<img src="<?php include "../config.php"; mysql_connect($server, $db_user, $db_pass) or die (mysql_error());  $result = mysql_db_query($database, "select * from $table WHERE username = '$username'") or die (mysql_error());      while ($qry = mysql_fetch_array($result)) {       echo "$qry[avatar]";     }  ?>
" alt="Avatar" />


    <p>Your Avatar (URL): 
      <input type="text" name="avatar" value="<?php include "../config.php"; mysql_connect($server, $db_user, $db_pass) or die (mysql_error());  $result = mysql_db_query($database, "select * from $table WHERE username = '$username'") or die (mysql_error());      while ($qry = mysql_fetch_array($result)) {       echo "$qry[avatar]";     }  ?>" />
      <br />
      Avatar size is 150px x 150px, resizing will occur if the image is larger than the 150px x 150px size..</p>
    <p>
      <input type="submit" name="Submit" value="Submit" />
</p>
</form>


</p>
</body>
</html>
------------------
(si bien me da una opcion de avatar es para agregar un avatar atraves de una url) lo que yo quiero es poner ahi el form de upload (examinar) se entiende! (Si bien vi muchos ejemplos, no estoi seguro todavia)

Y en la parte de sql tengo esto

una tabla creada con el nombre ''tabla'' que tiene lo siguiente

id

username

password

name1

name2

email

website

avatar

-----------

Si quieren que ponga toda la estructura de la sql diganme, pero en si que es lo que tendria que modificar en perfil.php para que me suba la foto y que me faltaria en la parte de sql para que me lea la imagen.

Última edición por montanianevada; 19/09/2010 a las 10:56