php sql problem med hvad den skal vise.
Oki så jeg har et problem med min registrering.. så snart der er 1 som har registret sig på min side virker min samlining ikk..Den tjekker vis en bruger har valgt samme domain name som en anden og vis han har så skal den sige det er optaget og men skal tilbage of finde et nyt... men når der er 2 der er registret vil den lave det alt output på siden bliver dubelt.. :( hvad gør jeg for at stoppe det?!
http://www.webhosteu.com/webhosteu_beta/index.php?page=service&goto=host
<? if($_GET['step'] == ""){?>
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
<table cellpadding="0" cellspacing="0" border="0">
<tr style="color:#999999;" bgcolor="#f3f3f3">
<td width="305px">
<strong>State Subdomain</strong>
</td>
<td width="305px" align="right">
<strong>Step 1 / 2 </strong>
</td>
</tr>
<tr>
<td colspan="2">
State the name of the domain, that you wish to resive on WEBHOSTEU's server.
</td>
</tr>
<form action="?page=host/guild&step=1" method="post">
<tr>
<td colspan="2">
<br>Subdomain name<br>
<input width="300px" type="text" name="subdomain" style="border:1px gray solid;">
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="submit" value="Next >">
</td>
</tr>
</form>
</table>
<? }elseif($_GET['step'] == "1"){?>
<?
$subdomain = trim($_POST['subdomain']);
$SQL = "SELECT * FROM webhosteu_users WHERE subdomain_name != ''";
$loadin = mysql_query($SQL) or die("There is an Error in the database");
while ($row = mysql_fetch_array($loadin)){?>
<? if($row['subdomain_name'] == "$subdomain"){ ?>
<table cellpadding="0" cellspacing="0" border="0">
<tr style="color:#999999;" bgcolor="#f3f3f3">
<td width="305px">
<strong>Error!!!</strong>
</td>
<td width="305px" align="right">
<strong>Step 2 / 2 </strong>
</td>
</tr>
<tr>
<td colspan="2">
<? echo "The subdomain ";?><span style="color:#FF0000;"><? echo $subdomain;?></span><? echo " is not available";?>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<br>Please go back and try another subdomain<br>
<a href="?page=host/guild">Go back</a>
</td>
</tr>
</table>
<? }else{
$subdomain = trim($_POST['subdomain']);
?>
<table cellpadding="0" cellspacing="0" border="0">
<tr style="color:#999999;" bgcolor="#f3f3f3">
<td width="305px">
<strong>Personal Informatin</strong>
</td>
<td width="305px" align="right">
<strong>Step 2 / 2 </strong>
</td>
</tr>
<tr>
<td colspan="2">
We need some information about you, to confirm ho you are.<br /><br />
</td>
</tr>
<form action="?page=host/guild&step=2" method="post">
<tr>
<td>First Name</td>
<td><input width="300px" type="text" name="first_name" style="border:1px gray solid;"></td>
</tr>
<tr>
<td>Last Name</td>
<td><input width="300px" type="text" name="last_name" style="border:1px gray solid;"></td>
</tr>
<tr>
<td>City</td>
<td><input width="300px" type="text" name="city" style="border:1px gray solid;"></td>
</tr>
<tr>
<td>Country</td>
<td><select name="country">
<option value="4">Afghanistan </option>
<option value="5">Albania </option>
<option value="6">Algeria </option>
<option value="7">American Samoa </option>
<option value="8">Andorra </option>
<option value="10">Angola </option>
<option value="11">Anguilla </option>
<option value="12">Antigua and Barbude </option>
<option value="9">Argentina </option>
<option value="13">Armenia </option>
<option value="14">Aruba </option>
<option value="15">Ascension Island </option>
<option value="16">Australia </option>
<option value="17">Austria </option>
<option value="18">Azerbaijan </option>
<option value="19">Bahamas </option>
<option value="20">Bahrain </option>
<option value="21">Bangladesh </option>
<option value="22">Barbados </option>
<option value="23">Belarus </option>
<option value="24">Belgium </option>
<option value="25">Belize </option>
<option value="26">Benin </option>
<option value="27">Bermuda </option>
<option value="28">Bhutan </option>
<option value="29">Bolivia </option>
<option value="30">Bosnia and Herzegonvina </option>
<option value="31">Botswana </option>
<option value="32">Brazil </option>
<option value="33">British Indian Ocean Territory </option>
<option value="34">Brunei Darussalam </option>
<option value="35">Bulgaria </option>
<option value="36">Burkina Faso </option>
<option value="37">Burundi </option>
<option value="39">Camaroon </option>
<option value="38">Cambodia </option>
<option value="2">Canada </option>
<option value="40">Cape Verde </option>
<option value="41">Cayman Islands </option>
<option value="42">Central African Republic </option>
<option value="43">Chad </option>
<option value="45">Chile </option>
<option value="44">China </option>
<option value="46">Christmas-Island </option>
<option value="47">Cocos Islands </option>
<option value="48">Columbia </option>
<option value="49">Comoros </option>
<option value="50">Congo </option>
<option value="51">Cook Islands </option>
<option value="52">Costs Rica </option>
<option value="53">Cote D Ivoire </option>
<option value="54">Croatia </option>
<option value="55">Cuba </option>
<option value="56">Cyprus </option>
<option value="57">Czech Republic </option>
<option value="58" selected="selected">Denmark </option>
<option value="59">Djibouti </option>
<option value="60">Dominican Republic </option>
<option value="63">Ecuador </option>
<option value="61">Egypt </option>
<option value="62">El Salvador </option>
<option value="64">Equatorial Guinea </option>
<option value="65">Eritrea </option>
<option value="66">Estonia </option>
<option value="67">Ethiopia </option>
<option value="68">Falkland Islands </option>
<option value="69">Faroe Islands </option>
<option value="70">Federated States of Micronesia </option>
<option value="71">Fiji </option>
<option value="72">Finland </option>
<option value="73">France </option>
<option value="74">French Guiana </option>
<option value="75">French Polynesia </option>
<option value="76">Gabon </option>
<option value="77">Gambia </option>
<option value="78">Gaza Strip </option>
<option value="79">Georgia </option>
<option value="80">Germany </option>
<option value="81">Ghana </option>
<option value="82">Gibralter </option>
<option value="83">Greece </option>
<option value="84">Greenland </option>
<option value="85">Grenada </option>
<option value="86">Guadeloupe </option>
<option value="87">Guam </option>
<option value="88">Guatemala </option>
<option value="89">Guernsey </option>
<option value="90">Guinea </option>
<option value="91">Guinea-Bissau </option>
<option value="92">Guyana </option>
<option value="93">Haiti </option>
<option value="94">Holy See </option>
<option value="95">Honduras </option>
<option value="96">Hong Kong </option>
<option value="97">Hungary </option>
<option value="98">Iceland </option>
<option value="99">India </option>
<option value="100">Indonesia </option>
<option value="101">Iran </option>
<option value="102">Iraq </option>
<option value="103">Ireland </option>
<option value="104">Israel </option>
<option value="105">Italy </option>
<option value="106">Jamaica </option>
<option value="108">Japan </option>
<option value="107">Jarvis Island </option>
<option value="109">Jordan </option>
<option value="110">Kazakhstan </option>
<option value="111">Kenya </option>
<option value="112">Kiribati </option>
<option value="113">Korea (Peoples Republic of) </option>
<option value="114">Korea (Republic of) </option>
<option value="115">Kuwait </option>
<option value="116">Laos </option>
<option value="117">Latvia </option>
<option value="118">Lebanon </option>
<option value="119">Lesotho </option>
<option value="120">Liberia </option>
<option value="121">Liechtenstein </option>
<option value="122">Lithuania </option>
<option value="123">Luxembourg </option>
<option value="124">Macau </option>
<option value="125">Macedonia </option>
<option value="126">Madagascar </option>
<option value="127">Malawi </option>
<option value="128">Malaysia </option>
<option value="130">Mali </option>
<option value="131">Malta </option>
<option value="132">Marshall Islands </option>
<option value="133">Martinique </option>
<option value="134">Mauritius </option>
<option value="135">Mayotte </option>
<option value="129">Meldives </option>
<option value="3">Mexico </option>
<option value="136">Moldavia </option>
<option value="137">Monaco </option>
<option value="138">Mongolia </option>
<option value="140">Montserrat </option>
<option value="141">Morocco </option>
<option value="139">Motenegro </option>
<option value="142">Mozambique </option>
<option value="143">Myamar </option>
<option value="144">Namibia </option>
<option value="145">Nauru </option>
<option value="146">Nepal </option>
<option value="147">Netherlands </option>
<option value="148">Netherlands-Antilles </option>
<option value="149">New Caledonia </option>
<option value="150">New Zealand </option>
<option value="151">Nicaragua </option>
<option value="152">Niger </option>
<option value="153">Nigeria </option>
<option value="154">Niue </option>
<option value="155">Norfolk Island </option>
<option value="156">Northern Cypress </option>
<option value="157">Northern Mariana Islands </option>
<option value="158">Norway </option>
<option value="159">Oman </option>
<option value="160">Pakistan </option>
<option value="161">Palau </option>
<option value="162">Panama </option>
<option value="163">Papa New Guinea </option>
<option value="164">Paraguay </option>
<option value="165">Peru </option>
<option value="166">Philippines </option>
<option value="167">Pitcairn </option>
<option value="168">Poland </option>
<option value="169">Portugal </option>
<option value="170">Puerto Rico </option>
<option value="171">Qatar </option>
<option value="172">Reunion </option>
<option value="173">Romania </option>
<option value="174">Russian Federation </option>
<option value="175">Rwanda </option>
<option value="176">Saint Vincent and the Grenadines </option>
<option value="177">San Marino </option>
<option value="178">Sao Tome and Principe </option>
<option value="179">Saudi Arabia </option>
<option value="180">Senegal </option>
<option value="181">Serbia </option>
<option value="182">Seychelles </option>
<option value="183">Sierra Leone </option>
<option value="184">Singapore </option>
<option value="187">Slovakia </option>
<option value="186">Slovenia </option>
<option value="188">Solomon Islands </option>
<option value="189">Somalia </option>
<option value="190">South Africa </option>
<option value="191">South Georgia </option>
<option value="192">South Sandwich Islands </option>
<option value="193">Spain </option>
<option value="185">Sri-Lanka </option>
<option value="194">St. Helena </option>
<option value="195">St. Kitts and Nevis </option>
<option value="196">St. Lucia </option>
<option value="199">Sualbard </option>
<option value="197">Sudan </option>
<option value="198">Suriname </option>
<option value="200">Swaziland </option>
<option value="201">Sweden </option>
<option value="202">Switzerland </option>
<option value="203">Syrian Arab Republic </option>
<option value="206">Taiwan </option>
<option value="204">Tajikistan </option>
<option value="205">Tanzania </option>
<option value="207">Thailand </option>
<option value="208">Togo </option>
<option value="209">Tokelau </option>
<option value="210">Tonga </option>
<option value="211">Trinidad and Tobago </option>
<option value="212">Tristan da Cunha </option>
<option value="213">Tunisia </option>
<option value="214">Turkey </option>
<option value="215">Turkmenistan </option>
<option value="216">Turks and Caicos Islands </option>
<option value="217">Tuvalu </option>
<option value="218">Uganda </option>
<option value="219">Ukraine </option>
<option value="220">United Arab Emirates </option>
<option value="221">United Kingdom </option>
<option value="1">United States </option>
<option value="222">Urugary </option>
<option value="223">Uzbekistan </option>
<option value="224">Vanuatu </option>
<option value="225">Venezuela </option>
<option value="226">Vietnam </option>
<option value="227">Virgin Islands (UK) </option>
<option value="228">Virgin Islands (US) </option>
<option value="229">Wallis and Futanu Islands </option>
<option value="230">West Bank </option>
<option value="231">Western Sahara </option>
<option value="232">Western Somoa </option>
<option value="233">Yemen </option>
<option value="234">Yugoslavia </option>
<option value="235">Zaire </option>
<option value="236">Zambia </option>
<option value="237">Zimbabwe</option>
</select></td>
</tr>
<tr>
<td>State/Province</td>
<td><input width="300px" type="text" name="state_province" style="border:1px gray solid;"></td>
</tr>
<tr>
<td>Gender</td>
<td>
<SELECT name="gender">
<OPTION value="male">Male</OPTION>
<OPTION value="female">Female</OPTION>
</SELECT>
</td>
</tr>
<tr>
<td>Date of Birth</td>
<td><input width="300px" type="text" name="date_of_birth" style="border:1px gray solid;"></td>
</tr>
<tr>
<td>E-mail</td>
<td><input width="300px" type="text" name="email" style="border:1px gray solid;"></td>
</tr>
<tr>
<td colspan="2" width="100%">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="border:1px black solid;">
<tr>
<td bgcolor="#CCCCCC">Subdomain Name</td>
<td bgcolor="#CCCCCC"><input width="300px" value="<? echo $subdomain;?>" type="text" name="subdomain_name" style="border:1px gray solid; background-color:#999999;" readonly=""></td>
</tr>
<tr>
<td bgcolor="#CCCCCC">Subdomain Password</td>
<td bgcolor="#CCCCCC"><input width="300px" type="text" name="subpass" style="border:1px gray solid;"></td>
</tr>
<tr>
<?php
function randomkeys($length)
{
$pattern = "1234567890";
for($i=0;$i<$length;$i++)
{
$key .= $pattern{rand(0,68)};
}
return $key;
}
?>
<td bgcolor="#CCCCCC">Customer Number</td>
<td bgcolor="#CCCCCC"><input width="300px" type="text" name="customer_number" value="Whe<? echo randomkeys(64);?>" style="background-color:#999999;" readonly=""></td>
</tr>
<tr>
<td bgcolor="#CCCCCC">User Password</td>
<td bgcolor="#CCCCCC"><input width="300px" type="text" name="password" style="border:1px gray solid;"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="submit" value="Next >">
</td>
</tr>
</form>
</table>
<? }?>
<? }?>
<? }elseif($_GET['step'] == "2"){?>
<? Db::Conn(open);
if($_POST['first_name'] != ""){ //-- ```````````````````````````````Registration
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$city = $_POST['city'];
$country = $_POST['country'];
$state_province = $_POST['state_province'];
$date_of_birth = $_POST['date_of_birth'];
$gender = $_POST['gender'];
$email = $_POST['email'];
$subdomain_name = $_POST['subdomain_name'];
$subpass = $_POST['subpass'];
$username = $_POST['customer_number'];
$password = $_POST['password'];
$date = date("d-m-Y");
$time = date("h:i a");
mysql_query("INSERT INTO webhosteu_users (
first_name,
last_name,
city,
country,
state_province,
date_of_birth,
gender,
email,
subdomain_name,
subpass,
username,
password,
date,
time
) VALUES (
'$first_name',
'$last_name',
'$city',
'$country',
'$state_province',
'$date_of_birth',
'$gender',
'$email',
'$subdomain_name',
'$subpass',
'$username',
'$password',
'$date',
'$time'
)") or die (Java::Alert("MySQL Error: ".mysql_error()));
Java::Alert("You will resive a mail with you registration information.");
$to = $_POST['email'];
$subject = 'WEBHOSTEU Registration!';
$message = 'Welcome '.$_POST['first_name'].', to WEBHOSTEU Guild creater.<br><br>Use the following information to get started<br>Customer number: '.$_POST['customer_number'].' <br>Password: '.$_POST['password'].' <br><br><center>From WEBHOSTEU</center>';
$headers = "From: webhosteu.webhosteu.com\r\n" .
'X-Mailer: PHP/' . phpversion() . "\r\n" .
"MIME-Version: 1.0\r\n" .
"Content-Type: text/html; charset=utf-8\r\n" .
"Content-Transfer-Encoding: 8bit\r\n\r\n";
mail($to, $subject, $message, $headers);
Java::GoToURL("http://www.webhosteu.com");
}elseif($do == ""){ //-- ```````````````````````````````MENU
Java::Alert("To littel information!");
}
Db::Conn(close);
?>
<? }?>
