PHP - What's Wrong With This Line???

I am querying...

$sql  = "SELECT `messages_inbox`.`message_id`, `users`.`firstname`, `users`.`lastname`, `users`.`username` AS `from`, '${user_info['username']}' AS `to`, `subject`, LENGTH(`files`) AS `len`, 'inbox' AS `box`, DATE_FORMAT(`messages_inbox`.`time` ,'%T %D-%M-%Y') AS `time` ";
   
$sql .= "FROM `messages_inbox` INNER JOIN `users` ON `messages_inbox`.`from_id` = `users`.`id` WHERE `to_id` = ${user_info['uid']} AND `messages_inbox`.`deleted` = 0 ORDER BY `messages_inbox`.`message_id` DESC";

and I am trying to output

$displayName = ucwords("${message['firstname']} ${message['lastname']}");

by using

$messages = pm_fetch_all($_GET['box']);

I know my fetch works but for some reason firstname and lastname are only returning the logged in users first name and last name, not the person who sent the message.

Hi.

I want a simple textbox, that when submited, will replace very every new line, with the <br> tag.

What will happen, when it submits, it will take the contents of a textbox, add the <br> tag where a new line is suposed to be, and save the string to a MySQL Database.

I think this is the easiest way of allowing a user to edit what appears on a website when logged in, but if there is a easier way, then please tell me.

What I am trying to do, is a login page, and once logged in, you enter new text into the textbox, click submit, and on the website homepage, the main text will change to what was submitted. But if there is a new line, I think the only way in HTML to make one is to put a <br> tag, so I want the PHP to but that tag wherever there is a new line.

Sorry if I am confusing, I am not that advanced at PHP, but I would be very happy if you could supply me with the correct code. Time is running out...

If you do not understand me, please tell me

--
PHPLeader (not) 

i have to read a single line from a csv,  its a really big file and i only need one column. i need the response to be a string ,i made a search and found the following code but i dont have any idea how to get a single line from a single string per run .

<?php
$row = 1;
//open the file
if (($handle = fopen("file.csv", "r")) !== FALSE)
{
    while (($data = fgetcsv($handle, 0, ",")) !== FALSE)
    {
        $num = count($data);
        echo "<p> $num fields in line $row: <br /></p>\n";
        $row++;
        for ($c=0; $c < $num; $c++)
        {
            echo $data[$c] . "<br />\n";
        }
    }
    fclose($handle);
}
?>

Edited by bores_escalovsk, 16 May 2014 - 06:38 PM.

Dear All

           Good Day, i am new to PHP (a beautiful server side scripting language). i want to send a mail with line by line message i tried with different types like by placing the things in table and using  <br /> but the thing is the tags are also visible in the message of the mail.

Here is my code:

$message1  = "Name       :".  $_REQUEST['name']."<br />";
$message1 .= "Surname    :".  $_REQUEST['surname']."<br />";
$message1 .= "Cellphone  :".  $_REQUEST['mobileno']."<br />";
$message1 .= "Telephone  :".  $_REQUEST['landno']."<br />";
$message1 .= "Fax        :".  $_REQUEST['fax']."<br />";
$message1 .= "Company    :".  $_REQUEST['company']."<br />";
$message1 .= "Email      :".  $_REQUEST['email']."<br />";
$message1 .= "Country    :".  $_REQUEST['country']."<br />";
$message1 .= "Enquity    :".  $_REQUEST['enquiry']."<br />";
$message1 .= "Date&Time  :".  $date."<br />";

For this code if try to print/echo it it is working fine it is displaying line by line, but using this variable ($message1) in the mail these <br /> are also visible.
Can any one guide me to resolve(to remove these tags from the message part) this issue.
Thanks in Advance. :confused:

How to get this echo line to display as one line?
No matter what I have done it displays as two lines.  I even tried <nobr></nobr>

Teachers Name:
John Jones

$userid = mysql_real_escape_string($_GET['user_id']);
$sql = "select * from users where `id`='$userid' ";

$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{ 
echo  "<h3>Teachers Name: </h3>" . $row["first_name"] . " " . $row["last_name"]  ;  }


Thanks for your help.

I have a script that reads a .gz file into an array and prints the name of each record but will not work on larger files. Is there a way to read 1 line at a time?
Here is the code I have so far.
Code: [Select]
<?php

