PHP - Saving Image

I am working on a simple gallery. I want to have an option to download full scale image without users having to right click and "save as". Using this code you get a image preview:

<a href="pictures/img-(1).jpg"><img src="thumbnails/img-(1).jpg"></a>

How can I modify it so when user clicks on thumbnail of image 1 it will prompt him to save the image instead of viewing it.

Thanks

I have a .php code that gets data from a database and saves it in a variables as xml.  However how can I then save all of the data in this variable as a .xml file somewhere?

Thanks for any help. 

i have made 2 classes. 

the first "point" has an array of 3 floats and some functions to help manipulate the values
the second "triangle" has an array of 3 points.

in this way if i want to make a tetrahedron i can make 4 points and assign them to 4 triangles.

problem is for some reason each triangle point group seems to use 1k.  any idea why?

I have problem how to saving all my record.    when I save I just got 1 record saved in mySQL and it the last record on that table. Here is my code =

<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO thasil (nrp, nama, pangkat, mgolongan, mtes_fisik, mkemampuan, hasil) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['nrp'], "int"),
                       GetSQLValueString($_POST['nama'], "text"),
                       GetSQLValueString($_POST['pangkat'], "text"),
                       GetSQLValueString($_POST['mgolongan'], "int"),
                       GetSQLValueString($_POST['mtes_fisik'], "double"),
                       GetSQLValueString($_POST['mkemampuan'], "double"),
                       GetSQLValueString($_POST['hasil'], "double"));

  mysql_select_db($database_stok, $stok);
  $Result1 = mysql_query($insertSQL, $stok) or die(mysql_error());

  $insertGoTo = "";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_stok, $stok);
$query_anggotaset = "SELECT * FROM tanggota ORDER BY nrp ASC";
$anggotaset = mysql_query($query_anggotaset, $stok) or die(mysql_error());
$row_anggotaset = mysql_fetch_assoc($anggotaset);
$totalRows_anggotaset = mysql_num_rows($anggotaset);

mysql_select_db($database_stok, $stok);
$query_bobotset = "SELECT * FROM tbobot";
$bobotset = mysql_query($query_bobotset, $stok) or die(mysql_error());
$row_bobotset = mysql_fetch_assoc($bobotset);
$totalRows_bobotset = mysql_num_rows($bobotset);

$crMax = mysql_query("SELECT min(Golongan) as minK1, 
max(tes_fisik) as maxK2,
max(kemampuan) as maxK3
FROM tanggota");
$max = mysql_fetch_array($crMax);

$no=1;



?>


<?php include ('header.php') ?>

<div id="conten-wrapper">
<div id="conten">
<h1> Normalisasi Anggota Kesamaptaan </h1>
<p> <a href="cetak.php"><img src="../images/btn_list.png" height="20"/> >>> Lihat & Cetak Hasil Akhir Perangkingan</a></p>
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
<table border="1" cellpadding="3" cellspacing="1">
  <tr>
  <td>no</td>
    <td>nrp</td>
    <td>nama</td>
    <td>pangkat</td>
    <td>C1 Golongan</td>
    <td>C2 tes_fisik</td>
    <td>C3 kemampuan</td>
     <td>hasil</td>
    
    </tr>
  <?php 
  
  do { 
  $hasil= round (($max['minK1']/$row_anggotaset['Golongan']*$row_bobotset['golongan']+
 $row_anggotaset['tes_fisik']/$max['maxK2']*$row_bobotset['tes_fisik']+
 $row_anggotaset['kemampuan']/$max['maxK3']*$row_bobotset['kemampuan']),2) ;
?>
  
    <tr>
    <td><?php echo $no; $no++;?></td>
      <td><input type="text" name="nrp" value="<?php echo $row_anggotaset['nrp']; ?>"  readonly/></td>
      <td><input type="text" name="nama" value="<?php echo $row_anggotaset['nama']; ?>"  readonly/></td>
       <td><input type="text" name="pangkat" value="<?php echo $row_anggotaset['pangkat']; ?>" size="4" readonly/></td>
      <td><input type="text" name="mgolongan" value="<?php echo round ($max['minK1']/$row_anggotaset['Golongan']
 *$row_bobotset['golongan'],2); ?>" size="2" readonly/></td>
      <td><input type="text" name="mtes_fisik" value="<?php echo round ($row_anggotaset['tes_fisik']/$max['maxK2']
 *$row_bobotset['tes_fisik'],2); ?>" size="2" readonly/></td>
       <td><input type="text" name="mkemampuan" value="<?php echo round ($row_anggotaset['kemampuan']/$max['maxK3']
  *$row_bobotset['kemampuan'],2); ?>" size="3" readonly/></td>
       <td><input type="text" name="hasil" value="<?php echo $hasil ?>" size="2" readonly/></td>
      </tr>
      
    <?php } while ($row_anggotaset = mysql_fetch_assoc($anggotaset));?>
    <tr valign="baseline">
      <td colspan="8" align="right" nowrap="nowrap"><input type="submit" value="Insert record" /></td>
      </tr>
