Scripts - Tutorials - Forum - Downloads - Showcase - Contact

Artikels

VPN vergelijken

Algemeen

Beginpagina

FAQ

Grafische worm (243)

Links

Nieuwsartikels

Nieuwsarchief

Boeken programmeren

Overzicht

Samenwerken

Webhosting

Zoek op Sitemasters

Leden

Registreren

Ledenlijst

Ons team

Links

webhostingtop10.be

Sociale media

Follow @sitemasters

Sitemasters

Adverteren op Sitemasters?

Contacteer ons

RSS

Link naar ons

Donaties

Poll

Je moet ingelogd zijn om te stemmen.

Statistieken

Linkpartners

Forum

Categorieën > PHP & SQL

databasevraaje

gamesty - 03/08/2005 08:33 (laatste wijziging 03/08/2005 08:33)
Onbekend		Hallo, Ik wil een url opslaan in database.Met wat doe ik het best?Int,text,varchar. Ik denk persoonlijk varchar maar ben het niet zeker.

7 antwoorden

Gesponsorde links

nemesiskoen - 03/08/2005 08:34
PHP expert		varchar

gamesty - 03/08/2005 08:34
Onbekend		Zoals ik dacht.Bedankt

lasdesigner - 03/08/2005 09:23
PHP beginner		Tenzij je url langer is dan 255 tekens. Dan moet je wel text gebruiken!

gamesty - 03/08/2005 10:25 (laatste wijziging 03/08/2005 10:32)

Onbekend

Hallo,

Ik krijg het dus maar niet naar de database geschreven:

Dit is wat ik heb:

php code - Bekijk de code zonder highlighting - Klap code in

$data->avaterurl		= preg_replace('/\</','&#60;',$_POST['website']);
mysql_query("UPDATE `[users]` SET `url`='{$data->url}',`info`='{$data->info}','avaurl'='{$data->avaterurl}' WHERE `login`='{$data->login}'");


<form method="post"><tr><td width=100>Picture(URL):</td>    <td><input type="wp" name="avaurl" value="{$data->avaurl}"></td></tr></form>

$data->avaterurl		= preg_replace('/\</','&#60;',$_POST['website']);
mysql_query("UPDATE `[users]` SET `url`='{$data->url}',`info`='{$data->info}','avaurl'='{$data->avaterurl}' WHERE `login`='{$data->login}'");
 
 
<form method="post"><tr><td width=100>Picture(URL):</td>    <td><input type="wp" name="avaurl" value="{$data->avaurl}"></td></tr></form>

Hiertussen zitten wel nog andere dingen maar die heb je denk ik niet nodig.Ik krijg dus wel de inhoud vanuit de database maar als ik de inhoud wil wijzigen met dat Form blijft het de oude.

Ontani - 03/08/2005 11:08
-1		name="avaurl" & $_POST['website'] gaat nie werken e name="avaurl" & $_POST['avaurl'] of name="website" & $_POST['website']

gamesty - 03/08/2005 11:43 (laatste wijziging 03/08/2005 19:52)

Onbekend

ow,Domme fout.Had ik niet gezien.

Edit:Helaas,Nog niet:
Ik wil dus avaurl wijzigen in tabel [users]
Dit is de code.En nu zie ik dat info en website ook niet veranderen in de database.Er moet dus iets fout zijn.

php code - Bekijk de code zonder highlighting - Klap code in

<?php /* ------------------------- */

  $OMNILOG				= 1;
  include("_include-config.php");
  if(! check_login()) {
    header("Location: login.php");
    exit;
  }

  mysql_query("UPDATE `[users]` SET `online`=NOW() WHERE `login`='{$data->login}'");

/* ------------------------- */ ?>
<html>


<head>
<title>[( Farwest )]</title>
<link rel="stylesheet" type="text/css" href="<?php echo ($_COOKIE['v'] == 2) ? "css-v2.css" : "css-v1.css"; ?>">

</head>


<body style="background: #DEB887; margin: 0px;">
<table width=100%>
  <tr><td class="subTitle"><b>Profiel</b></td>
<?php /* ------------------------- */

  print "  <tr><td class=\"mainTxt\"><a href=\"profile.php?x={$data->login}\">Bekijk je profiel</a></td></tr>\n";
  if(isset($_POST['profile'])) {
    $data->url				= preg_replace('/\</','&#60;',$_POST['website']);
    $data->avaurl		= preg_replace('/\</','&#60;',$_POST['avaurl']);
    $data->info				= preg_replace('/\</','&#60;',substr($_POST['info'],0,500));
    mysql_query("UPDATE `[users]` SET `url`='{$data->url}',`info`='{$data->info}','avaurl'='{$data->avaurl}' WHERE `login`='{$data->login}'");
    print "  <tr><td class=\"mainTxt\">Je profiel is veranderd</td></tr>\n";
  }
  else if(isset($_POST['password'])) {
    if($_POST['pass'] != "" && $_POST['pass'] == $_POST['confirm']) {
      mysql_query("UPDATE `[users]` SET `pass`=MD5('{$_POST['pass']}') WHERE `login`='{$data->login}'");
      print "  <tr><td class=\"mainTxt\">Je wachtwoord is veranderd</td></tr>\n";
    }
    else
      print "  <tr><td class=\"mainTxt\">De twee wachtwoorden waren niet identiek</td></tr>\n";
  }

  $data->url				= stripslashes($data->url);
  $data->avaurl				= stripslashes($data->avaurl);
  $data->info				= stripslashes($data->info);
  print <<<ENDHTML
  <tr><td class="mainTxt">
	<form method="post"><table align="center">
	  <tr><td width=100>E-Mail:</td>	<td>{$data->email}</td></tr>
	  <tr><td width=100>Website:</td>	<td><input type="text" name="website" value="{$data->url}"></td></tr>
	  <tr><td width=100>Picture(URL):</td>    <td><input type="wp" name="avaurl" value="{$data->avaurl}"></td></tr>
	  <tr><td width=100 valign="top">Info:</td>
						<td><textarea name="info" cols=30 rows=10>{$data->info}</textarea></td></tr>
	  <tr><td></td>				<td align="right"><input type="submit" name="profile" value="Verander"></td></tr>
	</table></form>
  </td></tr>
  <tr><td><br></td></tr>

  <tr><td class="subTitle"><b>Wachtwoord</b></td></tr>
  <tr><td class="mainTxt">
	<form method="post"><table align="center">
	  <tr><td width=100>Nieuw:</td>		<td><input type="password" name="pass" maxlength=16></td></tr>
	  <tr><td width=100>Herhaal:</td>	<td><input type="password" name="confirm" maxlength=16></td></tr>
	  <tr><td></td>				<td align="right"><input type="submit" name="password" value="Verander"></td></tr>
	</table></form>
  </td></tr>
