[ dejan92 @ 06.10.2011. 19:17 ] @
Uradio sam sve kako treba i kada iden na register na sajtu kada hocu da se registrujem izbaci mi ovu gresku


PHP Error Message

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a1949406/public_html/members/register.php on line 50

Free Web Hosting
Table 'a1949406_dejan.users' doesn't exist


a evo i tog fajla php

Code (php):

<?

include 'db.php';

// Define post fields into simple variables
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$email_address = $_POST['email_address'];
$username = $_POST['username'];
$info = $_POST['info'];

/* Let's strip some slashes in case the user entered
any escaped characters. */


$first_name = stripslashes($first_name);
$last_name = stripslashes($last_name);
$email_address = stripslashes($email_address);
$username = stripslashes($username);
$info = stripslashes($info);


/* Do some error checking on the form posted fields */

if((!$first_name) || (!$last_name) || (!$email_address) || (!$username)){
     echo 'You did not submit the following required information! ';
     if(!$first_name){
          echo "First Name is a required field. Please enter it below.";
     }
     if(!$last_name){
          echo "Last Name is a required field. Please enter it below.";
     }
     if(!$email_address){
          echo "Email Address is a required field. Please enter it below.";
     }
     if(!$username){
          echo "Desired Username is a required field. Please enter it below.";
     }
     include 'join_form.html'; // Show the form again!
     /* End the error checking and if everything is ok, we'll move on to
      creating the user account */

     exit(); // if the error checking has failed, we'll exit the script!
}
     
/* Let's do some checking and ensure that the user's email address or username
 does not exist in the database */

 
 $sql_email_check = mysql_query("SELECT email_address FROM users WHERE email_address='$email_address'");
 $sql_username_check = mysql_query("SELECT username FROM users WHERE username='$username'");
 
 $email_check = mysql_num_rows($sql_email_check);
 $username_check = mysql_num_rows($sql_username_check);
 
 if(($email_check > 0) || ($username_check > 0)){
     echo "Please fix the following errors: ";
     if($email_check > 0){
          echo "<strong>Your email address has already been used by another member in our database. Please submit a different Email address!";
          unset($email_address);
     }
     if($username_check > 0){
          echo "The username you have selected has already been used by another member in our database. Please choose a different Username!";
          unset($username);
     }
     include 'join_form.html'; // Show the form again!
     exit();  // exit the script so that we do not create this account!
 }
 
/* Everything has passed both error checks that we have done.
It's time to create the account! */


/* Random Password generator.
http://www.phpfreaks.com/quick...ndom_Password_Generator/56.php

We'll generate a random password for the
user and encrypt it, email it and then enter it into the db.
*/


function makeRandomPassword() {
  $salt = "abchefghjkmnpqrstuvwxyz0123456789";
  srand((double)microtime()*1000000);
     $i = 0;
     while ($i <= 7) {
          $num = rand() % 33;
          $tmp = substr($salt, $num, 1);
          $pass = $pass . $tmp;
          $i++;
     }
     return $pass;
}

$random_password = makeRandomPassword();

$db_password = md5($random_password);

// Enter info into the Database.
$info2 = htmlspecialchars($info);
$sql = mysql_query("INSERT INTO users (first_name, last_name, email_address, username, password, info, signup_date)
          VALUES('$first_name', '$last_name', '$email_address', '$username', '$db_password', '$info2', now())"
) or die (mysql_error());

if(!$sql){
     echo 'There has been an error creating your account. Please contact the webmaster.';
} else {
     $userid = mysql_insert_id();
     // Let's mail the user!
     $subject = "Clanovi naseg sajta";
     $message = "Dear $first_name $last_name,
     Hvala sto ste se registrovali na nas sajt, http://www.budipoznat.comli.com!
     
     Na dva koraka ste od uspesne registracije!
     
     Da aktivirate vas nalog kliknite na lik ispod: http://www.budipoznat.comli.com/members/activate.php?id=$userid&code=$db_password
     
     Once you activate your memebership, you will be able to login with the following information:
     Username: $username
     Password: $random_password
     
     Thanks!
     Dejan
     
     This is an automated response, please do not reply!"
;
     
     mail($email_address, $subject, $message, "From: MyDomain Webmaster<[email protected]>\nX-Mailer: PHP/" . phpversion());
     echo 'Your membership information has been mailed to your email address! Please check it and follow the directions!';
}

