PHP - String Manipulation | Insert After Body

Hi all,

I'm having a hard time with strings...

I am pulling data from an XML feed, and then trying to insert into my database. All the code is wrote, the problem is that some of the descriptions contain both ' and " so it is messing with my insert statement.

I can get over the ' by doing this: \"$newstring\" however it then fails on " 

I have tried every function I can think of:

str_replace, mysql_real_escape_string, htmlspecialchars, addslashes, stripslashes etc. etc. nothing seems to do the trick!

I have attached the code in full, would someone be able to take a look and help me out?

Any help would be greatly appreciated!

many thanks

Greens85

Hello all, been trying for over a day to get something to work and after searching and searching I could not find what I was looking for.  I found people looking to do something similar, but the answers seemed more complicated than I would think they need to be.  First off, I'm still horrible at arrays and loops so try not to laugh too hard if my code is waaaayyyy off...haha

I am essentially trying to tie products and quantities to a reservation.  The user has the ability to add items to the form.  I'm using jquery .clone to create each new item product and quantity form fields.  When the user submits the form jquery inputs the values of the cloned fields into 2 hidden text fields called "productsField" and "quantitiesField"  The values of these fields look something like value="1,2,2,1,3" depending on how many products were added.

What I want to do is explode both and then enter them into the database.  Seems simple enough, but apparently I am not getting it.

I thought something like this would work, but it is not.

  if (isset($_POST["reserve_button"])) {
   $theReservationID = $_SESSION['createdReservationID'];
  $items = explode (",",$_POST['productsField']); 
$quantities = explode (",",$_POST['quantitiesField']); 

// loop through array 
$number = count($items); 
for ($i=0; $i<=$number; $i++) 
{ 
    // store a single item number and quantity in local variables 
    $itno = $items[$i]; 
    $quant = $quantities[$i]; 
     
    if ($items[$i] <> '') { 
    mysql_query('INSERT INTO reservation_items (reservationID,productID,productQuantity) VALUES($theReservationID,$itno,$quant)'); 
    } 
} 
}

Any help would be greatly appreciated.

Thanks in advance,
Twitch

Hi guys,

I have a very simple add.php to add data to a mySQL db.

I have a menu/list drop down as one of my fields on my form and this shows an array of results from another table (ranks of the RAF) within my db.

When I click the save button I have it process a INSERT INTO command but all i get inputted into my staff table is the first word... eg if I chose "Pilot Officer" from the list menu and then click save all that would appear in my db is "Pilot".

Any clues? I will paste the php below...

Code: [Select]
<?php
include('config.php');
?>
<form action='' method='POST' enctype='multipart/form-data'>
<p><b>Rank:</b><br />
<select name="rank" id="rank">
<option selected>Please Select</option>
<?php
$query = "SELECT * FROM ranks ORDER BY rank ASC";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo "<option value=". $row["rank"] .">". $row["rank"] ."</option>";
}
?>
</select>
  <p><b>Forename:</b><br />
  <input name="forename" type="text" id="forename" value="" size="40">
<p><b>Surname:</b><br /><input name='surname' type='text' id="surname" value='' size="40" />
<p><b>Category:</b><br />
<select name="category" id="category">
<option selected>Please Select</option>
<?php
$query = "SELECT * FROM categories";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo "<option value=". $row["category"] .">". $row["category"] ."</option>";
}
?>
</select>
 
  <p><b>Email:</b><br /><input name='email' type='text' id="email" value='' size="50" />
  <p><b>Mobile:</b><br />
    <input name='mobile' type='text' id="mobile" value='' size="40" />
  </p>
  <input type='submit' value='Save' />
  <input type='hidden' value='1' name='submitted' />
</form>
   
<?php

if (isset($_POST['submitted'])) {

$rank = mysql_real_escape_string($_POST['rank']);
$forename = mysql_real_escape_string($_POST['forename']);
$surname = mysql_real_escape_string($_POST['surname']);
$category = mysql_real_escape_string($_POST['category']);
$email = mysql_real_escape_string($_POST['email']);
$mobile = mysql_real_escape_string($_POST['mobile']);

$sql = "INSERT INTO `staff` (`rank` ,  `forename` ,  `surname` ,  `category` ,  `email` ,  `mobile` ) VALUES ( '$rank' ,  '$forename' ,  '$surname' ,  '$category' ,  '$email' ,  '$mobile')"; 
mysql_query($sql) or die(mysql_error()); 

echo (mysql_affected_rows()) ? "Staff Added":"Nothing Added";

}
?>

