PHP - Why Is My Numbering Suddenly Skipping In My Php, Mysql Application

Hello Everyone

So i have this script that pulls some stuff out of a db and displays it. Pretty basic. It used to work fine but now it omits one entry from the table. It always shows one less than its supposed to. I.E. if there are 4 table entries, it only shows 3. It didnt do this before and I'm not sure why it changed. I didnt edit the code at all. Here it is:

Code: [Select]
else{
$sql = "SELECT * FROM article WHERE lang='" . $validlang ."' AND cat_id=" . $validentry
. " ORDER BY id DESC LIMIT 5";

$result = mysql_query($sql);
if(!$result){
echo "Error querying the database." . mysql_error();
exit;
}
else{
$row = mysql_fetch_assoc($result);
}
if(!$row){
echo "Error: No articles found." . mysql_error();
exit;
}
else{
echo "<div id='section'>Organization News</div>";
while($row = mysql_fetch_assoc($result)){
echo "<h3><a href='" . $validlang . "/" . $row['location'] . "'>" . $row['title'] . "</a></h3>";
echo "<div id='subtitle'>" . $row['summary'] . "</div>";
}
}
}
Any help would be appreciated. Thanks

I have a script that uploads and images, creates 2 versions of it, re-sizes the images and inserts all the info into a DB.

The odd thing is that if I don't have an image to upload, it will still run the script but it will completely skip over the description.  If I upload an image, it works fine.  Not too sure what the issue is.
Is it because my variable of $desc causing a conflict?

Here's my code:

Code: [Select]

<?php 
ini_set("display_errors",1);
include 'dbconn.php';

$change="";
$abc="";


 define ("MAX_SIZE"," 10000");
 function getExtension($str) {
         $i = strrpos($str,".");
         if (!$i) { return ""; }
         $l = strlen($str) - $i;
         $ext = substr($str,$i+1,$l);
         return $ext;
 }

 $errors=0;
  
 if($_SERVER["REQUEST_METHOD"] == "POST")
 {
  $image =$_FILES["file"]["name"];
$uploadedfile = $_FILES['file']['tmp_name'];
     
 
  if ($image) 
  {
 
  $filename = stripslashes($_FILES['file']['name']);
 
   $extension = getExtension($filename);
  $extension = strtolower($extension);


 if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif")) 
  {

  $change='<div class="msgdiv">Unknown Image extension </div> ';
  $errors=1;
  }
  else
  {

 $size=filesize($_FILES['file']['tmp_name']);


if ($size > MAX_SIZE*1024)
{
$change='<div class="msgdiv">You have exceeded the size limit!</div> ';
$errors=1;
}


if($extension=="jpg" || $extension=="jpeg" )
{
$uploadedfile = $_FILES['file']['tmp_name'];
$src = imagecreatefromjpeg($uploadedfile);

}
else if($extension=="png")
{
$uploadedfile = $_FILES['file']['tmp_name'];
$src = imagecreatefrompng($uploadedfile);

}
else 
{
$src = imagecreatefromgif($uploadedfile);
}

echo $scr;

list($width,$height)=getimagesize($uploadedfile);


$newwidth=150;
$newheight=($height/$width)*$newwidth;
$tmp=imagecreatetruecolor($newwidth,$newheight);


$newwidth1=50;
$newheight1=($height/$width)*$newwidth1;
$tmp1=imagecreatetruecolor($newwidth1,$newheight1);

imagecopyresampled($tmp,$src,0,0,0,0,$newwidth,$newheight,$width,$height);

imagecopyresampled($tmp1,$src,0,0,0,0,$newwidth1,$newheight1,$width,$height);

$famname = $_POST['famname'];
$desc =  $_POST['description'];
$petname = $_POST['petname'];
$letter = $_POST['letter'];
$filename = "images/". $_FILES['file']['name'];
$filename1 = "images/small". $_FILES['file']['name'];



imagejpeg($tmp,$filename,100);

imagejpeg($tmp1,$filename1,100);

imagedestroy($src);
imagedestroy($tmp);
imagedestroy($tmp1);
}}

}

//If no errors registred, print the success message
 if(isset($_POST['Submit']) && !$errors) 
 {
 
 $insert="insert ignore into tbl_tribue (petname,familyname,letter,description,imgpath,thumbpath) values ('$petname','$famname','$letter','$desc','$filename','$filename1')";
   mysql_query($insert);
   //mysql_query("update gallery set imgpath='$filename'");
  $change=' <div class="msgdiv">Pet Added Successfully!</div>';

print $insert;

 }
 
?>


I had turned on the error and the print to see the output.  Anyone have any ideas?  Thanks!

I am new to PHP. I have been trying to do some research online for a few days and not getting very far. I feel like I know less now than I did before I started.

Here's the story:

I've set up a LAMP server that runs a Wiki and AppGini (http://www.bigprof.com/appgini/) - AppGini allows you to "Create web database applications instantly without writing any code" - The only downside we have with it, is it's got it's own set of user accounts. My team all logs in with the default admin account which isn't a big deal but we'd prefer to use LDAP to AD for reasons I won't get into right now.