</table>
<input type="hidden" name="MM_insert" value="form1" />
</form>
</div>


<?php include ('footer.php') ?>



</body>
</html>
<?php
mysql_free_result($anggotaset);

mysql_free_result($bobotset);
?>

I'm trying to get an equation from a user that types it in the url, ex) 1+2+3. I can get the 1,2,3 fine, but the + operator is no longer in the string. Same with the * and / operators. Is there a way to keep them as a string using $_GET?

Am trying to update a table called "budget_request" and also inserting the data of that table into another table called "Budget". The Update works but it is not inserting into the other table.  please help me out.. check my code below       <?php
$id = $_GET['id'];
?>
<?php



include('mysql_connect.php');

$q = mysql_query("UPDATE budget_request SET status = 'Approved'  WHERE id = '$id'") or die(mysql_error());

// send the details to the budget database

$query = mysql_query("SELECT * FROM budget_request WHERE id = '$id' ") or die (mysql_error());
   $dat = mysql_fetch_array($query);
   
   $department = $dat['department'];
   $amount = $dat['amount'];
   
   // Add the data to the Budget DB
   
   $que = (" INSERT INTO  budget (id, department, amount, actual) VALUES ( ' ','$department', '$amount', '$amount')" ) or die(mysql_error()); 


header("Location: add_budget.php");

?>

Hi All...

I am looking for a way of saving currently open webpage as a pdf file.........I searched for that and even gone for this site http://www.tcpdf.org. But there also I didn't find any perfect way of doing this all....If somebody else has tried tcpdf for that or done something like that, then plzzzzz plzzz plzzzz do help me....Thanx......

                  $new_relation->save();
                  echo "after save".$requestor_profile->getId()."  ".$requestee_profile->getId();
                  return true;
            
               }catch(PropelException $e)
               {
                        echo "in die";
                  die($e);
                  return false;
               }
          }//end - if (!$res)
[/PHP]

the echo after the save executes but when i look in my db table there is nothing????
please help???