if ($handle = opendir('.')) {

print "<ol>";
    
    while (false !== ($file = readdir($handle))) {
if($file != '..' && $file!="." && $file!="start_update.php" && $file!="sharons_dbinfo.inc.php" && $file!="root.php" && $file!="read_directory.php" && $file!="read_dir.php" && $file!="new_category.php" && $file!="index.php" && $file!="file_count.php" && $file!="dir_loop2.php" && $file!="dir_loop1.php" && $file!=".htaccess" && $file!="Answer.txt" && $file!="Crucial_Technology-Crucial_US_Product_Catalog_Data_Feed.txt"){
$filename = $file;
$go = filesize($filename);
if($go >= 1){
$filename2 = explode("-", $filename);
$filename2 = $filename2[0];
echo str_replace("_"," ",$filename2) . ' | Filesize is: ' . filesize($filename) . ' bytes<br>';
$gz = gzopen($filename, 'r');
$lines = gzfile($filename,10000);
foreach ($lines as $line) {
$line2 = explode(",", $line);
$line2 = str_replace("," , "-" , $line2);
    echo "<li>".str_replace("," , "-" , $line2[4])."</li><br>";
}

}
}
    }

    closedir($handle);
}
?>
</ol>

I'm so sorry to ask such a "newbee question," but believe me I have been on Google for the better part of the week trying to find an answer.   I'll start with the brief question. Then I'll give an example to show what I mean. Then, I'll give the BESTEST "pseudo-code" I could come up with (to PROVE that I've really given it my best).   Question: How do I make PHP loop through a big file, make the changes line by line, and to save the resultant file.   Example: I have a 100mb text file ("animals.txt") with 500,000 lines. If any lines have the word "cat" in it, I want to add "Be careful with cats!" to the end of the line:   From this: A fish and his tank. A cat and his toy. A bird and her cage. A frog and his lilly. A cat and her friend.   To this: A fish and his tank. A cat and his toy. Be careful with cats! A bird and her cage. A frog and his lilly. A cat and her friend. Be careful with cats!   The best "pseudo-code" I can come up with is:   <?php $data = file_get_contents("animals.txt"); $lines = explode(PHP_EOL,$data);

I want my application will send a email after 10 minutes of sending another email.

In my application

A user completes registration with payment Application sends the user a payment confirmation email

Now I want to

send another email 10 minutes After payment confirmation email with welcome tips

Below is the function where for user setup .

 

public function finishUserSetup($Sub){

    if($Sub == 0){
        $subscription = SubscriptionPlans::where('identifier', '=', "Monthly")->first();
        $expiry = date('Y-m-d', strtotime('+' . $subscription->months . ' months'));
        $sub_period = "monthly";
    
    } else{
        $subscription = SubscriptionPlans::where('identifier', '=', "Annually")->first();
        $expiry = date('Y-m-d', strtotime('+' . $subscription->months . ' months'));
        $sub_period = "annually";
    }

    $this->expiry_date = $expiry;
    $this->user_type = "SUB";
    $this->subscription_period = $sub_period;
    $this->update();

    $replaceArray = array(
        'fullname' => $this->forename . " " . $this->surname,
        'subscriptionName' => $subscription->name,
        );
    EmailTemplate::findAndSendTemplate("paymentconfirm", $this->email, $this->forename . " " . $this->surname, $replaceArray);

  }

In the above function the last line of code is the one which sends a payment confirmation email to the user which is

EmailTemplate::findAndSendTemplate("paymentconfirm", $this->email, $this->forename . " " . $this->surname, $replaceArray);

I want to execute the following line of code 10 minutes after the above one

 

EmailTemplate::findAndSendTemplate("WelcomeTips", $this->email, $this->forename . " " . $this->surname, $replaceArray);

 

 

How to do that. that is running the last line of code 10 minutes after  

I am trying to create a very basic object but am having troubles.

Code: [Select]
<?php

class item{

public $name;
public $price;

function __construct($name,$price){
$this->name=$name;
$this->price=$price;}

function getName(){
return $this->name;
}

}


$object = new item("car",400);
echo $object->getName();


?>
The HTML output is:

name=$name; $this->price=$price;} function getName(){ return $this->name; } } $object = new item("car",400); echo $object->getName(); ?>


I'm sure that this code is clean but for some reason will not output the desired result! any help would be great. thanks.

Hi all.
I always create my sql queries like below.

        $user = "user";
$pass = "123456";
$host = "localhost";
$base = "test";

$cn = mysql_connect($host, $user, $pass) or trigger_error("SQL", E_USER_ERROR);
mysql_select_db($base,$cn) or trigger_error("SQL", E_USER_ERROR);

       $QUERY = mysql_query("SELECT id FROM someTable", [size=14pt][color=red][b]$cn[/b][/color][/size]) or die(mysql_error());

