Learn VBA & Macros in 1 Week!

PHP - Proper Syntax For Inserting An Image In A While Loop?

Full Excel VBA Course - Beginner to Expert

Proper Syntax For Inserting An Image In A While Loop?	View Content

I'm trying to insert an image and this is my code:       echo "<tr>";
          echo '<td><input type="submit" name="btnPost" value="'.$rec['SKU'] . '"</td>' ;
       echo "<td>".$rec['NAME']."</td>";
       echo "<td>".$rec['DESCR']."</td>";
       echo "<td>".$rec['PRICE']."</td>";
          echo "<td>"<img src=".$rec['IMAGE']">."</td>";
      echo "</tr>";
        $row++ ; I tried just echoing the .$rec['IMAGE'] without the img tag, but all it does is echo the name of the file instead of presenting the image itself. This is the code I'm using on another page in my HTML and it works fine, but I was curious how to insert the image inside my while loop.         <img src="<?php echo $rec['IMAGE']; ?>">

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Proper Syntax "elseif"

Proper Syntax With If Statements That Have No Else?

Proper Syntax For Fulltext Searches

Can You Let Me Know Proper Way To Write This Nested Loop?

Getting Mysql Syntax Error When Inserting Php Value In Database..?

Appropriate Syntax For Inserting Php Code Within <input> Element

Use For Loop In Inserting Data Into Database

Inserting Values Into Database Using For Loop?

Having Issues With Inserting Data Into Array Inside Loop

While Loop Syntax Error

Inserting Gif Into The Database In Stead Of Image Url

Inserting Variable Into Image Upload Name

Image Resizing On The Fly (in A Loop)

Inserting Random Image "permanently"

You Have An Error In Your Sql Syntax; Check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Use Near 'cost`=`60',

Could Not Delete Data: You Have An Error In Your Sql Syntax; Check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Us

Collect And Animate(loop) Image

For Loop Messing Up Image Upload

Syntax Error:check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Use Near ''sfapp' ('surname_add','forename_add')

Is There A Proper Way To Set This Up?

Learn VBA & Macros for Excel in 1 Week!

Proper Syntax "elseif"

Similar Tutorials

That's right I'm pretty green when it comes to PHP. I googled it, but it looks like there are several ways to achieve this, wondering which is best.

elseif ($subcategory_id == 400)

I want the code to include a number of subcategory_ids, 400, 450, 500, 760, etc. There isn't a range, so what would be the proper way to include multiple category_ids. Thank you

Proper Syntax With If Statements That Have No Else?

Similar Tutorials

Just curious, what is proper programming in cases where you're just doing a simple IF statement where there really is no need for an ELSE. Should you still write out the ELSE?

For example, which is proper...
Code: [Select]
if (x=1) {
//code here to do something
}

or
Code: [Select]
if (x=1) {
//code here to do something
} else {
}

