2 problemy s PHP

kalosrac

Nazdar mam dva scripty kde mam problemy... jeden je login.php ktory mam tu. Jednoducho ma nechce prihlasit a neviem ani za och prist na to v com je chyba
login.php

Kód: Vybrať všetko

<?
ob_start();
include "config.php";

if (isset($_GET['action']) && ($_GET['action'] == "logout")) {
	setcookie("user_logged", "", time()-86400, "/");
	header("Location: http://profiinvest.org/new1/index.php");
}

if (isset($_POST['login'])) {
		$pass = addslashes(htmlspecialchars($_POST['pass']));
		$nick = addslashes(htmlspecialchars($_POST['nick']));
	
		$sql = mysql_query("select id from users where username = '".$nick."' and password = '".md5($pass)."'");
		if (mysql_num_rows($sql)) {
			$row = mysql_fetch_array($sql);
			setcookie("user_logged", $row['id']."-".md5($pass), time()+86400, "/");
		} else {
			echo "Wrong nickname or password!";
		}
	header("Location: http://profiinvest.org/new1/index.php");
}

function logged() {
	if (isset($_COOKIE['user_logged'])) {
		$exp = explode("-",$_COOKIE['user_logged']);
		$sql = mysql_query("select id from users where id = '".(int)$exp[0]."' and password = '".$exp[1]."'");
		if (mysql_num_rows($sql)) { return true; }
		else { return false; }
	} else {
		return false;
	}
} 

/* povedzme ze mas tabulku users a v nej tieto polia: ID, nick, password, info */

if (!logged()) {
	?>

	<form action="http://profiinvest.org/new1/login.php" method="POST">
  <div><strong><u>Nickname:</u></strong>&nbsp;</div>

  <div><input type="text" style="width: 125px" name="nick" /></div>

  <div><strong><u>Password:</u></strong>&nbsp;</div>

  <div><input type="password" name="pass" style="width: 125px" /></div>
	<input type="submit" value="Login" name="login" align="center"> <br>
  <a href="index.php?a=registration">Sign Up Now !!</a><br>
  <a href="index.php?a=forget_pass">Forget Password?</a>
  </form>
	<?

} else {
	$exp = explode("-",$_COOKIE['user_logged']);
	$sql = mysql_query("select * from users where id = '".(int)$exp[0]."' and password = '".$exp[1]."'");
	if (mysql_num_rows($sql)) {
		while ($row = mysql_fetch_array($sql)) {
			$nickname = $row['username'];
			$id = $row['id'];
			$account = $row['account'];
		}
	} else {
	echo "Wrong nickname or password !";
	}            
	?>
	
<?
echo "<div><a href='index.php?action=my_profile&id=$id'>My Profil</a></div>"; ?>

<div><a href="http://profiinvest.org/login.php?action=logout">Logout</a></div>

<? if ( $account == "admin" )
{
?>
<div><H5 align='center'><strong>Administration</strong></H5></div>
<div><a href='index.php?action=pridat_novinku'>Pridať novinku</a></div>
<?php
}

}
?>

druhy problem mam pri registracii formular prejde do druhej fazi a nakoniec mi neodoslo do DB.
registration.php

Kód: Vybrať všetko

<div>
<form action="register.php" method="post">
<table width="645" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td>Nick name: <br /><input type="text" name="nick" class="inputtext" /></td>
    <td>&nbsp;</td>
    </tr>
  <tr>
    <td width="332">Password: <br /><input type="password" name="pwd1" class="inputtext" /></td>
    <td width="332">Password again: <br /><input type="password" name="pwd2" class="inputtext" /></td>
  </tr>
  <tr>
    <td>E-mail: <br /><input type="text" name="mail1" class="inputtext" /></td>
    <td>E-mail again: <br /><input type="text" name="mail2" class="inputtext" /></td>
  </tr>
  <tr>
    <td>Referrer: <br /><input type="text" size="25" class="inputtext" name="referer" value="<? echo $_GET["ref"]; ?>" autocomplete="off" /></td><? $a = rand(0,10); $b = rand(0,10); $c = rand(0,10); ?>
    <td><? echo "Write result (".$a.") + (".$b.") - (".$c. ") :</div>"; ?> <br /><input type="text" name="result" class="inputtext" /></td>
    <? echo "<input type=\"hidden\" name=\"a\" value=".$a.">";
    echo "<input type=\"hidden\" name=\"b\" value=".$b.">";
    echo "<input type=\"hidden\" name=\"c\" value=".$c.">"; ?>
  </tr>