Hi to everybody 

I need ur help because I’m trying to make a script in php to write the same data but with different date in MySQL depending on the splitting ($data06).... like a schedule...

 

For example if $data06 = annual and $data03 = “2019/01/01”

programm must create in MySQL :

2019/01/01

2020/01/01

2021/01/01

2022/01/01

2023/01/01

 

if $data06=“half year” will create 10 date , increasing 6 moths ...

 

But I have a problem at finish of code 

                                                                                                                                                     switch ($data06) {

                                                                                                                                             case 'annual':                                                                                                  $numrate = 5;                                                                                                 $aumdata = "+12 months"; 

break;

                                                                                                                                                                                           case 'half year':                                                                                          $numrate = 10;                                                                                                              $aumdata = "+6 month";                                                                                                              break;

                                                                                                                                                                                                                                                                                                                                                                      default:                                                                                                             echo "error";              
break;                                                                                            
}                                                                                                          

                                                                              $sql = "INSERT into $nometb (                                                                                                              name, scadenza                                                                                                                                    ) values (                                                                                                           '$data01',   '$data03'                                                                                             )";

                                                                                              if ($conna->query($sql) === TRUE) {} else {die('ERROR'. $conna->error); }

                                               

                                                                              //IMPORT NEXT AND NEW DATE

                                                                              $newDate = date_create($data03);                                                                          

                                                                              for ($mul = 2; $mul <= $numrate; ++$mul) {

                                                                                                                                                                                           

                                                                                            

                                                                                              $datanuova = date_create($data03);                                                                                              $datanuova->modify($aumdata);                                                                                            $datanuova->format('yy/m/d');                                                                                            $newDate = $datanuova->format('yy/m/d');

                                                                                             

                                                                                             

$sql = "INSERT into $nometb (                                                                                                              name, scadenza                                                                                                                                    ) values (                                                                                                           '$data01',   '$newDate'                                                                                             )";

                                                                                              if ($conna->query($sql) === TRUE) {} else {die('ERROR'. $conna->error); }

                                                                                          

                                                                                             

//HERE THERE IS ERROR                                                                                              $data03 = $newDate;

                                                                                             

                                                                                             

                                                                                             

                                                                                              if ($conna->query($sql) === TRUE) {} else {die('ERRORE NELL\'IMPORTAZIONE'. $conna->error); }

                                                                               }

                                               

                                                              

                                                               }

                                               }

                               }
 

$data03 need to be a string but I have problem at the end to convert a date in string

 

 How I can resolve ?

 

many thanks 

Francesco 

Hi everyone,

I'm new to this group and new to php. I have created a multi-part form that allows the user the option to add multiple input fields to a form to upload images. Here is the form structu

Code: [Select]
<form action="Scripts/processreports2.php" method="post" enctype="multipart/form-data" name="report_form" target="uploader" class="reportfrm">
<fieldset>
        <legend>Upload your images</legend>
        <ol id="add_images">
          <li>
        <input type="file" class="input" name="files[]" />
          </li>
  <li>
        <input type="file" class="input" name="files[]" />
          </li>
  <li>
        <input type="file" class="input" name="files[]" />
          </li>
        </ol>
        <input type="button" name="addFile"  id="addFile" value="Add Another Image" onclick="window.addFile(this);"/>
</fieldset>
        <p>* indicates a required field.</p>
        <input name="submit" type="submit" id="submit" value="Send Info!" />
</form>

Through php a maximum of three input fields are fed into an array that checks to make sure that the uploaded files are images and not some other type of file. The uploading porition of this script works.

Now I am trying to get the values of the input fields as a string and insert them into the database as one record.

Let's say the user has three files they want to upload. I have managed to get the files as a string ie; file1.jpg, file2.jpg, file3.jpg but what is happening is that I am getting three separate records with  file1.jpg, file2.jpg, file3.jpg in them. If the user has only two files to upload then I get two separate records with file1.jpg and file2.jpg in them. (Hope that makes sense). I want one record.

I have been struggling with this since Monnday and while every day I get closer, this is as close as I can get. Below is the php code.

#connect to the database

mysql_connect("localhost", "root", "");

mysql_select_db("masscic");

//Upload Handler to check image types

function is_image($file) {

$file_types = array('jpeg', 'gif', 'bmp'); //acceptable file types

if ($img = getimagesize($file)){

//echo '<pre>';

//print_r($_FILES); used for testing

//print_r($img); used for testing

if(in_array(str_replace('image/', '', $img['mime']), $file_types))

return $img;

}

return false;
}

//form submission handling

if(isset($_POST['submit'])) {

//file variables

$fname = $_FILES['files']['name'];

$ftype = $_FILES['files']['type'];

$fsize = $_FILES['files']['size'];

$tname = $_FILES['files']['tmp_name'];

$ferror = $_FILES['files']['error'];

$newDir = '../uploads/'; //relative to where this script file resides

for($i = 0; $i < count($fname); $i++) {
    //echo 'File name ' . $fname[$i] . ' has size ' . $fsize[$i]; used for testing

if ($ferror[$i] =='UPLOAD ERR OK' || $ferror[$i] ==0) 

{

if(is_image($tname[$i]))

{

//append the tmp_name($tname) to the file name ($fname) and upload to the server

move_uploaded_file($tname[$i], ($newDir.time().$fname[$i])); 

echo '<li><span class="success">'.$fname[$i].' -- image has been accepted<br></span></li>';

}else 

echo '<li><span class="error">'.$fname[$i].' -- is not an accepted file type<br></span></li>';

}

if (is_array($fname))

$files = implode(', ',$fname);

//else $files = $fname;

$sqlInsert = mysql_query("INSERT INTO files (file_names) VALUES('$files')") or die (mysql_error());

}
}

I have a table with postcodes in it. At some point some of the codes will be entered with spaces (LA12 5TH) and some without (LA17HU) what i need is a function to check if there is a space, if not - count back 3 characters from the end of the string and insert a space.

I don't know which string function to use - looked at pad but that seems to be for either end of string and not the middle - any ideas?

Right, I have a 2 part question. At the moment, each user has an image stored for them which is linked to via a field in the database.

Now I'm showing the image by a simple <img /> tag and just including the result of the filename from a database query, which works perfectly fine but I want to take this a step or two further.

1) Firstly, is it possible to get variables of width, height etc for images that are stored on the server as a file? Much like this information can be accessed when a user uploads an image, is it possible to do it if I'm showing the image once it's uploaded and stored?

2) If I can get dimensions for the image, is it possible to SCALE it properly down to a suitable size? For example, the maximum image can be 50 x 50, but images that are smaller would be scaled up PROPORTIONALLY or if they were bigger they would be scaled down PROPORTIONALLY. For example, if an image is 100 x 200, I don't want it scaled down to 50 x 50, I want it so that it remains to scale and is scaled down to 25 x 50.

I am building an application that creates a label for a manufacturing company... it finds an appropriate font size for given text, and then draws it and displays the image as a bmp(it is required to be a bmp).  That is all fine and dandy and working correctly.  The problem is that the label must have a depth of 2 bits for it to work correctly on their machine...I am using the following code, but cannot get a bit depth lower than 24.  iMagick and GD are both available on the server.

Code: [Select]
$text = $_GET['text'];

