Menu
Community /Pin to ProfileBookmark
https://www.google.com/search?client=firefox-b-d&q=i+found+the+cause+of+my+ignorance+-+Bruce+lee
https://www.youtube.com/watch?v=ll11FP35ThQ
NogDog,
I found the cause of my ignorance.
On the script, I added a new column last night but did not add it on mysql table.
"agree_to_tos".
Added it now and error gone.
"Hence, I found the cause of my ignorance".
But I did not find the "cause of the ignorance" of both php and mysql.
Why didn't php atleast give me an error stating the "agree_to_tos" column doesn't exist ? How to fix this so I don't go round & round in circles again when I add a new placeholder in the script but forget to add a new column representing it ?
Folks,
Can you spot any typos here:
I get echoed
**Statement Execution Success!**
But I see nothing echoed from mysql tbl. No data atall!
I need to know if this line is necessary or not if I use mysqli_stmt_get_result() instead of mysqli_stmt_bind_result(). I reckjon I do not need it.
@NogDogMay 31.2020 — #
Get rid of that line, too. It's incrementing the result row pointer, so that when you do the fetch a few lines later it thinks there are no more result rows.@NogDog#1618993
NogDog,
Getting rid of these 2 lines as you suggested throws following error:
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:xampphtdocspower.pagesearch_3.php on line 934
I spotted on tutorials now that, if you use mysqli_stmt_get_result($stmt), then you have to use mysqli_stmt_init().
https://www.phptutorial.info/?mysqli-stmt.get-result
I used that now and it is working.
But the funny thing is NogDog, I did not use the mysqli_stmt_init() on another file and that one still worked to echo the rows. How so ? Try answering me on that.
I did it like this on that other one and it is echoing the rows.
Look, no mysqli_stmt_init() with mysqli_stmt_get_result($stmt) plus mysqli_stmt_free_result($stmt) exists.
Look at that other working one ....
[upl-image-preview url=https://www.webdeveloper.com/assets/files/2020-06-02/1591104973-987435-1st-script-working.png]
How come this one is echoing the rows with these still intact ?
Check properly, there exist no:
And the above script is working fine. Look at the above img. Find it echoing the mysql tbl row.
Infact, the code in my original post (that was failing to echo the rows) is a copycat skeleton of the just above mentioned code and so my original post's code (in this thread) should have worked to echo the row. But it doesn't.
Anyway, I fixed this original post code like the following just now and it is working.
Note: On this following one (original post code), it doesn't work unless I use mysqli_stmt_init($stmt).
Plus, unlike the other one, I have to use mysqli_stmt_prepare() and simply using mysqli_prepare() throws error.
Why is that ?
So my questions to you now boils down to this:
2nd code (original post code that I just fixed):
[upl-image-preview url=https://www.webdeveloper.com/assets/files/2020-06-02/1591105112-188627-2nd-script-working.png]
Check properly, unlike 1st script, on this 2nd script, there DOES exist:
And the above script is working fine. Look at the above img. Find it echoing the mysql tbl row.
What is your conclusion now ?
Mine is: CONFUSING!
@Sempervivum
@ginerjm
I'd appreciate it if Sempervivum and Ginerjm can chime in. Aswell as anybody else.
Thanks!
@NogDogJun 02.2020 — #For god's sake be consistent. Don't use @NogDog#1619047
Quite frankly, I wanted to use mysqli_stmt_prepare() but used mysqli_prepare() as typo.
I see from php manual that you use mysqli_stmt_init() if you use mysqli_stmt_get_result(). That is all I know about mysqli_stmt_init(). Or is there more to it ?
How come you never use mysqli_stmt_init() when using mysqli_stmt_bind_result() ?
I am confused about this mydsqli_stmt_init() unless someone intends to shed some light here.@NogDogJun 06.2020 — #
I've never used it, as I've been using PDO for all database interactions for at least 8 years now, so really don't know why you'd use either of those MySQLi patterns over the other one. For that matter, once I learned PDO, I don't know why you'd want to use MySQLi functions at all. ;)@NogDog#1619200
@sempervivum
I found the difference between mysqli_prepare() and mysqli_stmt_prepare().
Either of following 2 is valid:
1.
2.
They say, the 2nd one is for procedural style. But I seen the 1st one works on my procedural style codes as I don't know oop.
In other words, mysqli_prepare() is an alias. That is what I gathered so far.
Gathered from here:
https://stackoverflow.com/questions/31462215/what-is-the-difference-between-mysqli-prepare-and-mysqli-stmt-prepare
Which pointed me to here:
https://www.php.net/manual/en/mysqli-stmt.prepare.php
You can do your own research:
https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&cad=rja&uact=8&ved=2ahUKEwiSjraXtfLpAhXhxTgGHfGIAcMQFjAAegQIARAB&url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F31462215%2Fwhat-is-the-difference-between-mysqli-prepare-and-mysqli-stmt-prepare&usg=AOvVaw1DP4v3csMHa9siRsLMJhb0
Why Mysqli Prepare Failed ?
Php Experts,
I can’t remember what I changed last night that is making the following code malfunctioning. Can you see if you can spot any typos ?
[code]
$sql_query = “UPDATE users SET first_name = ?, middle_name = ?, surname = ?, gender = ?, marital_status = ?, working_status = ?, agree_to_tos = ? WHERE id = ?”;
$stmt = mysqli_prepare($conn,$sql_query);
if($stmt == False)
{
//Close Connection.
mysqli_close($conn);
die(“<pre>2. Mysqli Prepare Failed!n”.mysqli_stmt_error($stmt).”n$sql_query</pre>”);
}
I get this error echoed:
**Warning: mysqli_stmt_error() expects parameter 1 to be mysqli_stmt, boolean given in C:xampphtdocspower.pagesearch_3.php on line 416
2. Mysqli Prepare Failed!
UPDATE users SET first_name = ?, middle_name = ?, surname = ?, gender = ?, marital_status = ?, working_status = ?, agree_to_tos = ? WHERE id = ?**
How to solve this ?
Sign in
to post a comment9 Comments(s) ↴
0
@developer_webauthorMay 31.2020 — #"I found the cause of my ignorance" - Bruce LeeNogDog,
I found the cause of my ignorance.
On the script, I added a new column last night but did not add it on mysql table.
"agree_to_tos".
Added it now and error gone.
"Hence, I found the cause of my ignorance".
But I did not find the "cause of the ignorance" of both php and mysql.
Why didn't php atleast give me an error stating the "agree_to_tos" column doesn't exist ? How to fix this so I don't go round & round in circles again when I add a new placeholder in the script but forget to add a new column representing it ?
reply?
0
@developer_webauthorMay 31.2020 — #New problem!Folks,
Can you spot any typos here:
<i>
</i>$sql_query = "SELECT first_name,middle_name,surname,gender,marital_status,working_status FROM users WHERE id = ?";
$stmt = mysqli_prepare($conn,$sql_query);
mysqli_stmt_bind_param($stmt,'i',$_SESSION["user_id"]);;//DELETE THIS WHOLE LINE AS USING IT AS A TEST!
if($stmt == False)
{
//Close Connection.
mysqli_close($conn);
echo "Line 862<br>";//DELETE THIS
die("<pre>2. Mysqli Prepare Failed!n".mysqli_stmt_error($stmt)."n$sql_query</pre>");
}
else
{
//Attempt to Execute the Prepared Statement.
mysqli_stmt_execute($stmt);
if(!mysqli_stmt_execute($stmt))
{
//Close Connection.
mysqli_close($conn);
echo "Line 915<br>";//DELETE THIS
die("<pre>Statement Execution Failed!n".mysqli_stmt_error($stmt)."n$mysqli_stmt_bind_param</pre>");
}
else
{
die("<pre>Statement Execution Success!</pre>");
}
}
//mysqli_stmt_bind_result($stmt,$email);
$result = mysqli_stmt_get_result($stmt);
//if(mysqli_fetch_array($result_3, MYSQLI_NUM))
//Fetch result row as an associative array. Since the result set contains only one row, we don't need to use the 'While loop'.
//mysqli_stmt_fetch($stmt);//use this if you use 'mysqli_stmt_bind_result($stmt,$email).
if($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) //Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of 'mysqli_stmt_bind_result($stmt,$email)'.
{
//Retrieve Values.
//$id = $row["id"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$username = $row["username"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$first_name = $row["first_name"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$middle_name = $row["middle_name"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$surname = $row["surname"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$gender = $row["gender"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
//$age_range = $row["age_range"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$marital_status = $row["marital_status"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$working_status = $row["working_status"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
//$country = $row["country"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
<i> </i>//echo "Id: $id<br>";
<i> </i>//echo "Username: $username<br>";
<i> </i>echo "First Name: $first_name<br>";
<i> </i>echo "Middle Name: $middle_name<br>";
<i> </i>echo "Surname: $surname<br>";
<i> </i>echo "Gender: $gender<br>";
<i> </i>//echo "Age Range: $age_range<br>";
<i> </i>echo "Marital Status: $marital_status<br>";
<i> </i>echo "Working Status: $working_status<br>";
<i> </i>//echo "Country: $country<br>";
<i> </i>
<i> </i>//Close Statement.
<i> </i>mysqli_stmt_close($stmt);
<i> </i>//Free Result.
<i> </i>mysqli_free_result($result);//Is this line necessary if using mysqli_stmt_get_result() ?
<i> </i>//Close Connection.
<i> </i>mysqli_close($conn);
}
I get echoed
**Statement Execution Success!**
But I see nothing echoed from mysql tbl. No data atall!
I need to know if this line is necessary or not if I use mysqli_stmt_get_result() instead of mysqli_stmt_bind_result(). I reckjon I do not need it.
<i>
</i>mysqli_free_result($result);//Is this line necessary if using mysqli_stmt_get_result() ?
reply?
0
@NogDogMay 31.2020 — #>@developer_web#1618992 $result = mysqli_stmt_get_result($stmt);
Get rid of that line, too. It's incrementing the result row pointer, so that when you do the fetch a few lines later it thinks there are no more result rows.
reply?
0
@developer_webauthorJun 02.2020 — #NogDog,
Getting rid of these 2 lines as you suggested throws following error:
<i>
</i>$result = mysqli_stmt_get_result($stmt);
mysqli_free_result($result);
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:xampphtdocspower.pagesearch_3.php on line 934
I spotted on tutorials now that, if you use mysqli_stmt_get_result($stmt), then you have to use mysqli_stmt_init().
I used that now and it is working.
But the funny thing is NogDog, I did not use the mysqli_stmt_init() on another file and that one still worked to echo the rows. How so ? Try answering me on that.
I did it like this on that other one and it is echoing the rows.
Look, no mysqli_stmt_init() with mysqli_stmt_get_result($stmt) plus mysqli_stmt_free_result($stmt) exists.
Look at that other working one ....
<i>
</i><?php
session_start();
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
if(!isset($_POST['email_account']) || !isset($_POST['email_service']))
{
$email_error = "<font color='red'>Input Email Address!</color>";
}
else
{
//Connect to Database. (DB_SERVER, BD_USERNAME, DB_PASSWORD, DB_NAME).
$conn = mysqli_connect("localhost","root","","powerpage");
$conn->set_charset('utf8mb4'); //Always set Charset.
<i> </i> if($conn === false)
<i> </i> {
<i> </i> die("ERROR: Connection Error!. " . mysqli_connect_error());
<i> </i> }
<i> </i> else
<i> </i> {
<i> </i> //Set Parameters.
<i> </i> $email = trim($_POST["email_account"]) . '@' . trim($_POST["email_service"]);
<i> </i> $_SESSION['email'] = trim($_POST["email_account"]) . '@' . trim($_POST["email_service"]);//If this fails on test then replace it with above line
<i> </i> echo "line 25 triggered: $email<br>";
<i> </i>
<i> </i> $sql_query = "SELECT COUNT(personal_email) FROM users WHERE personal_email = ?";
<i> </i> $stmt = mysqli_prepare($conn,$sql_query);
<i> </i> if($stmt == False)
<i> </i> {
<i> </i> //Close Connection.
<i> </i> mysqli_close($conn);
<i> </i> echo "Line 33<br>";//DELETE THIS
<i> </i> die("<pre>Mysqli Prepare Failed!n".mysqli_stmt_error($stmt)."n$sql_query</pre>");
<i> </i> }
<i> </i> else
<i> </i> {
<i> </i> mysqli_stmt_bind_param($stmt,'s',$email);
<i> </i>
<i> </i> if(!mysqli_stmt_execute($stmt))
<i> </i> {
<i> </i> //Close Connection.
<i> </i> mysqli_close($conn);
<i> </i> die("Could not mysqli_stmt_execute! Please try again later!");
<i> </i> }
<i> </i>
<i> </i> //$result = mysqli_stmt_bind_result($stmt,$email);
<i> </i> //$result = mysqli_stmt_store_result($stmt);
<i> </i> $result = mysqli_stmt_get_result($stmt);
<i> </i>
<i> </i> if(mysqli_fetch_array($result, MYSQLI_NUM)[0])
<i> </i> //($result->fetch_array()[0]) //DELETE THIS. THIS ALSO NOT RETYPED.
<i> </i> //if(mysqli_fetch_array($result, MYSQLI_NUM)) //WHY THIS NOT WORK UNLESS NUM ARRAY GIVEN ?
<i> </i> {
<i> </i> echo "Line 57 triggered: Function login() will trigger!<br>"; //DELETE THIS
<i> </i> $_SESSION['session_type'] = 'login';
<i> </i> login();
<i> </i>
<i> </i> }
<i> </i> else
<i> </i> {
<i> </i> echo "Line 61 triggered: Function register() will trigger!<br>"; //DELETE THIS
<i> </i> $_SESSION['session_type'] = 'register';
<i> </i> register();
<i> </i> }
<i> </i> }
<i> </i> }
<i> </i>}
}
function login()
{
if(!isset($_SESSION['session_type']) || $_SESSION['session_type'] != 'login')
{
//Close Statement.
mysqli_stmt_close($stmt);
//Close Connection.
mysqli_close($conn);
<i> </i> die("Could not check email! Please try again later!");
<i> </i>}
<i> </i>
<i> </i>//$email = trim($_POST["email_account"]) . '@' . trim($_POST["email_service"]);
<i> </i>$email = $_SESSION['email'];//If this fails on test then replace it with above line
<i> </i>
<i> </i>//Connect to Database. (DB_SERVER, BD_USERNAME, DB_PASSWORD, DB_NAME).
<i> </i>$conn = mysqli_connect("localhost","root","","powerpage");
<i> </i>
<i> </i>//Prepare a Select Statement.
<i> </i>$sql_query_3 = "SELECT id,username,first_name,middle_name,surname,gender,age_range FROM users WHERE personal_email = ?";
<i> </i>if(!$stmt_3 = mysqli_prepare($conn,$sql_query_3))
<i> </i>{
<i> </i> //Close Statement.
<i> </i> mysqli_stmt_close($stmt_3);
<i> </i> //Close Connection.
<i> </i> mysqli_close($conn);
<i> </i>
<i> </i> die("Could not check email! Please try again later!");
<i> </i>}
<i> </i>else
<i> </i>{
<i> </i> //Bind Variables to the Prepared Statement as parameters.
<i> </i> mysqli_stmt_bind_param($stmt_3,'s',$email);
<i> </i>
<i> </i> //Attempt to execute the Prepared Statement.
<i> </i> if(!mysqli_stmt_execute($stmt_3))
<i> </i> {
<i> </i> //Close Statement.
<i> </i> mysqli_stmt_close($stmt_3);
<i> </i> //Close Connection.
<i> </i> mysqli_close($conn);
<i> </i>
<i> </i> die("Could not check email! Please try again later!");
<i> </i> }
<i> </i> //mysqli_stmt_bind_result($stmt,$email);
<i> </i>
<i> </i> $result_3 = mysqli_stmt_get_result($stmt_3);
<i> </i>
<i> </i> //if(mysqli_fetch_array($result_3, MYSQLI_NUM))
<i> </i>
<i> </i> //Fetch result row as an associative array. Since the result set contains only one row, we don't need to use the 'While loop'.
<i> </i> //mysqli_stmt_fetch($stmt);//use this if you use 'mysqli_stmt_bind_result($stmt,$email).
<i> </i> if($row = mysqli_fetch_array($result_3,MYSQLI_ASSOC)) //Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of 'mysqli_stmt_bind_result($stmt,$email)'.
<i> </i> {
<i> </i> //Retrieve Values.
<i> </i> $id = $row["id"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
<i> </i> $username = $row["username"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
<i> </i> $first_name = $row["first_name"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
<i> </i> $middle_name = $row["middle_name"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
<i> </i> $surname = $row["surname"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
<i> </i> $gender = $row["gender"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
<i> </i> $age_range = $row["age_range"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
<i> </i>
<i> </i> echo "Id: $id<br>";
<i> </i> echo "Username: $username<br>";
<i> </i> echo "First Name: $first_name<br>";
<i> </i> echo "Middle Name: $middle_name<br>";
<i> </i> echo "Surname: $surname<br>";
<i> </i> echo "Gender: $gender<br>";
<i> </i> echo "Age Range: $age_range<br>";
<i> </i>
<i> </i> //Close Statement.
<i> </i> mysqli_stmt_close($stmt_3);
<i> </i> //Free Result.
<i> </i> mysqli_free_result($result_3);
<i> </i> //Close Connection.
<i> </i> mysqli_close($conn);
<i> </i> }
<i> </i>}
}
How come this one is echoing the rows with these still intact ?
<i>
</i>$result_3 = mysqli_stmt_get_result($stmt_3);
mysqli_free_result($result_3);
Check properly, there exist no:
And also exists:
And the above script is working fine. Look at the above img. Find it echoing the mysql tbl row.
Infact, the code in my original post (that was failing to echo the rows) is a copycat skeleton of the just above mentioned code and so my original post's code (in this thread) should have worked to echo the row. But it doesn't.
Anyway, I fixed this original post code like the following just now and it is working.
Note: On this following one (original post code), it doesn't work unless I use mysqli_stmt_init($stmt).
Plus, unlike the other one, I have to use mysqli_stmt_prepare() and simply using mysqli_prepare() throws error.
Why is that ?
So my questions to you now boils down to this:
And,
2nd code (original post code that I just fixed):
<i>
</i>$sql_query = "SELECT username,first_name,middle_name,surname,gender,marital_status,working_status FROM users WHERE id = ?";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql_query);
mysqli_stmt_bind_param($stmt,'i',$_SESSION["user_id"]);//DELETE THIS WHOLE LINE AS USING IT AS A TEST!
if($stmt == False)
{
//Close Connection.
mysqli_close($conn);
echo "Line 862<br>";//DELETE THIS
die("<pre>2. Mysqli Prepare Failed!n".mysqli_stmt_error($stmt)."n$sql_query</pre>");
}
//Attempt to Execute the Prepared Statement.
mysqli_stmt_execute($stmt);
if(!mysqli_stmt_execute($stmt))
{
//Close Connection.
mysqli_close($conn);
echo "Line 915<br>";//DELETE THIS
die("<pre>Statement Execution Failed!n".mysqli_stmt_error($stmt)."nmysqli_stmt_bind_param</pre>");
}
else
{
echo "<pre>Statement Execution Success!</pre>";
}
//mysqli_stmt_bind_result($stmt,$email);
$result = mysqli_stmt_get_result($stmt);
//if(mysqli_fetch_array($result_3, MYSQLI_NUM))
//Fetch result row as an associative array. Since the result set contains only one row, we don't need to use the 'While loop'.
//mysqli_stmt_fetch($stmt);//use this if you use 'mysqli_stmt_bind_result($stmt,$email).
if($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) //Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of 'mysqli_stmt_bind_result($stmt,$email)'.
{
//Retrieve Values.
//$id = $row["id"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$username = $row["username"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$first_name = $row["first_name"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$middle_name = $row["middle_name"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$surname = $row["surname"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$gender = $row["gender"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
//$age_range = $row["age_range"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$marital_status = $row["marital_status"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
$working_status = $row["working_status"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
//$country = $row["country"];//Use this if you use '$result = mysqli_stmt_get_result($stmt)' instead of //'mysqli_stmt_bind_result($stmt,$email_count)';
//echo "Id: $id<br>";
//echo "Username: $username<br>";
echo "First Name: $first_name<br>";
echo "Middle Name: $middle_name<br>";
echo "Surname: $surname<br>";
echo "Gender: $gender<br>";
//echo "Age Range: $age_range<br>";
echo "Marital Status: $marital_status<br>";
echo "Working Status: $working_status<br>";
//echo "Country: $country<br>";
//Close Statement.
mysqli_stmt_close($stmt);
//Free Result.
//mysqli_free_result($result);//Is this line necessary if using mysqli_stmt_get_result() ?
//Close Connection.
mysqli_close($conn);
}
//mail();
Check properly, unlike 1st script, on this 2nd script, there DOES exist:
And also like the 1st script, on this 2nd script, exists:
And the above script is working fine. Look at the above img. Find it echoing the mysql tbl row.
What is your conclusion now ?
Mine is: CONFUSING!
I'd appreciate it if Sempervivum and Ginerjm can chime in. Aswell as anybody else.
Thanks!
reply?
0
@SempervivumJun 02.2020 — #As far as I'm concerned:reply?
0
@NogDogJun 02.2020 — #For god's sake be consistent. Don't use mysqli_prepare()mysqli_init() / mysqli_stmt_prepare()reply?
0
@developer_webauthorJun 06.2020 — #Quite frankly, I wanted to use mysqli_stmt_prepare() but used mysqli_prepare() as typo.
I see from php manual that you use mysqli_stmt_init() if you use mysqli_stmt_get_result(). That is all I know about mysqli_stmt_init(). Or is there more to it ?
How come you never use mysqli_stmt_init() when using mysqli_stmt_bind_result() ?
I am confused about this mydsqli_stmt_init() unless someone intends to shed some light here.
reply?
0
@NogDogJun 06.2020 — #>@developer_web#1619191 I am confused about this mydsqli_stmt_init() unless someone intends to shed some light here.
I've never used it, as I've been using PDO for all database interactions for at least 8 years now, so really don't know why you'd use either of those MySQLi patterns over the other one. For that matter, once I learned PDO, I don't know why you'd want to use MySQLi functions at all. ;)
reply?
0
@developer_webauthorJun 08.2020 — #I found the difference between mysqli_prepare() and mysqli_stmt_prepare().
Either of following 2 is valid:
1.
<i>
</i>$sql_query = "SELECT username,first_name,middle_name,surname,gender,marital_status,working_status FROM users WHERE username = ? ORDER by id LIMIT $row_start,$row_end";//Offset,Max Result.
$stmt = mysqli_prepare($conn,$sql_query);
2.
<i>
</i>$sql_query = "SELECT username,first_name,middle_name,surname,gender,marital_status,working_status FROM users WHERE username = ? ORDER by id LIMIT $row_start,$row_end";//Offset,Max Result.
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql_query);
They say, the 2nd one is for procedural style. But I seen the 1st one works on my procedural style codes as I don't know oop.
In other words, mysqli_prepare() is an alias. That is what I gathered so far.
Gathered from here:
Which pointed me to here:
You can do your own research:
reply?