</table>
<table width="645" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td width="323">Paypal e-mail: <br /><input type="text" name="pmail" class="inputtext" /></td>
    <td width="322">Alertpay e-mail: <br /><input type="text" name="apmail" class="inputtext" /></td>
  </tr>
   <tr>
    <td>Country: <br /><select name="country" class="inputtext">
<option value="">Country...</option>
<option value="Afganistan">Afghanistan</option>
<option value="Albania">Albania</option>
<option value="Algeria">Algeria</option>
<option value="American Samoa">American Samoa</option>
<option value="Andorra">Andorra</option>
<option value="Angola">Angola</option>
<option value="Anguilla">Anguilla</option>
<option value="Antigua & Barbuda">Antigua & Barbuda</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="Bangladesh">Bangladesh</option>
<option value="Barbados">Barbados</option>
<option value="Belarus">Belarus</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="Bolivia">Bolivia</option>
<option value="Bonaire">Bonaire</option>
<option value="Bosnia & Herzegovina">Bosnia & Herzegovina</option>
<option value="Botswana">Botswana</option>
<option value="Brazil">Brazil</option>
<option value="British Indian Ocean Ter">British Indian Ocean Ter</option>
<option value="Brunei">Brunei</option>
<option value="Bulgaria">Bulgaria</option>
<option value="Burkina Faso">Burkina Faso</option>
<option value="Burundi">Burundi</option>
<option value="Cambodia">Cambodia</option>
<option value="Cameroon">Cameroon</option>
<option value="Canada">Canada</option>
<option value="Canary Islands">Canary Islands</option>
<option value="Cape Verde">Cape Verde</option>
<option value="Cayman Islands">Cayman Islands</option>
<option value="Central African Republic">Central African Republic</option>
<option value="Chad">Chad</option>
<option value="Channel Islands">Channel Islands</option>
<option value="Chile">Chile</option>
<option value="China">China</option>
<option value="Christmas Island">Christmas Island</option>
<option value="Cocos Island">Cocos Island</option>
<option value="Colombia">Colombia</option>
<option value="Comoros">Comoros</option>
<option value="Congo">Congo</option>
<option value="Cook Islands">Cook Islands</option>
<option value="Costa Rica">Costa Rica</option>
<option value="Cote DIvoire">Cote D'Ivoire</option>
<option value="Croatia">Croatia</option>
<option value="Cuba">Cuba</option>
<option value="Curaco">Curacao</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="Equatorial Guinea">Equatorial 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="French Southern Ter">French Southern Ter</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="Gibraltar">Gibraltar</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="Guyana">Guyana</option>
<option value="Haiti">Haiti</option>
<option value="Hawaii">Hawaii</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="Isle of Man">Isle of Man</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 Sout">Korea South</option>
<option value="Kuwait">Kuwait</option>
<option value="Kyrgyzstan">Kyrgyzstan</option>
<option value="Laos">Laos</option>
<option value="Latvia">Latvia</option>
<option value="Lebanon">Lebanon</option>
<option value="Lesotho">Lesotho</option>
<option value="Liberia">Liberia</option>
<option value="Libya">Libya</option>
<option value="Liechtenstein">Liechtenstein</option>
<option value="Lithuania">Lithuania</option>
<option value="Luxembourg">Luxembourg</option>
<option value="Macau">Macau</option>
<option value="Macedonia">Macedonia</option>
<option value="Madagascar">Madagascar</option>
<option value="Malaysia">Malaysia</option>
<option value="Malawi">Malawi</option>
<option value="Maldives">Maldives</option>
<option value="Mali">Mali</option>
<option value="Malta">Malta</option>
<option value="Marshall Islands">Marshall 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="Midway Islands">Midway Islands</option>
<option value="Moldova">Moldova</option>
<option value="Monaco">Monaco</option>
<option value="Mongolia">Mongolia</option>
<option value="Montserrat">Montserrat</option>
<option value="Morocco">Morocco</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="Netherland Antilles">Netherland Antilles</option>
<option value="Netherlands">Netherlands (Holland, Europe)</option>
<option value="Nevis">Nevis</option>
<option value="New Caledonia">New Caledonia</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="Norfolk Island">Norfolk Island</option>
<option value="Norway">Norway</option>
<option value="Oman">Oman</option>
<option value="Pakistan">Pakistan</option>
<option value="Palau Island">Palau Island</option>
<option value="Palestine">Palestine</option>
<option value="Panama">Panama</option>
<option value="Papua New Guinea">Papua New Guinea</option>
<option value="Paraguay">Paraguay</option>
<option value="Peru">Peru</option>
<option value="Phillipines">Philippines</option>
<option value="Pitcairn Island">Pitcairn Island</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="Republic of Montenegro">Republic of Montenegro</option>
<option value="Republic of Serbia">Republic of Serbia</option>
<option value="Reunion">Reunion</option>
<option value="Romania">Romania</option>
<option value="Russia">Russia</option>
<option value="Rwanda">Rwanda</option>
<option value="St Barthelemy">St Barthelemy</option>
<option value="St Eustatius">St Eustatius</option>
<option value="St Helena">St Helena</option>
<option value="St Kitts-Nevis">St Kitts-Nevis</option>
<option value="St Lucia">St Lucia</option>
<option value="St Maarten">St Maarten</option>
<option value="St Pierre & Miquelon">St Pierre & Miquelon</option>
<option value="St Vincent & Grenadines">St Vincent & Grenadines</option>
<option value="Saipan">Saipan</option>
<option value="Samoa">Samoa</option>
<option value="Samoa American">Samoa American</option>
<option value="San Marino">San Marino</option>
<option value="Sao Tome & Principe">Sao Tome & Principe</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="Slovakia">Slovakia</option>
<option value="Slovenia">Slovenia</option>
<option value="Solomon Islands">Solomon 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="Sudan">Sudan</option>
<option value="Suriname">Suriname</option>
<option value="Swaziland">Swaziland</option>
<option value="Sweden">Sweden</option>
<option value="Switzerland">Switzerland</option>
<option value="Syria">Syria</option>
<option value="Tahiti">Tahiti</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 & Tobago">Trinidad & Tobago</option>
<option value="Tunisia">Tunisia</option>
<option value="Turkey">Turkey</option>
<option value="Turkmenistan">Turkmenistan</option>
<option value="Turks & Caicos Is">Turks & Caicos Is</option>
<option value="Tuvalu">Tuvalu</option>
<option value="Uganda">Uganda</option>
<option value="Ukraine">Ukraine</option>
<option value="United Arab Erimates">United Arab Emirates</option>
<option value="United Kingdom">United Kingdom</option>
<option value="United States of America">United States of America</option>
<option value="Uraguay">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="Vietnam">Vietnam</option>
<option value="Virgin Islands (Brit)">Virgin Islands (Brit)</option>
<option value="Virgin Islands (USA)">Virgin Islands (USA)</option>
<option value="Wake Island">Wake Island</option>
<option value="Wallis & Futana Is">Wallis & Futana Is</option>
<option value="Yemen">Yemen</option>
<option value="Zaire">Zaire</option>
<option value="Zambia">Zambia</option>
<option value="Zimbabwe">Zimbabwe</option>
</select></td>
  </tr>
