De oplossing moet je zoeken in het volgende gegeven.
Link gekopieerd
In index.php je een ander bestand, b.v. menu.php
Link gekopieerd
SanThe schreef op 12.05.2006 13:45
De oplossing moet je zoeken in het volgende gegeven.
dus jij zegt action="index.php?page=register" maar als ik dit zo doe dan wordt de volgende pagina een lege. en de ingevulde gegevens zijn nogaltijd niet in een db. dus script werkt dan ook neit >.<
Link gekopieerd
<?
include('config.php');
if(isset($_POST['submit']))
{
$query = mysql_query("SELECT * FROM members WHERE gebruikersnaam = '".$_POST['gebruikersnaam']."'");
$result = mysql_num_rows($query);
if($result >= 1)
{
echo 'De door jou gekozen gebruikersnaam wordt al door iemand anders gebruikt.<br /><br /><a href="javascript:history.go(-1)">Ga terug</a>';
}
if(!empty($_POST['naam']) AND !empty($_POST['email']) AND !empty($_POST['gebruikersnaam']) AND !empty($_POST['geslacht']) AND !empty($_POST['country']) AND !empty($_POST['geb1']) AND !empty($_POST['geb2']) AND !empty($_POST['geb3']))
{
echo 'Er zijn nog open velden<br /><br /><a href="javascript:history.go(-1)">Ga terug</a>';
}
if($_POST['wachtwoord'] != $_POST['wachtwoord2'])
{
echo 'De wachtwoorden zijn niet het zelfde<br /><a href="javascript:history.go(-1)">Ga terug</a>';
}
$geboortedatum = "$geb1-$geb2-$geb3";
$gebruikersniveau = 1;
$sql = mysql_query("INSERT INTO members (gebruikersnaam,wachtwoord,naam,email,geboortedatum,gebruikerniveau,country,geslacht,geactiveerd) VALUES ('".$_POST['gebruikersnaam']."','".$_POST['wachtwoord']."','".$_POST['naam']."','".$_POST['email']."','".$geboortedatum."','".$gebruikerniveau."','".$country."','".$_POST['geslacht']."','".$activeringscode."')") or die(mysql_error());
echo 'Je acount is gemaakt je kunt je vanaf nu inloggen met je gegevens';
}
?>
<form method="POST" action=<?=$_SERVER['PHP_SELF'] ?>>
<p>
</p>
<table width="334" cellpadding="0" cellspacing="0">
<tr>
<td width="142" valign="top"><p>Naam: </p></td>
<td width="190" valign="top"><p>
<input type="text" name="naam" size="30">
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Email: </p></td>
<td width="190" valign="top"><p>
<input type="text" name="email" size="30">
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Username: </p></td>
<td width="190" valign="top"><p>
<input type="text" name="gebruikersnaam" size="25">
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Password: </p></td>
<td width="190" valign="top"><p>
<input type="password" name="wachtwoord" size="12" maxlength="12">
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Opnieuw Password: </p></td>
<td width="190" valign="top"><p>
<input type="password" name="wachtwoord2" size="12" maxlength="12">
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Geslacht: </p></td>
<td width="190" valign="top"><p>
<select size="1" name="geslacht">
<option value="Man">Man</option>
<option value="Vrouw">Vrouw</option>
</select>
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Land: </p></td>
<td width="190" valign="top"><p>
<select name="land" size="1" id="land">
<option value="Afganistan">Afganistan</option>
<option value="Albania ">Albania</option>
<option value="Algeria">Algeria</option>
<option value="Andorra">Andorra</option>
<option value="Angola">Angola</option>
<option value="Anguilla">Anguilla</option>
<option value="Antarctica ">Antarctica</option>
<option value="Antigua ">Antigua</option>
<option value="Argentina ">Argentina</option>
<option value="Armenia">Armenia</option>
<option value="Aruba ">Aruba</option>
<option value="Australia ">Australia</option>
<option value="Austria ">Austria</option>
<option value="Azerbaijan">Azerbaijan</option>
<option value="Bahamas">Bahamas</option>
<option value="Bahrain ">Bahrain</option>
<option value="Barbados ">Barbados</option>
<option value="Bangladesh">Bangladesh</option>
<option value="Belarous">Belarous</option>
<option value="Belgium ">Belgium</option>
<option value="Belize">Belize</option>
<option value="Benin ">Benin</option>
<option value="Bermuda">Bermuda</option>
<option value="Bhutan ">Bhutan</option>
<option value="Botswana">Botswana</option>
<option value="Bolivia">Bolivia</option>
<option value="Bosnia">Bosnia</option>
<option value="Bouvet Island ">Bouvet Island</option>
<option value="Brazil">Brazil</option>
<option value="Brunei Darussalam ">Brunei Darussalam</option>
<option value="Bulgaria">Bulgaria</option>
<option value="Burkina Faso">Burkina Faso</option>
<option value="Burundi">Burundi</option>
<option value="Canada">Canada</option>
<option value="Cambodia">Cambodia</option>
<option value="Cameroon">Cameroon</option>
<option value="Cape Verde ">Cape Verde</option>
<option value="Cayman Islands ">Cayman Islands</option>
<option value="Central Aferican Republic">Central Aferican Republic</option>
<option value="Chad">Chad</option>
<option value="Chile">Chile</option>
<option value="China">China</option>
<option value="Christmas Island">Christmas Island</option>
<option value="Cocos Islands ">Cocos Islands</option>
<option value="Columbia">Columbia</option>
<option value="Comoros">Comoros</option>
<option value="Congo">Congo</option>
<option value="Congo, Democratic Republic">Congo, Democratic Republic</option>
<option value="Cook Islands">Cook Islands</option>
<option value="Costa Rica">Costa Rica</option>
<option value="Ivory Coast">Ivory Coast</option>
<option value="Croatia">Croatia</option>
<option value="Cuba ">Cuba</option>
<option value="Cyprus">Cyprus</option>
<option value="Czech Republic">Czech Republic</option>
<option value="Denmark">Denmark</option>
<option value="Djibouti">Djibouti</option>
<option value="Dominica">Dominica</option>
<option value="Dominican Republic">Dominican Republic</option>
<option value="East Timor">East Timor</option>
<option value="Ecuador">Ecuador</option>
<option value="Egypt">Egypt</option>
<option value="El Salvador ">El Salvador</option>
<option value="Equilateral Guinea">Equilateral Guinea</option>
<option value="Eritrea">Eritrea</option>
<option value="Estonia">Estonia</option>
<option value="Ethiopia">Ethiopia</option>
<option value="Falkland Islands">Falkland Islands</option>
<option value="Faroe Islands">Faroe Islands</option>
<option value="Fiji">Fiji</option>
<option value="Finland">Finland</option>
<option value="France">France</option>
<option value="French Guiana">French Guiana</option>
<option value="French Polynesia">French Polynesia</option>
<option value="Macedonia">Macedonia</option>
<option value="Gabon">Gabon</option>
<option value="Gambia">Gambia</option>
<option value="Georgia">Georgia</option>
<option value="Germany">Germany</option>
<option value="Ghana">Ghana</option>
<option value="Gibralter">Gibralter</option>
<option value="Great Britain">Great Britain</option>
<option value="Greece">Greece</option>
<option value="Greenland">Greenland</option>
<option value="Grenada">Grenada</option>
<option value="Guadeloupe">Guadeloupe</option>
<option value="Guam">Guam</option>
<option value="Guatemala">Guatemala</option>
<option value="Guinea">Guinea</option>
<option value="Guinea-Bissau">Guinea-Bissau</option>
<option value="Guyana">Guyana</option>
<option value="Haiti">Haiti</option>
<option value="Honduras">Honduras</option>
<option value="Hong Kong">Hong Kong</option>
<option value="Hungary">Hungary</option>
<option value="Iceland">Iceland</option>
<option value="India">India</option>
<option value="Indonesia">Indonesia</option>
<option value="Iran">Iran</option>
<option value="Iraq">Iraq</option>
<option value="Ireland">Ireland</option>
<option value="Israel">Israel</option>
<option value="Italy">Italy</option>
<option value="Jamaica">Jamaica</option>
<option value="Japan">Japan</option>
<option value="Jordan">Jordan</option>
<option value="Kazakhstan">Kazakhstan</option>
<option value="Kenya">Kenya</option>
<option value="Kiribati">Kiribati</option>
<option value="Korea, North">Korea, North</option>
<option value="Korea, South">Korea, South</option>
<option value="Kuwait">Kuwait</option>
<option value="Laos">Laos</option>
<option value="Lativa">Lativa</option>
<option value="Lebanon">Lebanon</option>
<option value="Liberia">Liberia</option>
<option value="Libya">Libya</option>
<option value="Lesotho">Lesotho</option>
<option value="Lithuania">Lithuania</option>
<option value="Luxembourg">Luxembourg</option>
<option value="Macau">Macau</option>
<option value="Madagascar">Madagascar</option>
<option value="Malawi">Malawi</option>
<option value="Malaysia">Malaysia</option>
<option value="Maidives">Maidives</option>
<option value="Mali">Mali</option>
<option value="Malta">Malta</option>
<option value="Marshal Islands">Marshal Islands</option>
<option value="Martinique">Martinique</option>
<option value="Mauritania">Mauritania</option>
<option value="Mauritius">Mauritius</option>
<option value="Mayotte">Mayotte</option>
<option value="Mexico">Mexico</option>
<option value="Micronesia">Micronesia</option>
<option value="Monaco">Monaco</option>
<option value="Moldovia">Moldovia</option>
<option value="Morocco">Morocco</option>
<option value="Mongolia">Mongolia</option>
<option value="Montserrat">Montserrat</option>
<option value="Mozambique">Mozambique</option>
<option value="Myanmar">Myanmar</option>
<option value="Nambia">Nambia</option>
<option value="Nauru">Nauru</option>
<option value="Nepal">Nepal</option>
<option value="Netherlands">Netherlands</option>
<option value="Netherlands Antillies">Netherlands Antillies</option>
<option value="New Calidonia">New Calidonia</option>
<option value="New Zealand">New Zealand</option>
<option value="Nicaragua">Nicaragua</option>
<option value="Niger">Niger</option>
<option value="Nigeria">Nigeria</option>
<option value="Niue">Niue</option>
<option value="Norfold Island">Norfold Island</option>
<option value="Northern Mariana Islands">Northern Mariana Islands</option>
<option value="Norway">Norway</option>
<option value="Oman">Oman</option>
<option value="Pakistan">Pakistan</option>
<option value="Palau">Palau</option>
<option value="Panama">Panama</option>
<option value="Papau New Guinea">Papau New Guinea</option>
<option value="Paraguay">Paraguay</option>
<option value="Peru">Peru</option>
<option value="Phillipines">Phillipines</option>
<option value="Pitcairn">Pitcairn</option>
<option value="Poland">Poland</option>
<option value="Portugal">Portugal</option>
<option value="Puerto Rico">Puerto Rico</option>
<option value="Qatar">Qatar</option>
<option value="Reunion">Reunion</option>
<option value="Romania">Romania</option>
<option value="Russian Federation">Russian Federation</option>
<option value="Rwanda">Rwanda</option>
<option value="Sandwich Islands">Sandwich Islands</option>
<option value="Saint Kitts">Saint Kitts</option>
<option value="Saint Lucia">Saint Lucia</option>
<option value="Saint Vincent">Saint Vincent</option>
<option value="Samoa">Samoa</option>
<option value="San Marino">San Marino</option>
<option value="Sao Tome">Sao Tome</option>
<option value="Saudi Arabia">Saudi Arabia</option>
<option value="Senegal">Senegal</option>
<option value="Seychelles">Seychelles</option>
<option value="Sierra Leone">Sierra Leone</option>
<option value="Singapore">Singapore</option>
<option value="Slovenia">Slovenia</option>
<option value="Slovak Republic">Slovak Republic</option>
<option value="Soloman Islands">Soloman Islands</option>
<option value="Somalia">Somalia</option>
<option value="South Africa">South Africa</option>
<option value="Spain">Spain</option>
<option value="Sri Lanka">Sri Lanka</option>
<option value="St, Helena">St, Helena</option>
<option value="Sudan ">Sudan</option>
<option value="Suriname">Suriname</option>
<option value="Svalbard">Svalbard</option>
<option value="Swaziland">Swaziland</option>
<option value="Sweden">Sweden</option>
<option value="Switzerland">Switzerland</option>
<option value="Syria">Syria</option>
<option value="Taiwan">Taiwan</option>
<option value="Tajikistan">Tajikistan</option>
<option value="Tanzania">Tanzania</option>
<option value="Thailand">Thailand</option>
<option value="Togo">Togo</option>
<option value="Tokelau ">Tokelau</option>
<option value="Tonga">Tonga</option>
<option value="Trinidad ">Trinidad</option>
<option value="Tunisia">Tunisia</option>
<option value="Turkey ">Turkey</option>
<option value="Turkmenistan">Turkmenistan</option>
<option value="Caicos Islands">Caicos Islands</option>
<option value="Tuvalu ">Tuvalu</option>
<option value="Uganda">Uganda</option>
<option value="Ukraine">Ukraine</option>
<option value="United Arab Emirates">United Arab Emirates</option>
<option value="United Kingdom">United Kingdom</option>
<option value="United States">United States</option>
<option value="US Minor Outlying Islands">US Minor Outlying Islands</option>
<option value="Uruguay">Uruguay</option>
<option value="Uzbekistan">Uzbekistan</option>
<option value="Vanuatu">Vanuatu</option>
<option value="Vatican City State">Vatican City State</option>
<option value="Venezuela">Venezuela</option>
<option value="Viet Nam">Viet Nam</option>
<option value="Virgin Islands (British)">Virgin Islands (British)</option>
<option value="Virgin Islands (US)">Virgin Islands (US)</option>
<option value="Wallis and Fortuna Islands">Wallis and Fortuna Islands</option>
<option value="West Sahara">West Sahara</option>
<option value="Yemen">Yemen</option>
<option value="Yugoslavia">Yugoslavia</option>
<option value="Zambia ">Zambia</option>
<option value="Zimbabwe">Zimbabwe</option>
</select>
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Geboorte Datum: </p></td>
<td width="190" valign="top"><p>
<select name="geb1">
<?
for ($i=1;$i<32;$i++){
echo '<option value='.$i.'>'.$i.'</option>';
}
echo '</select>';
echo '<select name="geb2">';
for ($i=1;$i<13;$i++){
echo '<option value='.$i.'>'.$i.'</option>';
}
echo '</select>';
echo '<select name="geb3">';
for ($i=1900;$i<2007;$i++)
{
echo '<option value='.$i.'>'.$i.'</option>';
}
echo '</select> ';
?>
</p></td>
</tr>
<tr>
<td width="334" height="24" valign="top">
<input type="submit" name="submit" value="Sign Up!">
</td>
</tr>
</table>
</form>
eventuele aanpassingen na reacties van SanThe en wes zou je zelf even moeten verwerken :)
of je code nu perfect werkt kan ik niet zeggen, dat zou je gewoon moeten proberen :)
succes verder
Link gekopieerd
Link gekopieerd
Als je een lege pagina krijgt is de kans groot dat er een error is. Heb je error_reporting(E_ALL); bovenin je script staan.
Link gekopieerd
Wat een lijst met namen (de landen) is het ook, is het niet veel mooier om ze in een Array te zetten, en dan met de foreach functie voor elk land een option te laten genereren?
Link gekopieerd
dat krijg je als je die lijst kopieërd van een andere pagina ;) had geen zin om alle landen op te gaan zoeken in een atlas ;)
Link gekopieerd
hij gaat zoiezo naar index.php omdat $_SERVER['PHP_SELF'] naar zichzelf verwijst.
Link gekopieerd
