lets you have three tables in database. You can manually check in all tables by placing if-else. you can combine all above 3 inputs and make select query to generate output.
There was minor mistakes. I have removed it. Check with below code. Surely it will work.
database.php
<?php
class database{
function __construct() {
$db_name = 'Lakkam';
$db_host = 'localhost';
$db_user = 'root';
$db_password = '';
$con = mysql_connect ($db_host,$db_user,$db_password)
or die("Could not connect to MySQL server. Please try again.");
mysql_select_db($db_name,$con)
or die("Could not connect to the database. Please try again");
}
function login($uname,$pass)
{ // after creating the database object you have to pass username & password
// username and password sent from form
$myusername=$_POST['username'];
$mypassword=md5($_POST['password']);
// To protect MySQL injection
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT user_id,user_name,user_password FROM tbl_admin WHERE user_name = '$myusername' AND user_password ='$mypassword'";
$query = mysql_query($sql);
if(mysql_num_rows($query) == 1) // checks if a user name with that password exsists
{
$row = mysql_fetch_assoc($query); // Put it to an associative array
return $row['user_id'];
}
else
{
return false;
}
}
}
?>
login.php
<?php session_start();
include_once ('database.php'); // This is the location of your database class in your server
$con= new database(); // create the database object
if(isset($_POST['Submit'])){ // Check if the form is actually submitted
if($_POST['username']!='' && $_POST['password']!='')
{
$output = $con->login($_POST['username'],$_POST['password']);
if($output)
{ //check the username & password
$_SESSION['user_id'] = $output;
$_SESSION['logged_in'] = "ok";
header("Location: menu.php");
exit;
}
else
{
$error = 'Incorrect Login Details ...Try again later!<br>';
}
}
else
{
$error = 'Username Or Password Field is Empty..Please Check again!<br>';
}
}
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Lakkam Trade …
You can use javascript code that if user select any other option other than 'Any' then make js code will make 'Any' unchecked. This way you can implement your requirement.
Check with below code. This code will generate $sql based on your requirement. you can modify as per your want. if user have selected "Any" then no need to consider it as no filtration required for that in select query.
<?php
class database{
function __construct() {
$db_name = 'Lakkam';
$db_host = 'localhost';
$db_user = 'root';
$db_password = '';
$con = mysql_connect ($db_host,$db_user,$db_password)
or die("Could not connect to MySQL server. Please try again.");
mysql_select_db($db_name,$con)
or die("Could not connect to the database. Please try again");
}
function login($uname,$pass)
{ // after creating the database object you have to pass username & password
// username and password sent from form
$myusername=$_POST['username'];
$mypassword=md5($_POST['password']);
// To protect MySQL injection
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql=sprintf("SELECT user_id,user_name,user_password FROM 'tbl_admin' WHERE user_name = '$myusername' AND user_password ='mypassword'");
$query = mysql_query($sql);
if(mysql_num_rows($query) == 1) // checks if a user name with that password exsists
{
$row = mysql_fetch_assoc($query); // Put it to an associative array
return $row['user_id'];
}
else
{
return false;
}
}
}
?>
Login.php
<?php session_start();
include_once ('database.php'); // This is the location of your database class in your server
$con= new database(); // create the database object
if(isset($_POST['Submit'])){ // Check if the form is actually submitted
if($_POST['username']!='' && $_POST['password']!='')
{
$output = $con->login($_POST['username'],$_POST['password']);
if($output)
{ //check the username & password
$_SESSION['user_id'] = $output;
$_SESSION['logged_in'] = "ok";
header("Location: menu.php");
exit;
}
else
{
$error = 'Incorrect Login Details ...Try again later!<br>';
}
}
else
{
$error = 'Username Or Password Field is Empty..Please Check again!<br>';
}
}
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Lakkam Trade Center</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
</head>
<body>
<div id="Layer1"><img src="images/login.jpg" alt="" …
and when i use above link for sending mail from gmail account, i got below error.
SMTP -> ERROR: Failed to connect to server: Unable to find the socket transport "ssl" - did you forget to enable it when you configured PHP? (24)
SMTP Error: Could not connect to SMTP host. Mailer Error: SMTP Error: Could not connect to SMTP host.
I got below error when i connect with different machine.
Warning: mail() [function.mail]: SMTP server response: 550-(TEST-PC) [xx.xx.xx.xx]:50406 is currently not permitted to relay 550-through this server. Perhaps you have not logged into the pop/imap server 550-in the last 30 minutes or do not have SMTP Authentication turned on in your 550 email client. in C:\wamp\www\email.php on line 9
I think my working pc's ip address is allowed on that mydomain.com. How can i check on mydomain.com?
1) in register.php give all fielsa like name, address, city, state..etc. 2) When form is submitted store all values in table and get last inserted id $lastid with mysql_insert_id. 3) write header now.
Thanks all for help and time. This issue is solved. Even i don't know exact reason but one linux server guy have installed firewall and some software on dedicated server and issue is solved.
I have one website name e.g. www.mydomain.com Now i want to configure smtp setting in my local pc. Below is the phpini code i have set. Here i have not used any username and password.
And it is working.. Strange !!!! How this can work? I mean if this is the only required info then anyone can set this detail and can use my domain's smtp. What is the reason behind working of it?
If i want to use my gmail account info for smtp. Is it works? what is the steps to follow?
My site is on dedicated server by fasthosts.co.uk. i get email from host server that my site has been placed on the Spamhaus SBL. below is the content for that:
>> Web bot: port 80
>> IP address 217.174.241.205: on fasthosts.co.uk/live-servers.net
>> Canadian Pharmacy spammer[s] are using a botnet consisting of
>> compromised systems on which NGINX is installed listening on port 80
>> to proxy their pages unless the system, itself, is making use of that
>> port in which case nginx listend on port 8080. The nameservers
>> resolve hostnames which are spamvertized as port 80 (http://hostname)
>> to IP addresses of systems with nginx listening on port 80 and
>> resolve other hostnames, spamvertized on port 8080,
>> http://hostname:8080, to IP addresses with nginx listening on that port.
>>
>> The nameservers and hosts quickly rotate (double fast-flux) though
>> the nameserver IP addresses listed in the root servers ('glue'
>> records) may not change so quickly.
>>
>> If you know a hostname you can find it at both port 80 and port 8080
>> bots by forcing the resolution.
>>
>> Canadian Pharmacy is running a counterfeit luxury good ('replicas')
>> site along with their pharmacy site at these IP addresses.
>>
>> A currently resolvable (for some reason they seem often to lose
>> domains!) is discountprowatch.com (replicas site, spamvertized on
>> port 80) and a recent (unresolvable) pharmacy hostname is
>> buyviagraworld.com (spamvertized on …
I am accessing a stored date in my database so basically what I posted at the top was working but you did manually select a date, so is there any possible to access a date that came from my database and as soon as my page loads, it will display the date from my drop-downs and to a textfield. Thank you.
If you are using jquery you have to write js code to let dropdown selected. Its nothing wrong to write js code. I posted is just for month remain selected.You can write it for textbox,day,year same way.
My site is on dedicated server by fasthosts.co.uk. i get email from host server that my site has been placed on the Spamhaus SBL. below is the content for that:
>> Web bot: port 80
>> IP address 217.174.241.205: on fasthosts.co.uk/live-servers.net
>> Canadian Pharmacy spammer[s] are using a botnet consisting of
>> compromised systems on which NGINX is installed listening on port 80
>> to proxy their pages unless the system, itself, is making use of that
>> port in which case nginx listend on port 8080. The nameservers
>> resolve hostnames which are spamvertized as port 80 (http://hostname)
>> to IP addresses of systems with nginx listening on port 80 and
>> resolve other hostnames, spamvertized on port 8080,
>> http://hostname:8080, to IP addresses with nginx listening on that port.
>>
>> The nameservers and hosts quickly rotate (double fast-flux) though
>> the nameserver IP addresses listed in the root servers ('glue'
>> records) may not change so quickly.
>>
>> If you know a hostname you can find it at both port 80 and port 8080
>> bots by forcing the resolution.
>>
>> Canadian Pharmacy is running a counterfeit luxury good ('replicas')
>> site along with their pharmacy site at these IP addresses.
>>
>> A currently resolvable (for some reason they seem often to lose
>> domains!) is discountprowatch.com (replicas site, spamvertized on
>> port 80) and a recent (unresolvable) pharmacy hostname is
>> buyviagraworld.com (spamvertized on …
create one session array. when user click on link you can pass veh_id to ajax page. where in ajax page you will add veh_id in session array. And when user checkout it will use session array.
// Check if button name "Submit" is active, do this
if($_POST['Submit']){
foreach($checkbox as $i){
$sql2 = "INSERT INTO assignments SET firstName = '$firstName[$i]', lastName = '$lastName[$i]', AP = '$AP[$i]', last_teacher = '$last_teacher[$i]', description = '$description', subject = '$subject'";
$result2=mysql_query($sql2) or die(mysql_error());
}
