PHP - Programmer Open For Work

I am in the process of making a promising company that is the first of it's kind in it's respective market and require an in-house programmer. PM me for further details.    Mr. Lankee

i can do stuff in html, php, flash, java and server developement and work for more then 8 years in different segments for webprogramming.     german.    

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.. 

Hey my friends, as you are reading this I am going to share an amazing opportunity I have today. I am about to launch a HUGE website and am looking for a PHP coder who wants to get in right before we launch to take advantage of a money making collaboration. The website is about 90% finished coding and all we need is to have a pre-coded script integrated into the already coded website.   If you are selected as a part of our team, you could potentially have your hand in alot of other HUGE projects launching in the coming future. We are wanting to possibly have a coder work along side us, long term. Imagine how secure you will feel knowing you could have a ton of paid projects lined up in the future. We are only going to accept someone who is a quick and effiecient coder, because we are going to launch very soon, as marketing and advertising is already set up. If you are interested in this one of a kind opportunity, either reply to this message or send me a PM.   We will start looking at the coders who reply first, as we interpret that as a great sign that you realize what a great opportunity this is. If, that is you, I look forward to sharing all the details. - Garrett, CEO

This topic has been moved to Miscellaneous.

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

I'm trying to open a URL using fopen() and I keep getting this error:
Code: [Select]
Failed to open stream: Permission deniedI can not work out what is wrong, it's not a firewall as far as I can tell.

Not to say that this occurs in every php software out there, but I far too occasionally notice that the application is written with scattered php open and close tags, for instance

<?php if(true) ?>
<?php { ?>
Blah blah blah, because it's true
<?php } else { ?>
because it's not true
<?php } ?>