if (isset($text)) {



$image = new Imagick();
$image->setResolution(71.5, 71.5);
$image->newImage(160, 40, new ImagickPixel('black'));

$draw = new ImagickDraw();
$draw->setFillColor('white');
$draw->setStrokeColor(new ImagickPixel('black'));
$draw->rectangle(0, 0, 159, 39);

$font_size = 25;
$font_name = 'arial.ttf';

do
{
$font_size--;
$bbox=imagettfbbox($font_size, 0, $font_name, stripcslashes($text));
$right_text = $bbox[2];
$left_text = $bbox[0];
$width_text = $right_text - $left_text;
$height_text = abs($bbox[7] - $bbox[1]);
}
while ($font_size>9 && ($height_text>40 || $width_text>160));

if ($height_text>40 || $width_text>160 || $font_size<10)
{
echo 'The text given will not fit on the label.<br />';
}
else
{
$draw->setFont($font_name);
$draw->setFontSize($font_size);
$draw->setFillColor('black');
$draw->setTextAntialias(false);
$draw->setGravity (Imagick::GRAVITY_CENTER);
$draw->annotation(0, 0, stripcslashes($text));

$image->drawImage($draw);
$image->blackthresholdImage( "#999999" );
$image->whitethresholdImage( "#999999" );

$image->setImageType(1);

$image->setImageFormat('bmp');

$image->writeImage("flavor_labels/".$text.".bmp");
echo '<img src="flavor_labels/'.$text.'.bmp" /><br /><p>Right click this image and click Save As or Save Image As.  <br />Enter in the desired label name and save it to the desired destination.</p>';

}

}

I am currently working on a website where users can go and upload images and select different types of filters for the images and then let the user see the result of the filter. This has all gone fine and the image filters are working, the only problem I am having is trying to add a function that allows the user to convert the image so that it looks like a Polaroid. I have seen sites that do similar things but cant work out how its done, wondering if someone could shed some light on the whole area?
thanks

Hello,
I had this case:
Text is stored in mysql table in the means of html, i.e. it contains <p> ,<br /> .... I want to display it on a php page, I had 2 questions:

I want to display the first 400 characters, then the second 300 each on different <div> , so I need to save them each on different variable? and what about html tags?
Thanks

Hello

I have this code:
Code: [Select]
$data = mysql_query("SELECT  * FROM remind WHERE  DATE_SUB(CURDATE(), INTERVAL 1 DAY) = event_date  ") or die(mysql_error());
Basically what I need, I have a table (remind) with lots of dates of events (event_date).

1 day before the event and on the day of the event, I want to send an e-mail to my customers, automatically.

This up mentioned code send e-mails to all the upcoming events, not ONLY to the ones TOMORROW or TODAY.

I need something like this:

If today is 01-01-2011 AND I have an event on 02-01-2011

I want that the SQL code will find and send the e-mail only for the event tomorrow and on 02-01-2011 send again the reminder of today's event.
*I have events every day BUT I want to send a reminder ONLY 1 day before and on the day of the event.

Any help ??

Hello,

I have a code that adds 1 month to a specific date every month.
Code: [Select]
$newdate = strtotime ( '+1 month' , strtotime ( $b_date ) ) ;
$new_date = date ( 'Y-m-d' , $newdate );

the thing is some month of the year do not contain the SAME amount of days.

For example:

If the date was 2011-01-31

+ 1 month

=

03-03-2011

Is there any way to add a month (+1 month) but make it consider the calendar.

lets say that I had 2011-01-31 --> +1 month == 2011-28-02 (the last day of the next month if there is NO similar days in month

Thanks

I am trying to find a workaround for people using bookmarks and executing them simultaneously forcing a script to run thousands of times in just a second. Is there a way I can implement a token or a short bit of javascript that would force the user to use the link vs bookmarked URL pages?

Sorry if I am being vague here but its really causing me issues having people doing this on my site.

Hi have an array() in which I would like to manipulate certain elements:

Code: [Select]
Array
(
    [TESCO] => Array  (
            [Veg] => Array (
                    [Potatoe] => 12
                    [Cabbage] => 24
                    [Cucumber] => 56
                )
            [Meat] => Array (
                    [Chicken] => 54
                    [Beef] => 89
                )
        )

    [ASDA] => Array (
            [Veg] => Array (
                    [Potatoe] => 12
                    [Cabbage] => 24
                    [Cucumber] => 56
                )
            [Meat] => Array (
                    [Chicken] => 23
                    [Beef] => 90
                )
        )
)

How would I go about adding the price of my meat section together e.g. Chicken + Beef from ASDA = 113

Also how to add/remove elements from Meat/Veg?
Like adding Pork

Cheers