PHP - Adding A Line To A Table

Hi all,

I'm working on a webpage that dynamically shows sales of products over a number of years. It's going well apart from the data isn't showing as I want it to. The data is showing the number of sales per month in a given year.

What I want to do is add up all sales of the same product within a year to give one row for each product for each year. The below screenshot shows what my current output is.



I want to be able to have one row showing sales all year rather than month by month.

Code: [Select]
  <?php 

error_reporting(E_ERROR | E_PARSE); 

$desiredProduct = $_POST['product'];
$server = 'SQL2008';
$connectionInfo = array( "Database"=>"rde_400792");
$conn = sqlsrv_connect($server,$connectionInfo);


$describeQuery="select ProductCode , SalesVolume, Year, Month from MonthlySales where ProductCode = $desiredProduct";
$results = sqlsrv_query($conn, $describeQuery);

echo '<table border="1" BORDERCOLOR=Black>';
echo '<tr><th bgcolor = "LightBlue">Product Code</th><th bgcolor = "LightBlue" >Sales Volume</th><th  bgcolor = "LightBlue">Month</th><th bgcolor = "LightBlue">Year</th></tr>';


while($row = sqlsrv_fetch_array($results, SQLSRV_FETCH_ASSOC)) 
{
    echo '<tr>';
echo '<td >' .$row['ProductCode'].'</td>'; 
echo '<td>' .$row['SalesVolume'].'</td>'; 
echo '<td >' .$row['Month'].'</td>'; 
echo '<td>' .$row['Year'].'</td>'; 
echo '</tr>';
} 

echo '</table>';
sqlsrv_close($conn); 
Can somebody help me?

Here is a link to the website I am designing. http://173.167.65.189/singleton/
the username and password is ksingleton
at the bottom where the calendar is the query is searching for scheduled events, i am only posting the company_id right now,  the problem I am having is I want a scheduled event that continues through the week to stay in line with the one before.  But if the schedule before ended and a new one continues it moves the next date company_id up.  How can i align the table rows or create an empty table row on all other days if there was a schedule before.  here is the code for the calendar.

Quote

<?php
$db = new mysqli();
$setdate=strtotime($_GET['date']);
$session=$_GET['session'];
$calview=$_GET['calview'];
if ($setdate <> "") {
   $date=$setdate;
} else {
$date=time();
}
$day=date('d',$date);
$month=date('m',$date);
$year=date('Y',$date);
$first_day=mktime(0,0,0,$month,1,$year);
$title=date('F',$first_day);

$day_of_week = date('D', $first_day);

switch($day_of_week) {
case "Sun": $blank = 0;break;
case "Mon": $blank = 1;break;
case "Tue": $blank = 2;break;
case "Wed": $blank = 3;break;
case "Thu": $blank = 4;break;
case "Fri": $blank = 5;break;
case "Sat": $blank = 6;break;
}

$days_in_month = cal_days_in_month(0, $month, $year);