?>
 



sta je u pitanju sta treba tu da kucam? :S plz pomoc
[ Aleksandar Ružičić @ 06.10.2011. 19:28 ] @
Moguce da nemas aktivnu konekciju sa bazom pa ti mysql_query vrati false. Sta ti je u db.php?
[ dejan92 @ 06.10.2011. 19:30 ] @
<?
/* Database Information - Required!! */
/* -- Configure the Variables Below --*/
$dbhost = 'mysql6.000webhost.com';
$dbusername = 'a1949406_dejan';
$dbpasswd = '@@@@@@@';
$database_name = 'a1949406_dejan';

/* Database Stuff, do not modify below this line */

$connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd")
or die ("Couldn't connect to server.");

$db = mysql_select_db("$database_name", $connection)
or die("Couldn't select database.");
?>
[ dejan92 @ 06.10.2011. 19:41 ] @
to mi je u data base php pw sam sakrio naravno :) sta da radim :S
[ ColdKeyboard @ 06.10.2011. 20:01 ] @
Gore ti kaze da ti ne postoji tabela users u tvojoj databazi. Provjeri mala/velika slova i da li si naziv tabele tacno napisao.

Drugo mozda ti uopste ne treba mysql_pconnect(), probaj sa mysql_connect()

Trece nema potrebe da radis mysql_connect("$host", "$user", "$pass"), dovoljno je da napises mysql_connect($host, $user, pass)


Post varijable mozes da uzimas kao recimo
$first_name = isset($_POST['name']) ? mysql_real_escape_string(trim($_POST['name'])) : '';

U tvom slucaju, stranica tek kada se otvori ili kada nisu sva polja popunjena izbacivat ce ti obavestenje da varijable $_POST['name'] ne postoji (nije definisana).
[ dejan92 @ 06.10.2011. 20:37 ] @
znaci umesto pcconect stavicu conect samo i bez navodnika i pisacu pw i to ostalo...al sta da kucam na ono num email check tu mi nalazi gresku ? :(
[ ColdKeyboard @ 06.10.2011. 20:45 ] @
Probaj da imena tabela i polja u tabelama stavis izmedju ` i naravno uvijek kada testiras nesto stavi iza query-a da ti ispise mysql_error() ukoliko ne uspije da izvrsi
upit, cisto da te obavjesti u cemu je problem a ne da moras ovako gledati u pasulj.

Znaci promjeni kod u sledeci:

Code:

 $sql_email_check = mysql_query("SELECT `email_address` FROM `users` WHERE `email_address`='$email_address' LIMIT 1") or die('Email Check Error:'. mysql_error());
 $sql_username_check = mysql_query("SELECT `username` FROM `users` WHERE `username`='$username' LIMIT 1") or die('Username Check Error:'. mysql_error());
 
 $email_check = mysql_num_rows($sql_email_check);
 $username_check = mysql_num_rows($sql_username_check);



Alternativno mozes da koristis jedan query gdje bi trazio da li postoji username ili email, ako postoji kazes da ima greska. Ako ti bas treba da odredis da li je
username ili email zauzeto onda mozes da uzmes taj rezultat u neki array i provjeris da li je username ili email isti i na osnovu toga generises gresku.
[ dejan92 @ 06.10.2011. 21:12 ] @
Uspesno ste se registrovali,radi verifikovanja vaseg naloga posetite vasu email postu.Hvala!


tooooo breeeeeee.....hvala brate puno.....puno...veruj mi sve mi je islo za rukom al sam zablokiro na ovoj registraciji vec 3 dana besprekidno se mucim hteo sam da odustanem....hvala puno!!!Imas pice od mene :) !!!Ovaj sajt je ne verovatan i clanovi u njemu :) poz
[ ColdKeyboard @ 06.10.2011. 22:14 ] @
Drago mi je da si uspio.

Uvek kada radis sa mysql_query u fazi razvoja, dodaj or die('Neki identifikator: '. mysql_error()); i zivot ce ti biti mnogo laksi
[ dejan92 @ 07.10.2011. 19:05 ] @
hehe dobro...:))) hvala jos jednom !