php - INSERT value from another table and variable -


i wondering if possible insert table (which have managed do) whilst inserting value of variable current php file?

i aiming user id table, have gotten selecting email user input. need insert hash automatically created via variable.

this current code gets correct id users table.

$forgot = $pdo->prepare("                         insert                           forgot (                               user_id                           ) select                               id                                                         users                                                         email = :email ");

now need insert value of :hash too.

would need done separate query?

thanks.

try following:

insert forgot (     user_id, hash ) select     id, :hash     users     email = :email

-

Comments

Post a Comment

Popular posts from this blog

php - Displaying JSON data posts for blog using just the post id -

i have page named 'posts_list.php' containing list of blog posts retrieved form json api have id, title, image etc . have link on page goes page called 'post.php' below: <a href="post.php?id=<?php echo $post->id ?> "> using method can retrieve 'id' of post clicked user using: <?php $postid = $_get['id']; ?> what want display json post on post.php corresponds id retrieved link on posts_list.php i know sql use clause, being new json im not sure if possible. need achieve php , json it has info /v1/blogs/@blog/@id @blog - blog identifier @id - blog post id
Read more

docusignapi - Documents restrictions within a package -

i have looked through docusign documentation, stackoverflow , google without success. when creating package, possible restrict signers able view pages of document ? let's borrower lisa smith should not allowed see pages 5 10 while second borrower can allowed see pages 1 5, possible within rest api ? thanks you can use docusign document visibility feature. if send document containing multiple files , want control files each recipient sees, can use document visibility accomplish this. common scenario want recipients see files need sign. document visibility, can create 1 document files intended individual recipients, rather having create separate document each recipient. using document visibility can set access @ document level. setting access @ page level not supported. see answer on how set documentvisibility using rest api. for more context, excludeddocuments property on page .
Read more

javascript - angular.forEach loop with $http.get -

i want create array containing objects firstly, first array server containing list of devices [ {accountid : "sysadmin",deviceid : "123"}, {accountid : "sysadmin",deviceid : "3"} ... ] then create second array containing objects each object represent device(deviceid) , contains array of events of device server i loop upon first array : $scope.myarrayofdevices = []; angular.foreach(response, function(device){ $scope.myobject={}; $scope.myobject.device = device.deviceid; $http.get('events') .success(function (data) { $scope.myobject.events = data; }); $scope.myarrayofdevices.push($scope.myobject); });//end loop i events data server correctly . but, when check $scope.myarrayofdevices array first object deviceid , no event array , second object deviceid , events array correctly like : [ {deviceid : 123, events:}, {deviceid : 3 , events : array...
Read more