PHP - Small Issue Inserting And Retrieving A Row With Php And Ajax

First, here's some code:

Code: [Select]
$result = mysql_query("SELECT standard FROM thestandards WHERE id={$theSearch}", $connection);
if (!$result) {
     die("Database connection failed: " . mysql_error());
}

while ($row = mysql_fetch_array($result)) {
     $query = $row[0];
}

// echo $testing = nl2br($query);

$subStrings = explode('\n', $query);

echo $subStrings[0] . "<br />";   // outputs entire query
echo $subStrings[1] . "<br />";   // undefined offset
echo $subStrings[2] . "<br />";   // undefined offset
echo $subStrings[3] . "<br />";   // undefined offset   
So, the data I'm retrieving from the database is several small paragraphs.  I want to take these paragraphs, separate them, and put them into an array.  I tried using the explode function with the newline char, but for some reason it doesn't work.  I can get it to work if I want to go explicitly add "\n"s in the database everywhere, but that just doesn't seem practical.  nl2br doesn't work for what I need, but I find it interesting that this function is somehow able to "see" all the newlines in the query, whereas the explode function cannot.  Explode is really what I need, but I've tried '\n', '\r', '\r\n' and nothing works.  Thanks for the help.

Hi Guys, I have a small issue with a new php script I wrote.  It works fine, except for one issue.  When the scrip emails me the info it captures, I need it to have the email sent to me from the person filling out the form.  i.e.  from the email address located in the $email field.  It does not.  Here's the code. (domain.com is just a dummy name to hold the spot, obviously.)

<?php

/* Subject and email */

   $emailSubject = 'Centre Street Registration';
   $webMaster = 'email@domain.com';

/* Gathering Data */

   $firstname = $_POST['FirstName'];
   $lastname = $_POST['LastName'];
   $email = $_POST['Email'];
   $daytime = $_POST['Daytime'];
   $home = $_POST['Home'];
   $citytown = $_POST['CityTown'];
   $movingwhen = $_POST['MovingWhen'];
   $hearofus = $_POST['HearofUs'];
   $contactmethod = $_POST['ContactMethod'];
   $squareft = $_POST['SqareFt'];
   $important = $_POST['Important'];
   $pricerange = $_POST['PriceRange'];
   
   $body = <<<EOD


First Name: $firstname
Last Name: $lastname
Email: $email
Daytime Number: $daytime
Home Number: $home
City: $citytown
Moving When: $movingwhen
Hear of Us: $hearofus
Contact Method: $contactmethod
Square Feet: $squareft
Important to You: $important
Price Range: $pricerange

Excel Data: $firstname,$lastname,$email,$daytime,$home,$citytown,$movingwhen,$hearofus,$contactmethod,$squareft,$important,$pricerange
EOD;

   $headers = "From: $email";
   $headers .= "Conten-type: text/html";
   $success = mail($webMaster, $emailSubject, $body);

/* Results rendered as HTML */

/*   $theResults = 'domain.com'; */

header( "Location: http://www.dommain.com/thankyou_centre.shtml" );
   
?>

I'm using a wordpress theme which comes with a zoom feature for the product (main image and image gallery thumbnails). 
It currently opens the primary image (and any thumbnail) in a modal window which is quite ugly for a product showcase. 

Code is:

Code: [Select]
    $imgtag = '<img src="'.$src.'"'.$titleattr.' alt="'.$alt.'" width="'.$width_a.'" height="'.$height_a.'" '.$classes.' />';
   
    if (value_is_true($zoom))
    return '<a href="'.ecarturl($img->id,'images').'/'.$img->filename.'" class="'.$zoomfx.'" rel="product-'.$this->id.'">'.$imgtag.'</a>';
I'm trying to implement Cloudzoom (http://www.professorcloud.com/mainsite/cloud-zoom-integration.htm)

I changed the code to:
Code: [Select]
$imgtag = '<a href="'.ecarturl($img->id,'images').'/'.$img->filename.'" class = "cloud-zoom" id="zoom1" rel="adjustX: 10, adjustY:-4, zoomWidth:150, zoomHeight:150, position:\'inside\'"> <img src="'.$src.'"'.$titleattr.' alt="'.$alt.'" width="'.$width_a.'" height="'.$height_a.'" '.$classes.' /></a>';

