| var sql = "SELECT * from addresses";
new Promise(function (resolve, reject) {
JwApp.db.executeSql(sql, [], function (resultSet) {
console.log('Length: '+resultSet.rows.length);
for(var i = 0; i < resultSet.rows.length; i++) {
results[resultSet.rows.item(i).id] = resultSet.rows.item(i);
}
console.log(results);
resolve(results);
}, function(error) {
console.log('SELECT error: ' + error.message);
reject(error.message);
})
})
.then(function (res) {
console.log('Execuited Then');
console.log(res);
})
.catch(function (res) {
console.log('Execuited Then Reject');
console.log('SQL error: '+res);
});
|
Expand
Collapse
(25 lines)
https://snipt.net/embed/b8f84e331691e27497e9da6248bc4b86/
/raw/b8f84e331691e27497e9da6248bc4b86/
b8f84e331691e27497e9da6248bc4b86
text
Text only
25
2025-04-04T11:37:10
True
False
False
/api/public/snipt/147698/
javascript-promise
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a>
<a href="#L-2"> 2</a>
<a href="#L-3"> 3</a>
<a href="#L-4"> 4</a>
<a href="#L-5"> 5</a>
<a href="#L-6"> 6</a>
<a href="#L-7"> 7</a>
<a href="#L-8"> 8</a>
<a href="#L-9"> 9</a>
<a href="#L-10">10</a>
<a href="#L-11">11</a>
<a href="#L-12">12</a>
<a href="#L-13">13</a>
<a href="#L-14">14</a>
<a href="#L-15">15</a>
<a href="#L-16">16</a>
<a href="#L-17">17</a>
<a href="#L-18">18</a>
<a href="#L-19">19</a>
<a href="#L-20">20</a>
<a href="#L-21">21</a>
<a href="#L-22">22</a>
<a href="#L-23">23</a>
<a href="#L-24">24</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a> var sql = "SELECT * from addresses";
</span><span id="L-2"><a name="L-2"></a> new Promise(function (resolve, reject) {
</span><span id="L-3"><a name="L-3"></a> JwApp.db.executeSql(sql, [], function (resultSet) {
</span><span id="L-4"><a name="L-4"></a> console.log('Length: '+resultSet.rows.length);
</span><span id="L-5"><a name="L-5"></a>
</span><span id="L-6"><a name="L-6"></a> for(var i = 0; i < resultSet.rows.length; i++) {
</span><span id="L-7"><a name="L-7"></a> results[resultSet.rows.item(i).id] = resultSet.rows.item(i);
</span><span id="L-8"><a name="L-8"></a> }
</span><span id="L-9"><a name="L-9"></a>
</span><span id="L-10"><a name="L-10"></a> console.log(results);
</span><span id="L-11"><a name="L-11"></a> resolve(results);
</span><span id="L-12"><a name="L-12"></a> }, function(error) {
</span><span id="L-13"><a name="L-13"></a> console.log('SELECT error: ' + error.message);
</span><span id="L-14"><a name="L-14"></a> reject(error.message);
</span><span id="L-15"><a name="L-15"></a> })
</span><span id="L-16"><a name="L-16"></a> })
</span><span id="L-17"><a name="L-17"></a> .then(function (res) {
</span><span id="L-18"><a name="L-18"></a> console.log('Execuited Then');
</span><span id="L-19"><a name="L-19"></a> console.log(res);
</span><span id="L-20"><a name="L-20"></a> })
</span><span id="L-21"><a name="L-21"></a> .catch(function (res) {
</span><span id="L-22"><a name="L-22"></a> console.log('Execuited Then Reject');
</span><span id="L-23"><a name="L-23"></a> console.log('SQL error: '+res);
</span><span id="L-24"><a name="L-24"></a> });
</span></pre></div>
</td></tr></table>
angular, ionic, javascript
| var sql = "SELECT id FROM streets WHERE territory_id = ? AND md5checksum = ?"
JwApp.db.executeSql(sql, [JwApp.working_territory, street_md5], function (resultSet) {
if (resultSet.rows.length) {
street_id = resultSet.rows.item(0).id;
for(var i = 0; i < resultSet.rows.length; i++) {
results[resultSet.rows.item(i).id] = resultSet.rows.item(i);
}
}
else {
console.log('No records returned.');
}
},
function (error) {
console.log('SELECT Street error: ' + error.message);
});
|
Expand
Collapse
(17 lines)
https://snipt.net/embed/c4d85f21d90fd616c1a8497c99c86115/
/raw/c4d85f21d90fd616c1a8497c99c86115/
c4d85f21d90fd616c1a8497c99c86115
text
Text only
17
2025-04-04T11:37:09
True
False
False
Sep 04, 2016 at 11:25 PM
/api/public/snipt/147697/
execute-db
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a>
<a href="#L-2"> 2</a>
<a href="#L-3"> 3</a>
<a href="#L-4"> 4</a>
<a href="#L-5"> 5</a>
<a href="#L-6"> 6</a>
<a href="#L-7"> 7</a>
<a href="#L-8"> 8</a>
<a href="#L-9"> 9</a>
<a href="#L-10">10</a>
<a href="#L-11">11</a>
<a href="#L-12">12</a>
<a href="#L-13">13</a>
<a href="#L-14">14</a>
<a href="#L-15">15</a>
<a href="#L-16">16</a>
<a href="#L-17">17</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a> var sql = "SELECT id FROM streets WHERE territory_id = ? AND md5checksum = ?"
</span><span id="L-2"><a name="L-2"></a> JwApp.db.executeSql(sql, [JwApp.working_territory, street_md5], function (resultSet) {
</span><span id="L-3"><a name="L-3"></a> if (resultSet.rows.length) {
</span><span id="L-4"><a name="L-4"></a> street_id = resultSet.rows.item(0).id;
</span><span id="L-5"><a name="L-5"></a>
</span><span id="L-6"><a name="L-6"></a> for(var i = 0; i < resultSet.rows.length; i++) {
</span><span id="L-7"><a name="L-7"></a> results[resultSet.rows.item(i).id] = resultSet.rows.item(i);
</span><span id="L-8"><a name="L-8"></a> }
</span><span id="L-9"><a name="L-9"></a>
</span><span id="L-10"><a name="L-10"></a> }
</span><span id="L-11"><a name="L-11"></a> else {
</span><span id="L-12"><a name="L-12"></a> console.log('No records returned.');
</span><span id="L-13"><a name="L-13"></a> }
</span><span id="L-14"><a name="L-14"></a> },
</span><span id="L-15"><a name="L-15"></a> function (error) {
</span><span id="L-16"><a name="L-16"></a> console.log('SELECT Street error: ' + error.message);
</span><span id="L-17"><a name="L-17"></a> });
</span></pre></div>
</td></tr></table>
angular, ionic
| <select ng-model="contact.reason"
ng-options="reason as reason.name for reason in reasons track by reason.id"
name="reason"
required>
</select>
<select ng-model="application.requested_loan_amount"
ng-options="item.value as item.label for item in requested_loan_amounts"
name="requested_loan_amount"
required>
</select>
|
Expand
Collapse
(12 lines)
https://snipt.net/embed/34b59817d93f881818f3912103bc497d/
/raw/34b59817d93f881818f3912103bc497d/
34b59817d93f881818f3912103bc497d
text
Text only
12
2025-04-03T00:41:56
True
False
False
/api/public/snipt/147297/
ng-options
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a>
<a href="#L-2"> 2</a>
<a href="#L-3"> 3</a>
<a href="#L-4"> 4</a>
<a href="#L-5"> 5</a>
<a href="#L-6"> 6</a>
<a href="#L-7"> 7</a>
<a href="#L-8"> 8</a>
<a href="#L-9"> 9</a>
<a href="#L-10">10</a>
<a href="#L-11">11</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><select ng-model="contact.reason"
</span><span id="L-2"><a name="L-2"></a> ng-options="reason as reason.name for reason in reasons track by reason.id"
</span><span id="L-3"><a name="L-3"></a> name="reason"
</span><span id="L-4"><a name="L-4"></a> required>
</span><span id="L-5"><a name="L-5"></a> </select>
</span><span id="L-6"><a name="L-6"></a>
</span><span id="L-7"><a name="L-7"></a> <select ng-model="application.requested_loan_amount"
</span><span id="L-8"><a name="L-8"></a> ng-options="item.value as item.label for item in requested_loan_amounts"
</span><span id="L-9"><a name="L-9"></a> name="requested_loan_amount"
</span><span id="L-10"><a name="L-10"></a> required>
</span><span id="L-11"><a name="L-11"></a> </select>
</span></pre></div>
</td></tr></table>
angular, ionic
https://snipt.net/embed/522d98c8977fbab70f716adfe325bdfd/
/raw/522d98c8977fbab70f716adfe325bdfd/
522d98c8977fbab70f716adfe325bdfd
text
Text only
1
2025-03-28T13:59:24
True
False
False
Jun 27, 2016 at 08:57 PM
/api/public/snipt/147293/
ionic-link
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><a href="#/app/privacy">
</span></pre></div>
</td></tr></table>
angular, ionic
| <ion-view title="Contact">
<ion-content class="has-header padding">
<div class="bar bar-positive" style="margin-bottom: 8px; position: relative;" ng-show="result">{{result}}</div>
<form ng-submit="sendContact()">
<div class="list">
<label class="item item-input item-stacked-label">
<span class="input-label">First Name</span>
<input type="text" ng-model="contact.first_name" placeholder="Enter First Name">
</label>
<label class="item item-input item-stacked-label">
<span class="input-label">Last Name</span>
<input type="text" ng-model="contact.last_name" placeholder="Enter Last Name">
</label>
<label class="item item-input item-stacked-label">
<span class="input-label">Phone #</span>
<input type="text" ng-model="contact.phone" placeholder="Enter Phone Number">
</label>
<label class="item item-input item-stacked-label">
<span class="input-label">Email</span>
<input type="text" ng-model="contact.email" placeholder="Enter Email">
</label>
<label class="item item-input item-stacked-label item-select">
<select ng-model="contact.reason"
ng-init="contact.reason = reasons[0]"
ng-options="reason as reason.name for reason in reasons track by reason.id">
</select>
</label>
<label class="item item-input item-stacked-label">
<span class="input-label">Message</span>
<input type="text" ng-model="contact.message" placeholder="Enter any comments">
</label>
<padding>
<button class="button button-balanced button-block" ng-disabled="!contact.email || !contact.first_name || !contact.last_name">
Send
</button>
</padding>
</div>
</form>
</ion-content>
</ion-view>
|
Expand
Collapse
(41 lines)
https://snipt.net/embed/2480bde8e5183790a188d09a20f0be71/
/raw/2480bde8e5183790a188d09a20f0be71/
2480bde8e5183790a188d09a20f0be71
text
Text only
41
2025-04-04T11:37:09
True
False
False
/api/public/snipt/146988/
angular-contact-form
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a>
<a href="#L-2"> 2</a>
<a href="#L-3"> 3</a>
<a href="#L-4"> 4</a>
<a href="#L-5"> 5</a>
<a href="#L-6"> 6</a>
<a href="#L-7"> 7</a>
<a href="#L-8"> 8</a>
<a href="#L-9"> 9</a>
<a href="#L-10">10</a>
<a href="#L-11">11</a>
<a href="#L-12">12</a>
<a href="#L-13">13</a>
<a href="#L-14">14</a>
<a href="#L-15">15</a>
<a href="#L-16">16</a>
<a href="#L-17">17</a>
<a href="#L-18">18</a>
<a href="#L-19">19</a>
<a href="#L-20">20</a>
<a href="#L-21">21</a>
<a href="#L-22">22</a>
<a href="#L-23">23</a>
<a href="#L-24">24</a>
<a href="#L-25">25</a>
<a href="#L-26">26</a>
<a href="#L-27">27</a>
<a href="#L-28">28</a>
<a href="#L-29">29</a>
<a href="#L-30">30</a>
<a href="#L-31">31</a>
<a href="#L-32">32</a>
<a href="#L-33">33</a>
<a href="#L-34">34</a>
<a href="#L-35">35</a>
<a href="#L-36">36</a>
<a href="#L-37">37</a>
<a href="#L-38">38</a>
<a href="#L-39">39</a>
<a href="#L-40">40</a>
<a href="#L-41">41</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><ion-view title="Contact">
</span><span id="L-2"><a name="L-2"></a>
</span><span id="L-3"><a name="L-3"></a> <ion-content class="has-header padding">
</span><span id="L-4"><a name="L-4"></a> <div class="bar bar-positive" style="margin-bottom: 8px; position: relative;" ng-show="result">{{result}}</div>
</span><span id="L-5"><a name="L-5"></a> <form ng-submit="sendContact()">
</span><span id="L-6"><a name="L-6"></a> <div class="list">
</span><span id="L-7"><a name="L-7"></a> <label class="item item-input item-stacked-label">
</span><span id="L-8"><a name="L-8"></a> <span class="input-label">First Name</span>
</span><span id="L-9"><a name="L-9"></a> <input type="text" ng-model="contact.first_name" placeholder="Enter First Name">
</span><span id="L-10"><a name="L-10"></a> </label>
</span><span id="L-11"><a name="L-11"></a> <label class="item item-input item-stacked-label">
</span><span id="L-12"><a name="L-12"></a> <span class="input-label">Last Name</span>
</span><span id="L-13"><a name="L-13"></a> <input type="text" ng-model="contact.last_name" placeholder="Enter Last Name">
</span><span id="L-14"><a name="L-14"></a> </label>
</span><span id="L-15"><a name="L-15"></a> <label class="item item-input item-stacked-label">
</span><span id="L-16"><a name="L-16"></a> <span class="input-label">Phone #</span>
</span><span id="L-17"><a name="L-17"></a> <input type="text" ng-model="contact.phone" placeholder="Enter Phone Number">
</span><span id="L-18"><a name="L-18"></a> </label>
</span><span id="L-19"><a name="L-19"></a> <label class="item item-input item-stacked-label">
</span><span id="L-20"><a name="L-20"></a> <span class="input-label">Email</span>
</span><span id="L-21"><a name="L-21"></a> <input type="text" ng-model="contact.email" placeholder="Enter Email">
</span><span id="L-22"><a name="L-22"></a> </label>
</span><span id="L-23"><a name="L-23"></a> <label class="item item-input item-stacked-label item-select">
</span><span id="L-24"><a name="L-24"></a> <select ng-model="contact.reason"
</span><span id="L-25"><a name="L-25"></a> ng-init="contact.reason = reasons[0]"
</span><span id="L-26"><a name="L-26"></a> ng-options="reason as reason.name for reason in reasons track by reason.id">
</span><span id="L-27"><a name="L-27"></a> </select>
</span><span id="L-28"><a name="L-28"></a> </label>
</span><span id="L-29"><a name="L-29"></a> <label class="item item-input item-stacked-label">
</span><span id="L-30"><a name="L-30"></a> <span class="input-label">Message</span>
</span><span id="L-31"><a name="L-31"></a> <input type="text" ng-model="contact.message" placeholder="Enter any comments">
</span><span id="L-32"><a name="L-32"></a> </label>
</span><span id="L-33"><a name="L-33"></a> <padding>
</span><span id="L-34"><a name="L-34"></a> <button class="button button-balanced button-block" ng-disabled="!contact.email || !contact.first_name || !contact.last_name">
</span><span id="L-35"><a name="L-35"></a> Send
</span><span id="L-36"><a name="L-36"></a> </button>
</span><span id="L-37"><a name="L-37"></a> </padding>
</span><span id="L-38"><a name="L-38"></a> </div>
</span><span id="L-39"><a name="L-39"></a> </form>
</span><span id="L-40"><a name="L-40"></a> </ion-content>
</span><span id="L-41"><a name="L-41"></a></ion-view>
</span></pre></div>
</td></tr></table>
angular, ionic
| $scope.sendContact = function() {
var contact_data = {
first_name: this.contact.first_name,
last_name: this.contact.last_name,
phone: this.contact.phone,
email: this.contact.email,
message: this.contact.message,
reason: this.contact.reason.id
};
$http({
method : "POST",
url: apiDomain + contentPath + "contact.php",
data: contact_data
}).then(function mySucces(response) {
$scope.result = response.data;
}, function myError(response) {
alert(response.statusText);
});
}
|
Expand
Collapse
(23 lines)
https://snipt.net/embed/f86ea718d6895d3cb5ebf278733f2fe3/
/raw/f86ea718d6895d3cb5ebf278733f2fe3/
f86ea718d6895d3cb5ebf278733f2fe3
text
Text only
23
2025-04-04T11:35:19
True
False
False
Jun 27, 2016 at 08:59 PM
/api/public/snipt/146986/
angular-contact-form-processing
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a>
<a href="#L-2"> 2</a>
<a href="#L-3"> 3</a>
<a href="#L-4"> 4</a>
<a href="#L-5"> 5</a>
<a href="#L-6"> 6</a>
<a href="#L-7"> 7</a>
<a href="#L-8"> 8</a>
<a href="#L-9"> 9</a>
<a href="#L-10">10</a>
<a href="#L-11">11</a>
<a href="#L-12">12</a>
<a href="#L-13">13</a>
<a href="#L-14">14</a>
<a href="#L-15">15</a>
<a href="#L-16">16</a>
<a href="#L-17">17</a>
<a href="#L-18">18</a>
<a href="#L-19">19</a>
<a href="#L-20">20</a>
<a href="#L-21">21</a>
<a href="#L-22">22</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a> $scope.sendContact = function() {
</span><span id="L-2"><a name="L-2"></a>
</span><span id="L-3"><a name="L-3"></a> var contact_data = {
</span><span id="L-4"><a name="L-4"></a> first_name: this.contact.first_name,
</span><span id="L-5"><a name="L-5"></a> last_name: this.contact.last_name,
</span><span id="L-6"><a name="L-6"></a> phone: this.contact.phone,
</span><span id="L-7"><a name="L-7"></a> email: this.contact.email,
</span><span id="L-8"><a name="L-8"></a> message: this.contact.message,
</span><span id="L-9"><a name="L-9"></a> reason: this.contact.reason.id
</span><span id="L-10"><a name="L-10"></a> };
</span><span id="L-11"><a name="L-11"></a>
</span><span id="L-12"><a name="L-12"></a> $http({
</span><span id="L-13"><a name="L-13"></a> method : "POST",
</span><span id="L-14"><a name="L-14"></a> url: apiDomain + contentPath + "contact.php",
</span><span id="L-15"><a name="L-15"></a> data: contact_data
</span><span id="L-16"><a name="L-16"></a> }).then(function mySucces(response) {
</span><span id="L-17"><a name="L-17"></a> $scope.result = response.data;
</span><span id="L-18"><a name="L-18"></a>
</span><span id="L-19"><a name="L-19"></a> }, function myError(response) {
</span><span id="L-20"><a name="L-20"></a> alert(response.statusText);
</span><span id="L-21"><a name="L-21"></a> });
</span><span id="L-22"><a name="L-22"></a> }
</span></pre></div>
</td></tr></table>
angular, ionic
| $headers = apache_request_headers();
if (empty($headers['Content-Length'])) exit;
$input = file_get_contents('php://input');
$post_object = json_decode($input);
|
https://snipt.net/embed/025b58161eb18a6417782d4d290f23a4/
/raw/025b58161eb18a6417782d4d290f23a4/
025b58161eb18a6417782d4d290f23a4
text
Text only
6
2025-04-04T11:35:19
True
False
False
/api/public/snipt/146985/
angular-ajax-post-to-php
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a>
<a href="#L-2">2</a>
<a href="#L-3">3</a>
<a href="#L-4">4</a>
<a href="#L-5">5</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>$headers = apache_request_headers();
</span><span id="L-2"><a name="L-2"></a>if (empty($headers['Content-Length'])) exit;
</span><span id="L-3"><a name="L-3"></a>
</span><span id="L-4"><a name="L-4"></a>$input = file_get_contents('php://input');
</span><span id="L-5"><a name="L-5"></a>$post_object = json_decode($input);
</span></pre></div>
</td></tr></table>
angular, ionic