Help - Php

25-06-2005, 10:30

Im going to leasrn PHP but i carnt find any decent tutorials if anyone noes of any good ones or even better Video tutorials could you post them here

Ive learnt a lot of HTML and VB in the last month

with video tutorials from
http://www.seangreasley.com/

vegancoder · 25-06-2005, 13:11

never seen any video tutorials, but www.spoono.com is pretty good for beginning, making a guestbook is a good way to learn and then you can improve it as you advance

25-06-2005, 13:34

right i need HELP
ive made a script

Code:

<?PHP

$cfg['mysqlhost'] = '';	// Database host URL
$cfg['mysqluser'] = '';				// Database user
$cfg['mysqlpassword'] = '';		// Database password
$cfg['mysqldb'] = '';			// Database name
// MySql
$db_banlist = '';
$db_config = '';
$db_levels = '';
$db_mail = '';
$db_users = '';
$db_admin = '';
$db_style = '';
$db_lang = '';
$db_ads = '';
$db_online = '';

?>

i have that but how do i make my other script connect to it i need it to get mysql of my mysql script ? can any one help me?
its for a register form

vegancoder · 26-06-2005, 12:11

hmmm not sure why you have put the connection variables into an array.

Here is the way i do it:

I save the code below in to a file called db.php

PHP Code:

  <?

//database information

$host = 'localhost'; //the host, if the database is held on the server that the script is ran from it is localhost

$db_username = ''; //the username

$db_name = ''; //the name of the database

$db_password = ''; //the database password for the username

 
//connection strings

mysql_connect($db_host,$db_username,$db_password) or die(mysql_error());

mysql_select_db($db_name) or die(mysql_error());

?>

and the i use

PHP Code:

  include('db.php';)

on any page i want to connect to the database.

remeber to use this when you have finished with the connection(when you have finished querying the database):

PHP Code:

  mysql_close();

that will close the connection

26-06-2005, 12:39

thank you
tahats what i need to do

28-06-2005, 20:27

could someone help me make a login form please?
i dont know what to put

randomman · 28-06-2005, 20:48

these php tuts are good but i find php an odd/hardish script anyway

28-06-2005, 20:57

can someone HELP ME please and soon Please i despiately need it in next 5 mins or SOONER PLEASE

vegancoder · 29-06-2005, 14:13

Its un tested but should be fine, there are many improvements that coupld be made but it should do the job you want.

You will need to create a mysql database with a table called whatever you like but it must have the username and password columns. Edit the code so that $table equals whatever table name you have used.

Here is the code hope it helps!

PHP Code:

 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Login</title>

</head>

 
<body>

<?

$table = '';//your user table

if($_POST['submit']){

    $username = $_POST['username'];

    $password = $_POST['password'];

    $sql = "SELECT * FROM $table WHERE username = '$username' password = '$password'";

    $sql = mysql_query($sql);

    if(mysql_num_rows($sql)){

        //successfull login

        echo 'successfully logged in';

    } else {

        //unsuccessful login

        echo 'login failed';

    }

}else{

?>

    <form name="form1" method="post" action="<? echo $PHP_SELF; ?>">

        Username: 

        <input type="text" name="username">

        Password: 

        <input type="password" name="password">

        <input type="submit" name="submit" value="Login">

    </form>

<?

}//end submission check

?>

</body>

</html>

randomman · 01-07-2005, 17:18

back on topic, i still cant find anything good for the absolute begginer. can anyone help me?

25-06-2005, 10:30	#1 (permalink)
KF1 Guest Posts: n/a iTrader: / %	Help - Php Im going to leasrn PHP but i carnt find any decent tutorials if anyone noes of any good ones or even better Video tutorials could you post them here Ive learnt a lot of HTML and VB in the last month with video tutorials from http://www.seangreasley.com/

26-06-2005, 12:11	#4 (permalink)
vegancoder Active Member Join Date: May 2005 Location: Doncaster, UK Posts: 58 iTrader: 0 / 0%	hmmm not sure why you have put the connection variables into an array. Here is the way i do it: I save the code below in to a file called db.php PHP Code: `<? //database information $host = 'localhost'; //the host, if the database is held on the server that the script is ran from it is localhost $db_username = ''; //the username $db_name = ''; //the name of the database $db_password = ''; //the database password for the username //connection strings mysql_connect($db_host,$db_username,$db_password) or die(mysql_error()); mysql_select_db($db_name) or die(mysql_error()); ?>` and the i use PHP Code: `include('db.php';)` on any page i want to connect to the database. remeber to use this when you have finished with the connection(when you have finished querying the database): PHP Code: `mysql_close();` that will close the connection

28-06-2005, 20:57	#8 (permalink)
KF1 Guest Posts: n/a iTrader: / %	can someone HELP ME please and soon Please i despiately need it in next 5 mins or SOONER PLEASE Last edited by KF1; 29-06-2005 at 08:12.

29-06-2005, 14:13	#9 (permalink)
vegancoder Active Member Join Date: May 2005 Location: Doncaster, UK Posts: 58 iTrader: 0 / 0%	Its un tested but should be fine, there are many improvements that coupld be made but it should do the job you want. You will need to create a mysql database with a table called whatever you like but it must have the username and password columns. Edit the code so that $table equals whatever table name you have used. Here is the code hope it helps! PHP Code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Login</title> </head> <body> <? $table = '';//your user table if($_POST['submit']){ $username = $_POST['username']; $password = $_POST['password']; $sql = "SELECT * FROM $table WHERE username = '$username' password = '$password'"; $sql = mysql_query($sql); if(mysql_num_rows($sql)){ //successfull login echo 'successfully logged in'; } else { //unsuccessful login echo 'login failed'; } }else{ ?> <form name="form1" method="post" action="<? echo $PHP_SELF; ?>"> Username: <input type="text" name="username"> Password: <input type="password" name="password"> <input type="submit" name="submit" value="Login"> </form> <? }//end submission check ?> </body> </html>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

25-06-2005, 13:11	#2 (permalink)
vegancoder Active Member Join Date: May 2005 Location: Doncaster, UK Posts: 58 iTrader: 0 / 0%	never seen any video tutorials, but www.spoono.com is pretty good for beginning, making a guestbook is a good way to learn and then you can improve it as you advance

26-06-2005, 12:39	#5 (permalink)
KF1 Guest Posts: n/a iTrader: / %	thank you tahats what i need to do

28-06-2005, 20:27	#6 (permalink)
KF1 Guest Posts: n/a iTrader: / %	could someone help me make a login form please? i dont know what to put

28-06-2005, 20:48	#7 (permalink)
randomman King of scotland Join Date: Jun 2005 Location: ye olde oxforshire Posts: 720 iTrader: 0 / 0%	these php tuts are good but i find php an odd/hardish script anyway

01-07-2005, 17:18	#10 (permalink)
randomman King of scotland Join Date: Jun 2005 Location: ye olde oxforshire Posts: 720 iTrader: 0 / 0%	back on topic, i still cant find anything good for the absolute begginer. can anyone help me?