به روز رسانی ردیف ها در MySQL با UPDATE

$new_content

<?php 
require_once('dbase.php'); 

$query = "SELECT * FROM posts";
$result = $connect->prepare($query);
$result->execute();

while($row = $result->fetch(PDO::FETCH_ASSOC)){ 
	$id       = $row['id'];
	$content  = $row['content'];
	$video_url     = "data-source='//videos/";
	$new_video_url = "data-source='https://dl2.mizbanfa.net/videos/";
	
	$new_content = str_replace($video_url, $new_video_url, $content);
	
	$update = "UPDATE posts SET content = '$new_content' WHERE id = '$id'"
	$result = $connect->prepare($update);
	if($result->execute()){ 
		echo 'update success!';
	}
}
?>

<div class="Search" style="background:blue"><div class="title-right"  style="background:blue"><p class="right" style="color:white;" >لطفا جهت مشاهده نام خانوادگی بیمار را وارد نموده و جستجو نمایید<hr class="right" style=""></p>
<form action="#" style="width:100%;" method="post">
<input  class="Search" style="width:75%;margin-right:2%;float:right; border-radius:10px;border:1px solid blue;;height:30px"type="text" name="query"placeholder="عبارت مورد نظر را جستجو نمایید...">
<input class="w3-hover-shadow" style="margin-left: 2%;border-radius:5px;background:blue;color:white;width:20%;height:30px"type="submit" name="search" value="جستجو">
</form></div></div>
</div>
</div>
</div>
<div class="col-10 col-s-12" style="margin-top:5px;">
<?php
$servername = "localhost";
$username = "";
$password = "";
$dbname = "";
 
// Create connection
$db = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($db->connect_error) {
    die("ارتباط برقرار نشد: " . $db->connect_error);
}

     if(isset($_POST['search'])){
         $searchQuery=$_POST['query'];
         $getnewposts=mysqli_query($db,"SELECT * FROM `patients`WHERE lastname!= '' AND  lastname LIKE '%$searchQuery%' OR firstname LIKE '%$searchQuery%' OR nationalcode LIKE '%$searchQuery%' OR date LIKE '%$searchQuery%' OR day LIKE '%$searchQuery%' OR time LIKE '%$searchQuery%' OR description LIKE '%$searchQuery%' OR videocall LIKE '%$searchQuery%' ORDER BY `date` DESC  ");
		echo "<table  border='1' >
<tr>
<th >ردیف</th>
<th>نام</th>
<th>نام خانوادگی</th>
<th>کد ملی </th>
<th>شماره تماس </th>
<th>تاریخ</th>
<th>روز</th>
<th>زمان</th>
<th>وضعیت پرداخت</th>
<th>توضیحات</th>
<th>ویرایش</th>
<th>حذف</th>
</tr>";
while($row = mysqli_fetch_array($getnewposts)){

		 echo "<tr>";
    echo "<td>" . $row['id'] . "</td>";
    echo "<td>" . $row['firstname'] . "</td>";
    echo "<td>" . $row['lastname'] . "</td>";
	echo "<td>" . $row['nationalcode'] . "</td>";
	echo "<td>" . $row['mobile'] . "</td>";
    echo "<td>" . $row['date'] . "</td>";
    echo "<td>" . $row['day'] . "</td>";
    echo "<td>" . $row['time'] . "</td>";
    echo "<td>" . $row['paymentstatus'] . "</td>";
    echo "<td>" . $row['description'] . "</td>";
	       echo "<td>" .'<a href="https://www.drmoslemsoltani.ir/dashbord/update.php?id=$p"><img src="/img/edite.png" width="20px" height="20px" alt="update"/></img></a>';
    echo "<td>" .'<a href="https://www.drmoslemsoltani.ir/dashbord/delete.php?id=$p"><img src="/img/delete.png" width="20px" height="20px" alt="delete"/></img></a>';
    echo "</tr>";	
	   }
	   
}
else{
	    echo "با اطلاعات فوق مشخصاتی وجود ندارد";
}
?>
</div>
</div>
</div>

 This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

http://molkaneh.com/f/b.rar