while ($list = mysql_fetch_assoc($QUERY)){
              echo "Some Text over loop";
        }


Okay here is the question (or problem). What if i have 5000 records in my Table. Doesn't this code connect DB 5000 times?
If yes, then how can i optimize it?

I am trying to create a log in page but all that comes up is Please enter a username and password

<?php

session_start () ;

$username = $_POST ['username'] ;
$password = $_POST ['passowrd'] ;

if ($username&&$password) 
{

define ('DB_HOST' , 'localhost') ;
define ('DB_USER' , 'root')  or die ("Could not connect!") ;
define ('DB_PASSWORD', "")  or die ("Could not find DB!") ;
define ('DB_DATABASE', 'joke') ; 

}
else
   die ("Please enter a username and password") ;
$query = mysql_query ("SELECT * FROM Joke WHERE username = '$username'") ;
$numrow = mysql_num_rows ($query) ;

if ($numrows!=0)
{	
	//code to login

   While ($row= mysql_fetch_assoc($query))
   {
   		$dbusername = $row ['username'] ;
   		$dbusername = $row ['password'] ;
   }	

   //check if they match

   if ($username==$dbusername&&$password==$dbpassword)
   {
   		echo "You're inn! <a href=member.php> Click here to enter member page" ;
   		$_SESSION['username']=$dbusername ;
   	}
   		else
   			echo "incorrect password!" ;
}
else
	die("That user does'nt exist") ;
echo $numrows;

?>

$result3 = mysql_query("SELECT User_ID FROM leaderboards WHERE User_ID = '$user'");

if(mysql_num_rows($result3) == 0){

$query1 = "INSERT INTO leaderboards (User_ID, CollegeFootballPoints) VALUES ('$user','$points')";
$result1 = mysql_query($query1);

}else{

$query2 = "UPDATE leaderboards SET  CollegeFootballPoints='$points' WHERE User_ID='$user'";
$result2 = mysql_query($query2);
}

I keep getting this error...'

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in update_collegeFBpoints_points.php on line 40

And the script is not working!

