05-01-2008
Try var1, var2, var3, ... instead. $var1 means "the field whose position is stored in var1[/b], but since you have not even read any records yet it is meaningless.
Unlike perl and shells, awk does not require its variables to be prefixed by $.
Annihilannic.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
Have the following code(1) producing the results(2 & 3).
Would like to know if there is a way to format the two reports created in a similar fashion.
IE - The first is formatted nicely as a result of the echo "$xmpbdate $xavgs" >> $xmpbrpt
However when I attempt to do the same on... (7 Replies)
Discussion started by: Cameron
7 Replies
2. Shell Programming and Scripting
Hi need some advice..
#grep -i hostname test.csv
(gives the below output)
HOSTNAME,name,host_test,,,,,,,,
Now I need to format the above output as below.
HOSTNAME:
name=host_test
Any easy way of doing this using awk or sed or printf? (4 Replies)
Discussion started by: balaji_prk
4 Replies
3. Shell Programming and Scripting
Ok, for a fun project, my goal is to replicate the style of "catalog" on an old apple ]
*A 002 SOMEAPPLESOFTFILE
B 004 SOMEFILE
T 006 SOMETEXT
I 002 SOMEINTEGERFILE
The first character is either " " or "*" depending on if the file is locked or not.
Next is the filetype, so in... (1 Reply)
Discussion started by: patrick99e99
1 Replies
4. Shell Programming and Scripting
I am using find and ls to search for "warez" files on my server.
find /home/ -regex ".*\.\(avi\|mp3\|mpeg\|mpg\|iso\)" -print0 | xargs -0 ls -oh
This command produces this:
-rw-r--r-- 1 1000 3.2M Feb 18 2009 /home/user/public_html/lupus.mp3
I want to only get this
3.2M... (4 Replies)
Discussion started by: bonrad
4 Replies
5. Shell Programming and Scripting
Sorry for being a n00b, but I'm having a lot more trouble than I should with formatting the output to the program I finally completed. I'm basically looking for the linux equivalent to setw( ) from c++ so that I can print things in columns like this (but without the underlines lol):
MISSPELLED: ... (4 Replies)
Discussion started by: aikaterinimak
4 Replies
6. Shell Programming and Scripting
Hi Experts,
I have to create a report for certain audit and my output looks as follows
I m trying to format my output to look like
Any inputs would be highly appreciated
Thanks
Syed (5 Replies)
Discussion started by: maverick_here
5 Replies
7. Shell Programming and Scripting
Hi Guys
I need help removing some lines from output i am receiving from a shell script.
Here is the output:
http://i52.tinypic.com/10z0fut.png
I am trying to remove the output that i have circled.
. ${EDW}/extracts/bin/extracts_setup2.sh
. ${EDW}/extracts/extracts.conf
... (7 Replies)
Discussion started by: mooey1232003
7 Replies
8. Shell Programming and Scripting
Hi,
I have a file which contents entries in this form.
Only in /data4/temp abc.000001
Only in /data4/temp abc.000003
Only in /data4/temp abc.000012
Only in /data4/temp abc.000120
Only in /data4/temp abc.000133
Only in /data4/temp abc.001444
i want to read line by line and format... (2 Replies)
Discussion started by: arijitsaha
2 Replies
9. AIX
I am using FORTRAN 90 on AIX 5.3 and need to output my data to a tab-delimited file. It must have actual tabs, and I cannot figure out a way to make it work. The resulting file will be imported into another application (quickbooks) as an .iif file....for some reason, it needs the tabs; spaces do... (2 Replies)
Discussion started by: KathyB148
2 Replies
10. Shell Programming and Scripting
Hi,
I am trying to use printf command and format certain output in a specific format as under:
While the left side (upto |) of the above format is part of a fixed header function, the right side is where i am expecting data to be printed. However, as seen, Row1 value is reflecting on last... (5 Replies)
Discussion started by: EmbedUX
5 Replies
LEARN ABOUT PHP
mysqli_stmt.bind_result
MYSQLI_STMT.BIND_RESULT(3) 1 MYSQLI_STMT.BIND_RESULT(3)
mysqli_stmt::bind_result - Binds variables to a prepared statement for result storage
Object oriented style
SYNOPSIS
bool mysqli_stmt::bind_result (mixed &$var1, [mixed &$...])
DESCRIPTION
Procedural style
bool mysqli_stmt_bind_result (mysqli_stmt $stmt, mixed &$var1, [mixed &$...])
Binds columns in the result set to variables.
When mysqli_stmt_fetch(3) is called to fetch data, the MySQL client/server protocol places the data for the bound columns into the speci-
fied variables $var1, ....
Note
Note that all columns must be bound after mysqli_stmt_execute(3) and prior to calling mysqli_stmt_fetch(3). Depending on column
types bound variables can silently change to the corresponding PHP type.
A column can be bound or rebound at any time, even after a result set has been partially retrieved. The new binding takes effect
the next time mysqli_stmt_fetch(3) is called.
PARAMETERS
o $
stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).
o $var1
- The variable to be bound.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
/* prepare statement */
if ($stmt = $mysqli->prepare("SELECT Code, Name FROM Country ORDER BY Name LIMIT 5")) {
$stmt->execute();
/* bind variables to prepared statement */
$stmt->bind_result($col1, $col2);
/* fetch values */
while ($stmt->fetch()) {
printf("%s %s
", $col1, $col2);
}
/* close statement */
$stmt->close();
}
/* close connection */
$mysqli->close();
?>
Example #2
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (!$link) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
/* prepare statement */
if ($stmt = mysqli_prepare($link, "SELECT Code, Name FROM Country ORDER BY Name LIMIT 5")) {
mysqli_stmt_execute($stmt);
/* bind variables to prepared statement */
mysqli_stmt_bind_result($stmt, $col1, $col2);
/* fetch values */
while (mysqli_stmt_fetch($stmt)) {
printf("%s %s
", $col1, $col2);
}
/* close statement */
mysqli_stmt_close($stmt);
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
AFG Afghanistan
ALB Albania
DZA Algeria
ASM American Samoa
AND Andorra
SEE ALSO
mysqli_stmt_get_result(3), mysqli_stmt_bind_param(3), mysqli_stmt_execute(3), mysqli_stmt_fetch(3), mysqli_prepare(3), mysqli_stmt_pre-
pare(3), mysqli_stmt_init(3), mysqli_stmt_errno(3), mysqli_stmt_error(3).
PHP Documentation Group MYSQLI_STMT.BIND_RESULT(3)