echo "<table cellpadding=0 cellspacing=0 border=0>";
echo "<tbody>";
echo "<tr>";
echo "<td><a href=?session=$session&calview=day>Day</a></td>";
echo "<td><a href=?session=$session&calview=week>Week</a></td>";
echo "<td><a href=?session=$session&calview=month>Month</a></td>";
echo "</tr>";
echo   "<tr>";
echo      "<td colspan=3>";
if ($calview=="month") {
echo         "<table border=1 width=800>";
echo            "<tbody>";
echo               "<tr height=25><th colspan=7> $title $year </th></tr>";
echo               "<tr height=25><td width=58 align=center>Sunday</td><td width=58 align=center>Monday</td><td width=58 align=center>Tuesday</td><td width=58 align=center>Wednesday</td><td width=58 align=center>Thursday</td><td width=58 align=center>Friday</td><td width=58 align=center>Saturday</td></tr>";

$day_count = 1;

echo               "<tr height=50>";

while ( $blank > 0 ) {
echo               "<td></td>";
$blank = $blank-1;
$day_count++;
}

$day_num = 1;

while ($day_num <= $days_in_month ) {
$newdate = $month ."/". $day_num ."/". $year;
$msqlnewdate = date('m/d/Y',strtotime($newdate));
echo "<td valign=top><table cellpadding=0 cellspacing=0 border=0><tr><td><a href=?session=$session&calview=day&date=$newdate> $day_num </a></td></tr>";
$db = new mysqli('localhost','username','password', 'rsdata');

if (!$db) {
   echo 'ERROR: Could not connect to database.';
} else {
$query = $db->query("SELECT * FROM rentals WHERE date_format(str_to_date(pdate_out,'%Y-%m-%d'), '%m/%d/%Y') <= '$msqlnewdate' AND date_format(str_to_date(pdate_in, '%Y-%m-%d'), '%m/%d/%Y') >= '$msqlnewdate'");
if ($query) {
   while ($result = $query->fetch_object()) {
      echo "<tr><td>".$result->company_id."</td></tr>";
   }
}
echo "</table>";
}


$day_num++;
$day_count++;

if ($day_count > 7) {
echo "</tr><tr>";
$day_count=1;
}
}

while ($day_count >1 && $day_count <=7 ) {
echo "<td></td>";
$day_count++;
}
echo "</tr></table>";
} else if ($calview=="week") {

} else {

}
         
echo      "</td>";
echo   "</tr>";
echo "</tbody>";
echo "</table>";
?>


MOD EDIT: DB credentials edited out.

I have MySQL table with the following fields:

user=>varchar
product=>varchar
Amount=>int
Date=>date
Note=>tinytext

I can't add value to these field by the following php code:

$date = date("Y.m.d");
$query = "INSERT INTO order VALUES ('farhad', 'Mango', '10', '$date', 'hello')";
$result = mysql_query($query) or die(mysql_error());

I receive the following warning:

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2.0/DST' instead in C:\inetpub\wwwroot\Okern\~order.php on line 10 Call Stack: 0.0047 325856 1. {main}() C:\inetpub\wwwroot\Okern\~order.php:0 0.0274 344912 2. date() C:\inetpub\wwwroot\Okern\~order.php:10 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 'order VALUES ('farhad', 'Mango', '10', '2011.04.17', 'hello')' at line 1

Can someone five me the correct code or format to use that will allow my TINYINT columns to carry TWO decimal places when creating my table?  I have a script for creating the table and columns, but only recently learned that I need to ADD the TWO decimal place FUNCTION in order to get whole dollar values to display WITH the trailing zeros (ie.:2.00).  I don't expect to need any values greater than xxx.xx in my columns, I'm just not clear on how to get the desired script when running the initial CREAT script.

Thanks

i have a mysql table which contains name like

mid           mname

101           AAA
102          BBB
103          CCC

now i have to print this name in a html table like AAA, BBB, CCC

i am getting this by while loop in a variable but when loop changes then value also change so please tell me how i get this only in one variable & print

Hi,

I'm making a website that uses data stored in SQL.

One of my pages allows the user to enter a new product into a product table. I was wondering if somebody could help me with some validation or Query that will not allow the user to enter a product name that already exists in the table?

Code: [Select]