if (value_is_true($zoom))
return '<a href="'.ecarturl($img->id,'images').'/'.$img->filename.'" class="cloud-zoom-gallery" rel="useZoom: \'zoom1\'">"'.$imgtag.'</a>';
HTML Output:
Code: [Select]
    <div id="main-picture-default">
    <a href="http://www.url.com?siid=9/2-9202.jpg" class = "cloud-zoom" id="zoom1" rel="adjustX: 10, adjustY:-4, zoomWidth:150, zoomHeight:150, position:'inside'"> <img src="http://www.url.com?siid=9&#038;360,450,1,100,2441305929" alt="product-picture" width="360" height="450"  /></a> </div>
    <div id="thumbs">
    <ul id="thumbs-list-default">
   
    <li class="one_third "><a href="http://www.url.com?siid=9/2-9202.jpg" class="cloud-zoom-gallery" rel="useZoom: 'zoom1'">&#8220;<a href="http://www.url.com?siid=9/2-9202.jpg" class = "cloud-zoom" id="zoom1" rel="adjustX: 10, adjustY:-4, zoomWidth:150, zoomHeight:150, position:'inside'"> <img src="http://www.url.com?siid=9&#038;64,64,1,452849676" alt="thumb" width="64" height="64"  class="thumb-picture" /></a></a></li>
    <li class="one_third "><a href="http://www.url.com?siid=17/2-9203.jpg" class="cloud-zoom-gallery" rel="useZoom: 'zoom1'">&#8220;<a href="http://www.url.com?siid=17/2-9203.jpg" class = "cloud-zoom" id="zoom1" rel="adjustX: 10, adjustY:-4, zoomWidth:150, zoomHeight:150, position:'inside'"> <img src="http://www.url.com?siid=17&#038;64,64,1,1330882420" alt="thumb" width="64" height="64"  class="thumb-picture" /></a></a></li>
    </ul>
The primary image zooms just fine. 

The trouble I have now caused is as follows: 

- On hovering the thumbnails, they automatically zoom. They shouldn't. Rather on clicking them it should change the primary image to that image. 
- There is a " on the page above each thumbnail which links to the thumbnail images bigger image, and on click it shows "loading" on the primary image but doesn't actually change the image.

How can I fix my code to work the way the script works he http://www.professorcloud.com/mainsite/cloud-zoom-test.htm, so the thumbnail changes the primary image and the zoom doesn't occur on the thumbnail, only the primary image? 

Thanks!

Note: Would changing the last line `'.$imgtag.'` to `'.ecarturl($img->id,'images').'/'.$img->filename.'` be the fix? Don't want to try it before I get confirmation

Hi:

I have another small issue like the one I just posted about.

I am trying to get the full state name based upon the state abbreviation.

Like this:
Code: [Select]
<?php

$query=mysql_query("SELECT full_state FROM zip_codes WHERE abbr_state = abbr_state") or die("Could not get data from db: ".mysql_error());

$full_state=$result['full_state'];

?>

...

State Name: <input type="text" name="full_state" value="<?php echo $full_state; ?>" /><br />
[CODE]

No errors, but also no "full_state" appears.

(It is pulling in the correct "abbr_state")

What am I missing here?

Hello all,

I'm designing an upload file section for a home medical company.
So far it has been going great, I am uploading files and they're being successfully inserted into my MYSQL Table.
However, my issue is when I download the files they claim to be corrupted and unusable.
If I save the PDF files to my desktop they won't open at all, they claim to be corrupted. If I download a JPG and then open it in photshop it warns me
the file may be corrupted, knowing it is not I clicked "yes". The jpg actually opens and looks like the image, however about 50 pixels on the bottom get cut off and look like a messy TV screen, if that makes sense.

Wondering if anyone has had this similar issue, the uploading part is not the issue - just downloading the files.

My Upload Form Code:

Code: [Select]
<p><a href="upload.php">Upload a File</a>&nbsp;&nbsp;<a href="../admin/admin.php">Back to Control Panel</a></p>
<form action="add_file.php" method="post" enctype="multipart/form-data">
       <input type="file" name="uploaded_file"><br>
       <input type="submit" value="Upload file">
</form>
       <p>
        <a href="list_files.php">See all files</a>
       </p>