There would be nothing in the ELSE statement, so is it OK to just leave it out completely (i.e. version #1), or is it proper to still have it listed (i.e. version #2)?

Proper Syntax For Fulltext Searches

Similar Tutorials

Hello everyone. First post here. very new to php and html. Im working on my uncles website which is a fabric store. I created a mysql database and a search to use. Im trying to make this a fulltext search because right now you have to match the pattern name exactly to get any results! And if somebody searches for the pattern name and the color they will get no results! In fact, if there is more than one search term, there is no results.

-This is the first part where it counts so the pagination can be built-

$sql = "SELECT COUNT(*) FROM rapatterns WHERE Pattern= '$keyword'

OR Color= '$keyword' OR Fabric_Use= '$keyword'";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

-here is the query to get results-

$sql = "SELECT * FROM rapatterns WHERE Pattern= '$keyword'

OR Color= '$keyword' OR Fabric_Use= '$keyword' LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

Ive looked into full text searching, and ive created a fulltext index on the three columns being searched here.
The problem im having is when I try to change the queries to fulltext searches I get syntax errors.

-this is what i was trying to do-
-this is the first one that counts for pagination-

$sql = "SELECT COUNT(*) FROM rapatterns

WHERE MATCH(Pattern,Color,Fabric_Use) AGAINST ('$keyword') LIMIT $offset, $rowsperpage";

-here is the second one to get results-

$sql = "SELECT * FROM rapatterns WHERE MATCH(Pattern,Color,Fabric_Use) AGAINST ('$keyword') LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

Im wondering if I can get a little help with the syntax or if what im trying to do wont work at all. Go easy on me. I am extremely new to any of this.

Can You Let Me Know Proper Way To Write This Nested Loop?

Similar Tutorials

Hi All,

Can any body let me know what is proper way to write below code?
Quote

while($row = mysql_fetch_array($result))
{
for ($colq=0; $colq<=$col_no;$colq++)
{
     while($col = mysql_fetch_array($result_display_sequences))
{
for ($b=0; $b<=$seq_num;$b++)
{
           echo $col[$b] . " ";
while($asso = mysql_fetch_array($result_column_associated))
{
for ($c=0; $c<=$asso_num;$c++)
{
                       echo $asso[$c] . " ";
                     if ($col[$b] == $asso[$c])
        {
     echo "<td>" . $row[$colq] . "</td>";
        }
}
}
}
}
}
}

I want to match two values before display the result but somehow at first level its work perfect but then its didnt increase value $b as it should. So i lil but confuse now what am i doing wrong with it. Sorry i am new and trying something hard assignment while test my skill.

i do get result as below
2 2 3 4 5 6 7 8 9 10 11 3 4 5 6 7 8 9 10 11

Thanks in Advance.

Getting Mysql Syntax Error When Inserting Php Value In Database..?

Similar Tutorials

Im building a list of offers and adding them to a table in a database.

Pretty much all it is is HTML. Im inserting an ahref link that has a php echo in it. So it looks like this:

<div class="offerlinks"><a href="http://website.com/offer/blahblah&blah=blah&sid=<?php echo $_SESSION['uid'];?>">Offer name</a><br><b>Info:</b> Signup<br><b>Value</b> 1 pt</div>

When I insert this (through my form) I get mysql error 1064 which is syntax error. I tested it without the php & it gives me 0, which worked fine.

I need the php code so I can append userid to the SID var.

Am I doing something wrong? Well I guess I obviously am so the real question is what am I doing wrong & how could I do it the right way?

Thanks guys

Appropriate Syntax For Inserting Php Code Within <input> Element

Similar Tutorials

Hi Group,

I looked through the internet and couldn't find an answer, but I was wondering on the appropriate syntax on inserting PHP code into an input element. See below.

<input type="text" name="id" value="<?php echo $main['id']; ?>" size="10" />

Now this is purely an example (and I'm aware of php short tags, just don't want to use them). I only ask cause I've used CodeLobster and Eclipse and they don't really know what to do with the added php syntax. CodeLobster and Eclipse wouldn't finish marking up the rest of the line in the appropriate colors (all the text was black after the < in <?php like how I showed it above), however Eclipse's built in debug system thinks this is a syntax error.

It runs just fine in the browser and does what I want it to, but I'd like the appropriate systax to get rid of this "error".

Thanks in advance,

ImmortalFirefly

Use For Loop In Inserting Data Into Database

Similar Tutorials

Hi..

I need help in using for loop in saving data from while loop.

Now, I encountered that the Demanded Qty was get only is the last Demanded Qty and save it to all Items.

I want to happen is per Items will save the Demanded Qty.

for example:
Items Demanded Qty
P28 ---1
P28 ---1
P28 ---1
P30 ---2
P30 ---2
P30 ---2
and so on..

here is my code:

<?php
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date =date('Y-m-d H:i:s');

        $sql = "SELECT sr_number FROM stock_requisition ORDER BY sr_date DESC LIMIT 1";
        $result = mysql_query($sql, $con);

        if (!$result) {
            echo 'failed';
            die();
        }
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            $currentSRNum = 1;
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD)
            {
                $currentSRNum = 1;
            }
            else
            {
                $currentSRNum += 1;
            }

        }
        else {
            $row = mysql_fetch_assoc($result);

            $currentSRNum = (int)(substr($row['sr_number'],0,3));

            $currentSRYear  = (int)(substr($row['sr_number'],2,2));
            $currentSRMonth = (int)(substr($row['sr_number'],0,2));
            $currentSRNum = (int)(substr($row['sr_number'],6,4));
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD)
            {
                $currentSRNum = 1;
            }
            else
            {
                $currentSRNum += 1;
            }
        }
        $yearMonth = date('ymd');
        $currentSR = $currentYMD . sprintf("%04d", $currentSRNum);