$nameNew = $_POST['new];
$nameID = $_POST['newID];
$namePrice = $_POST['newPrice];

INSERT INTO products
VALUES ($nameNew, $newID, $newPrice)

$describeQuery = "SELECT ID, Name, Price FROM Products";


$results = sqlsrv_query($conn, $describeQuery);

echo '<table border="1" BORDERCOLOR=Black>';
echo '<tr><th bgcolor = "LightBlue">Name</th><th bgcolor = "LightBlue" >ID</th> <th bgcolor = "LightBlue" >Price</th></tr>';


while($row = sqlsrv_fetch_array($results, SQLSRV_FETCH_ASSOC))
  {   
    echo '<tr>';
echo '<td >' .$row['Name'].'</td>';
echo '<td>' .$row['ID'].'</td>';
echo '<td>' .$row['Price'].'</td>';

echo '</tr>';
}

echo '</table>';
sqlsrv_close($conn);


   
Thanks

Im not much of a coder, and I obviously did this wrong since it is not working. Im trying to bring a new field value in to an existing php file. I created a new table, and an admin page to control that field. I cant, however, figure out how to use that value in a different php file. Actually, there are 2 files. Each using a different field from that new table. I will post what my current code is below with the additions I tried to add. I bolded the lines that contain the tags Im trying to use. Any and help you can give in fixing this to make it work is greatly appreciated.

Code: [Select]
<?php

# INCLUDE ALL NECESSARY FILES.
include_once("Constants.php");
include_once("Database.php");
include_once("SiteSetting.php");

[b]$query = "SELECT arcade_multiplier FROM tbl_point_rewards";
mysql_query($query) or die("Invalid query". mysql_error() );
$result = mysql_fetch_array($result);
$arcade_multiplier = $result["arcade_multiplier"];[/b]

$dbObj = new database();

# SAVE ARCADE GAME POINTS INTO THE DATABASE
function saveGamePoints( $game_id, $user_id, $game_score, $calculate_score_flag, $play_date ){
global $dbObj;

$user_max_plays = getUserMaxPlaysLimit( $user_id, $game_id );
//$_SESSION["arcade_game"]["save_score"] = ($user_max_plays < $_SESSION["arcade_game"]["max_plays"]) ? "yes" : "no" ;

if($user_max_plays < $_SESSION["arcade_game"][$_SESSION["url_gameid"]]["max_plays"]){

$total_points = calculatePointRatio($game_id, $game_score);
//$total_points = $game_score;

$x_gameid = md5($game_id);
if($_SESSION["arcade_game"][$x_gameid]["play_time"] > 0){
$playTime['start'] = $_SESSION["arcade_game"][$x_gameid]["play_time"];
$playTime['end'] = time();
$playTime = ($playTime['end'] - $playTime['start']);
}
else
{
$playTime = 0;
}

# update total points into main score
[b] $update_sql = "update tbl_users set points_gained = (points_gained+(".ceil($total_points)." * $arcade_multiplier)) where usrid={$user_id}";[/b]
$rs = mysql_query($update_sql) or die("Invalid query: {$update_sql} - ". mysql_error());

$table  = "tbl_arcade_game_score";
$fields  = array("game_id", "user_id", "game_score", "calculate_score_flag", "play_date", "game_time");
$values  = array($game_id, $user_id, $game_score, $calculate_score_flag, $play_date, $playTime);

//  return $dbObj->cgi( $table, $fields, $values, 1 );

$insertid = $dbObj->cgi( $table, $fields, $values, "" );

$ceiling_point =  getCeiling($game_id);

if($game_score >= $ceiling_point)
{
$chk_authourity = isAlreadyTrophyOwner($user_id, $game_id);
//if($chk_authority < 1)
if($chk_authourity < 1)
{
# store award details into the database (tbl_trophy_award) 
//$trophy_id  = getTrophy( $game_id );
$trophy = getTrophyDetails($game_id);
$trophy_id = $trophy['ctoon_id'];
$tbl_fields = array('userid', 'game_id', 'award_date', 'trophy' );
$tbl_values = array($user_id, $game_id, $play_date,  $trophy_id );
$insert_tbl_trophy_award_id = $dbObj->cgi('tbl_trophy_award', $tbl_fields, $tbl_values , "" );

# award trophy to user (tbl_users_ctoons)
$table  = "tbl_users_ctoons";
$fl = array("usrid", "ctoon_id", "del_status", "ctoons_auction", "auction_id", "location", "batpts");
$vl = array($user_id, $trophy_id, '0', '', 0, 1, 0);
$dbObj->cgi($table, $fl, $vl , "" );

# send a pm to the user about the trophy
include_once("send_pm_message.php");
$game = getGameDetails($game_id);

$msgSub  = "Grats! You just got a trophy!";
$message = "Grats! You got the ".$trophy["toon_name"]." trophy for the  ".$game["game_name"]." game!<br>
<img src=\"{$game['path']}\">";

  //echo $message;
  //echo "<br><hr><br>";
sendMessage($user_id, 0, 0, $msgSub, $message, 1);
sendMessage(2034, $user_id, 0, $msgSub, $message, 1);

}
}

return $insertid;
}
}//end function

function getCeiling($game_id)
{
$sql = "SELECT ceiling FROM tbl_game WHERE game_id = '".$game_id."'"; 

$rs = mysql_query($sql);

$result = mysql_fetch_assoc($rs);

return $result['ceiling'];
}

function isAlreadyTrophyOwner($user_id, $game_id)
{
$sql  = "SELECT * FROM tbl_trophy_award WHERE game_id = {$game_id} and userid = {$user_id}"; 

$rs  = mysql_query($sql);
$num_rows  = 0;
$num_rows  = mysql_num_rows($rs);

if($num_rows > 0)
{
return $num_rows;
}
else
{
return $num_rows;
}
}

# calculate game ratio
function calculatePointRatio($game_id, $game_score){
//return $game_score;
$sql = "select gs.* from arcade_game_setting as gs where gs.game_id={$game_id}";
$rs = mysql_query($sql) or die( "Invalid query". mysql_error() );
if($rs){
$row = mysql_fetch_array($rs);
switch($row["calculation_type"]){

case "divide":
$x_score =  round($game_score / $row["r_no"]);
break;

case "multiply":
$x_score = round($game_score * $row["r_no"]);
break;

default :
$x_score = ceil($game_score);
break;

}//switch
$row["r_no"];
if($row["game_cap"] > 0){
if($x_score > $row["game_cap"]){
$x_score = $row["game_cap"];
}
}
return $x_score;
}//if
}// end function


# get user total plays 
function getUserMaxPlaysLimit($user_id, $game_id){
global $d_start_time, $d_end_time;
$sql = "select * from tbl_arcade_game_score where user_id={$user_id} and game_id={$game_id} and play_date between {$d_start_time} and {$d_end_time}";
$rs = mysql_query($sql) or die("Invalid query :". mysql_error() );
if($rs){
return mysql_num_rows($rs);

}//if
}

# get game details
function getGameDetails($game_id){
$sql = "select g.game_id, g.game_name, g.award_ctoonid, c.toon_name, c.toon_cat, c.toon_subcat, c.toon_small_img from tbl_game as g, tbl_ctoon as c where g.game_id = {$game_id} and g.award_ctoonid=c.ctoon_id";
$rs = mysql_query($sql);
if($rs){
$row = mysql_fetch_array($rs);

if($row['toon_cat']!="" && $row['toon_subcat']!=0)
$tpth="imgtoon/".$row['toon_cat']."/".$row['toon_subcat']."/thumb";
elseif($row['toon_cat']!="" && $row['toon_subcat']==0)
$tpth="imgtoon/".$row['toon_cat']."/thumb";

$game["game_name"]  = $row["game_name"];
$game["award_ctoon_id"]  = $row["award_ctoonid"];
$game["toon_name"] = $row["toon_name"];
$game["path"] = SITEROOT ."/" . $tpth ."/" . $row["toon_small_img"];


return $game;
}
else
{
return false;
}

}

# send pm message to winner
function sendPMToWinner($user_id, $game_id, $game_score){
include_once("send_pm_message.php");
$g = $game_id;
//$point_prize = calculatePointRatio($game_id, $game_score);
$point_prize = $game_score;
$game = getGameDetails($game_id);

//# select ctoon
//$sql = "select award_ctoonid from tbl_game where game_id=".$g;
//$rsctoon = mysql_query($sql) or die("Invalid query: {$sql} - ". mysql_error());
//$row_ctoon = mysql_fetch_array($rsctoon);
//$ctoon_id = $row_ctoon["award_ctoonid"];

//# award ctoon
//$insert_user_ctoon = "insert into tbl_users_ctoons (usrid, ctoon_id, del_status, ctoons_auction, auction_id, location, batpts)
//values('{$user_id}', '{$ctoon_id}', '0', '', '', '1', '0')";
//mysql_query($insert_user_ctoon) or die("Invalid insert query:".mysql_error() );

//# update points
$update_points_sql = "update tbl_users set points_gained = (points_gained+1500) where usrid={$user_id}";
mysql_query($update_points_sql) or die("Invalid updates points query". mysql_error() );


$dbObj  = new database();
$msgSub  = "Grats! You got a Top Score for ".$game["game_name"]." !";
$message = "Grats! You had one of the Top 10 scores in the ".$game["game_name"]." game last month, and got a 1500 point bonus!<br>";
//<img src=\"{$game['path']}\">";

//  echo $message;
//  echo "<br><hr><br>";
sendMessage($user_id, 0, 0, $msgSub, $message, 1);

}



/**
* function getTrophy( $game_id )
* @param $game_id
*/
function getTrophy( $game_id ){
$sql = "select award_ctoonid from tbl_game where game_id=".$game_id;
$rs = mysql_query( $sql ) or die( mysql_error() );
if( $rs ){
$row = mysql_fetch_assoc( $rs );
}

return $row["award_ctoonid"];

}

// Updated function from above
// Will get more information about the trophy
function getTrophyDetails($game_id)
{
$sql = "select b.ctoon_id,b.toon_name,b.toon_small_img from tbl_game as a,tbl_ctoon as b where a.game_id = '$game_id' and b.ctoon_id = a.award_ctoonid LIMIT 1";
$rs = mysql_query( $sql ) or die( mysql_error() );
if( $rs ){
$row = mysql_fetch_assoc( $rs );
}

return $row;
}

?>

Code: [Select]
<?php

include_once("Constants.php");
include_once("Database.php");
include_once("SiteSetting.php");

/**************************************************/
# SAVE DONETION IN DATABASE
# @param $uid
# @param $donation_amt
/**************************************************/
function saveDonetion($uid, $donation_amt, $transaction_id, $subscr_id='', $type){

if($transaction_id != "")
        {
    $flag = checkExist($uid);
         
    if($flag > 0){
    updateDonetion($uid, $donation_amt, $transaction_id, $subscr_id='', $type);
    }else{
    addDonetion($uid, $donation_amt, $transaction_id, $subscr_id='', $type);
    }
        }

}
/**************************************************/


/**************************************************/
# CHECK IS RECORD EXITS IN DONETION TABLE
# @param $uid
/**************************************************/
function checkExist($uid){

$dbObj = new database();

$sql = "select user_id from tbl_donation where user_id={$uid}";
$dbObj->myquery($sql);

if($dbObj->row_count > 0){
return $dbObj->f_user_id;
}else{
return 0;
}
}
/**************************************************/



/**************************************************/
# INSERT DONETION RECORD IN tbl_donation
# @param $uid
# @param $donation_amt
/**************************************************/

[b]$query = "SELECT arcade_multiplier FROM tbl_point_rewards";
mysql_query($query) or die("Invalid query". mysql_error() );
$result = mysql_fetch_array($result);
$arcade_multiplier = $result["arcade_multiplier"];[/b]


function addDonetion($uid, $donation_amt, $transaction_id, $subscr_id='', $type){

$dbObj = new database();

$months = floor($donation_amt / 5);
$exp_time = mktime(date("H"),date("i"),date("s"),date("m") + $months,date("d"),date("Y"));

$fields = array("transaction_id", "subscr_id", "user_id", "donation_amt", "donation_date", "exp_date", "donation_type", "transaction_details");
$values = array($transaction_id, $subscr_id, $uid, $donation_amt, time(), $exp_time, $type, serialize($_SESSION["recurring_td"]));

# update points
[b]$update_points_sql = "update tbl_users set points_gained = (points_gained+(($donation_amt / 5) * $donation_pts)) where usrid={$uid}";/[b]
mysql_query($update_points_sql) or die("Invalid updates points query". mysql_error() );


if($donation_amt < 5){
// The user donated less than $5

}else{
upgradeAccount($uid);
}

return $dbObj->cgi("tbl_donation", $fields, $values, false);
}
/**************************************************/


/**************************************************/
# UPDATE EXISTING DONETION RECORD
# @param $uid
# @param $donation_amt
/**************************************************/
function updateDonetion($uid, $donation_amt, $transaction_id, $subscr_id='', $type){

if(strlen($subscr_id) > 0){
$cd = " AND subscr_id='".$subscr_id."'";
}
$sql_select = "select exp_date, donation_amt from tbl_donation where user_id=".$uid;
//$sql_select = "select exp_date, donation_amt from tbl_donation where user_id=".$uid." and donation_type like '%recurring%'";
$rs_select  = mysql_query($sql_select) or die("Invalid query".mysql_error());
if($rs_select){
$row  = mysql_fetch_array($rs_select);
$expdt  = $row["exp_date"];
$damt  = ($row["donation_amt"] + $donation_amt);
$months = floor($donation_amt / 5);
$exp_time = mktime(23, 59, 59, date("m",$row["exp_date"]) + $months, date("d", $row["exp_date"]), date("Y", $row["exp_date"]));
}

$dbObj = new database();
$sql = "update tbl_donation set 
transaction_id='".$transaction_id."', 
donation_amt=(donation_amt + {$donation_amt}), 
donation_date = ".time().", 
exp_date=".$exp_time.", 
donation_type='".$type."', 
transaction_details='".serialize($_SESSION["recurring_td"])."' 
where user_id={$uid}";

# update points
[b]$update_points_sql = "update tbl_users set points_gained = (points_gained+(($donation_amt / 5) * $donation_pts)) where usrid={$uid}";[/b]
mysql_query($update_points_sql) or die("Invalid updates points query". mysql_error() );

$dbObj->myquery($sql, 1);

if($donation_amt < 5){
// The user donated less than $5

}else{
upgradeAccount($uid);
}

}
/**************************************************/




/**************************************************/
# UPDATE EXISTING RECURRING DONETION RECORD
# @param $uid
# @param $donation_amt
/**************************************************/
function updateRecurringDonetion($subscr_id, $transaction_amt){

$sql_subscr = "select donation_id, transaction_id, user_id from tbl_donation where subscr_id = '".$subscr_id."'";
$rs_subscr  = mysql_query($sql_subscr) or die("Invalid query".mysql_error());
if(strlen($rs_subscr) > 0){
$row_subscr = mysql_fetch_assoc($rs_subscr);
$uid = $row_subscr["user_id"];
$donation_amt = $transaction_amt;
$transaction_id = $row_subscr["transaction_id"];
$subscr_id = $subscr_id;
$type = "Recurring";
updateDonetion($uid, $donation_amt, $transaction_id, $subscr_id='', $type);
}
}
/**************************************************/






/**************************************************/
# UPDATE USER STATUS FROM STANDERED TO PREMIUM
# @param $uid
/**************************************************/
function upgradeAccount($uid){

$dbObj = new database();

$sql = "UPDATE tbl_users SET acc_type = 'P' WHERE usrid={$uid} LIMIT 1 ";

# update points
$update_points_sql = "update tbl_users set points_gained = (points_gained+0) where usrid={$uid}";
mysql_query($update_points_sql) or die("Invalid updates points query". mysql_error() );

$dbObj->myquery($sql, 1);

}//function upgradeDonation($uid)

?>

As I title says; I need to have an image showed the number of times, the value of a table/field..

How can I do this?

what im trying to do is take a youtube embed code find the URL code for that video and remove all other parts of the code keeping only the URL of the video
after i get the URL by it self then replace the http://www.youtube.com/ part of the URL with http://i2.ytimg.com/vi/

to do this i know that i need something like this to get the URL of the video
http://www.youtube.com/((?:v|cp)/[A-Za-z0-9\-_=]+)
but how to only return just the URL is something idk how to do

then use str_replace http://www.youtube.com/(?:v|cp)/" with  http://i2.ytimg.com/vi/

so in the end im asking if anyone know how to remove all other codes i dont want  and only keep the URL


this may have to be done using "regex" im not sure as i dont know to much about regex and what it can do but does sound like it would help lol

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:

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 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>

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'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);