My Add File Code (This is working fine but may cause issues with downloading?)
Code: [Select]
<?php
// Check if a file has been uploaded
if(isset($_FILES['uploaded_file'])) {
    // Make sure the file was sent without errors
    if($_FILES['uploaded_file']['error'] == 0) {
        // Connect to the database
       $dbLink = new mysqli('localhost', 'vzimbel_user', 'webdesign1', 'vzimbel_db');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
 
        // Gather all required data
        $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
        $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
        $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
        $size = intval($_FILES['uploaded_file']['size']);
 
        // Create the SQL query
        $query = "
            INSERT INTO `file` (
                `name`, `mime`, `size`, `data`, `created`
            )
            VALUES (
                '{$name}', '{$mime}', {$size}, '{$data}', NOW()
            )";
 


        // Execute the query
        $result = $dbLink->query($query);
 
        // Check if it was successfull
        if($result) {
            echo 'Success! Your file was successfully added!';
        }
        else {
            echo 'Error! Failed to insert the file'
               . "<pre>{$dbLink->error}</pre>";
        }
    }
    else {
        echo 'An error accured while the file was being uploaded. '
           . 'Error code: '. intval($_FILES['uploaded_file']['error']);
    }
 
    // Close the mysql connection
    $dbLink->close();
}
else {
    echo 'Error! A file was not sent!';
}
 
// Echo a link back to the main page
echo '<p>Click <a href="upload.php">here</a> to go back</p>';
?>


My List File Code (This is working fine also, but does contain the link that I click when I want to download a file)

Code: [Select]
<?php
         $dbLink = new mysqli('localhost', 'vzimbel_user', 'webdesign1', 'vzimbel_db');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
     
    // Query for a list of all existing files
    $sql = 'SELECT `id`, `name`, `mime`, `size`, `created` FROM `file`';
    $result = $dbLink->query($sql);
     
    // Check if it was successfull
    if($result) {
        // Make sure there are some files in there
        if($result->num_rows == 0) {
            echo '<p>There are no files in the database</p>';
        }
        else {
            // Print the top of a table
            echo '<table width="100%">
                    <tr>
                        <td><b>Name</b></td>
                        <td><b>Mime</b></td>
                        <td><b>Size (bytes)</b></td>
                        <td><b>Created</b></td>
                        <td><b>&nbsp;</b></td>
                    </tr>';
     
            // Print each file
            while($row = $result->fetch_assoc()) {
                echo "
                    <tr>
                        <td>{$row['name']}</td>
                        <td>{$row['mime']}</td>
                        <td>{$row['size']}</td>
                        <td>{$row['created']}</td>
                        [u][b]<td><a href='get_file.php?id={$row['id']}'>Download</a></td>[/b][/u]
                    </tr>";
            }
     
            // Close table
            echo '</table>';
        }
     
        // Free the result
        $result->free();
    }
    else
    {
        echo 'Error! SQL query failed:';
        echo "<pre>{$dbLink->error}</pre>";
    }
     
    // Close the mysql connection
    $dbLink->close();
    ?>


And here is my Get File page. This is where my problem lies. (I think)

Code: [Select]
<?php
// Make sure an ID was passed
if(isset($_GET['id'])) {
// Get the ID
    $id = intval($_GET['id']);
 
    // Make sure the ID is in fact a valid ID
    if($id <= 0) {
        die('The ID is invalid!');
    }
    else {
        // Connect to the database
      $dbLink = new mysqli('localhost', 'vzimbel_user', 'webdesign1', 'vzimbel_db');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
     
            // Fetch the file information
            $query = "
                SELECT `mime`, `name`, `size`, `data`
                FROM `file`
                WHERE `id` = {$id}";
            $result = $dbLink->query($query);
     
            if($result) {
                // Make sure the result is valid
                if($result->num_rows == 1) {
                // Get the row
                    $row = mysqli_fetch_assoc($result);
     
                    // Print headers
                    header("Content-Type: ". $row['mime']);
                    header("Content-Length: ". $row['size']);
                    header("Content-Disposition: attachment; filename=". $row['name']);
     
                    // Print data
                    echo $row['data'];
                }
                else {
                    echo 'Error! No image exists with that ID.';
                }
     
                // Free the mysqli resources
                @mysqli_free_result($result);
            }
            else {
                echo "Error! Query failed: <pre>{$dbLink->error}</pre>";
            }
            @mysqli_close($dbLink);
        }
    }
    else {
        echo 'Error! No ID was passed.';
    }
    ?>



Thanks for any help that anyone can provide, this issue is really causing some stress and hurting my sleep at night! Can't figure out why this won't work, it's literally the last step in completing this website.
Please let me know if you need any other information regarding this issue.

Thanks,
- Mike