I am trying to learn something from ur code. Me too have to send an HTML content as Message Body. I may also have attachment of any DOC type..eg .xls, .pdf, .rtf etc. though unlike u I do not have a .zip file as an attachment.
I tried to follow ur code and managed the following code:
But I dont see the message body, neither the Attachment.
Can u guide me so ?
Thanks
Amruta Pitkar
Last edited by Amruta Pitkar; 08-14-2006 at 06:52 AM..
Hi All,
Can you please help me in solving this. I am facing some problem sending mails.
If I use like this, I am able to send mail the mail
echo "This is an automated e-mail; please do not reply." | mailx -s "Good Morning ." 'abc@xys.com'
But if I use like this, then I am unable to send... (1 Reply)
How to embed a html file as subject in a mail sending from Linux box with uuencode or mailx or any other way?
we do not want the file as attachment, it should be embedded in the mail subject. (2 Replies)
I have written a scripts that checks the load average of server and if it is more than 5 it send a mail describing Current Load Average and High CPU/RAM processes .
The problem is I want to send these information in html form .I have done necessary coding to do the same but whenever i try to... (0 Replies)
I have written a scripts that checks the load average of server and if it is more than 5 it send a mail describing Current Load Average and High CPU/RAM processes .
The problem is I want to send these information in html form .I have done necessary coding to do the same but whenever i try to... (7 Replies)
The below code is not working. I am able to send only inline html or only attachment. When trying to do both, only inline html is sent without attachment. Please help!
#!/bin/ksh
(echo "Subject: Test Mail - HTML Format"
echo "MIME-Version: 1.0"
echo "Content-Type: text/html"
echo... (1 Reply)
Hi,
I am using solaris 5.9 OS and I am facing an issues with mailx.
My SMTP port is configured to listen 6190 and not the default one which is 25. I can send mail to my inbox when i do it manually through the following steps
root@<dbname> # telnet 15.12.88.10 6190
Trying 15.12.88.10...... (0 Replies)
I have to send a couple of rows that have been returned from a SQL query. I have written the output of the query to a file and while i try to print this in the mail body the formatting goes wrong.
Intended Output in mail body:
Col1 Col2 Col3
------ ... (2 Replies)
Hi All,
I am trying to send a mail from linux server but could'nt able to send the mail.
I tried the below syntax's so far but no luck.
mail -s “Hello world” abc@xyz.com < /usr/g/txt.log
cat "txt.log" | mailx -s "Hello world" abc@xyz.com
mailx -s “Hello world” abc@xyz.com <... (2 Replies)
I am unable to send email with attachment using the mailx command. Without the attachment, the email goes through file.
This is the command I use.
Works : $ echo "Test" | mailx -s "Test" username@website.com
Fails : $echo "Test" | mailx -a all-dss-accounts.txt -s "Test"... (3 Replies)
Hi,
I am trying to attach a .log file or .txt file to mail command to send an email once my ksh script executed. I am unable to use mutt command as it has been not installed and i am not supposed to install it. I have tried many ways by googling which has not helped me to succeed.
Here is my... (5 Replies)
Discussion started by: Samah
5 Replies
LEARN ABOUT PHP
oci_field_type
OCI_FIELD_TYPE(3)OCI_FIELD_TYPE(3)oci_field_type - Returns a field's data type nameSYNOPSIS
mixed oci_field_type (resource $statement, mixed $field)
DESCRIPTION
Returns a field's data type name.
PARAMETERS
o $statement
- A valid OCI statement identifier.
o $field
- Can be the field's index (1-based) or name.
RETURN VALUES
Returns the field data type as a string, or FALSE on errors.
EXAMPLES
Example #1
oci_field_type(3) example
<?php
// Create the table with:
// CREATE TABLE mytab (number_col NUMBER, varchar2_col varchar2(1),
// clob_col CLOB, date_col DATE);
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}
$stid = oci_parse($conn, "SELECT * FROM mytab");
oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rows
echo "<table border="1">
";
echo "<tr>";
echo "<th>Name</th>";
echo "<th>Type</th>";
echo "<th>Length</th>";
echo "</tr>
";
$ncols = oci_num_fields($stid);
for ($i = 1; $i <= $ncols; $i++) {
$column_name = oci_field_name($stid, $i);
$column_type = oci_field_type($stid, $i);
$column_size = oci_field_size($stid, $i);
echo "<tr>";
echo "<td>$column_name</td>";
echo "<td>$column_type</td>";
echo "<td>$column_size</td>";
echo "</tr>
";
}
echo "</table>
";
// Outputs:
// Name Type Length
// NUMBER_COL NUMBER 22
// VARCHAR2_COL VARCHAR2 1
// CLOB_COL CLOB 4000
// DATE_COL DATE 7
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocicolumntype(3) instead. This name still can be used, it was left as alias of
oci_field_type(3) for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO oci_num_fields(3), oci_field_name(3), oci_field_size(3).
PHP Documentation Group OCI_FIELD_TYPE(3)