ENDHTML;

/* ------------------------- */ ?>
</table>

</body>


</html>

<?php /* ------------------------- */
 
  $OMNILOG				= 1;
  include("_include-config.php");
  if(! check_login()) {
    header("Location: login.php");
    exit;
  }
 
  mysql_query("UPDATE `[users]` SET `online`=NOW() WHERE `login`='{$data->login}'");
 
/* ------------------------- */ ?>
<html>
 
 
<head>
<title>[( Farwest )]</title>
<link rel="stylesheet" type="text/css" href="<?php echo ($_COOKIE['v'] == 2) ? "css-v2.css" : "css-v1.css"; ?>">
 
</head>
 
 
<body style="background: #DEB887; margin: 0px;">
<table width=100%>
  <tr><td class="subTitle"><b>Profiel</b></td>
<?php /* ------------------------- */
 
  print "  <tr><td class=\"mainTxt\"><a href=\"profile.php?x={$data->login}\">Bekijk je profiel</a></td></tr>\n";
  if(isset($_POST['profile'])) {
    $data->url				= preg_replace('/\</','&#60;',$_POST['website']);
    $data->avaurl		= preg_replace('/\</','&#60;',$_POST['avaurl']);
    $data->info				= preg_replace('/\</','&#60;',substr($_POST['info'],0,500));
    mysql_query("UPDATE `[users]` SET `url`='{$data->url}',`info`='{$data->info}','avaurl'='{$data->avaurl}' WHERE `login`='{$data->login}'");
    print "  <tr><td class=\"mainTxt\">Je profiel is veranderd</td></tr>\n";
  }
  else if(isset($_POST['password'])) {
    if($_POST['pass'] != "" && $_POST['pass'] == $_POST['confirm']) {
      mysql_query("UPDATE `[users]` SET `pass`=MD5('{$_POST['pass']}') WHERE `login`='{$data->login}'");
      print "  <tr><td class=\"mainTxt\">Je wachtwoord is veranderd</td></tr>\n";
    }
    else
      print "  <tr><td class=\"mainTxt\">De twee wachtwoorden waren niet identiek</td></tr>\n";
  }
 
  $data->url				= stripslashes($data->url);
  $data->avaurl				= stripslashes($data->avaurl);
  $data->info				= stripslashes($data->info);
  print <<<ENDHTML
  <tr><td class="mainTxt">
	<form method="post"><table align="center">
	  <tr><td width=100>E-Mail:</td>	<td>{$data->email}</td></tr>
	  <tr><td width=100>Website:</td>	<td><input type="text" name="website" value="{$data->url}"></td></tr>
	  <tr><td width=100>Picture(URL):</td>    <td><input type="wp" name="avaurl" value="{$data->avaurl}"></td></tr>
	  <tr><td width=100 valign="top">Info:</td>
						<td><textarea name="info" cols=30 rows=10>{$data->info}</textarea></td></tr>
	  <tr><td></td>				<td align="right"><input type="submit" name="profile" value="Verander"></td></tr>
	</table></form>
  </td></tr>
  <tr><td><br></td></tr>
 
  <tr><td class="subTitle"><b>Wachtwoord</b></td></tr>
  <tr><td class="mainTxt">
	<form method="post"><table align="center">
	  <tr><td width=100>Nieuw:</td>		<td><input type="password" name="pass" maxlength=16></td></tr>
	  <tr><td width=100>Herhaal:</td>	<td><input type="password" name="confirm" maxlength=16></td></tr>
	  <tr><td></td>				<td align="right"><input type="submit" name="password" value="Verander"></td></tr>
	</table></form>
  </td></tr>
ENDHTML;
 
/* ------------------------- */ ?>
</table>
 
</body>
 
 
</html>

Iemand?

Button - 03/08/2005 22:37
PHP ver gevorderde		mysql_query("UPDATE `[users]` SET `online`=NOW() WHERE `login`='{$data->login}'") or die ("Fout: " . mysql_error()); zet die "or die ("Fout: " . mysql_error());" achter al je mysql_query()'s dan kan je misschien zien wat er scheelt.

Gesponsorde links

Dit onderwerp is gesloten.

Actiefste leden van de maand

Actieve forumberichten