(LINE 40 is

$result3 = mysql_query("SELECT User_ID FROM leaderboards WHERE User_ID = '$user'");   
   if(mysql_num_rows($result3) == 0){

specifically mysql_num_rows)

Here is code I have, I can't seem to figure this error out,  I bet it is obvious, but I clearly am not seeing it.....  Here is error:
Problem with the query:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

(not really that good of an error, but maybe help getting started?)


Code: [Select]
<?php
session_start(); // Must start session first thing
/* 
Created By Adam Khoury @ www.flashbuilding.com 
-----------------------June 20, 2008----------------------- 
*/
// Here we run a login check
if (!isset($_SESSION['id'])) { 
   echo 'Please <a href="login.php">log in</a> to access your account';
   exit(); 
}
//Connect to the database through our include 
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$username = $row["username"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
$accounttype = $row["accounttype"];
$rank = $row["rank"];
$badges = $row["badges"];
}
// Set error message as blank upon arrival to page
$errorMsg = "";
// First we check to see if the form has been submitted 
if (isset($_POST['name'])){
$name = ereg_replace("[^A-Z a-z0-9]", "", $_POST['name']); // filter everything but numbers and letters
$phone = ereg_replace("[^A-Z a-z0-9]", "", $_POST['phone']); // filter everything but spaces, numbers, and letters
$username = ereg_replace("[^A-Z a-z0-9]", "", $_POST['username']); // filter everything but spaces, numbers, and letters
$address = ereg_replace("[^A-Z a-z0-9]", "", $_POST['address']); // filter everything but spaces, numbers, and letters
$city = ereg_replace("[^A-Za-z0-9]", "", $_POST['city']); // filter everything but lowercase letters
$state = ereg_replace("[^A-Za-z0-9]", "", $_POST['state']); // filter everything but lowercase letters
$zip = ereg_replace("[^A-Za-z0-9]", "", $_POST['zip']); // filter everything but lowercase letters
$cell = ereg_replace("[^A-Za-z0-9]", "", $_POST['cell']); // filter everything but lowercase letters
$accounttype = ereg_replace("[^A-Z a-z0-9]", "", $_POST['accounttype']); // filter everything but lowercase letters
$email = stripslashes($_POST['email']);
$email = strip_tags($email);
$email = mysql_real_escape_string($email);
$password = ereg_replace("[^A-Za-z0-9]", "", $_POST['password']); // filter everything but numbers and letters
// Check to see if the user filled all fields with
// the "Required"(*) symbol next to them in the join form
// and print out to them what they have forgotten to put in
if((!$name) || (!$username) || (!$password)){

$errorMsg = "You did not submit the following required information!<br /><br />";
if(!$name){
$errorMsg .= "--- Name";
} else if(!$username){ 
    $errorMsg .= "--- Username"; 
   } else if(!$Password){ 
       $errorMsg .= "--- Password";    
   }
} else {
// Database duplicate Fields Check
$sql_username_check = mysql_query("SELECT userid FROM members WHERE username='$username' LIMIT 1");
$username_check = mysql_num_rows($sql_username_check); 
if ($username_check > 0){ 
$errorMsg = "<u>ERROR:</u><br />Your User Name is already in use inside our system. Please try another.";
} else {
// Add MD5 Hash to the password variable
       $hashedPass = md5($password); 
// Add user info into the database table, claim your fields then values 
$sql = mysql_query("INSERT INTO members (name, phone, username, address, city, state, zip, cell, email, accounttype, password ) 

VALUES('$name','$phone','$username','$address','$city','$state','$zip','$cell','$email','$accounttype','$hashedPass'") or die ("Problem with the query: $sql<br>" . mysql_error());
 printf("Records updated: %d\n", mysql_affected_rows());
echo mysql_error();

 echo '<meta HTTP-EQUIV="REFRESH" content="3; url=http://final.net46.net/success.php">';

exit(); // Exit so the form and page does not display, just this success message
} // Close else after database duplicate field value checks
  } // Close else after missing vars check
 //Close if $_POST
}
 
?>

mysql_query("UPDATE categories SET active=0 WHERE id=$id");

What am I doing wrong here to get: Parse error: syntax error, unexpected T_STRING

???

it's supposed to check the file, to see if it's available for download, the code below looks okay to me, what's wrong?

if($row[2]==2) // 4shared check
{
$row[1]="http://www.".$row[1];
$index=getpage($row[1]);
preg_match("/Download ([^<]+)<\/div>/",$index,$match);
if(strpos($index,"The file is shared for public access and download.")===false || !$match)
{
mysql_query("UPDATE `v2links` SET `checked`='-1',`lastcheck`=NOW() WHERE `id`=".$row[0]);
print "bad link\n";
logstr("log-c.txt","bad link\n");
}
else
{
$words=trim($match[1]);
$words=preg_split("/[_\.\-\s]/",$words);
$lastword=array_pop($words);
$words=implode(" ",$words);
$words=preg_replace("/\s{2,}/"," ",$words);
$caption=mysql_real_escape_string($words);
unset($words);
unset($match);
preg_match("/<td>Size\:<\/td><td>([^<]+)<\/td>/",$index,$match);
$fsize=$match[1];
unset($match);
print "$caption :: $fsize\n";
logstr("log-c.txt","$caption :: $fsize\n");
mysql_query("UPDATE `v2links` SET `checked`='1',`lastcheck`=NOW(),`fsize`='$fsize',`caption`='$caption' WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
}


I'm wondering if the sharing website has changed anything, because for rapidshare it works fine, code:

if($row[2]==1) // rapidshare check
{
$index=getpage($row[1]);
if(strpos($index,"<p><script>alert(\"File not found.\")</script>File not found.</p>")===false && strpos($index,"This file has been deleted.")===false)
{
preg_match("/<form action=\"([^\"]+)\" method=\"post\">/",$index,$match);
//print $index;
if($match[1])
{
$fpath=$match[1];
$index=getpage($fpath,"dl.start=Free",$row[1]);
preg_match("/<\/font> \(([^\(]+)\)\.<\/p>/",$index,$match);
$fsize=0;
if($match[1]) $fsize=mysql_real_escape_string(strip_tags($match[1]));
print $fsize."\n";
logstr("log-c.txt",$fsize."\n");
mysql_query("UPDATE `v2links` SET `checked`='1',`fsize`='$fsize',`lastcheck`=NOW() WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
else
{
print "bad link\n";
logstr("log-c.txt","bad link\n");
mysql_query("UPDATE `v2links` SET `checked`='-1',`lastcheck`=NOW() WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
}
else
{
print "bad link\n";
logstr("log-c.txt","bad link\n");
mysql_query("UPDATE `v2links` SET `checked`='-1',`lastcheck`=NOW() WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
}


any help would be appreciated!