I would like to create a command to copy a file with a restriction- if the file exists at the copy destination, the copy does not occur and message is provided that file already exists. (3 Replies)
I was sure there was a way to put a timestamp ina logfile but I can't seem to figure out how.
What I would like to do is after the last messages in the rptmgr.err log is put a timestamp so I know the next time I look whats new. I am using AIX 5.1
any help will great
Thanks (2 Replies)
Hello All,
I have a file which contain data something like this:
CELL 2 TEST AND DIAGNOSTIC UNIT 2
CELL 2, CDM 1 CBR 1 TRANSMIT PORT (TXPORT) 1
CELL 2, CDM 1 CBR 2 TRANSMIT PORT (TXPORT) 1
CELL 2, CDM 1 CBR 3 TRANSMIT PORT (TXPORT) 1
CELL 2, CDM 1 CBR 1 TRANSMIT PORT... (21 Replies)
Hi,
I've set up a script so that a user answers questions, and then these answers come back onto the screen accompanied by text that I've echoed. Is there a way of putting this into a new file?
Thanks (7 Replies)
Hi
I have a file that is organized like this. Basically the name is indicated by >name, then on a newline there is a sequence of letters. The letters are ASKL however sometimes there are non ASKL's like U's, G's or O's. Basically what I want to do is cut out the UUUU and record them. So heres... (4 Replies)
do you have any simple script on how to change the color and font of a string in a script example
echo "===================================="
echo " sample color script"
echo "===================================="
echo " hello "
echo " bye"
on hello,... (3 Replies)
Hi All,
This is what I am trying to achieve but to no avail.
I have three sets of files which are:
1. One big dictionary file which looks like this:
apple
orange
computer
pear
country
2. Some thousands of text files which are named as 1.dat, 2.dat, 3.dat etc
The text files... (2 Replies)
Not sure how to do the following, but any help would be appreciated.
Has to be done using C shell (sorry about that).
I have about 300 files that I need this done for, but I am only going to give one example. I will just need to know how to execute your solution through some type of loop to... (2 Replies)
I have a file with the following content:
a-123-345-232
a-23343-4545-545
a-67676-45454-8787
a-129-8912-9824
b-564-78678-2322
b-5454-76767-8899
b-85554-124-152-29
c-34534-654543-323
(... and so on, actually these are pretty huge records)
Now, I want that the file should not be broken in to... (8 Replies)
Hi,
I am new to unix. Kindly help me on this.
My requirement is as below:
I have a path temp/input , temp/CL and temp/CM
I have files in temp/input as below (dates in YYYYMMDDHHMISS)
NMP1515O.CL.20181026111213
NMP1515O.CM.20181025111213
... (4 Replies)
Discussion started by: Shanmugapriya D
4 Replies
LEARN ABOUT PHP
mysql_fetch_assoc
MYSQL_FETCH_ASSOC(3) 1 MYSQL_FETCH_ASSOC(3)mysql_fetch_assoc - Fetch a result row as an associative arraySYNOPSIS
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_assoc(3)
o PDOStatement::fetch
array mysql_fetch_assoc (resource $result)
DESCRIPTION
Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead. mysql_fetch_assoc(3) is equiv-
alent to calling mysql_fetch_array(3) with MYSQL_ASSOC for the optional second parameter. It only returns an associative array.
o $
result -The result resource that is being evaluated. This result comes from a call to mysql_query(3).
Returns an associative array of strings that corresponds to the fetched row, or FALSE if there are no more rows.
If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the
same name, you either need to access the result with numeric indices by using mysql_fetch_row(3) or add alias names. See the example at the
mysql_fetch_array(3) description about aliases.
Example #1
An expanded mysql_fetch_assoc(3) example
<?php
$conn = mysql_connect("localhost", "mysql_user", "mysql_password");
if (!$conn) {
echo "Unable to connect to DB: " . mysql_error();
exit;
}
if (!mysql_select_db("mydbname")) {
echo "Unable to select mydbname: " . mysql_error();
exit;
}
$sql = "SELECT id as userid, fullname, userstatus
FROM sometable
WHERE userstatus = 1";
$result = mysql_query($sql);
if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}
if (mysql_num_rows($result) == 0) {
echo "No rows found, nothing to print so am exiting";
exit;
}
// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
// then create $userid, $fullname, and $userstatus
while ($row = mysql_fetch_assoc($result)) {
echo $row["userid"];
echo $row["fullname"];
echo $row["userstatus"];
}
mysql_free_result($result);
?>
Note
Performance
An important thing to note is that using mysql_fetch_assoc(3) is not significantly slower than using mysql_fetch_row(3), while it
provides a significant added value.
Note
Field names returned by this function are case-sensitive.
Note
This function sets NULL fields to the PHP NULL value.
mysql_fetch_row(3), mysql_fetch_array(3), mysql_data_seek(3), mysql_query(3), mysql_error(3).
PHP Documentation Group MYSQL_FETCH_ASSOC(3)