I think ditty was right. There should be "Where" in the query so that the script can identify the record you want to update.
Something like this.
<?php
// Connects to your Database
mysql_connect("localhost", "john", "nicho123") or die(mysql_error());
mysql_select_db("john_321") or die(mysql_error());
echo "connected to database";
$update = "UPDATE auth SET auth.realuser = '$_POST[realuser]' where usermail='$_POST[usermail]'";
$update = "UPDATE auth SET auth.realpass = '$_POST[realpass]' where usermail='$_POST[usermail]'";
mysql_query($update);
?>
Try this Joe. Just find out the difference of the 3 query. ^^,
$Find_Query1 = mysql_query("SELECT * FROM pages WHERE title='$Search' AND keywords LIKE '%$Search%' AND description LIKE '%$Search%'"); // between
// or
$Find_Query1 = mysql_query("SELECT * FROM pages WHERE title='$Search' AND keywords LIKE '$Search%' AND description LIKE '$Search%'"); //starts with
// or
$Find_Query1 = mysql_query("SELECT * FROM pages WHERE title='$Search' AND keywords LIKE '%$Search' AND description LIKE '$%Search'"); //end with
Can anyone one help me with this? The scenario goes like this. I have this PHP script:
<?php
$to = "email_address_here";
$subject = "SAMPLE AUTOMATIC MAIL";
$body = "Hi to Every one. Please help me with this ^^,";
if (mail($to, $subject, $body))
{
echo("<p>Message successfully sent!</p>");
echo "Sent to: $to";
}
?>
Above code works fine. When I type the "http://server/folder/phpfile.php" at my explorer address bar, the message was successfully sent.
I try to use windows schedule task to run this automatically, but it only open the phpfile.php itself. By the way, my I'm using Windows Server 2003 OS.
Try this: 1. Why don't create a page where your sql connection is coded. For example, create a php script and save it as connection.php and here is the code for it.
<?php
error_reporting(0);
$connection = Mysql_connect('localhost','root','');
mysql_select_db('test'); //test is the name of your database.
?>
Now analyze the modification that I made in this code.
<?PHP
error_reporting(0);
session_start();
include 'connection.php' // call the connection for your database.
$critiria=$_POST['critiria'];
$search=$_POST['search'];
if($critiria=="epitheto_iatrou"){
$sql=mysql_query("SELECT * FROM doctors WHERE epitheto='$critiria'");
while($newarray=mysql_fetch_array($sql)){
echo "Epitheto: $newarray['epitheto'] <br>";
echo "Eidikotita: $newarray['eidikotita']<br>";
echo "Misthos: $newarray['misthos']<br>";
}
}
else if($critiria=="eidikotita"){
$sql=mysql_query("SELECT * FROM doctors WHERE eidikotita='$eidikotita'");
while ($newarray=mysql_fetch_array($sql)){
echo "Epitheto: $newarray['epitheto'] <br>";
echo "Eidikotita: $newarray['eidikotita']<br>";
echo "Misthos: $newarray['misthos']<br>";
}
}
else if($critiria=="epitheto_patient"){
$sql=mysql_query("SELECT * FROM patients WHERE epitheto='$critiria'");
while ($newarray=mysql_fetch_array($sql)){
echo "Epitheto: $newarray['epitheto'] <br>";
echo "Onoma: $newarray['onoma']<br>";
echo "id_doctor: $newarray['id_doctor']<br>";
echo "date: $newarray['date']<br>";
echo "poli: $newarray['poli']<br>";
}
}
else if ($critiria=="poli")
{
$sql=mysql_query("SELECT * FROM patients WHERE poli='$critiria'");
while ($newarray=mysql_fetch_array($sql)){
echo "Epitheto: $newarray['epitheto'] <br>";
echo "Onoma: $newarray['onoma']<br>";
echo "id_doctor: $newarray['id_doctor']<br>";
echo "date: $newarray['date']<br>";
echo "poli: $newarray['poli']<br>";
}
}
else if ($critiria=="date"){
$sql=mysql_query("SELECT * FROM patients WHERE date='$critiria'");
while ($newarray=mysql_fetch_array($sql)){
echo "Epitheto: $newarray['epitheto'] <br>";
echo "Onoma: $newarray['onoma']<br>";
echo "id_doctor: $newarray['id_doctor']<br>";
echo "date: $newarray['date']<br>";
echo "poli: $newarray['poli']<br>";
}
}
?>
The above query should work, but if not, try to eliminate "else" on "else if". Just make
<?php
// let say the time now is 06:00 PM
$time = Date('h:i A');
$time1 = strftime('$time'); // I know it is wrong coz the output of this code is $time only. I just include this for you to have an specific idea ^^
// now i want to display $time1 as 1800
?>
Ahm ok. So I'll try to elaborate as much as I can ^^,
The situation goes like this.
I have a script where I can save records (stock number, item, hours before expire,). Now for example, I save the record at exactly 4:00 PM and then in the "hours before expire", I input 4 hrs. So I want to have a script that send a mail stating the this item is expire at exactly 8:00 PM.
Can anyone show me a sample alarm script using php or javascript? The alarm was base on the record at the database. I mean, for example I have records that have overdue, the user is the one who state the overdue. For example, the user input his overdue is after one 1 he saves the record, so I want the system will give an alarm after 1 hour.
<?php
$username = 'username';
$password = 'password';
if (isset($_POST["username"]) && isset($_POST["password"]))
{
// open text.txt for reading
$file = fopen("text.txt","r");
while (!feof($file))
{
$data = explode ("|", fgets($file));
}
if(isset($data[0]) && isset($data[1]))
{
if (trim($data[0]) == trim($_POST["username"]) && trim($data[1]) == trim($_POST["password"]))
{
$login = true;
$_SESSION["login"] = $login;
$_SESSION["username"] = $_POST["username"];
//$_SESSION['type'] = $data[3];
echo "Thank you for logging in, in 5 seconds you will be taken to the homepage.";
header("refresh: 5; private.php");
break;
}
else
{
// something you want if the log in failed.
}
}
fclose($file);
}
?>
<?php
$username = 'username';
$password = 'password';
if (isset($_POST["username"]) && isset($_POST["password"]))
{
// open text.txt for reading
$file = fopen("text.txt","r");
while (!feof($file))
{
$data = explode ("|", fgets($file));
if(isset($data[0]) && isset($data[1])){
if (trim($data[0]) == trim($_POST["username"]) && trim($data[1]) == trim($_POST["password"]))
{
$login = true;
$_SESSION["login"] = $login;
$_SESSION["username"] = $_POST["username"];
//$_SESSION['type'] = $data[3];
echo "Thank you for logging in, in 5 seconds you will be taken to the homepage.";
header("refresh: 5; private.php");
break;
}
else
{
// something you want if the log in failed.
}
}
}
fclose($file);
}
?>
Can anyone help me with this? I have PHP script the save record. But I want to have time limit in saving the record. When the local time is 4:00 PM, the user can no longer save their record. Please help.
//if time is beyond 4:00 PM this code is enable ------ this what i want. mysql_query("insert into file(name,age,address) values ('$name','$age','$addr')"); echo "Record Save";
//if time is exceed 4:00 PM this code is enable and disable the saving codes echo "Can not save record. Time limit has expire"
$query = "SELECT * FROM venues"; $result = mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); //change this to $num=mysql_num_rows($result); $i=0; while ($i < $num) { $option = mysql_result($result,$i,'vname'); // i dont know waht is vname? echo "<option value='$2option'>".$1option."</option>"; // notice the (") and (') $i++; }
$query_Directory_update = "update directory set Sno=<?php $Directory_update; ?>where Sno='$_GET[updateid]'";
try to modified the above code into this:
$query_Directory_update = mysql_query("update directory set directory.Sno='$Directory_update[Sno]' where Sno='".$_GET[updateid]."'");
I think you don't have any PHP error with that query, but I'm not so sure if the query successfully update the record, since I don't know what is the exact variable from your database and PHP code itself.
Try to put the $subject into a variable. For example, $id=$subject; then make a query like this: $page_set=mysql_query("SELECT * FROM pages WHERE subject_id='".$id."'"); just pay attention (') and (").
Can anyone help me on the problem? The scenario goes like this.
I have lots of files (.pdf, .doc, and .xls) stored on my sever. I want the user to access the files. I mean, they can open it for some review purposes but I don't want them to save it on their local machine. Is the possible?
Here's my sample codes: <?php echo "<a href='folder/file.pdf'>"."Sample Files"."</a>"; ?>
I want that when they click the Sample Files link, the file.pdf will open so they can read it, but i don't want them to save it on their local machines.
If you are lazy, then it is impossible for you to learn PHP and MySQL. PHP is not an easy programming language specially to the lazy person like you. Try to help your self first... You can search over the internet to have basic knowledge in PHP.
