mysql_stmt_bind_result(3)

💖 mysql_stmt_bind_result — MariaDB Connector/C 💖

okay bestie, pull up a chair, because this one is literally the glue that makes your result set usable 🫶

✨ Name ✨

mysql_stmt_bind_result — she binds result columns to variables. that's the whole job. that's the vibe. 💅

🌸 Synopsis 🌸

#include <mysql.h>

my_bool mysql_stmt_bind_result(MYSQL_STMT * stmt,
                               MYSQL_BIND * bind);

🦋 Description 🦋

okay so here's the tea: this function binds the columns in the result set to variables. you're basically telling the connector "hey, when you fetch stuff, put it here" and it says "bet" 💖

Returns zero on success, non-zero on failure. no cap.

🎀 Parameters 🎀

• stmt — a statement handle, which was previously allocated by mysql_stmt_init(3). like, she needs to already exist, you can't just manifest her out of thin air. ✨
• bind — an array of [MYSQL_BIND]] structures. and listen, the size of this array must be equal to the number of columns in result set. not more, not less, it's giving exact match energy 👑

👑 Notes 👑

• to figure out the number of columns in the result set, use mysql_stmt_field_count(3). she will tell you. 🔥
• 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 mysql_stmt_fetch(3) is called. so like, you can change your mind mid-fetch and that's iconic of you, the new binding just won't kick in until the next mysql_stmt_fetch(3) call. periodt. 💅

🌈 See Also 🌈

• mysql_stmt_field_count(3)
• mysql_stmt_execute(3)
• mysql_stmt_fetch(3)

fr fr, go read those three, they're the besties this function runs with 🧚

and that's the whole page, bestie, go bind some results and slay 💜

Version 3.4 of the MariaDB Connector/C manual, page mysql_stmt_bind_result(3) — mwah, love that for us 🎀💖✨