</table>
<table width="645" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="323"></td>
    <td width="322"><input type="reset" name="reset" value="Reset Fields"  />&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="action" value="Complete registration" /></td>
  </tr>
</table>
<br />

</form>
</div>
</div>

register.php

Kód: Vybrať všetko

<?
require_once 'config.php';
require_once 'http.php';
require_once 'mailer/class.phpmailer.php';

if ( isset( $_REQUEST['action']) ) {
	switch ( $_REQUEST['action']) {
		case 'Complete registration':
		
		if ( isset( $_POST['nick']) and isset( $_POST['mail1']) and isset( $_POST['mail2']) and isset( $_POST['pwd1']) and isset( $_POST['pwd2']) and isset( $_POST['country']) and ($_POST['pwd1'] == $_POST['pwd2']) and ( $_POST['referer']) and ($_POST['mail1'] == $_POST['mail2'])) {
		
		$login = $_POST['nick']; $mail1 = $_POST['mail1']; $mail2 = $_POST['mail2']; $pwd1 = $_POST['pwd1']; $pwd2 = $_POST['pwd2']; $referer = $_POST['referer']; $country = $_POST['country']; $a = $_POST['a']; $b=$_POST['b']; $c=$_POST['c']; $res = $_POST['result'];

// Check if referer is provided
      if ($_POST["referer"] != "") {

         $checkref = mysql_query("SELECT username FROM users WHERE username='$referer'");
	 $referer_exist = mysql_num_rows($checkref);

	 if ($referer_exist<1) {

	    // In the absence of referer give an error message
            errorMsg("The referer User Doesn't Exists.",1); exit();
	 } else {

	    // If everything seems ok proceed
            $sqlz = "SELECT * FROM users WHERE username='$referer'";
            $resultz = mysql_query($sqlz);        
            $myrowz = mysql_fetch_array($resultz);

	    $numero=$myrowz["referals"];

            $sqlex = "UPDATE users SET referals='$numero' +1 WHERE username='$referer'";
     	    $resultex = mysql_query($sqlex);
	 }

      }

$length_nick = strlen($login); $length_pwd = strlen($pwd1); $d = $a + $b - $c;

if ($login=="") $error[0]="You must enter nickname";
if ($mail1=="") $error[1]="You must enter e-mail";
if ($mail1 != $mail2) $error[2]="Entered e-mails are not same";
if ($pwd1=="") $error[3]="You must enter password";
if ($pwd1!=$pwd2) $error[4]="Entered passwords are not same";
if ($country=="") $error[7]="You must select country";

if ($length_nick < 4) $error[8]="Nickname is too short. You must write 4 characters min...";
if ($length_nick > 50) $error[9]="Nickname is too long. You must write 50 characters max...";
if ($length_pwd < 6) $error[10]="Password is too short. You must write 6 characters min...";
if ($length_pwd > 50) $error[11]="password is too long. You must write 50 characters max...";
if ($d != $res) $error[16] = "You wrote wrong result, please count it again";

if (isset($error))
	redirect('registration.php');
		
$pass = md5($_POST['pwd1']); 
		
		$sql = "INSERT INTO users ( nick, email, password, pmail, apmail, country, date_reg, amount, referer) " .
			   "VALUES( '".$_POST['nick']."','".$_POST['mail1']."','".$pass."','".$_POST['pmail']."','".$_POST['apmail']."','".$_POST['country']."','".date( "Y-m-d" )."','0.0000','".$_POST['referer']."' )";
		
		mysql_query( $sql, $connect )
		or die('Cannot create new user account; ' . mysql_error() );
		
		$mail = new phpmailer();
		$mail->From     = "[email protected]";
		$mail->FromName = "Arkaz99";
		$mail->AddAddress($_POST['mail1']);
		$mail->Subject="New registration - profiinvest.org";
		$mail->Body="You was successful registrated into our system profiinvest.org: \n Information: \n Nick: " .$_POST['nick']. "\n Password: " .$_POST['pwd1']."\n For: \n Paypal mail: " .$_POST['pmail']. "\n Alertpay mail: " .$_POST['apmail']. "\n From: " .$_POST['country']. "\n Thanks for registration and for using our system. Profiinvest administrators.";
		$mail->Send();		
		session_start();
		
		redirect('index.php?a=reg_ok');
		break;
}
}
}
?>

v prvom prípade (login) máš zlé nastavovanie cookies. Posledný parameter (to lomítko v zátvorkach) tam nemá čo robiť. Osobne by som to ale radšej riešil cez session ako cez cookies, lebo keď niekto niekomu ukradne cookies tak má rovno jeho hash hesla čo nie je šťastné riešenie

v druhom prípade neviem čo robí problém, je tam príliš veľa "možno" problémov. Includuješ tam tri súbory, pracuješ s db.. A keď nenapíšeš či hodí nejakú chybu alebo kde to zkolabuje tak je príliš veľa možností čo môže byť zle a bez dodatočných info sa nedá poradiť.

celkovo je ten kod strašne škaredo napísaný. Už len to že sa spoliehaš na shorttagy (používaš <? namiesto <?php ) je dosť naivné dúfanie že bude server nakonfigurovaný presne tak ako si želáš.

kalosrac

login vyrieseny ostava uz len problem s registraciou

a čo je s tou registráciou? Vyhodí nejakú chybu, alebo neskúšal si tam dávať nejaké pomocné výpisy aby si zistil kde to zkolabuje? (najlepšie by bolo použiť debugger ale to by som bol veľmi naivný keby som predpokladal že nejaký máš a vieš s ním robiť)

kalosrac

keby sa dalo dat like na tvoj post je to tam... nemam debugger dal som si vypis ale ale ani to nic... tak ja uz neviem

