PHP - Programmer For Hire (10 Years) | Immediate Work Needed

Howdy Colleagues,   I was wondering whether you know ways/websites/channels/magic owls to how to help find a job in USA as a programmer as in for relocating there while the company pays for the Visa and the travel expenses?   My land-lord's son found a job as a programmer in Texas and the company was generous and kind enough to pay his travelling expenses, as well for his wife and kid.    I have an account in Monster & Indeed and I send CVs very often, but no luck so far.   And I want to go there to work and live, not like some people to rely on welfare, I have worked my whole life.    Thank you!   BR, Stefany

Hi, I'm looking for a programmer to fix my search engine script.     If interested, please go to www.shoppersplace.com and check out the buffering, header, errors at the top of the page of this search engine.   try a few searches and see the errors.   thank you. 

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

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 Guys,

In a form within PHP coding i can get the the next 10 years with the following code:

Code: (php) [Select]
<?php 
$date_future = date("Y", strtotime('+10 year'));
$date_year = date("Y");
for($i=$date_year;$i<$date_future;$i++){
if($date_year == $i){ 
echo "<option value=\"$i\" selected=\"selected\">$i</option> \n";
} else { 
echo "<option value=\"$i\">$i</option> \n"; 
}
} 
?>
I have tried to mess about with the same code and try and get it to work for the last 10 years without any luck. He's what i did:
Code: (php) [Select]
<?php 
$date_past = date("Y", strtotime('-10 year')); 
$date_year = date("Y");
for($i=$date_year;$i>$date_past;$i++){
if($date_year == $i){ 
echo "<option value=\"$i\" selected=\"selected\">$i</option> \n"; 
} else { 
echo "<option value=\"$i\">$i</option> \n"; 
}
} 
?>
I would appreciate any help with this.

I can determine 3 years from today, but How do determineo 3 years from march 1st?

So I want to echo out "3/1/2013"?

Thanks!

Hi everyone,

I'm writing a science fiction wordpress blog set 10 years into the future.
I basically need all posts to display as if they are 10 years from now.

Eg. posts needs to display as:
February 7, 2021 instead of
February 7, 2011

This will be for every post that I write.


How can I automatically add 10 years to every post date?
(And where would I put that code?)

Currently, the wordpress php is calling the date with `<?php the_time(__('M j, Y')) ?>`

I realise it's a bit of an odd request, but it's necessary for this particular project. I know it's possible - but I'm brand new to php and am not sure how. =)

I hope someone out there can help. It would be very much appreciated.

many thanks in advance

Luke

How can i group the data by year to build the graph

I need the data to be like so

2012
0 - total customers
0 - total customers
0 - total customers
0 - total customers
0 - total customers
9 - total customers
5 - total customers
3 - total customers
5 - total customers

however i only have this data

Code: [Select]
total_customers month year
1 Aug 2011
9 Oct 2011
8 Nov 2011
4 Dec 2011
4 Jan 2012
so i need to make it show 0 for the months i dont have data for

Code: [Select]
<div id="dash_chart" class="portlet x9">

<div class="portlet-header">
<h4>Customer Growth</h4>

<ul class="portlet-tab-nav">
<li class="portlet-tab-nav-active"><a href="#tab1" rel="tooltip" title="Customers">Customers </a></li>
<li class=""><a href="#tab2" rel="tooltip" title="Sales over last 48 hours.">Sales </a></li>
</ul>
</div> <!-- .portlet-header -->

<div class="portlet-content">
<div id="tab1" class="portlet-tab-content portlet-tab-content-active">
               
                <?php 

echo '<table class="stats" title="area" width="100%" cellpadding="0" cellspacing="0">
<caption>Customer Base Growth</caption>
<thead>
                <tr>';

$monthNames = Array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');

$i = 0;

foreach ($monthNames as $month){

echo '<th>'.$month.'</th>'."\n";

}

echo '</tr>
  </thead>';

                      $q = "SELECT count(cus_id) as total_customers, DATE_FORMAT(sign_date, '%b') as month, YEAR(sign_date) as year FROM customers 
  GROUP BY YEAR(sign_date), MONTH(sign_date) ORDER BY sign_date ASC";
