PHP - Requesting Help Regarding Ajax

Hi   What is the best recommended way to "sort through" and "place certain data" into a sql table?   For example, I create a input form.php      Company Name: 

The Blah Company

Product/Industry

Dedicated Servers

HTML Source Code

<div class="allservers">		
			<div class="serverType" id="server1">	
			<div class="myFeaturesBox">
				<ul class="tabination">		        		                  		            
					<li><a href="#" class="activeTab" data-tab='feature'>FEATURED</a></li>
					<li><a href="#" data-tab='single'>SINGLE PROCESSOR</a></li>
					<li><a href="#" data-tab='dual'>DUAL PROCESSOR</a></li>
					<div class="clear"></div>			
				</ul>					
				<div class="feature myTab activeTabs">
				<table class="table">
					<tr>
						<th></th>
						<th>Processor</th>
						<th>RAM</th>
						<th>Hard Drive</th>
						<th>Price/Mo</th>
						<th></th>
						<th></th>
					</tr>
					<tr>
						<td><img src='img/server.png' alt='Server' width="20" height="20" /></td>
						<td>Intel Xeon E3-1230 (4x3.2GHz)</td>
						<td>8 GB DDR3</td>
						<td>1x500 GB SATA</td>
						<td>$98.00</td>
						<td><a href="https://portal.securedservers.com/wap-jpost3/UP011013E31230" target="_self"><img src='img/deploy.png' alt='Deploy Now' width="86" height="18" /></a></td>
						<td class="wB"></td>
					</tr>
					<tr>
						<td><img src='img/server.png' alt='Server' width="20" height="20" /></td>
						<td><div style="position:relative;">Intel Xeon E3-1240 v3 (4x3.4GHz)</div></td>
						<td>8GB DDR3</td>
						<td>1x1 TB SATA</td>
						<td>$128.00</td>
						<td><a href="https://portal.securedservers.com/wap-jpost3/UP031013E31240" target="_self"><img src='img/deploy.png' alt='Deploy Now' width="86" height="18" /></a></td>
						<td class="wB"></td>
					</tr>
					<tr>
						<td><img src='img/server.png' alt='Server' width="20" height="20" /></td>
						<td><div style="position:relative;">Intel Xeon E3-1240 v3 4-bay (4x3.4GHz)</div></td>
						<td>8GB DDR3</td>
						<td>4x500 GB SATA</td>
						<td>$148.00</td>
						<td><a href="https://portal.securedservers.com/wap-jpost3/UP431013E31240" target="_self"><img src='img/deploy.png' alt='Deploy Now' width="86" height="18" /></a></td>
						<td class="wB"></td>
					</tr>
					<tr>
			</table>

Submit Button --> sends to the "sorting process?" than into proper DB tables for search query.        Ultimately, there I require to be able to pull from my DB upon query, pricing, hardware, processor, etc..

Any recommendation for me to try? I'm new to PHP but I want to learn and do it myself (better after effect feeling than paying someone)

Hi:

I am trying to request an id to do a transfer back to a page, but am having difficulties.

This is on a page where a person can add a new section, which gets assigned a unique id.

I am trying to send the user to the page where they can edit the new page, once it has been created.

Like this:

a_websiteDataADD.php
Code: [Select]
<?php
$id = $_REQUEST['id'];
?>

...

<script language="JavaScript">
alert("The new section was added!");
location.href = "a_websiteData.php?id=[id]";
</script>

What am I missing on this ??

Hi all. 

I have been trying something for 2 days, having no success and was hoping someone could help.  I know this is a long post but it's mostly just php code below. 

I'm trying to do "pagination" for a script that I came across.  First of all.. I am not a programmer in any way.  I didn't even know what pagination was until 2 days ago when I was trying to explain what I wanted in a forum and was educated.  So.. off to Google I went.  I found all kinds of "free pagination" script articles with "how-to's".  Well.. I think you need to at least have an idea of how to program becuase I've tried 4 now and failed every time.  Or... maybe I'm just the world's worst at understanding programming concepts (very possible).  I really have spent just hours and hours trying to make pagination happen.. to no avail. 

So.. if you know an easier way, please share!  Or.. If you care to read on and help with the pagination script I've been trying to make work, that would be awesome.  Either way, I would be most grateful! 

Here's what I got and what I've tried..

My index.php page:

Code: [Select]
<?php 
include_once('inc_dbcon.php'); 
require_once('admin/config.php');
require_once($languageFile);

// Preview descrition length in characters
$previewLength = 240;

// check to see if in admin mode and validate key
global $keyOut;
$keyOut = "";
if (isset($_GET["k"]))
if($_GET["k"] == $key){ // Key comes from admin/password.php file
$keyOut = "&k=" . $key;
}

global $category;
$category = "%";
if (isset($_GET["category"]))
$category = mysql_real_escape_string($_GET["category"]);

$msg = "";
if (isset($_GET["msg"]))
$msg = mysql_real_escape_string($_GET["msg"]);

// SEARCH CODE START
$searchQuery = "";
if (isset($_GET["q"]))
$searchQuery = mysql_real_escape_string($_GET["q"]);

if ($searchQuery != "") 
{
$query_Recordset1 = "SELECT postId,category,title,description,isAvailable,description,price,confirmPassword,category,imgURL,imgURLThumb,DATE_FORMAT(timeStamp,'%b %d, %Y %l:%i %p') AS timeStamp1 FROM md_postings WHERE isConfirmed = '1' AND title like '%$searchQuery%' OR description like '%searchQuery%' ORDER BY `timeStamp` DESC";
} else {

$query_Recordset1 = "SELECT postId,category,title,description,isAvailable,description,price,confirmPassword,category,imgURL,imgURLThumb,DATE_FORMAT(timeStamp,'%b %d, %Y %l:%i %p') AS timeStamp1 FROM md_postings WHERE isConfirmed = '1' AND category like '$category' ORDER BY `timeStamp` DESC";
}
// SEARCH CODE END - see also line 113 below

$maxRows_Recordset1 = 100;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = mysql_real_escape_string($_GET['pageNum_Recordset1']);
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1);
if (!$Recordset1){    
print("It appears we have a problem: " . mysql_error());    
exit();  
}
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = mysql_real_escape_string($_GET['totalRows_Recordset1']);
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset1") == false && 
        stristr($param, "totalRows_Recordset1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="md_style.css" rel="stylesheet" type="text/css" />
<script language="JavaScript">
function doFilter(dis)
{
window.location.href = "index.php?category=<?php echo $category ?>&type=" + dis.value + "<?php echo $keyOut;?>"
}
</script>
</head>
<body>
<?php include_once("inc_navigation.php") ;?>
<div id="md_container">

<?php 
if ($msg == "deleted")
print("<br clear='all' />&nbsp;<div class='md_msg' style='margin-top:-10px;'>" . STR_DELETED ."</div>"); 
?>
<br clear="all" />
<div id='md_listingBox'>
<?php
if($totalRows_Recordset1 < 1)
{
// SEARCH START new Code - added IF statement to support search
if ($searchQuery != "")
echo "<p><br /><br /><br />" . STR_NORESULTS . "<b>" . $searchQuery ."</b></p>";
else
echo "<p><br /><br /><br />" . STR_NOITEMS . "</p>";
// SEARCH END NEW CODE
} else {

 do { 
    $img = "/images/gift_light.gif' title='This is a gift!'";
 $type = $row_Recordset1['type'];
 $isAvailable = $row_Recordset1['isAvailable'];
     $isAvailableClass = ($isAvailable == 0) ? 'md_taken' : ''; 
 $thumbnail = '&nbsp;';
 if (strlen($row_Recordset1['imgURLThumb']) > 3){
  $thumbnail = "<a href='viewItem.php?id=" . $row_Recordset1['postId'] . "' class='md_recordLink " . $isAvailableClass . "'>";
$thumbnail .= "<img src='" . $row_Recordset1['imgURLThumb'] . "' class='md_thumbnail' border='0'></a>";
}
?>
<table width="100%" border="0" cellpadding="4" class="md_listingTable">
  <tr>
    <td width="54" align="center"><?php echo $thumbnail; ?></td>
    <td valign="top">
    <div class='md_date'><?php echo $row_Recordset1['timeStamp1'];?></div>
    <a href="viewItem.php?id=<?php echo $row_Recordset1['postId'] . $keyOut;?>"
    class='md_recordLink<?php echo $isAvailableClass; ?>'><?php echo stripslashes($row_Recordset1['title']); ?></a>
    &#8212; $<?php echo $row_Recordset1['price']; ?> <br />
    <?php echo stripslashes(substr($row_Recordset1['description'],0,$previewLength)); ?>...
    </td>
  </tr>
</table>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); 
} // end else clause
?>

</div>
</div>
<?php include_once("inc_footer.php");?>
</body>
</html>
<?php  mysql_close($dbConn); ?>
Here's the inc_dbcon.php file that it calls to connect:
Code: [Select]
<?php

// Change these to be for your database
$dbhostname = "localhost";
$dbname     = "justtes1_123";
$dbusername = "justtes1_12";
$dbpassword = "abc12";

if(!$dbConn = mysql_connect($dbhostname, $dbusername, $dbpassword))
die('I could not connect to the database. Clease check the inc_dbcon file and make sure everything is correct.');
if(!mysql_select_db($dbname, $dbConn))
die('I could not select the database. Check the inc_dbcon file and make sure everything is correct.');
?>
I've trying to use the pagination script from:  http://www.phpeasycode.com/pagination/

Here's the "usage example" that is in the pagination script:
Code: [Select]
<?php

$rpp = 10; // results per page
$adjacents = 4;

$page = intval($_GET["page"]);
if($page<=0) $page = 1;

$reload = $_SERVER['PHP_SELF'];

// connect to your DB:
$link_id = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname, $link_id);