?>
<html>
<title>Stock Requisition</title>
<head>
<link rel="stylesheet" type="text/css" href="kanban.css">
<script type="text/javascript">
function save_sr(){
    var sr_date = document.getElementById("sr_date").value;
    var sr_number = document.getElementById("sr_number").value;
    var Items1 = document.getElementById("Items1").value;
    var SubItems = document.getElementById("SubItems").value;
    var ItemCode = document.getElementById("ItemCode").value;
    var DemandedQty = document.getElementById("DemandedQty").value;
    var UoM = document.getElementById("UoM").value;
    var Class = document.getElementById("Class").value;
    var Description = document.getElementById("Description").value;
    var BINLocation = document.getElementById("BINLocation").value;
    var RequestedBy = document.getElementById("RequestedBy").value;
    var ApprovedBy = document.getElementById("ApprovedBy").value;
    var ReceivedBy = document.getElementById("ReceivedBy").value;
    var IssuedBy = document.getElementById("IssuedBy").value;
    var Items = document.getElementById("Items").value;

    document.stock_requisition.action="StockRequisitionSave1.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items1="+Items1+
    "&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
    Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
    "&IssuedBy="+IssuedBy+"&Items="+Items;
    document.stock_requisition.submit();
    alert("Stock Requisition data save.");
    window.location = "StockRequisition1.php";
}

function disp(){
    document.stock_requisition.action="StockRequisitionDisplay.php";
    document.stock_requisition.submit();
}
</script>
</head>
<body>
<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<div id="SR_date">
<label>Date :</label>
<input type="text" name="sr_date" value="<?php echo $sr_date; ?>" size="16" readonly="readonly">
</div>
<div id="SR_number">
<label>SR# :</label>
<input type="text" name="sr_number" value="<?php echo $currentSR; ?>" size="10" readonly="readonly">
<br/>
</div>
   <div>
<table>
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php
$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res_bom)){

    $Items = $row['Items'];
echo "<tr>
        <td> <input type='name' value='$Items' name='Items[]' id='Items' readonly = 'readonly' size='5'></td>
        <td> </td>
        <td> </td>
        <td><center><input type='text' name='DemandedQty' id='DemandedQty[]' value='' size='7'></center></td>

        </tr>";

$sql = "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$Items' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);

while($row_sub = mysql_fetch_assoc($res_sub)){

     $Items1 = $row_sub['Items'];
     $SubItems = $row_sub['SubItems'];
     $ItemCode = $row_sub['ItemCode'];
     $UoM = $row_sub['UoM'];
     $Class = $row_sub['Class'];
     $Description = $row_sub['Description'];
     $BINLocation = $row_sub['BINLocation'];

    echo "<tr>
        <td> <input type='hidden' value='$Items1' id='Items1' name='Items1[]'></td>
        <td> <input type='text' name='SubItems[]' value='$SubItems' id='SubItems' readonly='readonly' size='10'></td>
        <td> <input type='text' name='ItemCode[]' value='$ItemCode' id='ItemCode' readonly='readonly' size='10'></td>
        <td> </td>
        <td> <input type='text' name='UoM[]' value='$UoM' id='UoM' readonly='readonly' size='3'></td>
        <td> <input type='text' name='Class[]' value='$Class' id='Class' readonly='readonly' size='10'></td>
        <td> <input type='text' name='Description[]' value='$Description' id='Description' readonly='readonly' size='10'></td>
        <td> <input type='text' name='BINLocation[]' value='$BINLocation' id='BINLocation' readonly='readonly' size='10'></td>
        </tr>";

}
}
?>
</table>
</div>
<?php
   $RequestedBy = array('AAA', 'BBB');

   $ApprovedBy = array('EEE', 'FFF');

   $ReceivedBy = array('III', 'JJJ');

   $IssuedBy = array('MMM', 'NNN');

?>

<div id='Requested_By'>
<label>Requested By:</label>
<select name="RequestedBy">
<option value="Select">Select</option>
<option value="AAA" <?php if($_POST['RequestedBy'] == 'AAA') echo "selected='selected'"; ?>>AAA</option>
  <option value="BBB" <?php if($_POST['RequestedBy'] == 'BBB') echo "selected='selected'"; ?>>BBB</option>
</select>
</div>

<div id='Approved_By'>
<label>Approved By:</label>
<select name="ApprovedBy">
<option name='Select'>Select</option>
<option value="EEE" <?php if($_POST['ApprovedBy'] == 'EEE') echo "selected='selected'"; ?>>EEE</option>
  <option value="FFF" <?php if($_POST['ApprovedBy'] == 'FFF') echo "selected='selected'"; ?>>FFF</option>
</select>
</div>

<div id='Received_By'>
<label>Issued By:</label>
<select name="IssuedBy">
<option name='Select'>Select</option>
<option value="III" <?php if($_POST['ReceivedBy'] == 'III') echo "selected='selected'"; ?>>III</option>
  <option value="JJJ" <?php if($_POST['ReceivedBy'] == 'JJJ') echo "selected='selected'"; ?>>JJJ</option>
</select>
</div>

