$value ='1'; $stmt = $link->prepare("SELECT id FROM " . $db_prefix . "test WHERE id = ?"); $stmt->bind_param('i', $value); if($stmt->execute()) { $result = $stmt->get_result(); while ($row = $result->fetch_assoc()) { } }
$value ='1'; $stmt = $link->prepare("SELECT id FROM " . $db_prefix . "test WHERE id = ?"); $stmt->bind_param('i', $value); if($stmt->execute()) { $result = $stmt->get_result(); while ($row = $result->fetch_assoc()) { } }
$query = "INSERT INTO '". $db_prefix ."'modules (`name`, `description`, `number`, `file_start`, `position`, `active`, `dateAdd`) VALUES (?,?,?,?,?,?,?)"; $stmt = $link->prepare($query); $stmt->bind_param("ssisiss", $name, $description, $name, $number, $start_file, $active, $today); /* Execute the statement */ $stmt->execute();
$query = "INSERT INTO " . $db_prefix . "modules (`id`,`name`, `description`, `number`, `file_start`, `position`, `active`, `dateAdd`) VALUES ('',?,?,?,?,?,?,?)"; $stmt = $link->prepare($query); $stmt->bind_param("ssisiss", $name, $description, $name, $number, $start_file, $active, $today); /* Execute the statement */ $stmt->execute();
<div class="form-group"> <label for="ActiveModule">Aktywny</label> <div class="checkbox"> <label><input name="active" type="radio" value="1" id='ActiveModule' required>TAK</label> <label><input name="active" type="radio" value="0" checked>NIE</label> </div> </div>
$query = "SELECT `number` FROM `" . $db_prefix . "modules` WHERE `number` = ? ";
$query = "SELECT `number` FROM`" . $db_prefix . "modules` WHERE `number` = ? ";
"INSERT INTO "
"INSERT INTO"