// select appropriate results from DB:
$sql = "SELECT * FROM table_name WHERE table_field LIKE '%search string%' ORDER BY field_name";
$result = mysql_query($sql, $link_id);

// count total number of appropriate listings:
$tcount = mysql_num_rows($result);

// count number of pages:
$tpages = ($tcount) ? ceil($tcount/$rpp) : 1; // total pages, last page number

$count = 0;
$i = ($page-1)*$rpp;
while(($count<$rpp) && ($i<$tcount)) {
    mysql_data_seek($result,$i);
    $query = mysql_fetch_array($result);

    // output each row:
    echo "<p>" . $query['table_field_1'] . ", " . $query['table_field_2'] . "</p>\n";

    $i++;
    $count++;
}

// call pagination function:
include("paginate.php");
echo paginate_three($reload, $page, $tpages, $adjacents);
?>
The pagination script also comes with a demo.php.   I uploaded that and it works just great.  But.. when I try to incorporate the above usage into my index.php, I fail miserably. 
So.. If you prefer, I can copy index.php with what I've tried.. which is apparently very wrong.  The page I tried it in is he   http://justtesting.freehosting.com/indexPaginate.php

So.. if anyone is able to tell me how they'd incorporate the usage script into the index.php, that would solve my 2 day dilemna and I would be eternally grateful. 

If you want to login to my test version (feel free to edit as this is purely a test site), it's he  

http://justtesting.freehosting.com/
ftp host:  62.75.203.94
FTP Username: justtes1
FTP Password: JpxF34j80h

A HUGE thanks for anyone who can help!  I have tried everything for hours and hours.. 

This topic has been moved to Other Web Server Software.

http://www.phpfreaks.com/forums/index.php?topic=351526.0

Hey everyone,
I'm new to this forum and I came here looking for some help with PHP. I've just started
getting into PHP and you guys are probably a smile ahead.

So basically, I have some inputs and want them to be sent to my email in a basic layout shown below.

Code: [Select]
Inputs:

Title = _title
Forum Name = _forumname
Name = _irlname
Age = _age

I want the email to be sent to me like:

Code: [Select]
Email Title
---------------
Forum Name: TextGiven
Real Life Name: TextGiven
Age: TextGiven
Here is my current code which titles the email correctly, but I want to figure out how
to make $message set to the example email I showed above.

Code: [Select]
<?php 
$to = "******@*********.net";
$subject = $_REQUEST['_title'];
$headers = "From: ***** Applicant \r\n"; 
$headers .= "MIME-Version: 1.0\r\n"
  . "Content-Type: text/html; charset=\"iso-8859-1\"\r\n"
 . "Content-Transfer-Encoding: 7bit\r\n";
$message =  $_REQUEST['_forumname' & '_irlname'];  <--- Part I want fixed


if(mail($to, $subject, $message, $headers)) 
{
     echo 'MAIL SENT'; 
} else { 
     echo 'MAIL FAILED';
} 
?>

I have this code, and it works. But I want $message = "" to make the message contain not just the
forum name, but as well as the name, age, and all other inputs I want.