I need to manipulate two tables(in different DB) to print out data, what's the effective way to do that in php code?

$conn = mssql_connect($intraserver, $intrauser, $intrapass);...

I try to generate on-fly pdf files by php code, the pdf file will display the web page exactly the same as on browser, did some research but have no clue how to do that.
The function: PDF_show_xy (...

I try to copy and paste TAB delimited list into html text area, then save it to database, however when I retrieve it from DB, all TAB space are gone, does anyone can give me advice is there a way to...

how can I replace who string with certain beginning and ending, for example I have string:
abc........xyz

I want to replace this string with "this is a test", no matter what text in between, only...

Is there attachment feature in standard php mail() function? I don't want to install additional application as I have bunch of files use mail(), I don't know if this new application will affect that.

In php mail() function, how can I send attachments? I didn't find parameter to do this. any help will be appreciated.

how can I pass GET url which contains character "?" to php file.
for example I have url:
http://www.mysite.com/file1.php?string=file2.php?a1=1&a2=2&a3=3

I want to pass all string...

How can I get future date by php date() function, for example today is 11/13/2007, I want to get the date after 60 days.

Any advice will be appreciated.

The php page contains table that display dynamic data retrieved from mysql database, I have no problem to display this table on web browser and convert it to excel file, by manually.
Now I need to...

Thanks for reply.
I tried this, it works ok from web browser, but not from command line, it doesn't generate excel file.
Actually this $data is the dynamic php web page I created, I want to save...

I have a simple php file for example:

<?
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=file123.xls");
header("Pragma: no-cache");...

I have a question about how to manipulate php string.
For example, I have a text string:
$text="
---<updated:12/20/06>---
this is 2nd entry
---<updated:12/19/06>---
this is 1st entry
";

Now...

I have php code that retrieve data from mysql DB, and print it in html table.
<?
print "<table>";
$result=mysql_query("select fd1,fd2,fd3 from tbl");
for ($i = 0; $i < mysql_num_rows($result);...

I am planing to write a php script which can display time schedule bar, based on start/end date, and each project(see attached image, start/end date and project name are saved in database), the...

I try to set cookie values from mysql DB, I have the code:

$result = mysql_query("select ID from table");
while ($thisrow=mysql_fetch_row($result))
{
$gname="name_".$i;
setcookie...

What I mean is within <select> dropdown menu, I need to submit:
(1) <option value=$line[0]>
(2) another hidden value "$line[1]"
so after submitting the form, I can retrieve both option value and...

If the items in <select> drop down menu are populated from mysql DB, like:

<?
echo "<select name=ptype>";
echo "<option value=\"\">------Select------</option>";
for ($i = 0; $i <...

I want to use PHP mail() function to send email to hundreds of users, in mail function I can set mail list like:
$sendto="user1@abcd.com,user2@xyz.com,user3@yahoo.com,.....";
But in this way when...

If I have an array $abc=[0,0,0,1,0,2];
how to change it to $abc=[1,2]; (remove all 0), is there php function can handle that? thanks.

Thanks for the reply.
I also found another way to do that:
$order_num ="SN".str_pad($a,5,0,STR_PAD_LEFT);

A simple question.
I have integer variable $a=2, how can I display it in string format: "SN0002" with 4 '0' inserted? thanks.

I have date value saved in Mysql DB, with format "dd.mm.yyyy", now I want to delete all records that date is older than 10 days from today, how can I do that in php? is there php function can...

In php, is there a function like "wait()", the program executes to certain line and wait a moment(like 1 second) then proceed to next line? thanks.

I turned on php Domxml module in php.ini and restart apache server, I can read domxml is enabled in phpinfo, however when I try to load XML file:
$dom =...

I try to resize jpeg from photo size to thumbnails, however the thumbnails quality is bad, it looks fade and blur, I have no idea how to improve the quality of thumbnails.
PHP resize function:...

is there a php function that I can verify if the string contains all digital number, not alphabetic charactor? thanks.

Can anyone answer my question?

I try to use PHP GD library to resize image to thumbnail size, however I found the small converted image has bad quality(distorted color), how can I improve the image quality by using PHP GD library:...

Is there php function to remove the space inside the string? for example:
$abcd="this is a test"
I want to get the string:
$abcd="thisisatest"

How to do that? thanks.

Can anyone answer this question? thanks.

Is there a function in php to remove the duplicate string variables, for example there is "abcd,ab,cd,abc,abc", how to change it to "abcd,ab,cd,abc"?thanks.

I want to know is there a way to display .tiff files on the web page directly? As html can handle jpg,gif,bmp, but how about tiff file? I tried to use <img src=abc.tiff> it pops up the download box...

How can I conver the date format in php, like from "12/31/05"(mm/dd/yy) to "31 December 2005"?

I have a textbox where user can enter the date in format of MM/DD/YY, now I want to set a rule only accept the date within one month from current date, how can I do that, anyone help will be...

As POST is more secure than GET, and can handle larger amount of text, why we still need GET? Even if we cannot POST in a link like <a href="product_detail.php?id=15">, we still can use POST in form...

Hi,

I'm new to php, I want to know what's the better time to use POST instead of GET(or GET instead of POST)? what's the advantage to use one rather than other.

Thanks.

I have a login script, I want to modify it to restrict the sharing username access, by IP address, what will be a good method to do this?

thanks.

I have a <textarea></textarea> in this textarea, people can type anything they want, for example:
in <textarea> people will write like;

123456789
abcdefghigk

and save to the database. but...

Thanks, Troy, I will give it a try.

I created a from which includes a textarea, this data will be saved to mysql, when I retrieve it, I want to only display the first two lines of this textarea data(ignore the rest), and only limit to...