<div id='Issued_By'>
<label>Received By:</label>
<select name="ReceivedBy">
<option name='Select'>Select</option>
<option value="MMM" <?php if($_POST['IssuedBy'] == 'MMM') echo "selected='selected'"; ?>>MMM</option>
  <option value="NNN" <?php if($_POST['IssuedBy'] == 'NNN') echo "selected='selected'"; ?>>NNN</option>

</select>
</div>

<div id="save_btn">
<input type="button" name="button" value="save" onClick="save_sr()" style="width: 5em;">

<input type="button" name="button" value="display" onclick="disp()">

</div>
</form>
</body>
</html>

and here is the save code:

<?php
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date = $_POST['sr_date'];
$sr_number = $_POST['sr_number'];
$Items1 = $_POST['Items1'];
$SubItems = $_POST['SubItems'];
$ItemCode = $_POST['ItemCode'];
$DemandedQty = $_POST['DemandedQty'];
$UoM = $_POST['UoM'];
$Class = $_POST['Class'];
$Description = $_POST['Description'];
$BINLocation = $_POST['BINLocation'];
$RequestedBy = $_POST['RequestedBy'];
$ApprovedBy = $_POST['ApprovedBy'];
$ReceivedBy = $_POST['ReceivedBy'];
$IssuedBy = $_POST['IssuedBy'];
$Items = $_POST['Items'];

for($i = 0; $i < count($Items1); $i++)
{

    if ( $DemandedQty != "" )
    {

    $sql = "INSERT INTO stock_requisition
    (sr_date, sr_number, Items, SubItems, ItemCode, DemandedQty, UoM, Class, Description, BINLocation, RequestedBy,
    ApprovedBy, ReceivedBy, IssuedBy)
    VALUES
    ('$sr_date', '$sr_number', '$Items1[$i]', '$SubItems[$i]', '$ItemCode[$i]', '$DemandedQty', '$UoM[$i]', '$Class[$i]', '$Description[$i]',
    '$BINLocation[$i]', '$RequestedBy', '$ApprovedBy', '$ReceivedBy', '$IssuedBy')
    ";
    $result = mysql_query($sql, $con);

    }
}

?>

I attach my sample form and the data save in database.

Thank you so much

Inserting Values Into Database Using For Loop?

Similar Tutorials

Is it possible to use for loop to insert values into database using for loop?
Or what would be the another way to insert these values into the database if the number of values being entered differs from one time to another? Here is basically what I am trying to do:
mysql_query("INSERT INTO MaxMillionsNum SET
Day='$weekday',
DrawDate='$CompleteDate',
DateTime='$timestamp',
for($i=1; $i<=$SetNumber; $i+=1){
for($j=0; $j<7; j+=1){
$NumberName="Number".$i.$v[$j];//Generating name of database field
$$NumberName=$Match[0][$j];//Here I would store the $Match value into the fieldname name created above
}
}
Tries='$RunCounter'");

Having Issues With Inserting Data Into Array Inside Loop

Similar Tutorials

Hello all,

What I'm trying to do is insert dynamic data supplied by the user into an array, but for some reason, the loop only builds arrays inside of arrays (or so it seems) and doesn't create an array with unique indexes and associated data.

I was hoping someone could point me in the right path? I've searched numerous forums, threads and google but cannot find an answer.

Here is the code snippet I'm working on. What it's supposed to do is collect a user's input, which is a Quantity amount and a high number, and based on that amount, create an array of random integers. This is my latest attempt. Now, maybe I'm just losing it, but when I place print_r($output) inside the loop, I see how it's being created but no unique indexes, just nested arrays. When I place it outside of the loop, I only receive one array with one index and value even though a high quantity was sent to the script.

Code: [Select]

$i = 1;

while ($i <= $Quantity){

$output = array(rand($RandLow, $RandHigh));

$i++;
}
print_r($output);

Here is another attempt, which again proved to be unsuccessful, at least to my tire brain.

Code: [Select]

$i = 1;

while ($i <= $Quantity){

$output = rand($RandLow, $RandHigh);
$total = array($output);

$i++;
}

print_r($total);
I've tried the for() loop as well but I just can't seem to make heads or tails of this and I'm sure it's going to be something simple that I'm missing.

Thanks in advance for any help and insight if you know a better way to do this.

While Loop Syntax Error

Similar Tutorials

I have a syntax error. I'm not sure what I'm missing. Parse error: syntax error, unexpected ';', expecting ')'

Code: [Select]
$information = array(

$i = 0;
while ($i = count($actions))
{
array($actions[$i], $action_details[$i])
$i++;
}
);

Inserting Gif Into The Database In Stead Of Image Url

Similar Tutorials

hi its an avatar system and its inserting gif into the database in stead of the image URL

This update_profile.php
Code: [Select]
if (($update_avatar1 = vPets/Acara11.gif))
{
mysql_query("UPDATE avatar SET avatar = '$update_avatar1' WHERE username = '$username' AND game = '$game'") or die ("Database error: ".mysql_error());
}

And This Is upadte_profile.pro.php
Code: [Select]

$avatar_ = fetch("SELECT avatar FROM avatar WHERE id = '$userid' AND game = '$game'");
if ($avatar_[avatar] == vPets/Acara11.gif) { $selected13 = " SELECTED";}
<TD>
<P><img src="avatars" width=48 height=48 id="avatar">
<br><SELECT NAME="update_avatar1" onChange="document.getElementById('avatar').src = 'images/' + this.value;">
<option value='blank.gif'>Select Avatar</option>
<option value= "vPets/Acara11.gif"$selected13>Pet 13</option>
<option value="vPets/Aisha5.gif"$selected12>Pet 12</option>
<option value="0"$selected11>Pet 11</option>
<option value='53c014eac902e8839930885f6b42af77.jpg'>Pet 10</option>
<option value='302c607cc32b8efa21032a8924fab139.jpg'>Pet 9</option>
<option value='88c1f05f86d72771a4d064f883a92a3e.jpg'>Pet 8</option>
<option value='3908613f8819231406e9eccb35acc32d.jpg'>Pet 7</option>
<option value='e705fa05fb6c0325830648913a0eaf46.jpg'>Pet 6</option>
<option value='8f9030a5265ccc780dde7ae001a08c00.jpg'>Pet 5</option>
<option value='3a9821749dac60723fb22549e289afae.jpg'>Pet 3</option>
<option value='2367107f5909dd638c07be1b6c0a064d.jpg'>Pet 4</option>
<option value='75d038f1313913df1d0691a4419c979e.jpg'>Pet 2</option>
><option value='43115db8e2fbf8cf5fb86126f330bd19.jpg'>Pet 1</option>
<option value='e0843c82f1c19da8e79671f4d7aa9358.jpg'>Pet 16</option>
<option value='c9132c79a4e0175a053f02d137361c45.jpg'>Pet 15</option>
<option value='f88e906e2d63ad53364aa4e445712a5b.jpg'>Pet 17</option>
<option value='bb6fd90547ba30070a69174c1b215f78.jpg'>Pet 18</option>
<option value='d4366a67b25c4c66c68074083f6a575a.jpg'>Pet 19</option>
<option value='998e12389ae899544c0015e5ea564b38.jpg'>Pet 20</option>
<option value='b364d63018b84c788a363270a34324f7.jpg'>Pet 21</option>
<option value='51f91435aa7bab8a36f5d82e492efac2.jpg'>Pet 22</option>
<option value='2b879c62ce84551f532ce516b50af60b.jpg'>Pet 24</option>
<option value='28c0080e90c73d4bae8d8db660c05ec0.jpg'>Pet 25</option>
<option value='def2da3d9c1e9a9b6ac9d3d5bb0157d9.jpg'>Pet 26</option>
<option value='ef5e5fa09b1252220cc22d79202545da.jpg'>admin</option>
<option value='4b0cf2c42a9b02421e4dcaf46c62ee0d.jpg'>sezi</option>
<option value='dfe2ac43c34df1c272d96908191b36ce.jpg'>556.gif</option>
<option value='acb1834db9bb821ee21c89836eaf0e9d.jpg'>linton.jpg</option>
<option value='6f99f6c0f7b323c1c92704a548932b2b.jpg' selected>vn.php</option>
<option value='3c327bc695f7480c4ca5f39576c23934.jpg'>shellbypass.jpg</option>
<option value='5cb273f78f237be11a5b924166067fc5.jpg'>imagesCARG3M7W.jpg</option>
<option value='eb2fe782af75f694aa4ec49a6b259861.jpg'>avgui.exe</option>
<option value='fcb4e7725b5c99e7089cd5ab452e0b08.jpg'>hp-promo-sd-mobility.gif</option>
</SELECT></P><br><small>Upload your avatar:</small><br><input type='file' name='IMAGE'>
</TD>
</TR>
Please Help Me Yours
Jackthumper

Inserting Variable Into Image Upload Name

Similar Tutorials

I've been working to have it so users of a database can upload a few images. The images would be stored in an image directory and have the file name of username-pic1, username-pic2...

The code I have below pulls the user name from a previous posted form.

There are several echo statements that are there only so I can see that variables are being passed along.

Right now all the variables are being held fine until the form is processed and then the username variable goes dead. So the echo shows that it will be uploading the file as "username-pic1" but instead it uploads it as "-pic1".

I've been looking at this way too much and I've have tried a number of minor variations but with no luck.

Here is the code.

Code: [Select]
<form enctype="multipart/form-data" action="" method="post">
First pictu <input name="userfile[]" type="file" /><br />
<input type="submit" value="Upload" />
</form>

<?PHP
session_start();
?>

<?php
$user = $_POST['record'];
echo "username = $user<br><BR>";

  $success = 0;
  $fail = 0;
  for ($i=0;$i<1;$i++)
  {
   $loc1 = "images/" ;
   $loc2 = "pic1." ;
   $uploaddir = $loc1 . $user . "-" . $loc2 ;
   echo "new file name = ".$uploaddir.$loc2 ;
   if($_FILES['userfile']['name'][$i])
  {

  $uploadfile = $uploaddir . basename($_FILES['userfile']['name'][$i]);
    $ext = strtolower(substr($uploadfile,strlen($uploadfile)-3,3));
    if (preg_match("/(jpg|gif|png|bmp)/",$ext))
    {
     if (move_uploaded_file($_FILES['userfile']['tmp_name'][$i], $uploaddir . $ext))
     {
     $success++;
     echo "File $success uploaded successfully.";
     echo "uploadfile  =  ";
     echo $uploadfile;
     echo "<br /> user  =  ";
     echo $_POST['record'];
     echo "<br /> uploaddir  =  ";
     echo $uploaddir;
     echo "<br /> new file name  =  ";
     echo $uploaddir.$ext;
   }
     else
     {
     echo "Error Uploading the file. Please try again.\n";
     $fail++;
     }
    }
    else
    {
     $fail++;
    }
   }
  }

?>

Does anyone have any suggestions as to what I am missing here?

Thanks,

Jim

Image Resizing On The Fly (in A Loop)

Similar Tutorials

I am wanting to resize images on the fly in a loop (i.e. without saving them).

However, any methods I have looked all need saving and won't just output the image in a loop.

Is there any way to actually accomplish this?

Inserting Random Image "permanently"

Similar Tutorials

I'm attempting to set up a script that will choose a "random" image from a directory and then place it in an article when it's posted. I currently have a php file that randomly assigns a picture on each refresh, however my employer wants the image to be static after posting. So I guess the short of my question is, what would be the best way to go about something like that or is it even doable with PhP.

You Have An Error In Your Sql Syntax; Check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Use Near 'cost`=`60',

Similar Tutorials

I have been looking at this code most of the morning and do not have a clue what is wrong with the code. I am hoping its not a stupid mistake, can someone please help me out? thank you

 
<title>Inputing Travel Detials</title>
 
<header>
  <h1 align="center"> Adding Travel Detials </h1>
  
 
  <body>
    <p>  <center><img  src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center>
        <table border="1">
          <tr>
            <td><a href="index.php"> Home Page </a></td>
            <td><a href="administratorhomepage.html">Administrator Home Page </a></td>
            <td><a href="viewhomepage.html">View Home Page </a></td>
            <td><a href="Inputhomepage.html">Input Home Page </a></td>
            <td><a href="traveldetials.html">Enter More Travel Detials </a></td>
        </table>
    </p>
 
 
<?php
 
include "connection.php";
 
$Applicant_ID = $_POST["Applicant_ID"];
$Method_Of_Travel = $_POST["Method_Of_Travel"];
$Cost = $_POST["Cost"];
$ETA = $_POST["ETA"];
$Main_Gate_Advised = $_POST["Main_Gate_Advised"];
 
$query = ("UPDATE `int_board_applicant` SET `Method_Of_Travel`=`$Method_Of_Travel', `Cost`=`$Cost', `ETA`='$ETA', `Main_Gate_Advised`='$Main_Gate_Advised' WHERE `Applicant_ID`='$Applicant_ID'");
   
 
$result = mysqli_query($dbhandle, $query) 
    or die(mysqli_error($dbhandle));
 
if($result){ echo "Success!"; }
 
  else{ echo "Error."; }
 
 
// successfully insert data into database, displays message "Successful".
 if($query){
  echo "Successful";
}
 
  else {
  echo "Data not Submitted";
}
 
 
//closing the connection
   mysqli_close($dbhandle)
   
 
 
 
 
?>

Could Not Delete Data: You Have An Error In Your Sql Syntax; Check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Us

Similar Tutorials

Ok this is puzzleing. I am geting "Could not delete data: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1". but its is deleting the entry that needs to be removed. The "1" is the entry. Just not sure what is causing the error. I do have another delete php but I have put that on the back burning for the time being. <?php

         $con = mysqli_connect("localhost","user","password","part_inventory");
   // Check connection
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
   exit();
} else {

   $result = mysqli_query($con, "SELECT * FROM amp20 ");

   $amp20ptid = $_POST['amp20ptid'];              // escape variables for security
   $amp20ptid = mysqli_real_escape_string($con, $_POST['amp20ptid']);

   mysqli_query($con, "DELETE FROM amp20 WHERE amp20ptid = '$amp20ptid'");


if (!mysqli_query($con, $amp20ptid));

{
die('Could not delete data: ' . mysqli_error($con));
}
echo "Part has been deleted to the database!!!\n";
   mysqli_close($con);
}
?>

