We have a program which create sar output files which has a weeks data...
To read file we use sar -f sa15 command which has multiple days data( a weeks data)....we need to only get last 48 hours data and email it to different users....
I guess we can use combination of sar -o or even awk.... (3 Replies)
I have to grep a pattern. scenario is like :-
Suppose "/etc/sec/one" is a string, i need to check if this string contains "one" using any utility
something like
if /etc/sec/one | grep ; then
Thanks in advance
Renjesh Raju (3 Replies)
I have these data below and i want my output to print only the 3rd files. For example, in /opt/home/nyfix/.k5login, i want to print only "nyfix".
/opt/home/nyfix/.k5login
/opt/home/security/.k5login
/opt/home/noc/.k5login
what is the appropriate command in shell scripting ? (2 Replies)
Hi!!
I have a bit of a task here and filtering/scripting not my strongest. I have to collect info of approx 1100 hdiskpower.so i have appended all the hdisk into a text file and i need it to run the command lscfg -vl to confirm if the drive is symmetrix. here's what i have so far
at... (3 Replies)
Hi
I am interested in DNS resolving a set of sites and each time the output is different-
$ host www.yahoo.com
www.yahoo.com is an alias for fd-fp3.wg1.b.yahoo.com.
fd-fp3.wg1.b.yahoo.com is an alias for ds-fp3.wg1.b.yahoo.com.
ds-fp3.wg1.b.yahoo.com is an alias for... (1 Reply)
Hi All,
I have a input file as below. Input file may contain more hostlists.
sample Input file
$ cat hostlist.lst
cs18-db1-1-sjl
cs22-db1-1-was
na88-db1-1-chi
na21-db1-2-was
I want the output like below format. Pls help. Thanks !
Output format:
... (4 Replies)
Hi,
I have this command on my linux jmap -heap $pid | grep '%\|:' the output of which is like below:
I need a smart way to check if any of these memory usage crosses 95%, 90% and 85% i need to triggerAlert accordingly.
I know how to trigger email alerts however I need a good way to... (3 Replies)
Hi All,
I am trying to collect the listen ports info from netstat command in centos 7
From that info i am trying to collect all the foreign address IP for those ports.
I am using below script to do the same.
netstat -an |grep -w "LISTEN" |grep -v "127.0.0.1" |awk '{print $4}' >... (3 Replies)
Discussion started by: sravani25
3 Replies
LEARN ABOUT PHP
mysql_fetch_field
MYSQL_FETCH_FIELD(3) 1 MYSQL_FETCH_FIELD(3)mysql_fetch_field - Get column information from a result and return as an objectSYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_fetch_field(3)
o PDOStatement::getColumnMeta
object mysql_fetch_field (resource $result, [int $field_offset])
DESCRIPTION
Returns an object containing field information. This function can be used to obtain information about fields in the provided query result.
o $
result -The result resource that is being evaluated. This result comes from a call to mysql_query(3).
o $field_offset
- The numerical field offset. If the field offset is not specified, the next field that was not yet retrieved by this function is
retrieved. The $field_offset starts at 0.
Returns an object containing field information. The properties of the object are:
o name - column name
o table - name of the table the column belongs to, which is the alias name if one is defined
o max_length - maximum length of the column
o not_null - 1 if the column cannot be
NULL
o primary_key - 1 if the column is a primary key
o unique_key - 1 if the column is a unique key
o multiple_key - 1 if the column is a non-unique key
o numeric - 1 if the column is numeric
o blob - 1 if the column is a BLOB
o type - the type of the column
o unsigned - 1 if the column is unsigned
o zerofill - 1 if the column is zero-filled
Example #1
mysql_fetch_field(3) example
<?php
$conn = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$conn) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('database');
$result = mysql_query('select * from table');
if (!$result) {
die('Query failed: ' . mysql_error());
}
/* get column metadata */
$i = 0;
while ($i < mysql_num_fields($result)) {
echo "Information for column $i:<br />
";
$meta = mysql_fetch_field($result, $i);
if (!$meta) {
echo "No information available<br />
";
}
echo "<pre>
blob: $meta->blob
max_length: $meta->max_length
multiple_key: $meta->multiple_key
name: $meta->name
not_null: $meta->not_null
numeric: $meta->numeric
primary_key: $meta->primary_key
table: $meta->table
type: $meta->type
unique_key: $meta->unique_key
unsigned: $meta->unsigned
zerofill: $meta->zerofill
</pre>";
$i++;
}
mysql_free_result($result);
?>
Note
Field names returned by this function are case-sensitive.
Note
If field or tablenames are aliased in the SQL query the aliased name will be returned. The original name can be retrieved for
instance by using mysqli_result::fetch_field.
mysql_field_seek(3).
PHP Documentation Group MYSQL_FETCH_FIELD(3)