PHP - I Can't Upload Anything On Increasing The Number Of Words.

Create a data form that should accept odd number of words in a particular sentence Input Example: I am working in retailon. and should display the output as reversing first and last word and second word to fourth word and so on and the middle word should be same and should also display the number of words. Output Example: retailon in working am i. words=5. Input:I am Working in Google. Output:Google in Working am I. Words:5

I'm getting the dreaded " Invalid parameter number: number of bound variables does not match number of tokens" error and I've looked at this for days.  Here is what my table looks like:

|  id          | int(4)       | NO   | PRI | NULL    | auto_increment |
| user_id     | int(4)       | NO   |     | NULL    |                |
| recipient   | varchar(30)  | NO   |     | NULL    |                |
| subject     | varchar(25)  | YES  |     | NULL    |                |
| cc_email    | varchar(30)  | YES  |     | NULL    |                |
| reply       | varchar(20)  | YES  |     | NULL    |                |
| location    | varchar(50)  | YES  |     | NULL    |                |
| stationery  | varchar(40)  | YES  |     | NULL    |                |
| ink_color   | varchar(12)  | YES  |     | NULL    |                |
| fontchosen  | varchar(30)  | YES  |     | NULL    |                |
| message     | varchar(500) | NO   |     | NULL    |                |
| attachment  | varchar(40)  | YES  |     | NULL    |                |
| messageDate | datetime     | YES  |     | NULL    |        

Here are my params:

            $params = array(                 
               ':user_id' => $userid,                 
               ':recipient' => $this->message_vars['recipient'],                 
               ':subject' => $this->message_vars['subject'],                 
               ':cc_email' => $this->message_vars['cc_email'],                 
               ':reply' => $this->message_vars['reply'],                 
               ':location' => $this->message_vars['location'],                 
               ':stationery' => $this->message_vars['stationery'],                 
               ':ink_color' => $this->message_vars['ink_color'],                 
               ':fontchosen' => $this->message_vars['fontchosen'],                 
               ':message' => $messageInput,                 
               ':attachment' => $this->message_vars['attachment'],                 
               ':messageDate' => $date             );

Here is my sql:

$sql = "INSERT INTO messages (user_id,recipient, subject, cc_email, reply, location,stationery, ink_color, fontchosen, message,attachment) VALUES( $userid, :recipient, :subject, :cc_email, :reply, :location, :stationery, :ink_color, :fontchosen, $messageInput, :attachment, $date);";

And lastly, here is how I am calling it:
            $dbh = parent::$dbh;             
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);              
           if (empty($dbh))    return false;             
                  $stmt = $dbh->prepare($sql);             
                 $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));              
           if (!$stmt) {    print_r($dbh->errorInfo());              }

I know my userid is valid and and the date is set above (I've echo'd these out to make sure).  Since the id is auto_increment, I do not put that in my sql (though I've tried that too), nor in my params (tried that too).  What am I missing?  I feel certain it is something small, but I have spent days checking commas, semi-colons and spelling.  Can anyone see what I'm doing wrong?

There are two things I want done.

1. Grab the current date in TIMESTAMP form and increase by a certain number of days as assigned by $days()
2. Similar to the previous one, it will grab an already specified TIMESTAMP, and work from there

All it echoes is 86400, which I assume is the number of seconds?

Code: [Select]
<?php
$days = 1;
echo strtotime("+$days days", strtotime($date));
?>

In the following code the memory usage balloons up to 500MB

       while ($priceRow = $pricestimes->fetch_assoc()) {

            //if another product
            if ($last_product_id != $priceRow['product_id']){
                // 100 products together
                if ($count % 100 == 0) {
                    echo 'MEM AFTER 100 products- ' . (memory_get_usage(true) / 1024 ). PHP_EOL;
                    //add_price_array_to_db($pricesArr) ;
                    $pricesArr = array();
                }
                $count++;
                $last_product_id = $priceRow['product_id'] ;
            }
            $pricesArr[$priceRow['product_id']][$priceRow['insertion_timestamp']] = $priceRow['price'];

        }

The 'echo MEM AFTER 100 products-' line shows that the memory of the script keeps on increasing. Any ideas why there is a memory leak here ? The $pricestimes is a huge mysqli resultset with 23 million rows, so I suspect that may be the issue here. Unless there is something wrong with the script logic.   btw the 'add_price_array_to_db($pricesArr)' is uncommented in the real code. But even with this line commented out the memory leak is there.   Thanks
Edited by nik_jain, 17 August 2014 - 01:30 PM.

Hello, I have problem durring binding update query. I can't find what is causing problem.

public function Update(Entry $e)
    {
        try
        {
            $query = "update entry set string = $e->string,delimiter=$e->delimiter where entryid= $e->id";
            $stmt = $this->db->mysqli->prepare($query);
            $stmt->bind_param('ssi',$e->string,$e->delimiter,$e->id);

            $stmt->close();
           

        }
        catch(Exception $ex)
        {
            print 'Error: ' .$ex->getMessage();
        }
    }

When I run function update I'm getting next error:Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement   Can you help me to solve this problem ?
Edited by danchi, 17 October 2014 - 10:25 AM.

I need to display a number(the number is retrieved from the db) in the form input field such that only the last 4 digits is visbile, the remaining can be masked as * or X or whatever is applicable.

I know the last 4 can be obtained as follows:

    Code: [Select]
$number=substr($number,-4,4);
 
But when i hit the submit button the form validates the input field and checks if the number is a valid number of a specific format.
Therefore when I click on the submit button then I should still be able to unmask the masked numbers or do something similar that would help me validate the whole number.

  Code: [Select]
  <input type="text" name="no" value="<?php if(!empty($number)){ echo $number;} ?>">

Hi everyone,

I have a page that i use to upload images to my website, i got a bit fed up of uploading one at a time so i decided to add multiple file fields to the form to upload multiple images at the same time.

Im having a few problems, iv read up he http://www.php.net/manual/en/features.file-upload.multiple.php and it seems all i have to do is add [] to the form names to turn them into arrays. However when i come to upload the images, i keep getting the "$error[] = "Incorrect format!...." error from the code below. I cant seem to figure out what the problem is.

Could anybody please point me in the right direction?


<?php 
session_start();

$id = $_SESSION['id'];

$connect = mysql_connect("localhost","leemp5_admin","p7031521");
mysql_select_db("leemp5_database");

$query = mysql_query("SELECT * FROM users WHERE id='$id'");
$row = mysql_fetch_assoc($query);

$username = $row['username'];

$submit = $_POST['submit'];

$type = $_FILES['image']['type'];
$size = $_FILES['image']['size'];
$max_size = "1000"; 
$width = "100"; 
$height = "100";
 
$error = array();

function make_thumb($image_name,$filename,$new_width,$new_height) 
{

$ext=getExtension($image_name); 

if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext)) 

$source_image=imagecreatefromjpeg($image_name);   

if(!strcmp("png",$ext)) 

$source_image=imagecreatefrompng($image_name);

if(!strcmp("gif",$ext)) 

$source_image=imagecreatefromgif($image_name); 

$old_x=imageSX($source_image);

$old_y=imageSY($source_image);   

$ratio1=$old_x/$new_width; 

$ratio2=$old_y/$new_height; 

if($ratio1>$ratio2)

{ 

$thumb_width=$new_width; 

$thumb_height=$old_y/$ratio1; 

} 

else 

{ 

$thumb_height=$new_height;

$thumb_width=$old_x/$ratio2; 

} 
  

$destination_image=ImageCreateTrueColor($thumb_width,$thumb_height);   

imagecopyresampled($destination_image,$source_image,0,0,0,0,$thumb_width,$thumb_height,$old_x,$old_y);   

if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))

{

imagejpeg($destination_image,$filename); 

}

if(!strcmp("png",$ext)) 

{

imagepng($destination_image,$filename); 

}

if(!strcmp("gif",$ext)) 

{

imagegif($destination_image,$filename); 

}

imagedestroy($destination_image); 

imagedestroy($source_image); 
}   


function getExtension($str)
{ 

$i = strrpos($str,"."); 

if (!$i) { return ""; } 

$l = strlen($str) - $i; 

$ext = substr($str,$i+1,$l); 

return $ext; 
}   

if($submit) 
{ 

$image=$_FILES['image']['name']; 

if ($image) 

{ 

$filename = stripslashes($_FILES['image']['name']);   

$extension = getExtension($filename); 

$extension = strtolower($extension); 

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

{ 

$error[] = "Incorrect format! Please make sure your image is a .jpg, .jpeg, .png or .gif file.";

} 

else

{ 

$size=getimagesize($_FILES['image']['tmp_name']); 

$sizekb=filesize($_FILES['image']['tmp_name']); 
  

if ($sizekb > $max_size*1024) 

{ 

$error[] = "Your image is too big! The maximum upload size is 1MB.";

}   

else

{

$image_name=time().'.'.$extension; 
 

$newname="uploads/" . $username . "/images/".$image_name; $copied = copy($_FILES['image']['tmp_name'], $newname); 

if (!$copied) 

{ 

$error[] = "There was an error uploading your image. Please try again!";

} 

else 

{ 

$thumb_name='uploads/' . $username . '/images/thumbs/thumb_'.$image_name; 
 

$thumb=make_thumb($newname,$thumb_name,$width,$height); 

}

}

}

}

else

{

$error[] = "Please select an image to upload!";

}

if(empty($error))

{

echo "Upload Successfully!<br />"; 

echo '<img src="'.$thumb_name.'">';

mysql_query("INSERT INTO images VALUES ('','$username','$image_name','','','','','uploads/$username/images/$image_name','uploads/$username/images/thumbs/thumb_$image_name','$type','$size')");

}

else

{
    

echo implode($error);

}
}
?>
<form method="post" enctype="multipart/form-data" action="upload_images.php">
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="submit" name="submit" value="Upload">
</form>


