Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save pipiscrew/8a74d98f183c6ce0fc0d to your computer and use it in GitHub Desktop.
Save pipiscrew/8a74d98f183c6ce0fc0d to your computer and use it in GitHub Desktop.
[php+js] pass PHP mySQL recordset to Javascript
<?php
session_start();
if (!isset($_SESSION["x"])) {
header("Location: index.html");
exit ;
}
if (isset($_GET["id"])) {
include ('config.php');
$conn = connect();
$stmt = $conn->prepare('SELECT * FROM mattel_companies WHERE companyid = ?');
$stmt->bind_param('s', $_GET["id"]);
$stmt->execute();
$result = $stmt->get_result();
$row=$result->fetch_assoc();
$stmt->close();
}
?>
<script type="text/javascript">
var jArray= <?php echo json_encode($row); ?>;
if (jArray)
{
// console.log(jArray);
$('[name=mattel_companiesFORM_updateID]').val(jArray["companyid"]);
$('[name=comp_title]').val(jArray["comp_title"]);
$('[name=comp_name]').val(jArray["comp_name"]);
$('[name=cmp_password]').val(jArray["cmp_password"]);
$('[name=page_editor]').val(jArray["page_editor"]);
$('[name=admin_name]').val(jArray["admin_name"]);
$('[name=comp_address]').val(jArray["comp_address"]);
}
</script>
<form id="formmattel_companiesFORM" role="form" method="post">
<form role="form">
<div class="row">
<div class="col-xs-6 col-md-4">
<div class='form-group'>
<label>Title :</label>
<input name='comp_title' class='form-control' placeholder='Title'>
</div>
</div>
<div class="col-xs-6 col-md-4">
<div class='form-group'>
<label>Name :</label>
<input name='comp_name' class='form-control' placeholder='Name'>
</div>
</div>
<div class="col-xs-6 col-md-4">
<div class='form-group'>
<label>Password :</label>
<input name='cmp_password' class='form-control' placeholder='Password'>
</div>
</div>
</div>
<div class="row">
<div class="col-xs-6 col-md-4">
<div class='form-group'>
<label>Editor :</label>
<input name='page_editor' class='form-control' placeholder='Editor'>
</div>
</div>
<div class="col-xs-6 col-md-4">
<div class='form-group'>
<label>Admin :</label>
<input name='admin_name' class='form-control' placeholder='Admin'>
</div>
</div>
<div class="col-xs-6 col-md-4">
<div class='form-group'>
<label>Address :</label>
<input name='comp_address' class='form-control' placeholder='Address'>
</div>
</div>
</div>
<input name="mattel_companiesFORM_updateID" class="form-control" style="display:none;">
</div>
<button id="bntCancel_mattel_companiesFORM" type="button" class="btn btn-default" data-dismiss="modal">
cancel
</button>
<button id="bntSave_mattel_companiesFORM" class="btn btn-primary" type="submit" name="submit">
save
</button>
</form>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment