PHP - Click A Form Image, Run A Query

Hi,

I need to run a database insert when somebody clicks on an image. Should I use a php function ? or javascript ? or something else ?

Many thanks in advance,

Scott.

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

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=347058.0

I have phpmailer on a website and after clicking send, it goes to the forms action page and don't seem to redirect to the enquiry confirmation page, the forms action page is a blank white page which am guessing is correct as it's PHP coding but thought it should redirect. I don't get any errors showing what the issue is. I have the phpmailer uploaded onto the FTP server and has the class.phpmailer.php file inside the phpmailer folder. The client has their email going through office365. Below is the code I have

+

<?php

ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);

//index.php

$error = '';
$name = '';
$email = '';
$subject = '';
$message = '';

function clean_text($string)
{
$string = trim($string);
$string = stripslashes($string);
$string = htmlspecialchars($string);
return $string;
}

if(isset($_POST["submit"]))
{
if(empty($_POST["name"]))
{
$error .= '<p><label class="text-danger">Please Enter your Name</label></p>';
}
else
{
$name = clean_text($_POST["name"]);
if(!preg_match("/^[a-zA-Z ]*$/",$name))
{
$error .= '<p><label class="text-danger">Only letters and white space allowed</label></p>';
}
}
if(empty($_POST["email"]))
{
$error .= '<p><label class="text-danger">Please Enter your Email</label></p>';
}
else
{
$email = clean_text($_POST["email"]);
if(!filter_var($email, FILTER_VALIDATE_EMAIL))
{
$error .= '<p><label class="text-danger">Invalid email format</label></p>';
}
}
if(empty($_POST["subject"]))
{
$error .= '<p><label class="text-danger">Subject is required</label></p>';
}
else
{
$subject = clean_text($_POST["subject"]);
}
if(empty($_POST["message"]))
{
$error .= '<p><label class="text-danger">Message is required</label></p>';
}
else
{
$message = clean_text($_POST["message"]);
}
if($error == '')
{

require 'phpmailer/class.phpmailer.php';
$mail = new PHPMailer;
$mail->SMTPDebug  = 2;
$mail->IsSMTP();        //Sets Mailer to send message using SMTP
$mail->Host = 'smtp.office365.com';  //Sets the SMTP hosts
$mail->Port = '587';        //Sets the default SMTP server port
$mail->SMTPSecure = 'tls';       //Sets connection prefix. Options are "", "ssl" or "tls"
$mail->SMTPAuth = true;       //Sets SMTP authentication. Utilizes the Username and Password variables
$mail->Username = 'email@domain.co.uk';     //Sets SMTP username
$mail->Password = 'password';     //Sets SMTP password
$mail->From = $_POST["email"];     //Sets the From email address for the message
$mail->FromName = $_POST["name"];    //Sets the From name of the message
$mail->AddAddress('email@domain.co.uk', 'Name');//Adds a "To" address
$mail->AddCC($_POST["email"], $_POST["name"]); //Adds a "Cc" address
$mail->WordWrap = 50;       //Sets word wrapping on the body of the message to a given number of characters
$mail->IsHTML(true);       //Sets message type to HTML    
$mail->Subject = "New Website Enquiry";    //Sets the Subject of the message
$mail->Body = "Name: " . $_POST["name"] . "<br><br>" . "Email: " . $_POST["email"] . "<br><br>" . "Subject: " . $_POST["subject"] . "<br><br>" . "Message: " . "<br>" . $_POST["message"];    //An HTML or plain text message body
if (!$mail->Send())        //Send an Email. Return true on success or false on error
{
header('Location: https://www.domain.co.uk/enquiry-confirmation.php');
}
else
{
$error = '<label class="text-danger">There is an Error</label>';
}
$name = '';
$email = '';
$subject = '';
$message = '';
}
}
?>

 

I have posted this problem in the PHP section but someone suggested I take it here because the hangup is likely in the JS. I have tried removing the JS validator with varying results; sometimes the form still requires double-clicking and sometimes it works fine. Please see my original post below:  

Hello all,   I am an absolute beginner when it comes to PHP and Javascript but wanted a simple contact form for my website. I used the PHP code from one source and the Javascript validator code from another source and all is working fine except for one very annoying bug: I have to press the Submit button twice in order for the form to send the email. I've found that if the validator is already triggered, however, I only need to press the button once for it to submit. I have scoured the internet for a solution to this problem but am realizing this must be a hangup in the particular code I'm using and I'm just not experienced enough to troubleshoot it.   A little help is greatly appreciated. Thank you for your time.   Here's the client side code (truncated to only show relevant parts):

<html>
<head>
<script src="js/gen_validatorv4.js" type="text/javascript"></script> 
</head>
 
<body>
<form method="post" action="contact.php" name="contactform">
    <div class="row collapse-at-2 half">
<div class="6u">
<input name="name" placeholder="Name" type="text" />
</div>
<div class="6u">
<input name="email" placeholder="Email" type="text" />
</div>
</div>
<div class="row half">
<div class="12u">
<textarea name="message" placeholder="Message"></textarea>
</div>
</div>
<div class="row half">
<div class="12u">
<ul class="actions">
<li><input type="submit" value="Send Message" /></li>
<li><input type="reset" value="Clear form" /></li>
</ul>
</div>
</div>
</form>
<script type="text/javascript">
var myformValidator = new Validator("contactform");
myformValidator.addValidation("name","req",
        "Please provide your name.");
myformValidator.addValidation("email","req",
        "Please provide your email.");
myformValidator.addValidation("message","req",
        "Please enter your message.");
myformValidator.addValidation("email","email",
        "Please enter a valid email address.");
</script>
</body>
</html>

 

When I click on the letter of the alphabet on my form page, it will bring up the results of my query.  I got this part working.  The next part is to be able to click on any of the populated results and have it autofill my form with organization, first name, last name, email address and phone number.   I know that I need to use Ajax and jQuery to accomplish this.    Here is my html

<!-- Letter Search -->
<div class="searchBox span12">

	<h3>Choose the First Letter of the Person's Last Name</h3>
	<ul>
        <li class="alphabets" id="A"><a href="?by=A">A</a></li>
        <li class="alphabets" id="B"><a href="?by=B">B</a></li>
        <li class="alphabets" id="C"><a href="?by=C">C</a></li>
        <li class="alphabets" id="D"><a href="?by=D">D</a></li>
        <li class="alphabets" id="E"><a href="?by=E">E</a></li>
        <li class="alphabets" id="F"><a href="?by=F">F</a></li>
        <li class="alphabets" id="G"><a href="?by=G">G</a></li>
        <li class="alphabets" id="H"><a href="?by=H">H</a></li>
        <li class="alphabets" id="I"><a href="?by=I">I</a></li>
        <li class="alphabets" id="J"><a href="?by=J">J</a></li>
        <li class="alphabets" id="K"><a href="?by=K">K</a></li>
        <li class="alphabets" id="L"><a href="?by=L">L</a></li>
        <li class="alphabets" id="M"><a href="?by=M">M</a></li>
        <li class="alphabets" id="N"><a href="?by=N">N</a></li>
        <li class="alphabets" id="O"><a href="?by=O">O</a></li>
        <li class="alphabets" id="P"><a href="?by=P">P</a></li>
        <li class="alphabets" id="Q"><a href="?by=Q">Q</a></li>
        <li class="alphabets" id="R"><a href="?by=R">R</a></li>
        <li class="alphabets" id="S"><a href="?by=S">S</a></li>
        <li class="alphabets" id="T"><a href="?by=T">T</a></li>
        <li class="alphabets" id="U"><a href="?by=U">U</a></li>
        <li class="alphabets" id="V"><a href="?by=V">V</a></li>
        <li class="alphabets" id="W"><a href="?by=W">W</a></li>
        <li class="alphabets" id="X"><a href="?by=X">X</a></li>
        <li class="alphabets" id="Y"><a href="?by=Y">Y</a></li>
        <li class="alphabets" id="Z"><a href="?by=Z">Z</a></li>
     </ul>
     	<? include('search.php'); ?>
    
</div>
     
<hr style="color:#ccc; margin-bottom:20px;" />

<!-- Main Form -->

<div id="mainForm">
	<form method="post" id="icsForm" class="searchBox span12">
    	     <div id="col1" class"span6">
    	           <h3>Contact Information</h3>
                        <label>Church / Organization:</label><input type="text" name="organization" id="organization" class="span6 upright" /><br />
		        <label>First Name:</label><input type="text" name="firstName" id="firstName" class="span6 upright" />
                        <label>Last Name:</label><input type="text" name="lastName" id="lastName" class="span6 left upright" />
                        <label>Email Address:</label><input type="text" name="email" id="email" class="span6 left upright" />
                        <label>Phone Number:</label><input type="text" name="phone" id="phone" class="span6 left upright" />
        </div>
</div>

Here is my php

if(preg_match("/^[A-Z | a-z]+/", $_POST['name'])){
$name=$_POST['name'];
}

if(isset($_GET['by'])){
$letter=$_GET['by'];

//query to sort by last name

$sql="SELECT contact_id, first_name, last_name, church_org, email_address, phone_number FROM ics_data WHERE last_name LIKE '$letter%' ORDER BY last_name ASC";

//run the query against the mysql query function
$result=mysql_query($sql); 

//count results
$numrows=mysql_num_rows($result);

echo "<p>" .$numrows . " results found for " . $letter . "</p>"; 

//Create while loop and loop through result set
while($row=mysql_fetch_array($result)){

        $first_name=$row['first_name'];
	$last_name=$row['last_name'];
	$church_org=$row['church_org'];
	$email_address=$row['email_address'];
	$phone_number=$row['phone_number'];
	$contact_id=$row['contact_id'];
	
//display the result of the array

echo "<div id=\"search-results\">";
echo "<ul class=\"letter-results\">\n"; 
echo "<li class=\"result-row\">" . "<a href=\"#\" class=\"testclass\">"  .$first_name . " " .$last_name . "". ", &nbsp;" ."" .$church_org ."</a></li>\n";
echo "</ul>";
echo "</div>";
}
}

Here is my Javascript file (Ajax)