$r = @mysqli_query ($dbc, $q);

$data = array();

if (mysqli_affected_rows($dbc) >= 1) {

echo '<tbody>
<tr>
   <th>2011</th>';

while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {


}

}

echo '</tr>';

?>
                            <tr>
<th>2012</th>
<td>3</td>
<td>4</td>
<td>2</td>
<td>0</td>
<td>0</td>
                                <td>0</td>
<td>0</td>
<td>3</td>
<td>5</td>
                                <td>3</td>
                                <td>9</td>
</tr>
</tbody>
</table>

Ok so here is my code. Ignore the $_POST['dobm']. That is part of the whole script.
All I want to know is how to set the list from 1998 to 1911 in descending order. I already tried making $i = 1998 and make $i - 1 til $i >= 1911. It seems to go in an infinite loop when I do that.

Code: [Select]
<?php
for($i = 1911; $i <= 1998; $i++)
{
if ($_POST['dobm'] == $i)
{
echo '<option selected="selected" value="'.$i.'">'.date('Y', mktime(0,0,0,0,0,$i+1)).'</option>\n';
}
else
{
echo '<option value="'.$i.'">'.date('Y', mktime(0,0,0,0,0,$i+1)).'</option>\n';
}
}
?>

I am searching the database for items that are plaques. There are different years of plaques. I find all the plaques sorted by year. My display puts them in rows of 4 max.
What I want is to display them by year with a different year on a different line.
Right now there are 4 (1963), 3 (1965), 1 (1978) all bunched together.
1963, 1963, 1963, 1963,
1965, 1965, 1965, 1978

What I want is:
1963, 1963, 1963, 1963,

1965, 1965, 1965,

1978,

Any help would greatly be appreciated.


<?php
include 'config0.php';

$search=$_GET["search"];

// Connect to server and select database.
mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect");
mysql_select_db("$dbname")or die("cannot select DB");


$result = mysql_query("SELECT * FROM table1 WHERE plaques LIKE '%$search%' ORDER BY year") or die(mysql_error());
// store the record of the "" table into $row
//$current = '';

// keeps getting the next row until there are no more to get
if($result && mysql_num_rows($result) > 0)

{
    $i = 0;
    $max_columns = 4;
    echo "<table align=center>";
echo "<br>";
    while($row = mysql_fetch_array($result))
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)

          echo "<tr>";

          echo "<td align=center>";
          ?>
          <div style="float: left;">
          <div><img src="<?php echo $tn; ?>"></div>

  </div>


          <?php
          echo "</td>";

       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns)
       {
           echo "</tr>";
           $i=0;
       }  // end if
   } // end while
} // end if results

// clean up table - makes your code valid!
if($i > 0)
{
    for($j=$i; $j<$max_columns;$j++)
        echo "<td>&nbsp;</td>";
   echo '</tr>';
}
mysql_close();
 ?>
</table>

Hello All,

I have a News database in which articles are entered in. Right now all the stories are being display in one big page with every story on it. What I would like to do is to create an "archive" in which it automatically organizes the stories by their date.

For example.

2011
February
January

2010
December
November
October
September
etc...
etc...

I have a datetime field for the database, and I know how to do this all manually, but I can't figure out how to make it automatically add a month each month. It would be too much maintanence to have to update this every month.

I also don't know what this would be called, so I don't even know what to search for. I've tried blog and news, but doesn't seem to be what I want.

Any help would be appreciated!

if(!is_array($e))
{
    $fulldisp = 1;
    $e = array('title' => 'No Entries Yet',
               'entry' => '<a href="../admin.php">Post an entry!</a>'
             );
        }
    }
    // Add the $fulldisp flag to the end of the array
    array_push($e, $fulldisp);
    
    return $e;
}

can someone please tell me why I'm getting this notice ?
Notice: Undefined variable: e in /var/www/blog/inc/functions.inc.php on line 40

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

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