Menu
Community /Pin to ProfileBookmark
@NogDogJul 19.2020 — #Did you try the manual?
https://php.net/mysqli_fetch_array
https://php.net/mysqli_fetch_assoc
Because, similar to Perl: [u][TMTOWTDI](https://en.wikipedia.org/wiki/There%27s_more_than_one_way_to_do_it) [/u]
@daveyerwinJul 20.2020 — #@daveyerwinJul 20.2020 — #@developer_web#1620941 said ...
I do not understand this part as the $POST is not named ...
if (array_key_exists('insert',$_POST))
Care to explain where php is checking for the key ? Which input of the user ?
this is displayed in browser ...
array(1) { ["insert"]=> string(0) "" }
so 'insert' is a key in $_POST@daveyerwinJul 20.2020 — #@developer_web#1620961 ... said
Dave, do you mind seeing if you can correct my mistakes on this thread by shortening the code as much as possible ? Thanks!
This code is based on the code you have posted
in various threads, it allows you to insert data
into a table then search for matching data in
a particular column and display all rows that
contain that data in the selected column
@daveyerwinJul 21.2020 — #@developer_web#1621059 said ...
I have never seen anything like this before 😀
<form method="POST">
link<input name=data[]><br>
anchor<input name=data[]><br>
url<input name=data[]><br>
dscrp<input name=data[]><br>
<input type="reset"><br>
<button name=insert>send</button></form>
html forms have not changed since day one
learning html forms is essential@daveyerwinJul 21.2020 — #@developer_web#1621058 said ...
I'm still not at intermediate level and so your code seems
a bit hard for me. One day it should become handy.
to the best of my understanding
that code is exactly what you are attempting
search a table column for the search term
then display all rows where the chosen column
contains the search term
have I misunderstood your requirements ?@daveyerwinJul 21.2020 — #@developer_web#1621059 said ...
What is replacing the data[] here since I see no array values in your code something like this:
the array is created automatically by the HTML Form
@developer_web#1621059 said ...
Where is the data of the data array ?
it is right here ...
@daveyerwinJul 21.2020 — #@developer_web#1621082 said ...
I meant I have never seen input field's names are named by array values.
well , they are not
all four inputs are named "data[]"
data[] is a string not an array
there are no arrays in HTML
the square brackets are just a convention in HTML
the HTML Form produces an array named data
data[] without the square brackets
(data can be any string eg columnNames[])
you can see that here ...
$data = $_POST[data];
don't be distracted by the square brackets@daveyerwinAug 03.2020 — #@developer_web#1621674
do a google for ...
html form names with square brackets
mysqli_fetch_assoc() AND mysqli_fetch_array()
Hi,
What is the difference between the 2 ?
What different results would they produce ?
to me they are the same. If the same, then why 2 different ways you can write this ?
[code]
while($rows = mysqli_fetch_assoc($result))
[code]
while($row = mysqli_fetch_array($result,MYSQLI_ASSOC))
Sign in
to post a comment17 Comments(s) ↴
0
@NogDogJul 19.2020 — #Did you try the manual?>@developer_web#1620911 why 2 different ways you can write this ?
Because, similar to Perl: [u]
0
@daveyerwinJul 20.2020 — #``<i>
</i>INSERT DATA<br>
<form method="POST">
link<input name=data[]><br>
anchor<input name=data[]><br>
url<input name=data[]><br>
dscrp<input name=data[]><br>
<input type="reset"><br>
<button name=insert>send</button></form>
SEARCH<br>
<form method="POST">
term<input name=term><br>
col<select name=col>
<option>link
<option>anchor
<option>url
<option>dscrp
</select><br>
<input type="reset"><br>
<button name=search>send</button></form>
<?php
if($_SERVER['REQUEST_METHOD'] === 'POST'){
$servername = "localhost";
$username = "x-x-x-x-x-x-x-x";
$password = "x-x-x-x-x-x-x-";
$dbname = "x-x-x-x-x-x-x-";
$conn = mysqli_connect($servername, $username, $password, $dbname);
$sql = "CREATE TABLE IF NOT EXISTS TestA (
link VARCHAR(255),
url VARCHAR(255),
anchor VARCHAR(255),
dscrp VARCHAR(255))";
$result=mysqli_query($conn, $sql);
$stmt = mysqli_stmt_init($conn);
if (array_key_exists('insert',$_POST)){
$data = $_POST[data];
$sql ="insert into TestA values (?,?,?,?)";
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt, "ssss", $data[0],$data[1],$data[2],$data[3]);
if(!mysqli_stmt_execute($stmt)){echo "exe Failed";}
}
if (array_key_exists('search',$_POST)){
$term=$_POST[term]; $col=$_POST[col];
if (in_array($col,array('link','anchor','url','dscrp'))){
$sql = "select * from TestA where ".$col." = ?";}
else{echo "bad column name";}
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt, "s", $term);
if(!mysqli_stmt_execute($stmt)){echo "exe Failed";}
$result = mysqli_stmt_get_result($stmt);
while ($row = mysqli_fetch_array($result, MYSQLI_NUM)){
foreach ($row as $r){print "$r ";}
print "<br>";
}
}
}<i>
</i>``0
@daveyerwinJul 20.2020 — #I do not understand this part as the $POST is not named ...
if (array_key_exists('insert',$_POST))
Care to explain where php is checking for the key ? Which input of the user ?
``<i>
</i><form method="POST">
<button name=insert>send</button>
</form>
<?php
if($_SERVER['REQUEST_METHOD'] === 'POST'){
echo var_dump($_POST);
}
?><i>
</i>``this is displayed in browser ...
array(1) { ["insert"]=> string(0) "" }
so 'insert' is a key in $_POST
0
@daveyerwinJul 20.2020 — #Dave, do you mind seeing if you can correct my mistakes on this thread by shortening the code as much as possible ? Thanks!
This code is based on the code you have posted
in various threads, it allows you to insert data
into a table then search for matching data in
a particular column and display all rows that
contain that data in the selected column
``<i>
</i>INSERT DATA<br>
<form method="POST">
link<input name=data[]><br>
anchor<input name=data[]><br>
url<input name=data[]><br>
dscrp<input name=data[]><br>
<input type="reset"><br>
<button name=insert>send</button></form>
SEARCH<br>
<form method="POST">
term<input name=term><br>
col<select name=col>
<option>link
<option>anchor
<option>url
<option>dscrp
</select><br>
<input type="reset"><br>
<button name=search>send</button></form>
<?php
if($_SERVER['REQUEST_METHOD'] === 'POST'){
$servername = "localhost";
$username = "x-x-x-x-x-x-x-x";
$password = "x-x-x-x-x-x-x-";
$dbname = "x-x-x-x-x-x-x-";
$conn = mysqli_connect($servername, $username, $password, $dbname);
$sql = "CREATE TABLE IF NOT EXISTS TestA (
link VARCHAR(255),
url VARCHAR(255),
anchor VARCHAR(255),
dscrp VARCHAR(255))";
$result=mysqli_query($conn, $sql);
$stmt = mysqli_stmt_init($conn);
if (array_key_exists('insert',$_POST)){
$data = $_POST[data];
$sql ="insert into TestA values (?,?,?,?)";
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt, "ssss", $data[0],$data[1],$data[2],$data[3]);
if(!mysqli_stmt_execute($stmt)){echo "exe Failed";}
}
if (array_key_exists('search',$_POST)){
$term=$_POST[term]; $col=$_POST[col];
if (in_array($col,array('link','anchor','url','dscrp'))){
$sql = "select * from TestA where ".$col." = ?";}
else{echo "bad column name";}
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt, "s", $term);
if(!mysqli_stmt_execute($stmt)){echo "exe Failed";}
$result = mysqli_stmt_get_result($stmt);
while ($row = mysqli_fetch_array($result, MYSQLI_NUM)){
foreach ($row as $r){print "$r ";}
print "<br>";
}
}
}<i>
</i>``0
@daveyerwinJul 21.2020 — #I have never seen anything like this before 😀
<form method="POST">
link<input name=data[]><br>
anchor<input name=data[]><br>
url<input name=data[]><br>
dscrp<input name=data[]><br>
<input type="reset"><br>
<button name=insert>send</button></form>
html forms have not changed since day one
learning html forms is essential
0
@daveyerwinJul 21.2020 — #I'm still not at intermediate level and so your code seems
a bit hard for me. One day it should become handy.
to the best of my understanding
that code is exactly what you are attempting
search a table column for the search term
then display all rows where the chosen column
contains the search term
have I misunderstood your requirements ?
0
@daveyerwinJul 21.2020 — #What is replacing the data[] here since I see no array values in your code something like this:
the array is created automatically by the HTML Form
Where is the data of the data array ?
it is right here ...
``<i>
</i>$data = $_POST[data];
$sql ="insert into TestA values (?,?,?,?)";
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt, "ssss", $data[0],$data[1],$data[2],$data[3]);<i>
</i>``0
@daveyerwinJul 21.2020 — #I meant I have never seen input field's names are named by array values.
well , they are not
all four inputs are named "data[]"
data[] is a string not an array
there are no arrays in HTML
the square brackets are just a convention in HTML
the HTML Form produces an array named data
data[] without the square brackets
(data can be any string eg columnNames[])
you can see that here ...
$data = $_POST[data];
don't be distracted by the square brackets
0
@daveyerwinAug 03.2020 — #do a google for ...
html form names with square brackets