Thanks

I have code written for image uploading, but it doesn't allow multiple images on a single upload, and doesn't re-size.

Anyone willing to share a good upload script that will do the following?:
-Allow multiple image uploads (10+ per submission),
-Re-size images on upload, and
-Rename images.

Thanks
Brett

Hey

I have a string that looks like the following:
Quote

top-php-tutorials-2.html


I have a script that cycles through each page. The 2 in the quote above is the page number.

How can I extract the number between the - and the .html and replace it with another number?

I've tried
Code: [Select]
substr($engine->selectedcaturl, 0,-6).$v.".html"But then I realised this only works for numbers that are 1 digit long

Any input would be appreciated

hello, im trying to see if there is a function that can get the value of the last row in mysql and see what is in field initial (this is letters A-Z) and make it one letter higher.  then, when it reaches letter Z, wrap around to A again.

Hello dear friends,

I've an idea so let us say we have paragraph with bad words 

Code: [Select]
$para = "Hello shit oh shit what the hell this is shit day";
Now let say we create textarea

Code: [Select]
<textarea id="badword" name="badword">
</textarea>
and let us say we have database table as following

Code: [Select]
CREATE TABLE `banned` (
 `id` varchar(50) NOT NULL default '',
 `badwords` text NOT NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

consider we have connetion and can update mysql table badwords

1- now how we can enter word per line in this textarea

example we entered in this textarea per line
shit
hell
die
death

then by click on submit it stored in an database table 'banned' as

INSERT INTO `banned` VALUES ('1', 'shit,hell,die,death');


2- if we called `badwords` from table 'banned' how then can put 'shit,hell,die,death' into array so we can exclude it from $para

 
can someone please help me in this , how to store textarea per line as sperated words in database table and how then call it back as array to exclude it form our paragraph

Or

it there any other simple way doing the same 

thank you

: : NEW Problem

I want to replace bad words which someone has inputted into my HTML textarea, with something like [CENSORED].
Here's what I've got so far:
note: $review is the posted textarea name.
Code: [Select]

$words_text = 'badwords.txt';
$bad_words = file($words_text);
               
$good_words = str_ireplace($bad_words,'[CENSORED]',$review);
         
echo $good_words;


The thing is, if I type bad words in the textarea, I still get bad words when I echo $good_words.

I don't know why I'm getting this, any ideas

files that upload during insert/submit form was gone , only files upload during the update remain , is the way query for update multiple files is wrong ?

$targetDir1= "folder/pda-semakan/ic/";
if(isset($_FILES['ic'])){
     $fileName1 = $_FILES['ic']['name'];
 $targetFilePath1 = $targetDir1 . $fileName1;
 //$main_tmp2 = $_FILES['ic']['tmp_name'];
$move2 =move_uploaded_file($_FILES["ic"]["tmp_name"], $targetFilePath1);
}

$targetDir2= "folder/pda-semakan/sijil_lahir/";
if(isset($_FILES['sijilkelahiran'])){
     $fileName2 = $_FILES['sijilkelahiran']['name'];
 $targetFilePath2 = $targetDir2 . $fileName2;
$move3 =move_uploaded_file($_FILES["sijilkelahiran"]["tmp_name"], $targetFilePath2);
}

$targetDir3= "folder/pda-semakan/sijil_spm/";
if(isset($_FILES['sijilspm'])){
     $fileName3 = $_FILES['sijilspm']['name'];
 $targetFilePath3 = $targetDir3 . $fileName3;
$move4 =move_uploaded_file($_FILES["sijilspm"]["tmp_name"], $targetFilePath3);
}



$query1=("UPDATE semakan_dokumen set student_id='$noMatrik', email= '$stdEmail', surat_tawaran='$fileName', ic='$fileName1',sijil_lahir='$fileName2',sijil_spm= '$fileName3' where email= '$stdEmail'");

 

hello,  i have a start time and an end time (no dates).  the following works great, except for when the start time is at night, and the end time is in the morning.  im thinking if i can do an if the number is negative, add 24, that it will resolve my issue.

any ideas?

Code: [Select]
$tbilled = $tfinish - $tstart;

hi,

now i have something like this:

$pizza  = "piece1 piece2 piece3 piece4";
$one_word = explode(" ", $pizza);

but i want to get 2 words together, like that:

$two_words[0]='piece1 piece2';
$two_words[1]='piece3 piece4';
$two_words[2]='piece2 piece3';
$two_words[3]='piece1 piece4';

if it's impossible with explode, then it's fine if you use some other function, i don't care as long as it works.

thank you, tastro