$(document).ready( function() {
	function formfill() {
		var organization = $('#organization').val();
		var firstname = $('#firstname').val();
		var lastname = $('#lastname').val();
		var email = $('#email').val();
		var phone = $('#phone').val();
		$.ajax ({
			method: "GET",
			url: "search.php",
			dataType: 'json',
			data: {
				organization:organization, firstname:firstname, lastname:lastname, email:email, phone:phone
			},
			type: "POST",
			success: function(data) {
				$organization
				$firstname
				$lastname
				$email
				$phone
			},
			
	 	failu  function() {
                alert('fail!');
            }
        });
	}
  

I know that I do not have a reference yet to JSON in my php file and that it is needed.  I'm not solid on the Ajax part.  That is the part that is tripping me up.  I know that I need to make the form autofill when clicking on a specific result returned from my query... but i'm not sure how to do that.   Thank you in advance for any help or advice you can give!!   I am relatively new to programming.  Hopefully I posted this in the right forum as a lot of these technologies overlap.
Edited by kjetterman, 26 September 2014 - 10:23 AM.

hey there peoples i have a bit of a problem with my php code. when i click on the name it wont play the video. but if i click on the thumbnail it plays here is the code

Code: [Select]
echo "<div class='Video_thumbnail'>";
  echo "<a href='/Video.php?id={$row['id']}'>";
  echo "<img src='http://i.ytimg.com/vi/{$row['link']}/hqdefault.jpg' width='220' height='170' alt='click' /></a>";
  echo "<br>";
  echo "</br>";
  echo "<a href='/Video.php?={$row['id']}'>";
  echo "{$row['navn']}</a>";
  echo "</div>";

You would think the answer would be all over the Internet and easy to find, but it’s not. I have searched many times, and in all the multitude of search results I have still never found an adequate usable answer. The MOST you ever find is someone saying how easy it is with PHP, but they don’t tell you how, even when the person they are answering asks them (odd). You can be that one in a billion person who finally answers it for real and helps someone out.

I have a simple HTML form with data fields first_name, last_name, email, phone, country, a few hidden inputs, and a single submit button, like so:

(Please note: the method is GET, not Post.)

<form action="https://MyDomainOnMyServer.com/MyPHPScript.php”> 
<input type="text" name="first_name" value="" />
<input type="text" name="last_name" value="" /> 
<input type="text" name="email" value="" /> 
<input type="text" name="phone" value="" /> 
<input type="hidden" name="type" value="type123"> 
<input type="hidden" name="project" value="new123"> 
<select required name="country"> 
<option value="">Choose your country</option> 
<option value="US">United States</option> 
<option value="CA">Canada</option> 
<option value="GB">United Kingdom</option> 
<option value="Many More">Many More Countries</option> 
</select> 
<input type="submit" value="Submit Form" /> </form>

NOTE: Originally, the form action would have been:

action="https://TheirExampleDomainOnTheirRemoteServer.com/TheirRemotePHPScript.php" name="form1234"

Upon clicking the single submit button only, what I need to have happen is this:

1. Send me an email to whatever@whatever.tld containing all the form submission data

2. Place the form submission data into a MySQL database having the corresponding data fields

3. Send the form submission contents including the hidden input values to "https://TheirExampleDomainOnTheirRemoteServer.com/TheirRemotePHPScript.php" name="form1234" AS IF that had remained set as the original form action to begin with

So basically what I’m trying to obtain is the cleanest possible PHP script that will do those three things, which is essentially what others have asked for over the years in search results I have found, but no one has ever provided it in a clear instance that works. If I can just see such a script, I should be able to see how it works and then do what I need. Thanks.

Reply

 I have a clothing store website which displays all my products with a price range of $0-$25 great on left side of my webpage with the count number beside it like so.

hi i am trying to make a payroll calculator script that takes employee info, calculates pay, displays submitted info in a table, stores info in an array, and updates the array when new info is submitted. i have most of these accomplished, i am having trouble with the "store into an array, and update the array when new info is submitted" parts of the project. i am still not very fluent in php so there may be easier ways to achieve what i have so far. any pointers would be a great help, this part has got me stumped.

Hi Members,   I am search for the reason for the problem why my mysql query cannot fetch data and store in file based on id in $variable form. For example, $sql="SELECT * FROM mytable WHERE mine_id='1234'"; works for me. But when i use $sql="SELECT * FROM mytable WHERE mine_id='$id'";, files are created as empty. I chanaged the quotes and could not store the data in file. So anyone please help me. For more clear, i attach the part of my code

for ($i=0;$i<=10;$i++)
    {

$id=$seqs[$i];
$dbo = new PDO($dbc, $user, $pass);
echo $sql = "SELECT * FROM mine_id WHERE locus_id='$id'";

$qry = $dbo->prepare($sql);
$qry->execute();
$data = fopen('file.csv', 'w');

   while ($row = $qry->fetch(PDO::FETCH_ASSOC))
              {
          fputcsv($data, $row);
             }
    }

Edited by phpnewbie007, 20 November 2014 - 02:17 AM.

Hello all,   I am completely sideways right now trying to get this to work.  Basically I am attempting to make a form that fetches results based on a drop down and then populates a text box that the user can then edit.  I have several issues, first of all, I would have to use check boxes for if a user has a certain file on record.  Which would be editable, however, I have had issues displaying tinyint values of -1 as true and 0 as false.   Secondly, writing the data back to the table after clicking a submit button, I have still issues with checkboxes here and am thoroughly confused to if I need to use an array or what here.   Thirdly, should I be using PDO or mysql for this?  We have an older NAS device that I will be running this on and the firmware is older.   All the info is stored in the same table, and would be selecting a single record at a time for a user to edit.  I was thinking I would just write back ALL values to the table when submit is clicked? Is that a bad idea?   As you can tell I just need someone to kick my butt in the right direction, I feel like I have read all the different ways to skin a cat but confused myself in the process.   Thanks

I'm having a few issues with a serach function in Internet Explorer, it works fine in firefox which is very annoying.

What basically is happening, is the a form is sumbitting and posting info across, but on itself and then this is transfered into a php variable which is used on the query. Default values have been assigned if the isset of the form is not true.

So I believe the issue is occuring on the " if(isset($_POST['submit'])) " but as stated it works perfectly fine in firefox. Any suggestions? 


Code: [Select]
<?php



print "
<form target='_self' method='POST'>
<table class=''> 
<tr> 
<td>
<input name='vehicle' type='text' id='search_name' size='16'>
<input type='image' src='images/search.gif' alt='Search' name='submit' id='search' value='Search'/>
</td>
</tr>
<tr>
<td>
<select name='filter' id='filter'>
<option value='make' selected='selected'>Filter By</option>
<option value='make'>Vehicle Manufacture</option>
<option value='model'>Vehicle Model</option>
<option value='our_price'>Price</option>
<option value='delivery_time'>Delivery Time</option>
</select>
</td>
</tr>
<tr>
<td>
<input type='radio' name='direction' value='ASC' checked/>Ascending 
<input type='radio' name='direction' value='DESC' />Descending

</td>
</tr>
     </form>
      ";
include "connections/dbconnect.php";

if(isset($_POST['submit'])) 
{
$vehicle = $_POST['vehicle'];
$filter = $_POST['filter']; 
$direction = $_POST['direction']; 
//$rowsPerPage = $_POST['limit']; 
}
else
{
$filter = "make"; 
$direction = "ASC"; 
}  
//$manfactures = "Ford";

if(isset($_GET['limit'])) 
{
$rowsPerPage = $_GET['limit'];;
}
else
{
// how many rows to show per page
$rowsPerPage = 10;
}


// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];

}

// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;


$car_query = " SELECT * FROM cars WHERE model LIKE '%$vehicle%' OR make LIKE '%$vehicle%' OR model_details LIKE '%$vehicle%' OR search LIKE '%$vehicle%' ORDER BY $filter $direction LIMIT $offset, $rowsPerPage";
$car_result = mysql_query($car_query) or die ("Error in query: $car_query. ".mysql_error()); 
setlocale(LC_MONETARY, 'en_GB');
$fmt = '%i';

// how many rows we have in database
$query   = "SELECT COUNT(model) AS numrows FROM cars";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);

// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav  = '';

for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pageNum)
   {
  $nav .= " $page "; // no need to create a link to current page
   }
   else
   {
  $nav .= " <a href=\"$self?page=$page&limit=$rowsPerPage\">$page</a> ";
   }
}

if ($pageNum > 1)
{
   $page  = $pageNum - 1;
   $prev  = " <a href=\"$self?page=$page&limit=$rowsPerPage\">[Prev]</a> ";

   $first = " <a href=\"$self?page=1&limit=$rowsPerPage\">[First Page]</a> ";
}
else
{
   $prev  = '&nbsp;'; // we're on page one, don't print previous link
   $first = '&nbsp;'; // nor the first page link
}

if ($pageNum < $maxPage)
{
   $page = $pageNum + 1;
   $next = " <a href=\"$self?page=$page&limit=$rowsPerPage\">[Next]</a> ";

   $last = " <a href=\"$self?page=$maxPage&limit=$rowsPerPage\">[Last Page]</a> ";
}
else
{
   $next = '&nbsp;'; // we're on the last page, don't print next link
   $last = '&nbsp;'; // nor the last page link
}



if (mysql_num_rows($car_result) > 0) 
{


...... bringing back all the information from the database