PHP - Php Side Of A Ajax Request.

Hello forum,   So I've been developing an app mostly in PHP, but am rather afraid of JS. Hope to fix that.   I have an AJAX dropdown using JQuery to search locations. It works great. However, I want to make it similar to what is seen on this site:   http://placefinder.com/   As you can see, the dropdown, when clicked populates a box. Then the user submits the form and the data is used in the application.   I have no clue how to make the form populate with data from the DB (I'm using mySQL) when clicked. So far, I've only been able to make it clickable as a URL (not what I want, obvioiusly!)   Is there a way to do this on a really small, simple script for starters? I'm certain their is, but don't even know where to begin.   Any help appreciated

Hello I am using JSONP as dataType on my AJAX, but there's  an incident that a Transaction was successfully complete but a PHP error text occured while trying pass the data.   E.g.

SMTP Error: Data not accepted.
Unable to send Mail: SMTP Error: Data not accepted.<p>SMTP server error: Requested action aborted: This mail account has sent too many messages in a short amount of time. Please try later.
</p>

jQuery111001592713373247534_1407318091484({"result":11308,"err":"no"})

There was an unexpected error happen, SMTP Error. So in my javascript  jquery ajax the response will go to 

.error(function(xhr,status,error){
 console.log(xhr);
});

But the thing here is that the transaction  was successfully complete. So how do I tell the to the client side about the transaction process and the error happen? 

Doing something wrong, but don't see it.  How should one retrieve a POST parameter?  My $request->toArray()['html'] works, but I am sure it is not the "right way".

<?php
namespace App\DataPersister;
use ApiPlatform\Core\DataPersister\DataPersisterInterface;
use Symfony\Component\HttpFoundation\RequestStack;

class ArchivePersister implements DataPersisterInterface
{
    public function __construct(RequestStack $requestStack)
    {
        $request = $requestStack->getCurrentRequest();
        syslog(LOG_ERR, '$request->getMethod(): '.$request->getMethod());
        syslog(LOG_ERR, '$request->getContent(): '.$request->getContent());
        syslog(LOG_ERR, '$request->request->get(html): '.$request->request->get('html'));
        syslog(LOG_ERR, '$request->query->get(html): '.$request->query->get('html'));
        syslog(LOG_ERR, '$request->get(html): '.$request->get('html'));
        syslog(LOG_ERR, '$request->toArray(): '.json_encode($request->toArray()));
        syslog(LOG_ERR, '$request->toArray()[html]: '.$request->toArray()['html']);
    }
}

output

$request->getMethod(): POST
$request->getContent(): {"project":"/projects/1","description":"","html":"<p>{{ project_name }}</p>"}
$request->request->get(html):
$request->query->get(html):
$request->get(html):
$request->toArray(): {"project":"\/projects\/1","description":"","html":"<p>{{ project_name }}<\/p>"}
$request->toArray()[html]: <p>{{ project_name }}</p>

  I’m trying to write a post-panel where the user can see the preview of his post to the right of the
text area he’s writing into.
  I tried the following into a file called writepost.php :
 

<?php

$text=(isset($_GET['message']))?$_GET['message']:'';
$formatted_text=nl2br(stripslashes(htmlspecialchars($text)));

echo '<form method="post" action="proceedtopost.php?>'.
'<table>'.
'<td style width="50%"><tr>'.
'<fieldset> Write your post here : <br> <textarea cols="50" rows="12" '.
'id="message" name="message">'.$text.'</textarea>'.
'</fieldset> <p> '.
'<input type="submit" name="submit" formaction="writepost.php" value="Preview" /> '.
'<input type="submit" name="submit" value="Sent" /> '.
'</p>'.
'</td>'.
'<td>'.
'<fieldset> Your post will appear as follows :<br><p> '.
$formatted_text.
'</fieldset>'.
'</td></tr>'.
'</table>'.
'</form>';

There are several things wrong with this code :

  1) When the user hits the "Preview" button, I expect writepost.php to be reloaded (this is what happens), and the current content of the textarea to be stored in $_GET['message'] (this is not what happens).

  2) Why does my browser output the preview part under the text area (or in other words outputs the HTML table as a single column of two cells), when I insist in my HTML code for the table to be displayed  as a single row ?
 