I emailed AppGini support and asked about LDAP integration. Their response was that it's "a little bit of work" and "You can modify the login authentication function to authenticate using LDAP ... please see the example code he http://code.activestate.com/recipes/101525-ldap-authentication/ (needs some modifications to work with AppGini)"

I've googled around and found 2 dozen different LDAP PHP samples. I've gotten some of them to work. By work I mean they connect to my domain controller and say "success" I'm not actually logged into anything.

So I'm looking for a little help from square one. I need to have a better understanding of how things are supposed to work so I know where I'm supposed to go with all of this. Where do I start? What do I do? What would YOU do?


This is the current "index.php" that logs you into the site.
Code: [Select]
<?php

error_reporting(E_ALL ^ E_NOTICE);
$d=dirname(__FILE__);
include("$d/defaultLang.php");
include("$d/language.php");
include("$d/incCommon.php");
$x->TableTitle=$Translation['homepage'];
include("$d/header.php");

if($_GET['signOut']==1){
logOutMember();
}

$tablesPerRow=2;
$arrTables=getTableList();

?>
<div align="center"><table cellpadding="8">
<?php if($_GET['loginFailed']==1 || $_GET['signIn']==1){ ?>
<tr><td colspan="2" align="center">
<?php if($_GET['loginFailed']){ ?>
<div class="Error"><?php echo $Translation['login failed']; ?></div>
<?php } ?>
<form method="post" action="index.php">
<table border="0" cellspacing="1" cellpadding="4" align="center">
<tr>
<td colspan="2" class="TableHeader">
<div class="TableTitle"><?php echo $Translation['sign in here']; ?></div>
</td>
</tr>
<tr>
<td align="right" class="TableHeader">
<?php echo $Translation['username']; ?>
</td>
<td align="left" class="TableBody">
<input type="text" name="username" value="" size="20" class="TextBox">
</td>
</tr>
<tr>
<td align="right" class="TableHeader">
<?php echo $Translation['password']; ?>
</td>
<td align="left" class="TableBody">
<input type="password" name="password" value="" size="20"class="TextBox">
</td>
</tr>
<tr>
<td colspan="2" align="right" class="TableHeader">
<span style="margin: 0 20px;"><input type="checkbox" name="rememberMe" id="rememberMe" value="1"> <label for="rememberMe"><?php echo $Translation['remember me']; ?></label></span>
<input type="submit" name="signIn" value="<?php echo $Translation['sign in']; ?>">
</td>
</tr>
<tr>
<td colspan="2" align="left" class="TableHeader">
<?php echo $Translation['go to signup']; ?>
<br /><br />
</td>
</tr>
<tr>
<td colspan="2" align="left" class="TableHeader">
<?php echo $Translation['forgot password']; ?>
<br /><br />
</td>
</tr>
<tr>
<td colspan="2" align="left" class="TableHeader">
<?php echo $Translation['browse as guest']; ?>
<br /><br />
</td>
</tr>
</table>
</form>
<script>document.getElementsByName('username')[0].focus();</script>
</td></tr>
<?php } ?>
<?php
if(!$_GET['signIn'] && !$_GET['loginFailed']){
if(is_array($arrTables)){
if(getLoggedAdmin()){
?><tr><td colspan="<?php echo ($tablesPerRow*3-1); ?>" class="TableTitle" style="text-align: center;"><a href="admin/"><img src=table.gif border=0 align="top"></a> <a href="admin/" class="TableTitle" style="color: red;"><?php echo $Translation['admin area']; ?></a><br /><br /></td></tr><?php
}
$i=0;
foreach($arrTables as $tn=>$tc){
$tChk=array_search($tn, array());
if($tChk!==false && $tChk!==null){
$searchFirst='?Filter_x=1';
}else{
$searchFirst='';
}
if(!$i % $tablesPerRow){ echo '<tr>'; }
?><td valign="top"><a href=<?php echo $tn; ?>_view.php<?php echo $searchFirst; ?>><img src=<?php echo $tc[2];?> border=0></a></td><td valign="top" align="left"><a href=<?php echo $tn; ?>_view.php<?php echo $searchFirst; ?> class="TableTitle"><?php echo $tc[0]; ?></a><br /><?php echo $tc[1]; ?></td><?php
if($i % $tablesPerRow == ($tablesPerRow - 1)){ echo '</tr>'; }else{ echo '<td width="50">&nbsp;</td>'; }
$i++;
}
}else{
?><tr><td><div class="Error"><?php echo $Translation['no table access']; ?><script language="javaScript">setInterval("window.location='index.php?signOut=1'", 2000);</script></div></td></tr><?php
}
}
?>

</table><br /><br /><div class="TableFooter"><b><a href=http://bigprof.com/appgini/>BigProf Software</a> - <?php echo $Translation['powered by']; ?> AppGini 4.61</b></div>

</div>
</html>

Hi,
I need a small help. Here is my situation.

