hisoka

thank you

You did not reply to this

 

if this what you mean then why do not we use an empty string instead of document.firstname.participator.value then return a value , which is the participator firstname and which will assigned to the variablevar participator_inputlike this :

 

var participator_input = " " ;

 

I did not ask what is var participator_input = " " ;

 

I asked , in our context , what is the difference between this var participator_input =

document.firstname.participator.value and this

 

var participator_input = " " ;

 

as both take any value the participator will input when the script is executed

"Because the value of the variable is not "document.firstname.participator.value", the value is the result of that expression."

 

You mean that the value of the variable var participator_input can be any firstname inputed by a participator ? is this what you mean?

 

if this what you mean then why do not we use an empty string instead of document.firstname.participator.value then return a value , which is the participator firstname and which will assigned to the variablevar participator_inputlike this :

 

var participator_input = " " ;

 

what is the difference between this

 

var participator_input = " " ;

 

and this

 

var participator_input = document.firstname.participator.value ;

 

 

??

I noticed that the value of this variable is without a double quotes:

 

var participator_input = document.firstname.participator.value ;

 

why is the value of the variable participator_input without double quotes???

 

 

 

 

Thank you very much

if I have

 

setcookie(user , brock , time() + 40000);

 

does the cookie become like this:

 

cookie = userbrock40000

 

 

????

ok

I already read them before I posted my first message concerning sessions and cookies . I know that $_COOKIE and $_SESSION with the variable logedin inside an array are used to store "logedin" variable in the cookie and session . However I could not understand , in the context of authentication or login and http l not in the context of programming , what does

 

$_COOKIE['logedin']$_SESSION['logedin']

 

mean ? and what they do ? their role

concerning sessions and cookies , could you please explain these to me:

 

$_COOKIE['logedin']

 

$_SESSION['logedin']

 

and what is the "logedin" inside the array ?

 

what is the meaning of both php script?

when we want to extract data from database , we use select .

 

For example : SELECT * CustomerName FROM customers WHERE CustomerName= Brock AND city= England

 

but 1) why we want to extract the username and the password from the database??? like in

 

SELECT * username FROM table WHERE username= Brock AND password= England

thank you

 

php mysqli_select_db() function : according to w3schools , The mysqli_select_db() function is used to change the default database for the connection.

 

syntax :

 

mysqli_select_db(connection,dbname);

 

both are required

 

connection Required. Specifies the MySQL connection to use dbname Required. Specifies the default database to be used

 

I cannot understand very well these two parameters and what is said concerning it in w3schools

 

for example :

 

 

 

1)the mysqli_select_db() function change the default database : it changes the name of the default database to another name ??

 

2)why change the name of the default database ? what is the purpose beyond changing it ?

 

3)what does it mean by :"Specifies the MySQL connection to use"??

 

4)Specifies the default database to be used : it means specifies the name of the default database to be used ?

 

5)The MySQL_select_db() function is used to change the default database for the connection : So why the default database is

 

required for the connection ??? I am confused

"No, it doesn't create the password. The define() function creates a constant"

 

so , according to what you wrote to me , here : "DEFINE('DB_PASS', ''); " the define function creates a constant whose name is DB_PASS and value should be given by me .

 

and in "DEFINE('DB_USER', 'root');" the define() function creates a constant whose name is DB_USER and whose value is root

 

and in define(EMPLOYEE_NAME,'employee'); the define () function creates a constant whose name EMPLOYEE_NAME and value is employee

 

and so on ........................ This is what I am writing in my previous message . Is not it ?

"Those define() functions, are usaully used only for connecting to myswl database as already discussed"

 

What I understood is that these :

 

DEFINE('DB_HOST', 'localhost');DEFINE('DB_USER', 'root');DEFINE('DB_PASS', '');

 

are used to create a password , username and host that are used later to connect to the database throughout this function :

 

MySQL_connect($db_host, $db_user, $db_pass)

 

we need to create a password , username and provide the host name before we can access our database

 

then once connected , we define a table that is we create a table with employee name , salary and employee list

 

throughout these function with their constants and value

 

define(TABLE_NAME,'employee_list');define(EMPLOYEE_NAME,'employee');define(SALARY_NAME,'salary');

 

Is not it???

 

please correct me if I am wrong

You already told me that " to access MySQL database server you have to provide host, username, and password" . I understood why I need to provide a username and a password . However , I cannot understand why I need to provide a host . So why?

 

the second question is :

 

when I delete the username and the password from the MySQL database of my server , normally , the next time the user put his username and password to log in , the server does not find the username and the password (because they are deleted from the database by the admin ) thus it alerts the user that " password or username are invalid " Am I right or am I wrong ??. Please correct me if I am wrong

 

the third question is about this

 

define(TABLE_NAME,'employee_list');define(EMPLOYEE_NAME,'employee');define(SALARY_NAME,'salary');

 

what does the three define function do ? do they create a table with three columns which has employee_list in the first column , employee in the second column and salary in the third column ???

thank you

 

when a user, first, registers in a website , he must give his email , username and password . Are these data (email , username and password) stored in the MySQL server database ?? this is the first question . The second question :

 

if I am the owner of the website in which this user is log in , after his registration and then after giving his username and password, and I do not want him to access my website -so that when he puts his username and password he gets only "password or/and username are not valid - is this done by deleting his username and password from the MySQL database of my server ???

"This requires the credentials to access a database and its tables."

 

Sorry but I still do not understand why I need a username and a password or credentials to connect to the database and then access the table field ??

thank you . Could you please tell me 1) why I need a password and a username to connect to the database ? why I cannot connect to it without password and username?

 

2)"sends the credentials to access MySQL and then the database and its tables"

 

What is the difference between MySQL and the database ?

I am a newbie and I have some questions concerning MySQL php server database

As I know , MySQL server database is a place in the server where information like usernames , passwords , images , texts , telephone numbers ..... are stored (please correct me if I am wrong)There is this PHP function :DEFINE('DB_HOST', 'localhost');DEFINE('DB_USER', 'root');DEFINE('DB_PASS', '');the function define in php defines a constant . However these 3 lines are not clear to me and confuse me :DB_HOST is the name of the MySQL server database. Is not "localhost" the hostname of a server installed in a computer !! so why it is the name of MySQL server database?? why should we assign a name to a database like "DEFINE('DB_HOST', 'localhost');"?? is not MySQL database installed with the server and when the server wants to retrieve information from it . It connects , automatically to it?? what is the 'root' username ? is it the admin ( the person with the highest privilege who control all in the server)?? why should he define himself (a root) username and define a password in MySQL database??? for what purpose??DEFINE('DB_PASS', ''); why is the value of DB_PASS is not defined meanwhile the value of DB_USER is defined as 'root'???and on the light of all that what does this function do :mysql_connect($db_host, $db_user, $db_pass) ????