I have a web portal which is scripted using client side scripting language i.e HTML. I want to create a login page in .php and want the other pages to be in .hmtl.
Can i do so?
I want to do this because i want the login password to be stored in a database. Also I want the password to get encrypted (by either MD5 javascript or OpenSSL ) when user enters it inside the login form.

I cannot create the entire portal in php because my portal makes use of C code. And php doesn't have an interface with C language.

Can a user get directed to a .html page after a secure login from login.php page ?
My main aim is to secure the access to my web portal using a password.

I tried to authenticate the login using javascript where the password was stored in an array. But i feel any one having moderate knowledge can easily break that password.

Any help would be greatly appreciated!!

need a little help guys! I use the script below to display profile images, trouble is it shows 1 on top of the other, and i need it to double up 2 profile images on top of 2 profile images ect any ideas how i can do this. 



require("./include/mysqldb.php");

$con = mysql_connect("$dbhost","$dbuser","$dbpass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("$dbame", $con);
$result = mysql_query("SELECT * FROM Search_profiles_up WHERE upgrade_one ='1' ORDER BY RAND() LIMIT 40");


print "<table width=\"293\" height=\"111\" border=\"0\">
  <tr>\n";

while($row = mysql_fetch_array($result))
  {
print "<td width=\"142\"><img src=" . $row['search_small_image'] . " width=\"144\" height=\"169\" /></td>\n";
print "  </tr>\n";
print "  <tr>  \n";
print "<td>" . $row['star'] . "</td>\n";
print "  </tr>\n";
print "  <tr>\n";
print "<td>" . $row['username_search'] . "</td>\n";
print "  </tr>\n";
print "  <tr>  \n";
print "<td>" . $row['phone_search'] . "</td>\n";
print "  </tr>   \n";

  }
print "</table>";

mysql_close($con);
?>


 

is it true that all the server side code runs before the client side code when accessing a webpage?  if that is true, what about PHP code that is embedded inside HTML tags?  wouldn't that result in an error a lot of times?

Right now I redirect to index page after I delete a record.  However I am looking to make it so that I can delete a record without redirecting the page. I know this can be accomplised using Ajax.  I have spent countless hours before trying to make it work, but it did not work.   So here is a basic setup I created.   Can you please update it with ajax code so that I can see how it's done properly?

<!DOCTYPE HTML>
<html lang="en"> 
	<head>
		<meta charset="UTF-8">
		<title>Home Page</title>
	</head>
	<body>
	
	<div class="record" >
		<a href="record.php?id=<?php echo $record_id ?>"><?php echo $record_name; ?></a>
		<div class="delete-record">
			<a href="delete.php">Delete Record</a>
		</div>
	</div>	
	
	</body>
</html>
	

Edited by man5, 18 August 2014 - 08:55 PM.

I have a few tables in php and want them to be side by side instead of under each other like below. I have spent about 2 days trying to figure it out, Anyone got a clue?


This is the code im using

<?php
$con = mysql_connect("localhost","user","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("People", $con);

$result = mysql_query("SELECT * FROM wang");

echo "<table border='1'>
<tr>
<th>Wang Total Report</th>

</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['got'] . "</td>";
   echo "</tr>";
  }
echo "</table>";

$result2 = mysql_query("SELECT * FROM miah");


echo "<table border='1'>
<tr>
<th>Miah Total Report</th>

</tr>";

while($row = mysql_fetch_array($result2))
  {
  echo "<tr>";
  echo "<td>" . $row['got'] . "</td>";
   echo "</tr>";
  }
echo "</table>";

$result3 = mysql_query("SELECT * FROM vinc");


echo "<table border='1'>
<tr>
<th>Vinc Total Report</th>

</tr>";

while($row = mysql_fetch_array($result3))
  {
  echo "<tr>";
  echo "<td>" . $row['got'] . "</td>";
   echo "</tr>";
  }
echo "</table>";



$result4 = mysql_query("SELECT * FROM ketarie");


echo "<table border='1'>
<tr>
<th>Ketarie Report</th>

</tr>";

while($row = mysql_fetch_array($result4))
  {
  echo "<tr>";
  echo "<td>" . $row['got'] . "</td>";
   echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?> 

Now I'm having this strange issue with my website

I'm currently working on a tester system and I've encountered a problem that I'm unable to find the issue, tho I'm thinking my ajax php part of the script to be the thing causing it even tho it seems strange that it would cause it.

The first part which is connected to where the problem occurs is the echo"<form>"; and from there, It should take you to index.php?page=tester&select=answer, now that is where it in the browser goes there tho it still shows the page stuff from the last page which is index.php?page=tester&select=applications, so it's like showing both &select=answer and &select=applications on the same page.
<?php
$q=$_GET["q"];
include'../config/connection.php';
$result = mysql_query("SELECT * FROM applications WHERE id = '$q'");

echo "<center><table border='1'>
<tr>
<th>Account Name</th>
<th>Character Name</th>
<th>Gender</th>
<th>Skin Color</th>
</tr>";

$row = mysql_fetch_array($result);
  echo "<tr>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['charactername'] . "</td>";
  echo "<td>" . $row['gender'] . "</td>";
  echo "<td>" . $row['race'] . "</td>";
  echo "</tr></table></center>";
  echo"<br/>";
  echo"<table><tr>
  <th>Description</th>
<th>Metagaming</th>
<th>Powergaming</th></tr>";
echo"<tr>";
  echo "<td><textarea readonly='readonly' style='width:22em; height:20em;'>".$row['description']."</textarea></td>";
  echo "<td><textarea readonly='readonly' style='width:22em; height:20em;'>".$row['mg']."</textarea></td>";
  echo "<td><textarea readonly='readonly' style='width:22em; height:20em;'>".$row['pg']."</textarea></td>";
  echo"</tr></table><table><br/><center><h1>Answer</h1><br/><form action='index.php?page=tester&select=answer' method='post'>";
  echo"<textarea name='why' style='height:10em; width:60em;'></textarea><br/>";
  echo"<input type='submit' name='answer' value='Accept' /><a/>";
  echo"<input type='submit' name='answer' value='Decline' /></center>";
  echo"<input type='hidden' name='id' value='$q'/>";
  echo"</form></table>";
?>
Now on &select=answer it included a page which the script of that include consist of the stuff below, it outputs that the query was successfully, and all that.
<?
if(!empty($_POST['why']))
   {

   $why = mysql_real_escape_string($_POST['why']);

   $answer = trim($_POST['answer']);

   $id = $_POST['id'];

   if($answer == "Accept")

   {

   $query1 = mysql_query("UPDATE characters SET accepted = '1' WHERE id = '".$id."'");

   echo"Successfully accepted";

   $answer = 1; 

   }

   elseif($answer == "Decline")

   {

   echo"Successfully declined";

   $answer = 0;

   }

   $query = mysql_query("UPDATE applications SET answer = '$why' AND tester = '".$_COOKIE['Username']."' AND accepted = '$answer' AND answered = '1' WHERE cid = '".$id."'") or die('Could not connect: ' . mysql_error());

   if($query)

   {

   

echo"<br/>Query went through without problems";

  

header("Refresh: 5;url=index.php?page=tester");

   }
   }
?>
This is the ajax part javascript of it which gets the information for index.php?page=tester&select=applications
Code: [Select]
<script type="text/javascript">
function showApplication(str)
{
if (str==""||str==0)
{
  document.getElementById("txtHint").innerHTML="";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
    }
}
xmlhttp.open("GET","tester/applications.php?q="+str,true);
xmlhttp.send();
}
</script>If you need any more information feel free to ask for it.
Thanks in advance.

Hello,

I've been trying this for hours now, looking at different examples and trying to change them to work for me, but with no luck...

This is what I am trying to do:

I have a simple form with:
- 1 input field, where I can enter a number
- 1 Submit Button

When I enter a number into the field and click submit, I want that number to be send to the php file that is in the ajax call, then the script will take that number and run a bunch of queries and then return a new number. I want that new number to be used to call the php script via ajax again, until no number is returned, or something else is returned like the word "done" or something like that, at which point is simply makes an alert or populated a div with a message...

The point is, that depending on the number entered it could take up to an hour to complete ALL the queries, so I want the script that is called to only run a fixed amount of queries at a time and then return the number it is currently at (+1), so that it can continue with the next number when it is called again.

I would like to use jquery, but could also be any other way, as long as I get this to work. I already have the php script completed that needs to be called by the ajax, it returns a single number when being called.

Thank you,
vb

As the title say, I can not for the life of me get the "$bank" content to display, no matter HOW much I try...
Does anyone see any errors. I am sooooooo wiped out at this!


main page

<?
$body = '

<script type="text/javascript" src="change-content.js"></script>

<div id="addSold">
<form action="'.$_SERVER['REQUEST_URI'].'" method="post" name="form" autocomplete="off">

<fieldset id="Vehicle">
<legend>Vehicle</legend>
<ul>
<li><label for="Year">Year</label>'.$Year.'</li>
<li><label for="Make">Make</label>'.$Make.'</li>
<li><label for="Model">Model</label>'.$Model.'</li>
<li><label for="Trim">Trim</label><input type="text" name="Trim" id="Trim" size="10" value="'.$trim.'" disabled="disabled"></li>
</ul>
<ul>
<li><label for="Mileage">Mileage</label><input type="text" name="Mileage" id="Mileage" size="5" maxlength="6" value="'.$row['mileage'].'"></li>
<li><label for="VIN">VIN</label><input type="text" name="VIN" id="VIN" size="23" maxlength="17" value="'.$row['vin'].'" disabled="disabled"></li>
<li><label for="Color">Color</label>'.$Exterior.'</li>
</ul>
</fieldset>

<fieldset id="Deal">
<legend>Deal</legend>
<ul>
<li>
<label for="soldDte1">Date</label>
<input type="text" name="soldDte1" id="soldDte1" size="1" maxlength="2" onkeyup="return autoTab(this, 2, event)" value="08"> / 
<input type="text" name="soldDte2" id="soldDte2" size="1" maxlength="2" onkeyup="return autoTab(this, 2, event)" value="30"> / 
<input type="text" name="soldDte3" id="soldDte3" size="1" maxlength="2" value="'.$year.'">
<a href="#"><img id="date_'.$row[stock].'" src="images/Icons/dateOff.png" onfocus="this.select();lcs(this)" onmouseover="MM_swapImage(\'date_'.$row[stock].'\',\'\',\'images/Icons/dateOn.png\',1)" onmouseout="MM_swapImgRestore()" alt="Choose Date"></a>
</li>
<li>
<label for="salesman">Salesman</label> 
<select name="salesman" id="salesman">
<option></option>
'.$salesmen.'
</select>
</li>
</ul>
<ul>
<li>
<label for="dealType">Deal Type</label>
<select name="dealType" class="select-content" onchange="getFile(this.value)">
<option></option>
<option value="AL">Auto Loan</option>
<option value="Cash">Cash</option>
<option value="CAC">Credit Acceptance</option>
<option value="IH">In House</option>
<option value="SAL">Sensible Auto</option>
</select>
</li>
<li>
<label for="tradeDrop">Trade</label> 
<select name="tradein" id="tradeDrop" onchange="show_hide_trade(this.value);">
<option value="No">No</option>
<option value="Yes">Yes</option>
</select>
</li>
</ul>
</fieldset>

<div id="Bank" class="view">'.$bank.'</div>
</form>
</div>
';
?>


get_Bank.php

<?
if ($_GET['dealType'] == "AL") {
$bank = '
<fieldset id="AL">
<legend>Auto Loan Figures</legend>
<ul>
<li><label for="price">Price</label><input type="text" name="price" id="price" class="price" size="7" onchange="currency(this)"></li>
<li><label for="down">Down</label><input type="text" name="down" id="down" class="price" size="6" onchange="currency(this)"></li>
<li><label for="tax">Tax</label><input type="text" name="tax" id="tax" class="price" size="6" onchange="currency(this)"></li>
<li><label for="reg">Plates</label><input type="text" name="reg" id="reg" class="price" size="4" onchange="currency(this)"></li>
<li><label for="gap">Gap</label><input type="text" name="gap" id="gap" class="price" size="4" onchange="currency(this)"></li>
</ul>
<ul>
<li>
<label for="pymtNum">--------------- Payment ---------------</label>
<input type="text" name="pymtNum" id="pymtNum" size="3" maxlength="3" onkeyup="return autoTab(this, 3, event)"> @ 
<input type="text" name="pymtAmnt" id="pymtAmnt" class="price" size="5" onchange="currency(this)"> per 
<select name="pymtType">
<option value="Weekly" selected="selected">Week</option>
<option value="Monthly">Month</option>
</select>
</li>
<li><label for="APR">APR</label><input type="text" name="APR" id="APR" class="rate" size="6" value="19.00"></li>
</ul>
</fieldset>
';
} elseif ($_GET['dealType'] == "CAC") {
$bank = '
Credit Acceptance stuff goes here
';
} else {
$bank = 'You must choose a bank before continuing';
}

?>


change-content.js
Code: [Select]
window.onload = init;

// finds all <select> tags will class="select-content" and activates function
function init() {
var sel = document.getElementsByTagName("select");
for (var i=0; i<sel.length; i++){
if (sel[i].className == "select-content") {
sel[i].onchange = getFile;
}
sel[i].selectedIndex = 0;
}
}

function getFile (url) {
var url = "AJAX/get_Bank.php?dealType="+ this.value;
if (window.XMLHttpRequest) {xmlhttp=new XMLHttpRequest();}
else {xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");}

xmlhttp.open("GET",url,false);
xmlhttp.send();

// a loop that looks through all <div>s on the page
// and then replaces the id with the value and gets that file
var divs = document.getElementsByTagName("div");
for (var i=0; i<divs.length; i++) {
if(divs[i].id == "bank") {
divs[i].id = this.value;
divs[i].innerHTML=xmlhttp.responseText;
}
}
}

Hi Everyone

First off I don't know PHP except the includes statement which I use regularly to make the site a little easier to update.

But anyways am having an issue. I am trying to make a standard template page. On a prior site I had it set up this way with the code I will post below and it worked for me but I have tried to implement it on this site and am not having any luck.

Few things on the code below. It was designed for another site. So what I need is as follows. The home page should bring up the default index.txt file. That has the home page info on it. Second the code below has a table in the coding as I required a table on my site so that is in the code but for this site don't need the table. There is also one image in the code. That too is no longer required.

I will just leave these in place that way you can see the code I am working with so you can hopefully correct it to work for me as I am going nuts trying to get this to work.

Also somewhere in the coding it seems maybe there is an open link tag as I did get this to work a little bit but for some reason when it was the TXT file information was also being made to be a link even though the txt file for time being only contains basic text no coding what so ever.

Now what I need is as follows. Default home page TXT file loaded when home page loads. But the link below is what I was using for my site and when this was clicked it would load the TXT file for that page so the example link below would open up a members page that was associated with my message board I was using.

Code: [Select]
<a href="members.php?categories_file=Members">Forum Members Websites</a>
that link would bring up file members.txt which was stored in the text folder

Below is the code that in both cases was and is placed in the main window of the table I am using for layout. Last time this all worked perfectly but this time not sure why it refuses to load the page like it use to.

Can anyways sort this code so it works fine for me.

Thanks!!
Dave

Code: [Select]
<?php


if ($_GET['categories_file'])
$fp = fopen("text/$categories_file.txt", "r")
or die("Could not open $categories_file.");
while (!feof($fp)) {
$line = fgets($fp, 512);
$categories[] = $line; }
asort($categories)
or die("Could not sort array.");
$table_column_counter = 0;
echo "<table border='0' cellpadding='0' cellspacing='0' width='90%'>";
foreach ($categories as $item) {
if ($table_column_counter == 0) {
echo "<tr>\r\n"; }

$link = explode(",", $item);
echo "<td><img src='images/green.gif' width='13' height='13'><a 
href='$link[1]' target='_blank'>".$link[0]."</a></td>";

if ($table_column_counter == 2) {
echo "</tr>\r\n"; }
$table_column_counter = $table_column_counter + 1;
if ( $table_column_counter >= 2 ) {
$table_column_counter = 0; } }
?>

hi, can anyone please check my code

it has an error
Quote

invalid content type for request: application/x-www-form-urlencoded


Code: [Select]
<?php
$request = "&lt;?xml version='1.0'?&gt;&lt;request&gt;<br>
&lt;authentication&gt;<br>
&lt;username&gt;username&lt;/username&gt;<br>
&lt;password&gt;password&lt;/password&gt;<br>
&lt;/authentication&gt;<br>
&lt;operation&gt;getResellerProducts&lt;/operation&gt;<br>
&lt;params&gt;<br>
&lt;int&gt;22&lt;/int&gt;<br>
&lt;/params&gt;<br>
&lt;/request&gt;&lt;/myXML&gt;
";

$url = "https://testapi.ssl.trustwave.com/3.0/";  
// fake - obviosly!

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POSTFIELDS, $request); 
// what to post
curl_setopt($ch, CURLOPT_BINARYTRANSFER, 1); 
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
$result = curl_exec($ch);
curl_close($ch);

print $result;
?>


thanks!