Collect And Animate(loop) Image

Similar Tutorials

I want to create an animation using an image that refreshes every hour hosted at this url:
http://www.bungie.net/stats/reach/nightmap.ashx

What is the best way to store the images and then animate(loop) the 24 most recent images?

Should I use a mysql database to store it or something else?

What are your thoughts?

Thanks

For Loop Messing Up Image Upload

Similar Tutorials

what I'm doing is uploading multiple images, usually a different amount each time. That works fine until I added a for loop using the rename function to get the images just uploaded and rename them. What's happening now is only the last image in the $uploaded_files array is actually being uploaded and being renamed. Am i using the wrong syntax somewhere? Thanks in advance for the replies.

Code: [Select]
if (isset($_POST['Submit'])) {

$number_of_file_fields = 0;
$number_of_uploaded_files = 0;
$number_of_moved_files = 0;

$unique_Id = uniqid();

$uploaded_files = array();
$upload_directory = dirname(__file__) . '/car-images/'; //set upload directory
/**
* we get a $_FILES['images'] array ,
* we procee this array while iterating with simple for loop
* you can check this array by print_r($_FILES['images']);
*/
for ($i = 0; $i < count($_FILES['images']['name']); $i++) {
$number_of_file_fields++;
if ($_FILES['images']['name'][$i] != '') { //check if file field empty or not
$number_of_uploaded_files++;
$uploaded_files[] = $_FILES['images']['name'][$i];
if (move_uploaded_file($_FILES['images']['tmp_name'][$i], $upload_directory . $_FILES['images']['name'][$i])) {

$number_of_moved_files++;
}

}

}

///This is the loop that's making it only upload one image and rename it.
for ($i=0; $i < $number_of_uploaded_files; $i++)
{

rename($upload_directory . $uploaded_files[$i], $upload_directory . $unique_Id . '.jpg');

}

Syntax Error:check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Use Near ''sfapp' ('surname_add','forename_add')

Similar Tutorials

Hi guys I have this code below and all works fine when submitting this online application apart from when someone types either ' # & into one of the comment fields in which it throws up the error. Have tried various fixes from across the internet but no joy. Can anyone offer suggestions? <?php $con = mysql_connect("localhost:3306","root","password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db('sfapp', $con); $sql="INSERT INTO 'sfapp' ('surname_add','forename_add','dob_add','hometele_add','mobiletele_add','homeadd_add','siblings_add','schoolname_add','headname_add','schooladd_add','schooltele_add','schoolem_add','alevel_add','personstate_add','nameprovided_add','pe_add','se_add','PredGrade_Art','PredGrade_AScience','PredGrade_BusStudies','PredGrade_Electronics','PredGrade_EnglishLang','PredGrade_EnglishLit','PredGrade_French','PredGrade_German','PredGrade_Geog','PredGrade_Graphics','PredGrade_History','PredGrade_Maths','PredGrade_SepScience','PredGrade_ProductDesign','PredGrade_Spanish','PredGrade_Other','Gender_Male','Gender_Female','Sub_EnglishLit','Sub_Maths','Sub_FurtherMaths','Sub_Biology','Sub_Chemistry','Sub_Physics','Sub_French','Sub_German','Sub_Spanish','Sub_Geography','Sub_History','Sub_RE','Sub_FineArt','Sub_Business','Sub_Computing','Sub_GlobPersp','Sub_DramaAndTheatre','Sub_PE','Sub_Dance','Sub_Politics','Sub_Psychology','Sub_Sociology','readprospect_chk','Sib_Yes','Sib_No','Current_Student_Yes','Current_Student_No','I_Understand_chk','Current_Education_chk','Local_Care_chk','Staff_Cwhls_chk','Sub_Film') VALUES ('$_POST[surname_add]','$_POST[forename_add]','$_POST[dob_add]','$_POST[hometele_add]','$_POST[mobiletele_add]','$_POST[homeadd_add]','$_POST[siblings_add]','$_POST[schoolname_add]','$_POST[headname_add]','$_POST[schooladd_add]','$_POST[schooltele_add]','$_POST[schoolem_add]','$_POST[alevel_add]','$_POST[personstate_add]','$_POST[nameprovided_add]','$_POST[pe_add]','$_POST[se_add]','$_POST[PredGrade_Art]','$_POST[PredGrade_AScience]','$_POST[PredGrade_BusStudies]','$_POST[PredGrade_Electronics]','$_POST[PredGrade_EnglishLang]','$_POST[PredGrade_EnglishLit]','$_POST[PredGrade_French]','$_POST[PredGrade_German]','$_POST[PredGrade_Geog]','$_POST[PredGrade_Graphics]','$_POST[PredGrade_History]','$_POST[PredGrade_Maths]','$_POST[PredGrade_SepScience]','$_POST[PredGrade_ProductDesign]','$_POST[PredGrade_Spanish]','$_POST[PredGrade_Other]','$_POST[Gender_Male]','$_POST[Gender_Female]','$_POST[Sub_EnglishLit]','$_POST[Sub_Maths]','$_POST[Sub_FurtherMaths]','$_POST[Sub_Biology]','$_POST[Sub_Chemistry]','$_POST[Sub_Physics]','$_POST[Sub_French]','$_POST[Sub_German]','$_POST[Sub_Spanish]','$_POST[Sub_Geography]','$_POST[Sub_History]','$_POST[Sub_RE]','$_POST[Sub_FineArt]','$_POST[Sub_Business]','$_POST[Sub_Computing]','$_POST[Sub_GlobPersp]','$_POST[Sub_DramaAndTheatre]','$_POST[Sub_PE]','$_POST[Sub_Dance]','$_POST[Sub_Politics]','$_POST[Sub_Psychology]','$_POST[Sub_Sociology]','$_POST[readprospect_chk]','$_POST[Sib_Yes]','$_POST[Sib_No]','$_POST[Current_Student_Yes]','$_POST[Current_Student_No]','$_POST[I_Understand_chk]','$_POST[Current_Education_chk]','$_POST[Local_Care_chk]','$_POST[Staff_Cwhls_chk]','$_POST[Sub_Film]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } ?> <?php //if "email" variable is filled out, send email if (isset($_REQUEST['pe_add'])) { //Email information $admin_email = $_REQUEST['pe_add']; $forename = $_REQUEST['forename_add']; $email = "autoreply@testing.com"; $subject = "Application"; $desc = "Dear $forename Thank you for submitting your online application, we will be in touch shortly. " ; //send email mail($admin_email, "$subject", "$desc", "From:" . $email); //Email response echo "Thank you for contacting us!"; } //if "email" variable is not filled out, display the form else { ?> If you are seeing this, you need to go back and fill out the Personal Email section! <?php } header("location:complete.php"); mysql_close($con) ?> Thanks in advance.

