|
Awesome!
As always, thank you very much Richard.
|
|
|
|
|
Hello,
i run a website with tables of diffrent contact numbers in the UK.Its a free project im working on. I have some issue with this table that wont go to the main DB and i cant find a way to control it...
I think the best way is just working with some tables plugin for WP?
Thank you
|
|
|
|
|
Member 12768096 wrote: I think the best way is just working with some tables plugin for WP?
So...is this a statement or a question?
Is WP short for WordPress, or some other acronym, or did you forget an F, or...?
We need information to give you any help.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
I have a page called MainPage which has a draggable object and an iframe. When the iframe loads it opens a page called TestPage which is in the same domain as MainPage.
The droppable area is in TestPage and when I drop an object into the iframe on MainPage I would like the object to appear on TestPage at the exact location it was dropped. Currently I am able to drag but not drop the object in the drop area.
Please see my markup and script here.
modified 28-Sep-16 19:42pm.
|
|
|
|
|
I have the following code:
$('#GetEmployee').click(function () {
var id = $('#employeeidget').val();
$.ajax({
url: 'http://localhost:56811/api/Values/Get?id=' + id,
type: 'GET',
dataType: 'jsonp',
success: function (data) {
var items = '';
$.each(data, function (i, item) {
var rows = "<tr>"
+ "<td>" + data.EmployeeID + "</td>"
+ "<td>" + data.Name + "</td>"
+ "<td>" + data.ManagerID + "</td>"
+ "</tr>";
$('#tblEmployee tbody').append(rows);
});
},
error: function (jqXHR, exception) {
if (jqXHR.status == 404) {
alert('Requested page not found. [404]');
} else if (jqXHR.status === 0) {
alert('Not connect.\n Verify Network.');
} else if (jqXHR.status == 500) {
alert('Internal Server Error [500].');
} else if (exception === 'parsererror') {
alert('Requested JSON parse failed.');
} else if (exception === 'timeout') {
alert('Time out error.');
} else if (exception === 'abort') {
alert('Ajax request aborted.');
} else {
alert('Uncaught Error.\n' + jqXHR.responseText);
}
}
});
I don't know what I am doing wrong but every time the ajax call is done it goes to error function
The error I am getting is jqXHR.status === 0 connect verify network. CORS is enabled in web.config file
modified 16-Sep-16 8:44am.
|
|
|
|
|
Member 8154845 wrote: CORS is enabled in web.config file
In which site? The one that's hosting your API, or the one where your code is running?
Member 8154845 wrote: dataType: 'jsonp',
Have you configured the JsonpMediaTypeFormatter, as described in this StackOverflow thread[^] and this tip[^]?
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
@Richardd Deeming
Thank you for the response. I have CORS enabled in API.
No, I did not have JsonpMediaTypeFormatter configured. Let me try configuring it.
|
|
|
|
|
What is jqXHR.responseText when the error occurs?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
>Hi,
I have a Oracle DB in which all the information is stored and this information is been consumed by different teams and below is the two options i have to decide on :
1. Write a Stored procedure and give the stored procedure to the respective teams and they can call the stored procedure.
2. Write a stored procedure wrap it as an API and expose the API, different team will call the API exposed and API will in turn hit the SP and return the response to the team.
Like to know what is the PRON and CRONS with these options and what is the best possible solution to go with.
Thanks
|
|
|
|
|
|
Java Lead wrote: 1. Write a Stored procedure and give the stored procedure to the respective teams and they can call the stored procedure.
Callers of the Stored Procedure will need direct access to the Oracle DB.
Java Lead wrote: 2. Write a stored procedure wrap it as an API and expose the API, different team will call the API exposed and API will in turn hit the SP and return the response to the team.
This gives you the most control over the situation and is likely to be the most secure.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
The second option is better than the first one if different teams are working.
|
|
|
|
|
I want to know what are the most sought after technologies for becoming a Full Stack Developer.
I am asking with respect to both, Open Source and Microsoft Stack.
|
|
|
|
|
FORTRAN with a dumb terminal front end.
But seriously, all you're going to get here is opinions. Why not go look up some statistics from survey firms, like Gartner?
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
Hi All,
I saw many posted and infact I worked on JSON based asp.net app which use to JSONSeralizecontents and then pass that data to WEB Services on same machine and then webervice creates objects of it and call an SP with parameters on SQL and the response back to UI. now that was fine until i was on intranet where the app was open with basic username and passowrd however
now I am looking for hosting this app on Internet / Cloud Machine on Amazon so my doubt is that is same Infrastructure still good since
1. I may be looking to get away with the webservice parts which reads json to create object and then use it to create SQL Command with parameters. I wish to get rid of this layer so that I can pass JSON to SQL and perform operation there itself.. or have a very light wrapper for this on web service so need suggestions on it
2. I may also be looking to secure the data which is over the internet. The app will be mainly used on PDA and Laptops Browsers so what is the best way to secure it (https, JWT or some other light weight mechanism).
Also I wish to have SSO enabled for my apps.
Kindly suggest.
cheers
varun sharma
|
|
|
|
|
So, your current application base uses username/password on an intranet, but is it leveraging Basic or Windows authentication? If you're on Windows then you're in luck, that same mechanism can work for an internet site and provide the SSO support that you're looking for.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
Thanks for your kind reply Nathan. I am yet to start development so I shared what I knew before hand with Asp.net + JSON and sql. Finally I am looking to deploy my app on Cloud (AWS or Azure or some other basic cloud so that my customers can use it from anywhere around the world with same performance and speed over the internet). I was initially looking at AJAX + JSON with ASP.NET on front end and oracle at bank end but now i have a SQL guy who can do it better.
I could either do JSON front end (with Ajax call with JSON data) -- webservice (convert JSON in .NET Object or Object) and call -- SQL Stored Proc with SQLCommend and Parameters
I am looking for a better way to do it since this design is almost 8 years old, toady we have latest and better techs which I may not be well aware of son kindly suggest.
cheers
varun sharma
|
|
|
|
|
COULD ANYBODY HELP IN MAKING A WEBSITE TO SELL CARS? I NEED A WEBSITE THAT CAN SEARCH AND LIST OUT DIFFERENT CARS WHICH THE USER WANTS AND DISPLAY IT?? REALLY URGENT.. COULD ANYBODY GIVE AN IDEA HOW TO DO IT OR GIVE ME THE FINAL RESULT SOMEHOW?? THANKS U
|
|
|
|
|
Hmmm.. do you really need to type with "all CAPS"? Adding the word "urgent" does not add value to your post, sometimes it's considered rude and nobody is interested in that. 
|
|
|
|
|
This site does not provide code to order. Nobody here is going to do your work for you, no matter how "urgent" you tell us it is, or how much you shout at us.
If you've taken on a project, but don't know where to start - ie: you've lied to your client - then you'll need to go to a site like freelancer.com and pay someone to do the job for you.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi,
In my project I am using mvc ajax form. we included js file. In that js file somebody written $.validator.unobtrusive.parse. The form id passing in parse is becoming undefined. because of this it's raising issue. how to resolve this issue
$.validator.unobtrusive.parse("#form");
this #form is becoming undefined at run time. any one help me to resolve this issue
|
|
|
|
|
Hi, I'm trying to write code with prepared stmt but only code is displayed. Anyone?
<?php
$con = new mysqli('localhost', 'root', 'cookie', 'homedb');
if ($con->connect_error)
{ echo 'Cannot Connect to mySQL: ', $con->connect_error(); }
else
{
if (isset($_POST['url']))
{
$stmt = $con->prepare('
SELECT url, username, password, purpose, emailused, date-time, count, saved
FROM emailtbl
WHERE url = ? ');
$stmt->bindValue(1, $_POST['url']);
$stmt->execute();
if ($row = $stmt->fetch())
{
echo '
<table class="emailResults">
<caption>
Email Activity for ', htmlspecialchars($_POST['url']), '
</caption>
<thead>
<tr>
<th scope="col">url</th>
<th scope="col">Username</th>
<th scope="col">Password</th>
<th scope="col">Purpose</th>
<th scope="col">E-Mail Used</th>
<th scope="col">date-time</th>
<th scope="col">count</th>
<th scope="col">Saved</th>
</tr>
</thead><tbody>';
do
{
echo '
<tr>';
foreach ($row as $value) echo '
<td>', $value, '</td>';
echo '
</tr>';
}
while ($row = $stmt->fetch());
echo '
</tbody></table>';
}
else echo '<div class="error">No Results Found</div>';
}
else echo '<div class="error">No valid "url" for Query</div>';
}
$stmt = $con->prepare('
UPDATE emailtbl
SET date-time=DATE();
count=count + 1'
WHERE url = ? ');
$stmt->bindParam(s, $_POST['url']);
$stmt->execute();
echo $stmt->error ? '
<div class="error">
url update query error: ' . $stmt->error . '
</div>
' : ( $stmt->affected_rows > 0 ? '
<div class="success">
Success! Updated ' . $stmt->affected_rows . ' records.
</div>
' : '
<div class="error">
FAILED! No records updated.
<div>
');
?>
</body></html>
|
|
|
|
|
I do not understand what you are saying. Please explain clearly what is happening and where you are stuck.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Hi, I'm trying for awhile to code up a MYSQLi dropdown from a database, select a field(url, formatted as "http://www.thisurl.com) and arrive at that destination. I've tried several forums re. compatability (connection/query/output etc..Problem is I blow up at the first query (see screen shot). It's like my PHP isn't working. If someone will advise of the PHP issue maybe I can work out the app code. Any volunteers? Thanks!
--------------------------------------------------------------------- 1
<!DOCTYPE html><html>.
<title>email visit info</title>
<head>
</head>
<BODY>
create and display dropdown from database, url selected provides needed username and password. clicking on selected takes the user(me) to that url<br>
<center>
<form id="testform" name="testform" action="" method="post" accept-charset="UTF-8">
<?php
echo "<center>";echo date('m/d/y');echo "</center>";
$con=mysqli_connect("localhost","root","cookie","homedb");
if(mysqli_errno($con))
{echo "Can't Connect to mySQL:".mysqli_connect_error();}
else
{echo "</br>";}
$id = ''; $url= ''; $username = ''; $password = ''; $purpose = '';
$emailused = ''; $date-time = ''; $count = ''; $saved = '';
echo "<select name= 'url'>";
echo '<option value="">'.' ---select email account ---'.'</option>';
$query = mysqli_query($con,"SELECT url FROM emailtbl");
$query_display = mysqli_query($con,"SELECT * FROM emailtbl");
while($row=mysqli_fetch_array($query))
{ echo "<option class=highlight value='". $row['url']."'>".$row['url']
.'</option>';}
echo '</select>';
?>
<input type="submit" name="submit" value="Submit"/>
</form>
{
$url = $_POST['url'];
// ----------------------- display the table ------------------------
echo '<tr>'.'<td>'.'<table border="1">'.'<tr>'.'
<td bgcolor="#ccffff">'.'url'.'</td>'.'
<td bgcolor="#ccffff">'.'username'.'</td>'.'
<td bgcolor="#ccffff">'.'password'.'</td>'.'
<td bgcolor="#ccffff">'.'purpose'.'</td>'.'
<td bgcolor="#ccffff">'.'emailused'.'</td>'.'
<td bgcolor="#FFD47F">'.'date-time'.'</td>'.'
<td bgcolor="#FFD47F">'.'count'.'</td>'.'
<td bgcolor="#ccffff">'.'saved'.'</td>'.'</tr>';
// while($data = mysqli_fetch_row($fetch))
while($data=mysqli_fetch_row($result))
{
echo ("<tr>
<td>$data[0]</td><td>$data[1]</td><td>$data[2]</td>
<td>$data[3]</td><td>$data[4]</td><td>$data[5]</td>
<td>$data[6]</td><td>$data[7]</td>
</tr>");
}
echo '</table>'.'</td>'.'</tr>'.'</table>';
mysqli_query($con,"UPDATE emailtbl SET
date-time = 'DATE()'; count = 'count + 1';
WHERE url=$url");
?>
</center></body></html>
------------------------------------------------------------------------
2
<?php
echo "<center>";echo date('m/d/y');echo "</center>";
$con=mysqli_connect("localhost","root","cookie","homedb");
if(mysqli_errno($con))
{echo "Can't Connect to mySQL:".mysqli_connect_error();}
else
{echo "</br>";}
$id = ''; $url= ''; $username = ''; $password = ''; $purpose = '';
$emailused = ''; $date-time = ''; $count = ''; $saved = '';
echo "<select name= 'url'>";
echo '<option value="">'.' ---select email account ---'.'</option>';
$query = mysqli_query($con,"SELECT url FROM emailtbl");
$query_display = mysqli_query($con,"SELECT * FROM emailtbl");
while($row=mysqli_fetch_array($query))
{ echo "<option class=highlight value='". $row['url']."'>".$row['url']
.'</option>';}
echo '</select>';
?>
<input type="submit" name="submit" value="Submit"/>
</form>
{
// ----------------------- display the table ------------------------
echo '<tr>'.'<td>'.'<table border="1">'.'<tr>'.'
// ======================anchor attempt=========================
// echo "<a href='".$row['url']."'>".$row['url']."</a>";
// ==========================================================
<td bgcolor="#ccffff">'.'username'.'</td>'.'
<td bgcolor="#ccffff">'.'password'.'</td>'.'
<td bgcolor="#ccffff">'.'purpose'.'</td>'.'
<td bgcolor="#ccffff">'.'emailused'.'</td>'.'
<td bgcolor="#FFD47F">'.'date-time'.'</td>'.'
<td bgcolor="#FFD47F">'.'count'.'</td>'.'
<td bgcolor="#ccffff">'.'saved'.'</td>'.'</tr>';
// while($data = mysqli_fetch_row($fetch))
while($data=mysqli_fetch_row($result))
{
echo ("<tr>
<td>$data[0]</td><td>$data[1]</td><td>$data[2]</td>
<td>$data[3]</td><td>$data[4]</td><td>$data[5]</td>
<td>$data[6]</td><td>$data[7]</td>
</tr>");
}
echo '</table>'.'</td>'.'</tr>'.'</table>';
mysqli_query($con,"UPDATE emailtbl SET
date-time = 'DATE()'; count = 'count + 1';
WHERE url=$url");
?>
</center></body></html>
-----------------------------------------------
3
<!DOCTYPE html><html>
<head>
<title>test 3</title>
</head>
<body><center>
<form id="testform" name="testform" action="" method="post" accept-charset="UTF-8">
<table border=1 cellpadding=2 cellspacing=2 bgcolor="#D4FFAA">
<tr>
<th>url</th><th>username</th><th>password</th><th>purpose</th>
<th>emailused</th><th>date-time</th><th>count</th><th>saved</th>
</tr>
<?php
$connect=mysql_connect("localhost", "root", "cookie") or die("error");
mysql_select_db("homedb", $connect);
$sql="SELECT * from emailtbl";
$result=mysql_query($sql, $connect);
$url='';;
while($res=mysql_fetch_assoc($result))
{
echo "<tr>";
echo "<td>"; echo '<input type="radio" name="url" >'; echo "</td>";
echo "<td>"; echo $res['username']>'; echo "</td>";
echo "<td>"; echo $res['password']; echo "</td>";
echo "<td>"; echo $res['purpose']; echo "</td>";
echo "<td>"; echo $res['emailused']; echo "</td>";
echo "<td>"; echo $res['date-time']; echo "</td>";
echo "<td>"; echo $res['count']; echo "</td>";
echo "<td>"; echo $res['saved']; echo "</td>";
echo "</tr>";
}
?>
</table> </form></body></html>
--------------------------------------------------------
modified 19-Aug-16 9:24am.
|
|
|
|
|
You haven't told us what the error message is, or included a link to the screenshot that you mentioned.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
