10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Hi,
Can you please advise on answers of below 4 questions as I am not sure on the answers.
1.
You are porting a C program that interacts over a network with remote systems. The program was originally written on AMD64 Linux. You are migrating it to SPARC Solaris architecture.
Question Based on... (1 Reply)
Discussion started by: Vivekit82
1 Replies
2. UNIX for Dummies Questions & Answers
Pleas I want answer this question or reference or link website can find answer to
this question?
1. We consider that we are running on a UNIX system which uses ACL as a mechanism for file protection. Where is the protection information of the file stored?
2. In UNIX, each device is... (1 Reply)
Discussion started by: tamer11007
1 Replies
3. UNIX for Dummies Questions & Answers
When you enter your login id and password, what determines what program startsup? Is it always a Unix shell? (3 Replies)
Discussion started by: Alice Klein
3 Replies
4. UNIX for Dummies Questions & Answers
Dear friends
I'm really new comer to this place and to this subject
you will make me so happy if you help me about these questions:
1- I must install UNIX 5.0.6 because one of my work software will works ONLY on this version , so , I want to know WHERE CAN I DOWNLOAD A COMPELETE PACKAGE OF... (1 Reply)
Discussion started by: mrr53
1 Replies
5. Solaris
IF A program or database routine is writing in a file laying on unix box then how can be identify the process id which is writing in the file.
Please let me know how can we do using root command and without root command?
Regards,
Shashank (10 Replies)
Discussion started by: TAPARIA
10 Replies
6. UNIX for Dummies Questions & Answers
Hey everyone i am new to unix as well, has anybody heard of the script that allows you screen to look just like the Windows screen, if yea, what is it? (3 Replies)
Discussion started by: Gueso
3 Replies
7. UNIX for Dummies Questions & Answers
I tried looking for the answer online and came up with only a few semi-answers as to why file and directory names are case sensitive in Unix. Right off the bat, I'll say this doesn't bother me. But I run into tons of Windows and OpenVMS admins in my day job who go batty when they have to deal... (3 Replies)
Discussion started by: deckard
3 Replies
8. UNIX for Dummies Questions & Answers
I'm a verteran to Windows but i newbie to UNIX so i hope this isn't too dumb of a question. I have an HP 9000 D Class Server that has 10.2 and uses a console. The console died and i was told i can put a standard EISA video card in it and use a regualr monitor and keyboard. My question is how do i... (5 Replies)
Discussion started by: egress1
5 Replies
9. IP Networking
hi there i'm a new bie
just got few simple questions to ask.
I got expert in windows configuration but totally new to unix environment . I want to make sure a com port (com1) is working, so I connect a 9-pin cable (CB9) for both PC using Unix environment (unix to unix).
The question are (1)... (1 Reply)
Discussion started by: typsam
1 Replies
10. UNIX for Dummies Questions & Answers
How might you look at the last mail message someone sent you , without running the mail utility? (1 Reply)
Discussion started by: swetha
1 Replies
MYSQLI_STMT_RESULT_METADATA(3) 1 MYSQLI_STMT_RESULT_METADATA(3)
mysqli_stmt::result_metadata - Returns result set metadata from a prepared statement
Object oriented style
SYNOPSIS
mysqli_result mysqli_stmt::result_metadata (void )
DESCRIPTION
Procedural style
mysqli_result mysqli_stmt_result_metadata (mysqli_stmt $stmt)
If a statement passed to mysqli_prepare(3) is one that produces a result set, mysqli_stmt_result_metadata(3) returns the result object
that can be used to process the meta information such as total number of fields and individual field information.
Note
This result set pointer can be passed as an argument to any of the field-based functions that process result set metadata, such as:
omysqli_num_fields(3)
omysqli_fetch_field(3)
omysqli_fetch_field_direct(3)
omysqli_fetch_fields(3)
omysqli_field_count(3)
omysqli_field_seek(3)
omysqli_field_tell(3)
omysqli_free_result(3)
The result set structure should be freed when you are done with it, which you can do by passing it to mysqli_free_result(3)
Note
The result set returned by mysqli_stmt_result_metadata(3) contains only metadata. It does not contain any row results. The rows are
obtained by using the statement handle with mysqli_stmt_fetch(3).
PARAMETERS
o $
stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).
RETURN VALUES
Returns a result object or FALSE if an error occurred.
EXAMPLES
Example #1
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "test");
$mysqli->query("DROP TABLE IF EXISTS friends");
$mysqli->query("CREATE TABLE friends (id int, name varchar(20))");
$mysqli->query("INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");
$stmt = $mysqli->prepare("SELECT id, name FROM friends");
$stmt->execute();
/* get resultset for metadata */
$result = $stmt->result_metadata();
/* retrieve field information from metadata result set */
$field = $result->fetch_field();
printf("Fieldname: %s
", $field->name);
/* close resultset */
$result->close();
/* close connection */
$mysqli->close();
?>
Example #2
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "test");
mysqli_query($link, "DROP TABLE IF EXISTS friends");
mysqli_query($link, "CREATE TABLE friends (id int, name varchar(20))");
mysqli_query($link, "INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");
$stmt = mysqli_prepare($link, "SELECT id, name FROM friends");
mysqli_stmt_execute($stmt);
/* get resultset for metadata */
$result = mysqli_stmt_result_metadata($stmt);
/* retrieve field information from metadata result set */
$field = mysqli_fetch_field($result);
printf("Fieldname: %s
", $field->name);
/* close resultset */
mysqli_free_result($result);
/* close connection */
mysqli_close($link);
?>
SEE ALSO
mysqli_prepare(3), mysqli_free_result(3).
PHP Documentation Group MYSQLI_STMT_RESULT_METADATA(3)