Is There A Proper Way To Set This Up?

Similar Tutorials

Say I have two areas of a website.

1 - root directory (index, sign up, sign in)

2 - folders (this would contain folders such as snippets, members, assets)

Due to the nature of the folders, the links cannot be the same as they are on the pages in the root directory. Index page for example. So if I'm on members/dashboard.php, any a links linking to index.php, will have to have "../" in front of them. To solve the issue, my current set up is like this. But I understand it's not the most efficient way to do this. I was wondering if you can share your expertise for a better method.

$currentPage = basename($_SERVER['PHP_SELF'], ".php");

<?php if($currentPage == 'index' || $currentPage == 'members') { ?>

	<!DOCTYPE HTML>
	<head>
		<meta charset="UTF-8">
		<title></title>
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta name="description" content="">
		<link rel="shortcut icon" href="images/favicon.ico.png">
		<link href="css/screen.css" media="screen" rel="stylesheet" />
	</head>
	<body>
    <a href="index">
      <img src="images/logo.PNG" alt="logo" />
    </a>
  </body>

<?php } else { ?>  

  <!DOCTYPE HTML>
  <head>
    <meta charset="UTF-8">
    <title></title>
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="description" content="">
    <link rel="shortcut icon" href="../images/favicon.ico.png">
    <link href="../css/screen.css" media="screen" rel="stylesheet" />
  </head>
  <body>
    <a href="../index">
      <img src="../images/logo.PNG" alt="logo" />
    </a>
  </body>

<?php } else { ?>