ten vypis som dal pod tie posty
$_POST['mail2'])) {

tuto som to dal

$login = $_POS

no to sa mi nejak nevidí. Určite na tú stránku pristupuješ správne, to znamená že tam máš aj toho referala? Napríklad registration.php?ref=nieco
Inak nevidím dôvod prečo by to tou podmienkou nemalo prejsť

kalosrac

teraz mi skoci presne na index.php ani neviem preco sak tam nic take nemam

ale máš: redirect('index.php?a=reg_ok');
na konci, čiže registrácia prešla celá a celé toto naťahovanie sa spočívalo v tom, že si chodil na zlú URL. Great. Mňa raz fakt porazí

kalosrac

uz mi to islo ale teraz mi to zas nejde a uz ma boli hlava... pise mi ze query empty a spraveny mam aj vypis... nic s vypisu neni prazdne a stale mi to pise query was empty.

kod vyzera teraz takto:

Kód: Vybrať všetko

<?
require_once 'config.php';
// require_once 'http.php';
require_once 'mailer/class.phpmailer.php';

if ( isset( $_REQUEST['action']) ) {
   switch ( $_REQUEST['action']) {
      case 'Complete registration':
		
		if ( isset( $_POST['login']) and isset( $_POST['mail1']) and isset( $_POST['mail2']) and isset( $_POST['pwd1']) and isset( $_POST['pwd2']) and isset( $_POST['country']) and ($_POST['pwd1'] == $_POST['pwd2']) and ( $_POST['referer']) and ($_POST['mail1'] == $_POST['mail2'])) {
		
		$login = $_POST['login']; $mail1 = $_POST['mail1']; $mail2 = $_POST['mail2']; $pwd1 = $_POST['pwd1']; $pwd2 = $_POST['pwd2']; $referer = $_POST['referer']; $country = $_POST['country']; $a = $_POST['a']; $b=$_POST['b']; $c=$_POST['c']; $res = $_POST['result'];

// echo "db = ".$_POST['login']."<br>".$_POST['mail1']."<br>".$_POST['mail2']."<br>".md5($_POST['pwd1'])."<br>".$_POST['pwd2']."<br>".$_POST['referer']."<br>".$_POST['country']."<br>".$_POST['a']."+".$_POST['b']."-".$_POST['c']."=".$_POST['result']."<br>"; 
// Check if referer is provided
      if ($_POST["referer"] != "") {

         $checkref = mysql_query("SELECT username FROM users WHERE username='$referer'");
	 $referer_exist = mysql_num_rows($checkref);

	 if ($referer_exist<1) {

	    // In the absence of referer give an error message
            errorMsg("The referer User Doesn't Exists.",1); exit();
	 } else {

	    // If everything seems ok proceed
            $sqlz = "SELECT * FROM users WHERE username='$referer'";
            $resultz = mysql_query($sqlz);        
            $myrowz = mysql_fetch_array($resultz);

	    $numero=$myrowz["referals"];

            $sqlex = "UPDATE users SET referals='$numero' +1 WHERE username='$referer'";
     	    $resultex = mysql_query($sqlex);
	 }

      }

$length_nick = strlen($login); $length_pwd = strlen($pwd1); $d = $a + $b - $c;

if ($login=="") $error[0]="You must enter nickname";
if ($mail1=="") $error[1]="You must enter e-mail";
if ($mail1 != $mail2) $error[2]="Entered e-mails are not same";
if ($pwd1=="") $error[3]="You must enter password";
if ($pwd1!=$pwd2) $error[4]="Entered passwords are not same";
if ($country=="") $error[7]="You must select country";

if ($length_nick < 4) $error[8]="Nickname is too short. You must write 4 characters min...";
if ($length_nick > 50) $error[9]="Nickname is too long. You must write 50 characters max...";
if ($length_pwd < 6) $error[10]="Password is too short. You must write 6 characters min...";
if ($length_pwd > 50) $error[11]="password is too long. You must write 50 characters max...";
if ($d != $res) $error[16] = "You wrote wrong result, please count it again";

if (isset($error))
//	redirect('registration.php')
		
		$sql = "INSERT INTO users VALUES( '','".$_POST['login']."','','".$_POST['mail1']."','".$_POST['pmail']."','".$_POST['apmail']."','".date( "Y-m-d" )."','".$_POST['country']."','".$_POST['referer']."','0.0000','user','0' )";
		
		mysql_query( $sql, $connect )
		or die('Cannot create new user account; ' . mysql_error() );
		
		$mail = new phpmailer();
		$mail->From     = "[email protected]";
		$mail->FromName = "Arkaz99";
		$mail->AddAddress($_POST['mail1']);
		$mail->Subject="New registration - profiinvest.org";
		$mail->Body="You was successful registrated into our system profiinvest.org: \n Information: \n Nick: " .$_POST['nick']. "\n Password: " .$_POST['pwd1']."\n For: \n Paypal mail: " .$_POST['pmail']. "\n Alertpay mail: " .$_POST['apmail']. "\n From: " .$_POST['country']. "\n Thanks for registration and for using our system. Profiinvest administrators.";
		$mail->Send();		
		session_start();
		
//    redirect ('index.php?a=reg_ok');
		break;
}
}
}
?>

//autoeditácia príspevku (28 Jan 2011, 14:49)
v INTO scripte mi tu chyba $_POST pwd1 ale mam ho tam

a kde ti to "query empty" píše?

Ja ti tam žiadnu takú chybovú hlášku nevidím

kalosrac

or die('Cannot create new user account; ' . mysql_error() ); to mysql_error

2 problemy s PHP

2 problemy s PHP

Re: 2 problemy s PHP

Re: 2 problemy s PHP

Re: 2 problemy s PHP

Re: 2 problemy s PHP

Re: 2 problemy s PHP

Re: 2 problemy s PHP

Re: 2 problemy s PHP

Re: 2 problemy s PHP

Re: 2 problemy s PHP

Re: 2 problemy s PHP