To me, it is extremely irritating.   Regardless, I see a lot of open source software written this way and I can't help but think that there must be some underlying reason for it.  Magento, for example, is written exactly in this manner.  The templates are infested with these opened and closed php snippets.  Obscurity is not security so I'm ruling security reasons out.  Maybe it is more efficient? -- But I couldn't understand why, if so.  It seems like that would put more of a drag on the system itself causing php to start and stop parsing continually and excessively, then again, I'm no expert in the field of memory consumption and other operating system complexities.   Honestly, in my opinion, it is stupid.  i would never write a program that way..   HEREDOCs are much more useful and eye pleasing than that awful <?php { ?>   I had the misfortune a few months ago when I purchased an invoicing/customer maintenance system that I didn't know was written for PHP 5.2 or something lower, one that allowed short tags; and thus short tags were used in the same manner as I've described.   Is this just plain disorganization or is there some deep-seated inner lining advantage that I'm not aware of?

Hi..,
I use below method to export data to excel.

header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename=abc.xls');

if I run the script from the server. (http://localhost/export.php) it is work. (pop-up window if i want save or open the file)

but if i run the script from the client (http://192.168.1.5/export.php) it is not work. (nothing happen)

any idea how to solve this?

This one requires lots of up front information:

I have a page, for this example that I will call page.php. It takes get parameters, and for this example I'll call the parameter "step". So I have a URL like this: page.php?step=1 This page has a form with an action of page.php?step=1. The code on the page validates the posting information. If the information is bad, it returns the user to page.php?step=1; if it is good, it takes the user to page.php?step=2 via header( "location:page.php?step=2" ). So redirection is done by relative path, not full URLs.
This all works as expected.

Now what I've done is set .htaccess to be HTTPS for this page, via this code:

# Turn SSL on for payments
RewriteCond %{HTTPS} off
RewriteCond %{SCRIPT_FILENAME} \/page\.php [NC]
RewriteRule ^(.*)$ https://%{HTTP_HOST}/$1 [R=301,L]

This works (initially). However, once you try to post the form, it just redirects back to the step=1 version of the page. I really don't know how or why that would be.

I'm not sure how else I can explain this or what other information you may have. But it's frustrating to not get a page working in HTTPS that works in HTTP. Very odd. Any suggestions? (I don't even really know the best location to figure out when/why it's redirecting back to the original page.)

require_once 'includes/upload.class.php';
$upload = new uploads();
$details = $upload->getFileInformation($id);

<?php echo $details['upload_desc']; ?>

then here the class.

require_once 'db.class.php';



class uploads extends database

{

   private $uploadData;

   function uploadFile() {

   public function getFileInformation($id)

   {

      $this->uploadData = $this->readData("uploadfiles", "upload_id", $id);

      return $this->uploadData;

   }


But it wont work!
      

Some of you may have seen one of my many posts about email issues.  Some users don't get them, and I have determined it is probably because we are marked as spam.   We are a service that grades sales team members on their phone skills.  Listening to pre-recorded calls, grading and uploading them to our site, and then another part of our business looks them over and sometimes leaves a message that then get's forwarded to this persons work email.   I have determined there is ways to get marked as spam as default by not having an opt out link.  This is not an option, these sales members employer has opted in, and the emails are going to work related accounts hosted at that employer.  Also, if one of these staff members is not so bright, or disgruntled they may mark us as spam anyways.  The bottom line is that we have very little control over whether we are or are not marked as spam.   So we want to start looking into sending text messages and this is where I start to question how good of an idea this is.   First off, if it was me, and the messages where being sent to a device that my employer did not provide, I would in no way want work related text messages coming to me.  Unless there is a vested interest in getting them.  IE, I'm the boss at this place and am always on the clock.  What if you are on the bottom?  It's just a job for you.   What if it is a pre-paid device, text messages cost money.  What then?  What if they don't even have, or want a cell phone?   The short of it is this.  If I'm at a job that is just another job, and this employer tells me that I have to get these messages.  I'm going to look for another job.  I see the organizations having continuous issues and complaints from their employees.  Thus us as a business having issues keeping clients.   What am I getting into here?  What are your opinions on this matter?  What are your recommendations as to alerting users of something on our site that we can rest assured are being received 100% of the time?   Thanks!   Nick

Hi there, As the question says i tried several things but i can't work it out and my knowledge about php isn't that well.

i need help trying to get this delete feature to work its not deleting from the database (by the way i took out my database names and passwords at the top of the file)

is it possible someone could help me, ive been working on this for like a week and cant figure out the problem. thanks! you can email me at spr_spng@yahoo.com


picture 2.png is showing what it looks like




Code: [Select]
<?php
$host="localhost"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="database_name"; // Database name
$tbl_name="table_name"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);


?>
<style>
/*table affects look of the whole table look */
table {
margin-left: auto;
margin-right: auto;
border: 1px solid #330000;
border-collapse:collapse;
width:70%;

border-width: 5px 5px 5px 5px;
border-spacing: 1px;
border-style: outset outset outset outset;
border-color: #330000 #330000 #330000 #330000;
border-collapse: separate;
background-color: #330000;


#800517

f535aa

#330000 school color
#9A0000 school color2
#991B1E school color3
#CCCC99 school color4
#9A0000

}
/*th is table header */
th {
text-align: left;
height: 2.5em;
background-color: #330000;
color: #FC0;
font-size:1.5em;
}
/*td is table data or the cells below the header*/
td {
text-align: left;
height:1.0em;
font-size:1.0em;
vertical-align:bottom;
padding:10px;

border-width: 5px 5px 5px 5px;
padding: 8px 8px 8px 8px;
border-style: outset outset outset outset;
border-color: #9A0000 #9A0000 #9A0000 #9A0000;
background-color: #CCCC99;
-moz-border-radius: 0px 0px 0px 0px;

}
</style>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Pick Which Rows you want to delete, Then press delete.</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF">delete</td></tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this // edited
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

Hi i have been working on a cow management program PHP based.
it works beautifull but now i'm stuck , and i hope i post it in the right forum.
On demand php has to generate an export.txt file with basic cow information (tag#, transponder#, Bdate)
this will be read by the parlour computer an Eprom based computer serial connected.

I finished the script and it creates a beautifull TXt file exxept it's php
http://localhost/tmp/test.php

if i open that URL in notepad, it prints the txt file:
Quote

DH9900010090000624000900002080
VH990001 Dairy Comp 305         20100203
DN99000200312008080003000020800030000303000300035 08000300357080003001940800030003308000300036020
VN99000200001034000014010052009112620100922201102 042001111706
VN99000200001061000009420032010032820100906????????2007120101
VN99000200001083000067850032010061720100927????????2002030706
VN99000200001104000055440052009062720100817201101 032002080605
VN99000200001116000078540042010083120110207????????2002082205
VN990002000011470000816800220101226????????????????2003010806
VN99000200001153000070120032010030420100906????????2003020305



but when i enter that URL in the sync.BAT nothing happends..

my question is, doe anyone know if there is a way to fool DOS for accepting a PHP url?.
OR is there a way for Apache to treat one TXT file as an PHP file?


my script:

Code: [Select]
<?php

//request sql cow info

$db_host = 'localhost';
$db_user = '';
$db_pwd = '';
$database = 'cowdbase';
$table = 'cows';


if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// sending query
$result = mysql_query("SELECT * FROM {$table}");
if (!$result) {
    die("Query to show fields from table failed");
}

//quiery alle info
$query="SELECT * FROM {$table}";
$result=mysql_query($query);

// hoeveel rijen zijn er?
$num=mysql_numrows($result);


//Type the header from the text file


echo "DH9900010090000624000900002080" . PHP_EOL ;
echo "VH990001 Dairy Comp 305         20100203" . PHP_EOL ;
echo "DN9900020031200808000300002080003000030300030003508000300357080003001940800030003308000300036020" . PHP_EOL ;



mysql_close();
$i=0;
while ($i < $num) {

$cowtag=mysql_result($result,$i,"cowTag");
$bdate=mysql_result($result,$i,"Bdate");
$group=mysql_result($result,$i,"group");
$alpro=mysql_result($result,$i,"Alpro_trans");


// LIST ALLE KOEIEN KOE VOOR KOE
///   unknown     cowtag     unknown-0000      #### Alpro tag     00   Group     20    Fresh dateyymmdd  20  Heatdate yymmdd, Drydate YYYYMMDD, Birthdate YYYYMMDD  Lactation number ##
echo "VN9900020000" . str_pad($cowtag, 4, "0", STR_PAD_LEFT) . "0000" . str_pad($alpro, 4, "0", STR_PAD_LEFT) . "00" . "$group" . "20" . "0000" . "????????????????" . "00000000" . "01" . PHP_EOL ;
$i++;
}
echo "EN" . PHP_EOL ;
echo "ZN" . PHP_EOL ;
?>

Hi,

I need to open an RTF File on client side. When user submit form, the system will write some data in database and at the end, it has to open an rtf file in order to user be able to print it. Any ideas?

Thanks

Hugo