Hjælp med array
Jeg har et problem som i kan se tjekker den om subdomain name er = med subdomain (i dette tilfælde test) som skal leje at den er noget fra databasen. når den så skriver up efter else skal den printe alt indhold 1 gang.Den skal udføre føljene funktion.
1. Tjekke om subdomain findes i database.
2. Vis den findes fortæl bruger at kan skal gå tilbage og tag et nyt
3. Vis det ikke findes gå til registrering og send oplysning om dig selv.
Håber i kan hjælpe kan bare ikke regne denne her ud
<?
$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'] == "test"){
echo "hej";
}else{
echo "hej2"; <-- den skulle gerne vise dette x2 men skal kun vise det 1 gang
}
}
?>
her er hele min kode men dette over er bare det samme.
<?php
function randomkeys($length)
{
$pattern = "1234567890";
for($i=0;$i<$length;$i++)
{
$key .= $pattern{rand(0,68)};
}
return $key;
}
?>
<? 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>
<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);
?>
<? }?>