I am using a MVC application (e.g. Joomla or Drupal) which has a .htaccess redirect rule that all requests are passed through index.php file. That's normal and this is my main application. Now I installed another application within the application folder structure. What I want do do here is to allow opening the third party application URLs after one logged into my main application.

Can anybody provide me some pointers to do the same? Please let me know if you need any further information on this. Any solution irrespective of framework will work.

Thanks!
Anupam

I am writing a small program that generates a sequential numbering array. I need to include potentially a prefix, leading zeros, a starting number, a suffix and a quantity and also reverse the generated values.

example:
P-000299-001
P-000298-001
P-000297-001
P-000296-001
P-000295-001
P-000294-001
P-000293-001
P-000292-001
P-000291-001
P-000290-001
P-000289-001

Here is my code to generate:

<?php
$quantity = "100";
$start = "200";
$leadingzeros = "000";
$prefix = "P-";
$suffix = "-001";

$i = $start + $quantity - 1;

while ($i >= $start)
{
echo $prefix . $leadingzeros . $i-- . $suffix . "<br />\n";
}
?>


The code all seem to function correctly until I increase the quantity to say 25000 numbers to be generated or if the number string gets too long and the server will just sit and spin until a "cannot be displayed error" appears in IE.


It had been suggested to abandone the array and simply write the generated sequence to a file and this is the code to generated the file it  - it really works great and is really fast.

<?php
$startTime = time(); // this is just for measuring execution time

$quantity = "25000";
$start = "26000";
$length = 6;
$prefix = "P-";
$suffix = "-001";

$file = "test.txt";

$fh = fopen($file, 'w') or die("Could not open $file for writing");
for($ix = 1, $nbr = $start; $ix <= $quantity; $ix++, $nbr--)
{
   fprintf($fh, $prefix.'%0'.$length.'d'.$suffix."\n", $nbr);
}

// all done, let's see how long it took:
$endTime = time();
echo "Script took about " . ($endTime - $startTime) . " seconds to run.";
?>



I am using this program to generate numbering files used in the printing industry. The sequential numbering works great.

I had to change your code slightly in order to produce a usable numbering file, I had to subtract "1" from the $start+$quantity in order to get the correct amount of numbers. For a start of 1000 and quantity of 10 you had 1010 as your first number and it should actually be 1009 to give you 10 numbers.

$fh = fopen($file, 'w') or die("Could not open $file for writing");
for($ix = 1, $nbr = $start+$quantity-1; $ix <= $quantity; $ix++, $nbr--)

P-001009-001
P-001008-001
P-001007-001
P-001006-001
P-001005-001
P-001004-001
P-001003-001
P-001002-001
P-001001-001
P-001000-001

Let's think of this as an 8.5" x 11" piece of paper going through a laser printer - if each page had one number on it the sequential number will be great.

Anyway, here is the next challenge: Let's say we have one 5.5" x 8.5" on an 8.5" x 11" sheet twice or two up. Each with its own number on the left and right side of the paper. That after printing will be cut and stacked on top of one another and produce a pile that is still in the right order. We need to take the $quantity+$start-1 and divide by 2 and then interleave the two sets of numbers and stop the numbering set at the starting number. easy huh!!!

P-001009-001
P-001004-001
P-001008-001
P-001003-001
P-001007-001
P-001002-001
P-001006-001
P-001001-001
P-001005-001
P-001000-001

Here is the code I have for an example:

<?php
$quantity = "10";
$start = "1000";
$leadingzeros = "00";
$prefix = "P-";
$suffix = "-001";

$i = $start + $quantity - 1;
$quantity2 = $quantity / 2;
$j = (int)($i - $quantity2);

while ($j >= $start)
{
echo $prefix . $leadingzeros . $i-- . $suffix ."<br />\n" . $prefix . $leadingzeros . $j-- . $suffix . "<br />\n";



}
?>

The third option is two completely different 5.5" x 8.5" items and two different numbering schemes on an 8.5" x 11" piece of paper.

Here is the code I have been using for it.

<?php
$quantity = "10";
$start = "1000";
$leadingzeros = "00";
$prefix = "P-";
$suffix = "-001";

$quantity2 = "10";
$start2 = "2000";
$leadingzeros2 = "000";
$prefix2 = "Q-";
$suffix2 = "-005";

$i = $start + $quantity - 1;
$k = $start2 + $quantity2 - 1;

while ($i >= $start)
{
echo $prefix . $leadingzeros . $i-- . $suffix . "<br />\n" .$prefix2. $leadingzeros2 . $k-- . $suffix2 . "<br />\n";
}
?>


Which produces:
P-001009-001
Q-0002009-005
P-001008-001
Q-0002008-005
P-001007-001
Q-0002007-005
P-001006-001
Q-0002006-005
P-001005-001
Q-0002005-005
P-001004-001
Q-0002004-005
P-001003-001
Q-0002003-005
P-001002-001
Q-0002002-005
P-001001-001
Q-0002001-005
P-001000-001
Q-0002000-005


Thanks in advance