Jump to content
xisto Community

alex1985

Members
  • Content Count

    398
  • Joined

  • Last visited

Posts posted by alex1985


  1. Hello, everyone. I'm using wireless at my home and connecting it through my neighbour network, but the signal sometimes neither low or just normal. If there is a way that I can imrove it or increase the sensitivity of that signal. I'm using my wireless adapter built in my laptop. If you know how, please let me know.


  2. I use Evince as my PDF reader. It renders the documents well (and correctly) and is very quick to load. It also has support for DVI, TIFF and Postscript files, along with encrypted documents.

    Could you givw the official link to download it?


  3. Hi, everyone. I'm offering the next PHP tutorial that verifies an email address of an user who wants to register on your site.
    This is how it works. When someone, went to registration page and filled out all of the details such as Name, Password, email and so on and submit those details to a server. The user is getting unique registration code to his or her email account, the one has to be clicked to activate the account.

    1. Outline:

    a) You need to create or build the following files:

    -config.php (The configuration file)
    -signup.php (Initial Registration)
    -signup_ac.php (Post Registration)
    -confirmation.php (The confirmation link)

    ^_^ You need to create 2 databases:

    -temp_members (The temporary members stored in, the confirmation link is sent to them)
    -registered_members (The registered members, who pressed the confirmation link, and became registered)

    CREATE TABLE `temp_members_db` (
    `confirm_code` varchar(65) NOT NULL default '',
    `name` varchar(65) NOT NULL default '',
    `email` varchar(65) NOT NULL default '',
    `password` varchar(15) NOT NULL default '',
    `country` varchar(65) NOT NULL default ''
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;



    CREATE TABLE `registered_members` (
    `id` int(4) NOT NULL auto_increment,
    `name` varchar(65) NOT NULL default '',
    `email` varchar(65) NOT NULL default '',
    `password` varchar(65) NOT NULL default '',
    `country` varchar(65) NOT NULL default '',
    PRIMARY KEY (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



    2. Creating the configuration file (config.php):

    <?$host="localhost"; // Host name$username="yourusername"; // Mysql username$password="yourpasword"; // Mysql password$db_name="yourdatabasename"; // Database name//Connect to server and select database.mysql_connect("$host", "$username", "$password")or die("cannot connect to server");mysql_select_db("$db_name")or die("cannot select DB");?>
    3. Creating the initial registration file (signup.php)

    <table width="350" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
    <td><form name="form1" method="post" action="signup_ac.php">
    <table width="100%" border="0" cellspacing="4" cellpadding="0">
    <tr>
    <td colspan="3"><strong>Sign up</strong></td>
    </tr>
    <tr>
    <td width="76">Name</td>
    <td width="3">:</td>
    <td width="305"><input name="name" type="text" id="name" size="30"></td>
    </tr>
    <tr>
    <td>E-mail</td>
    <td>:</td>
    <td><input name="email" type="text" id="email" size="30"></td>
    </tr>
    <tr>
    <td>password</td>
    <td>:</td>
    <td><input name="password" type="password" id="password" size="30"></td>
    </tr>
    <tr>
    <td>Country</td>
    <td>:</td>
    <td><input name="country" type="text" id="country" size="30"></td>
    </tr>
    <tr>
    <td> </td>
    <td> </td>
    <td><input type="submit" name="Submit" value="Submit">  
    <input type="reset" name="Reset" value="Reset"></td>
    </tr>
    </table>
    </form></td>
    </tr>
    </table>



    3. Creating the post registration file (signup_ac.php) where an user's information details as well as confirmation code are said to be stored in database.

    
    
    // table name
    $tbl_name=temp_members_db;

    // Random confirmation code
    $confirm_code=md5(uniqid(rand()));

    // values sent from form
    $name=$_POST['name'];
    $email=$_POST['email'];
    $country=$_POST['country'];

    // Insert data into database
    $sql="INSERT INTO $tbl_name(confirm_code, name, email, password, country)VALUES('$confirm_code', '$name', '$email', '$password', '$country')";
    $result=mysql_query($sql);

    // if suceesfully inserted data into database, send confirmation link to email
    if($result){[/sql]

    // send e-mail to ...
    $to=$email;

    // Your subject
    $subject="Your confirmation link here";

    // From
    $header="from linenums:0'><?include('config.php');// table name$tbl_name=temp_members_db;// Random confirmation code$confirm_code=md5(uniqid(rand()));// values sent from form$name=$_POST['name'];$email=$_POST['email'];$country=$_POST['country'];// Insert data into database$sql="INSERT INTO $tbl_name(confirm_code, name, email, password, country)VALUES('$confirm_code', '$name', '$email', '$password', '$country')";$result=mysql_query($sql);// if suceesfully inserted data into database, send confirmation link to emailif($result){[/sql]// send e-mail to ...$to=$email;// Your subject$subject="Your confirmation link here";// From$header="from: your name <your email>";// Your message$message="Your Comfirmation link \r\n";$message.="Click on this link to activate your account \r\n";$message.="http://forums.xisto.com/no_longer_exists/ send email$sentmail = mail($to,$subject,$message,$header);}// if not foundelse {echo "Not found your email in our database";}// if your email succesfully sentif($sentmail){echo "Your Confirmation link Has Been Sent To Your Email Address.";}else {echo "Cannot send Confirmation link to your e-mail address";}?>
    4. Creating the confirmation file page (confirmation.php), when it is clicked, the user is registered.

    
    
    // Passkey that got from link
    $passkey=$_GET['passkey'];

    $tbl_name1="temp_members_db";

    // Retrieve data from table where row that match this passkey
    $sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'";
    $result1=mysql_query($sql1);

    // If successfully queried
    if($result1){

    // Count how many row has this passkey
    $count=mysql_num_rows($result1);

    // if found this passkey in our database, retrieve data from table "temp_members_db"
    if($count==1){

    $rows=mysql_fetch_array($result1);
    $name=$rows['name'];
    $email=$rows['email'];
    $password=$rows['password'];
    $country=$rows['country'];

    $tbl_name2="registered_members";

    // Insert data that retrieves from "temp_members_db" into table "registered_members"
    $sql2="INSERT INTO $tbl_name2(name, email, password, country)VALUES('$name', '$email', '$password', '$country')";
    $result2=mysql_query($sql2);
    }

    // if not found passkey, display message "Wrong Confirmation code"
    else {
    echo "Wrong Confirmation code";
    }

    // if successfully moved data from table"temp_members_db" to table "registered_members" displays message "Your account has been activated" and don't forget to delete confirmation code from table "temp_members_db"
    if($result2){

    echo "Your account has been activated";

    // Delete information of this user from table "temp_members_db" that has this passkey
    $sql3="DELETE FROM $tbl_name1 WHERE confirm_code = '$passkey'";
    $result3=mysql_query($sql3);

    }

    }
    ?> linenums:0'><?include('config.php');// Passkey that got from link$passkey=$_GET['passkey'];$tbl_name1="temp_members_db";// Retrieve data from table where row that match this passkey$sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'";$result1=mysql_query($sql1);// If successfully queriedif($result1){// Count how many row has this passkey$count=mysql_num_rows($result1);// if found this passkey in our database, retrieve data from table "temp_members_db"if($count==1){$rows=mysql_fetch_array($result1);$name=$rows['name'];$email=$rows['email'];$password=$rows['password'];$country=$rows['country'];$tbl_name2="registered_members";// Insert data that retrieves from "temp_members_db" into table "registered_members"$sql2="INSERT INTO $tbl_name2(name, email, password, country)VALUES('$name', '$email', '$password', '$country')";$result2=mysql_query($sql2);}// if not found passkey, display message "Wrong Confirmation code"else {echo "Wrong Confirmation code";}// if successfully moved data from table"temp_members_db" to table "registered_members" displays message "Your account has been activated" and don't forget to delete confirmation code from table "temp_members_db"if($result2){echo "Your account has been activated";// Delete information of this user from table "temp_members_db" that has this passkey$sql3="DELETE FROM $tbl_name1 WHERE confirm_code = '$passkey'";$result3=mysql_query($sql3);}}?>
    Finish. That's the simple tutorial in PHP.

    There are more explanation points inside the code.

    If anyone, can improve please let me know.

  4. As alex7h3pr0gr4m3r has said, starting the path with a / makes PHP start from the root directory rather than your current location. The easiest way to do it will be the following:

     

    require_once('../config.php');

    The ../ tells PHP to move up to the parent directory, which is where it can find the config.php file.

    Thanks. This reply helped me. It does work now.

  5. hello,I\'m not US I use it for my paypal. I want to request paypal debit card, I need add credit card to paypal. Can I use virtual card? And where I can find it?
    Is it possible to request paypal debit card for non US member? I\'ll use myus address to received card. Is it possible and no problem?


    Listen, I know some of couple web-sites that offer debit cards which are shipped everywhere in any spot of the world and works at any ATM as well, let me know if you got interested through PM.

  6. I will try it tomorrows, and then post the answer if it's working or not, it's too late now. I hope it will.You are definitely right, the script which I want to initiate is located in test1 folder, but there is admin folder inside the test1 folder and the page that adds entries to database like add.php is located inside the admin folder.So, add.php has that function (require_once) in ...test1/admin/add.php location that has to find the config.php in ...test1/config.php. That's why I need the proper code or location for the url.I did not tried the previous post, as I said I will do it tomorrow. So, I did explain in detail.Thanks.


  7. I did the configuration file for my web-site but there is a mistake, it can find the path to that configuration file.

    Could you give me the proper way to set a correct path to the configuration file.

    This is what I did actually based on the used tutorial.


    require_once ("/mulhim.outlaw.trap17.com/library_project/test_dir/test1/config.php");


  8. I did construct the database connection file which is called "config.php". But, I got some mistake that has to be solved to continue with working.

    This is the code itself:

    $confg['db_paswd']="" //Your database user's password
    $confg['db_host']="localhost" //Your host
    $confg['db_dbase']="books" //Your database name
    //Create the function to log into the DB
    function db_login() {
    global $confg;
    $link = @mysql_connect($confg['db_host'], $confg['db_uname'], $confg['db_paswd']) or die("Error connecting linenums:0'><?//Set the database values$confg['db_uname']="alex1985_admin" //Your database username$confg['db_paswd']="" //Your database user's password$confg['db_host']="localhost" //Your host$confg['db_dbase']="books" //Your database name//Create the function to log into the DBfunction db_login() {global $confg;$link = @mysql_connect($confg['db_host'], $confg['db_uname'], $confg['db_paswd']) or die("Error connecting: " . mysql_error());@mysql_select_db($confg['db_dbase'], $link);}//Create the function for logging out from the DBfunction db_logout() {@mysql_close($link);}?>
    But, this is the message the browser gives me when I am trying to initiate that constructed file.

    "Parse error: syntax error, unexpected T_VARIABLE in /home/alex1985/public_html/mulhim/library_project/test_dir/test1/config.php on line 4"

    If I am not mistaken there is the mistake with the entry: "$confg['db_paswd']="userpw", for instance.

    I'm sure that I entered it correctly.

    What should I do?

    Notice from truefusion:
    Removed password for your security. ^_^

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.