function buy_project($cart_id, $number)
{
global $db;
$user_id = $_SESSION['user'];
$query = "SELECT * FROM cart WHERE id = '{$cart_id}';";
$result = $db->query($query);
$project_id = $result->fetch_assoc()['project_id'];
$query = "DELETE FROM `cart` WHERE id = '{$cart_id}'";
$result = $db->query($query);
while ($number > 0) {
$query = "SELECT id FROM project_links WHERE project_id = '{$project_id}' AND user_id = 0 LIMIT 1";
$project_link_id = $db->query($query);
$project_link_id = $project_link_id->fetch_assoc()['id'];
$query = "UPDATE `project_links` set user_id = '{$user_id}', sold = 1 Where id= '{$project_link_id}';";
$result = $db->query($query);
$number--;
}
return array("success", get_cart_number(), get_project_count($project_id), $project_id);
}
<?php
if ($_GET['assign'] == "done") {
?>
<div style="color:#006600"><strong> Thanks for assigning images to Project.</strong></div>
<?php
} else {
if ($_GET['assign'] == "no") {
?>
<div style="color:#FF0000"><strong>No Image Available.</strong></div>
<?php
}
}
?>
<?php
$project_count = get_project_count();
$cls = 'textdiv';
if (get_project_count > 0) {
$cls = '';
}
?>
<form name="checkconform" action="" method="post" >
<div><select name="your_project" class="form-control mselect" id="project"><?php
selectbox_project();
?>
<option value="other">Other</option></select></div>
<div class="<?php
echo $cls;
?>
topmargin" id="hidtext" ><input id="myproject" type="text" name="myproject" value="" <?php