Menu
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))
>@developer_web#1620911 why 2 different ways you can write this ?
``<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>
``
<i>
</i>if (array_key_exists('insert',$_POST))
<i>
</i>$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
printf ("%s (%s)n", $row["Name"], $row["CountryCode"]);
/* associative and numeric array */
$row = mysqli_fetch_array($result, MYSQLI_NUM);
printf ("%s (%s)n", $row[0], $row[1]);
<i>
</i> /* fetch associative array */
while ($row = mysqli_fetch_assoc($result)) {
printf ("%s (%s)n", $row["Name"], $row["CountryCode"]);
}
<i>
</i>mysqli_fetch_assoc($result)
<i>
</i>mysqli_fetch_array($result, MYSQLI_ASSOC);
<i>
</i>mysqli_fetch_array($result, MYSQLI_ASSOC);
<i>
</i>mysqli_fetch_array($result, MYSQLI_NUM);
<i>
</i>mysqli_fetch_assoc($result)
<i>
</i>mysqli_fetch_num($result)
<i>
</i>mysqli_fetch_assoc($result)
<i>
</i>mysqli_fetch_array($result, MYSQLI_ASSOC);
``<i>
</i><form method="POST">
<button name=insert>send</button>
</form>
<?php
if($_SERVER['REQUEST_METHOD'] === 'POST'){
echo var_dump($_POST);
}
?><i>
</i>
``
``<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>
``
<i>
</i><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>
<i>
</i>name="something" id="something"
<i>
</i><input name=data[]>
<i>
</i>array(first_name,surname);
<i>
</i>array(first_name,surname);
<i>
</i>array(something=>first_name,something=>surname);
<i>
</i><input name=data[]>
<i>
</i><input name=data[]>
``<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>
``
data[]
0.1.9 — BETA 5.2