Hi,
I'm completely new to anything that is not html but I'm wondering if in something like php I can get a checkbox to permanently save through reloads and different machines. My idea was just to have a page with only a checkbox on it, and then load that through and iframe in html. If anybody could give me the code for that checkbox page (complete if possible as I don't really know anything about that type of programming) I would be very grateful.
Thank You

Hello all I have a form for a meeting unable to attend log.
An attendee calls in to say they will not be able to make meeting and the form saves the reason etc into a db and infroms (via emails) all staff members who would have attended of the cancelation.

It works but for some reason the record saves twice in the db on occasion and I'm unsure why.

The loggers fills in some deatils on a form called log.php and then clicks save which goes to the following page:

Code: [Select]
<?php
$auth = $_COOKIE['auth'];
$login_id = $_COOKIE['login_id'];
header("Cache-Control:no-cache");
if(!$auth == "ok")
{ header("Location:../log_index.php");
exit();
}
include("../php_include/connection.php");
include("../php_include/functions.php");

$absent_date = $_POST['absent_date'];
$call_time = $_POST['hour'] .":". $_POST['mins'];
$reason = (! get_magic_quotes_gpc ()) ? addslashes ($_POST['reason']) : $_POST['reason'];
$reason = fix_quotes($reason);
$log_date = date ("d/m/Y");
$log_time = date("G:i");
$attendee_id = str_replace("\'","'",$_POST['attendee_id']);
$attendee_name = str_replace("\'","'",$_POST['attendee_name']);
$attendee_email = str_replace("\'","'",$_POST['attendee_email']);
$sent = $_POST['sent'];

if( !$sent )
{
echo( "Error - Data not sent from main form.<br><form action=\"log.php\"><input type=\"submit\" name=\"back\" value=\"Back\"></form>" );
}
else 
{ 
$sql = "SELECT staff_username FROM appointments where attendee_id = \"$attendee_id\" and date = \"absent_date\" ";

$rs = mssql_query( $sql, $conn )
or die( "Please contact admin and quote: Could not execute Find Staff Query" );

if(mssql_num_rows($rs)!=0) 
{
while ($row = mssql_fetch_array($rs)) 
{
$staff_email = $row["staff_username"]. "@ourdomain.co.uk,";
$to_staff .= $staff_email;
}
     $re_staff = "Unable to attend appointment logged for $attendee_name ($attendee_id)";
     $msg_staff = "An unable to attend appointment has been logged for $attendee_name ($attendee_id) \n\nReason: $reason \n\nDate of Absence: $absent_date \n\nTime of Call: $call_time \n\nLog Date: $log_date \n\nLog Time: $log_time \n\nLogger: $login_id \n\nThank You";
     $headers_staff = "From: No-Reply@ourdomain.co.uk \r\n";
if( mail( $to_staff, $re_staff, $msg_staff, $headers_staff ) )
{

$sql2 = "insert into att_log (attendee_id, reason, absent_date, call_time, log_date, log_time, logger) values (\"$attendee_id\", \"$reason\", \"$absent_date\", \"$call_time\", \"$log_date\", \"$log_time\", \"$login_id\") ";
$rs2 = mssql_query( $sql2, $conn )
or die( "Please contact admin and quote: Could not execute Save Absence Log");

$re = "Absence logged for you - $attendee_name ($attendee_id)";
$msg = "An absence has been logged for you - $attendee_name ($attendee_id) \n\nReason: $reason \n\nDate of Absence: $absent_date \n\nTime of Call: $call_time \n\nLog Date: $log_date \n\nLog Time: $log_time \n\nLogger: $login_id \n\nThank You";
$headers = "From: No-Reply@ourdomain.co.uk \r\n";

if( mail( $attendee_email, $re, $msg, $headers ) )
{
$sent_to = str_replace(",",",<br>",$to_staff);
echo("Thank you, An email has been sent to the attendees meeting organisers<br><br>$sent_to<br>as notification of this absence.<br><br>An email confirming this absence has been sent to the attendees email account.<br><form action=\"log.php\"><input type=\"submit\" name=\"back\" value=\"Back\"></form>");
}
else
{
echo("Error.....Email not sent to attendee.<br>This may be because the attendee did not provide an email account.<br>Please go back and check the record has been saved.<br><form action=\"log.php\"><input type=\"submit\" name=\"back\" value=\"Back\"></form>");
}
}
else
{ 
echo("Error.....Email not sent and record not saved.<br>This may be because the Email server is not responding. Please go back and try again.<br>If the problem persists please contact Admin.<br><form action=\"log.php\"><input type=\"submit\" name=\"back\" value=\"Back\"></form>");
}
}
else
{
echo("<br><br>Error.....Email not sent and record not saved.<br><br>This may be because the there is no record of a meeting for this Attendee.<br>Please contact Admin with the Attendee ID: ".attendee_id."<br><br><form action=\"log.php\"><input type=\"submit\" name=\"back\" value=\"Back\"></form>");
}
}

include("../php_include/close_all.php");
?>
Can anyone shed some light?
 Or suggest code improvements?
Many Thanks

Hi guys

Im looking to save the contents of 4 textboxes to a mySql db. Using wamp, phpmyadmin etc.

Code: [Select]
?php
$Name = $_Post('Name');
$Age = $_Post('Age');
$Sex = $_Post('Sex');
$Address_1 = $_Post('Address_1');

mysql_connect("127.0.0.1","user","") or die ('Error: ' .mysql_error());
mysql_select_db("user");

$query ="INSERT INTO users(Name,Age,Sex,Address_1) VALUES('".$Name."', '".$Age."','".$Sex."','".$Address_1."');

mysql_query($query) or die ('Error updating datadase');
mysql_Close();

?>This is the code im using, it dosent seem to do anything to the database..... can someone point out where im going wrong... thanks

How can I save an image created on-the-fly on the server?  For example,

$img = "<img src=ChessImager/ChessImager.php?ds_color=(176,144,112)&ls_color=(224,200,160)&coordinates=on&square_size=$square_size&fen=" . urlencode($fen) . ">";

I can display the diagram, but I want to save these images with PHP.

Hi, I'm still new to php and having some problems. Sorry about the code not being formatted properly. The snippet I posted has both the code intend to work but it is commented out and a test version that has an array already set thus getting rid of the need of setting up every thing like I have.

Ok this is basically my problem. I'm building a store like website. Its suppose to be very basic for now Part of the website is an RMA system where the customer enters an order number and then pulls up all items in the order on a different page in a table format with check boxes next to each item found in the database.  Each item that is checked off is then saved to an array rma[] which posts to another page when submitted. What this page(copied down below) does is it pulls values from the cookie already made and creates new variables which is not a problem. After that it does a foreach loop for the array of the items into a mysql query which then is suppose to insert it into a database.

When the code runs it only inserts the first item in the array into the database no matter how many items are in the array. When I echo the $insert statement I get this(using the test code) like I expect I'm suppose to. I would assume that because I'm doing a foreach loop that it is doing an INSERT for the number of items in the array.

Quote

INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','Saab','123')
INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','Volvo','123')
INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','BMW','123')
INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','Toyota','123')


Code: [Select]
<?php

//connects to the data base
 mysql_connect("localhost", "root", "") or die(mysql_error()); 
 mysql_select_db("project") or die(mysql_error()); 

/* //retrieving rma array from previous page
$rmarequest = $_POST['rma'];

//retieves using name from cookie
$username = $_COOKIE['ID_my_site'];

//retrieves order number from cookie
$ordernumber = $_COOKIE['order'];


//creates rma number
$rmanumber = rand(1000, 999999);

//retrieves accountid from database using the username
$getid = mysql_query("SELECT AccountID FROM users WHERE username = '$username'");
$id = mysql_fetch_array( $getid );

//takes the value of $id
$final = $id['AccountID'];


//suppose to loop through all values for the array created by $request on the previous page and insert into database

foreach($rmarequest as $key){


// $insert = "INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('".$rmanumber."', '".$AccountID."','".$key."','".$ordernumber."')";
//mysql_query($insert) OR die(mysql_error());


//this is test to see what is being passed to mysql server
$insert = "INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('".$rmanumber."', '1','".$key."','123')";
 //mysql_query($insert) OR die(mysql_error());

//to view what $insert is passing to the data base.
echo $insert;}
*/


//THIS SECTION IS TEST ONLY

//test array
$cars[0]="Saab";
$rmarequest[1]="Volvo";
$rmarequest[2]="BMW";
$rmarequest[3]="Toyota";


//creates rma number
$rmanumber = rand(1000, 999999);


foreach($rmarequest as $key){

//this is test to see what is being passed to mysql server
$insert = "INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('".$rmanumber."', '1','".$key."','123')";
 mysql_query($insert) OR die(mysql_error());

//to view what $insert is passing to the data base.
echo $insert."<br />";
}

?>

Included is a copy of the table and the php code above.

Hi guys,

Right now, I just save / update the database and refresh the page.  I'd like to do all of that, but have a nice looking 'Save / Update' indication - indicator.

How do you guys do it?  Do you have any recommendations?

Thanks

I have a bunch of users in a database (id, name, etc).   I have a bunch of documents which belong to users (id, filename, users_id, etc), and expect 500 or less per user.   The documents will be renamed to the document_id, and X-Sendfile (since they are stored under the document root) will be used to retrieve them and a header will be used to return them to their original name.   Is it recommended to make a separate folder for each user and store each individual user's documents in that folder, or create one folder for all documents?   If I go with the one folder approach, I will need some method from keeping the total files per folder below some reasonable limit (1,000?).  My thought is to estimate the maximum potential number of folders, and creating subfolders under the main document folder.  I will likely hash the ID, and use the first character to create the first subfolder, the second character to create a second subfolder in the first subfolder, and continue as long as needed to accommodate the maximum potential documents (if there are 1,000,000 potential folders, then three levels will keep the maximum per folder under 244).   Please provide rational for one approach over the other.   Thank you