PHP - Basic Quotes Problem

I don't think I've asked this before have I??  can someone give me an internet KB that gives me all scenarios that warrant using singles or doubles?  as in, wrapping values, variables, and why I need to do either, and when, etc, etc....?

thanks

Edited March 29 by ajetrumpet

Hi... I'm trying to make a form to edit a database entry that will be pre-populated with the current contents of the row being modified. Unfortunately, I only seem to be able to get it to pre-populate with the first word in each field (as in, if I had "two words" in a field, what would show up in my form is the word "two").

I've spent quite a while poking around on the web, and I'm 75% certain that my problem has something to do with my use/positioning of quotes, since that frequently seems to cause just this issue in just this situation, but none of the solutions I've found seem to help... Any advice would be much appreciated, I'm thoroughly stuck.

Code is currently as follows:
<?php
require("dbinfo.php");

$con = mysql_connect("localhost", $username, $password);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db($database, $con);

$result = mysql_query("SELECT * FROM main WHERE id='$_POST[id]'");

while($row = mysql_fetch_array($result))
  {
  echo "<form action='update.php' method='post'>";
  echo "<input type='hidden' name='id' value=".$_POST['id']."><br>";
  echo "Name: <input type='text' name='name' value=".$row['name']."><br>";
  echo "Type: <select name='type' value=".$row['type'].">
<option value='Food Pantry'>Food Pantry</option>
<option value='Food Pantry'>Soup Kitchen</option>
<option value='Food Pantry'>Shelter</option>
<option value='Food Pantry'>Other</option></select><br>";
  echo "Address: <input type='text' name='address' value=".$row['address']."><br>";
  echo "State: <input type='text' name='state' value=".$row['state']."><br>";
  echo "Phone: <input type='text' name='phone' value=".$row['phone']."><br>";
  echo "E-mail: <input type='text' name='email' value=".$row['email']."><br>";
  echo "Website: <input type='text' name='website' value=".$row['website']."><br>";
  echo "Hours: <input type='text' name='hours' value=".$row['hours']."><br>";
  echo "Requirements: <input type='text' name='requirements' value=".$row['requirements']."><br>";
  echo "Additional Information: <input type='text' name='additional' value=".$row['additional']."><br>";
  echo "<input type='submit' />";
  echo "</form>";
  }

mysql_close($con);
?>

After getting valuable help from DavidAm and wildteen88 I am left with this last piece to the puzzle:

I have created a function which identifies the names of multi-value checkbox fields used on a Post page where a form just filled out has been saved in a serialized array which will contain associative arrays wherever the checkboxes have been selected.

Now I need for the checkbox associative arrays returned on this Review before-final-saving-page to be detected or identified and then Changed to a comma-delimited array, or maybe it just gets converted to one string with commas separating what were parts of the array--I am not sure about that.

At any rate, here are the functions that WORK to do this---but they depend on knowing the specific checkboxes that will show up ahead of time:

 
$postvals['cp_checkbox_amenities']= implode(',', $_POST['cp_checkbox_amenities']);
   $postvals['cp_checkbox_days']= implode(',', $_POST['cp_checkbox_days']);
   $postvals['cp_checkbox_3']= implode(',', $_POST['cp_checkbox_3']);


So I created a function which polls the form and finds the specific names of the checkboxes used on this page--the function ends like this:

        $results = $wpdb->get_results($sql);

        if($results) {

        foreach ($results as $result):
            // now grab all ad fields and print out the field label and value

echo '<li><span>' . $result->field_name . '</li>';

endforeach; 
}

     else {

      echo __('No checkbox details found.', 'cp');

    }
 
}

}

This returns the following:

<li><span>cp_checkbox_help</span></li><li><span>cp_checkbox_charley</span></li><li><span>cp_checkbox_hello</span></li>
</li>


So, I then tried to REPLACE the hard-code functions I show above that take the checkbox arrays and implode them for saving when this form is updated as comma limited values.

I tried various versions of this using the same loop that produced the <li> list with  $result->field_name      :


       foreach ($results as $result):
            // now grab all ad fields and print out the field label and value

   $postvals['. $result->field_name .']= implode(',', $_POST[ '. $result->field_name .']);

endforeach; 
}

     else {

      echo __('No checkbox details found.', 'cp');

    }
 
}

}

Every different way I try to get something either errors out or does not perform the Implode, or notifies me that the Implode is creating problems.

SOMEHOW, dynamically for each loop I need for a ' single quote mark to appear on each side of $result->field_name  so that I have dynamically written in the php code the equivalent to

 
$postvals['cp_checkbox_amenities']= implode(',', $_POST['cp_checkbox_amenities']);
   $postvals['cp_checkbox_days']= implode(',', $_POST['cp_checkbox_days']);
   $postvals['cp_checkbox_3']= implode(',', $_POST['cp_checkbox_3']);

the $result->field_name gives me a cp_checkbox_3  or a cp_checkbox_amenities, etc,, but I cannot break it down so that

$postvals['$result->field_name']= implode(',', $_POST['$result->field_name']);

WORKS

and I have tried with [PHP? echo ''' .$result->field_name . ''' ?>] and other ways.

Incidentally, ", double quotes don't play nice on this server with PHP 5.

And I have tried combinations of " '  double quote then single quote and on the other side ' " inside the associative array brackets.. nothing works--either I get errors, implode warnings, or the arrays of these checkboxes do not get changed to comma delimited arrays if the page loads and saves without errors.

I'd appreciate receiving what must be an elegantly simple solution!

A problem has arisen which puzzles me. I have forms which save data to MySql and retrieve it, showing it as the default data in the form. Naturally I escape any quotes before sending it to the database and remove the slashes when I retrieve it. But the form HTML code shows the data like this value="$variable" which is fine when only single quotes are used in the data but causes a problem when the user uses double quotes. So data of John \"Jack\" Smith would be output as value="John "Jack" Smith" with obvious problems. If I use value='...' then that would cause problems with single quotes.

I haven't seen the answer in any of my books. The only things I can think of is changing all double quotes to single before saving to DB or converting them with htmlspecialcharacters so they are no longer actual quotes.

http://i.imgur.com/6olCy.png
The picture (in the imgur link) pretty much describes what I'm trying to do. As it stands, it would take too long to simply do everything manually with html and css (both of which I'm pretty good at I think), moving all img src and dates from one div tag to another whenever I wanna add something. So yeah, what's the most efficient way to simply submit a picture, and all my other pictures will move?

I know some of you guys will say to just learn php, but quite frankly, I don't have the time... and all the php books are ~1000pgs long which seems really daunting. I know, my problem's pretty basic and it'll probably be covered in the first 100pages or so, but still, like I said I don't have that much time for the moment.

When I do, however, can you guys recommend me the quickest guide/video series/book to learn practical php? Not the most comprehensive, as the stuff I'm going to be doing's not that complex.

One last thing, I've been hearing about CakePHP; what is it? I read that it's an "open source web application framework", but I still have little clue. I'm currently using dreamweaver for all my web stuff (no I do not use the WYSIWYG feature, I just grown accustom to using it). Should I "learn cakephp"?


Please answer any one of those questions (particularly the first one). Many thanks and I'll be sure to reply!

I have a table 'combo' with two fields, id and char. I want to populate a table, with the following query which fails. $sql = mysql_query("SELECT id,char FROM combo ORDER BY id DESC LIMIT 28");  I a bit rusty on sql but can't see what is wrong with this. Can anyone help please.

Hi, I'm very new to PHP so I hope this is not frustrating. I'm having trouble understanding how "isset" works. I'm trying to get it so that when I click a button, it returns two variables(in an array). This works, but I tried to use "Isset" to detect if a array was created, then alter the variable. It's not working... I'm not too sure where I'm going wrong, could anyone give me some advice? Thanks

<?php 


if(isset($_POST['name']))
{
	$userAnswer = $_POST['name'];
	if(isset($_SESSION['test'])){
			$_SESSION['test'][$userAnswer]['var1']++;
			$test = $_SESSION['test'][$userAnswer];
			foreach ($test as $key){
					echo json_encode($key);
						};
					}
	
	else {
	$test = $_SESSION['test'][$userAnswer]=array("var1" => 1, "var2" => 2);
	
	foreach ($test as $key){
				echo json_encode($key);
				};
	}
}


?>

$(document).ready(function(){
  $("button").click(function(){

                var test = "here";
                $.ajax({
				     url: 'info.php', 
				     type: "POST",
				     dataType:'json', 
				      data: ({name: test}),
				     success: function(data){
				     	     
					 $("#click").fadeOut(function() {
					 		 $(this).append(data);
					 		 
					 }).fadeIn();
					
				     }
				 
					});
  });
  
});

Ok first of all I want to apologize for asking what I'm about to ask. I understand it should be some stupidly easy to find mistake but considering the fact I have to send the code tomorrow leaves me with little to no time to try and find the solution so I'll be asking here and hope that by the time I wake up tomorrow an answer will be here and I'll be able to resume scripting.

So my problem is that I just can't find how to make php commands run at all. I tried just randomly inserting them into my html code then found out it needs a separate file. So I created the basic.php with this code:
<html>
<body>

<?php
echo "Hello World";
?>
<div>adgaeganerhaohn</div>

</body>
</html>
tried opening it through a form in my html code but it wouldn't print the Hello world line, then I tried running it straight into firefox but I only got adgaeganerhaohn again (without that line I get a white page) So I need to know what am I doing wrong?

I have php5.301 installed with default options (no server).

thanks for your help beforehand, once I get a bit more into php I'll be coming back with serious questions but for now I really need someone to tell me how php is supposed to work and what I'm doing wrong

Hi,

I have just started using PHP again after a long break and am very rusty. I am having a few problems with some basic things:

I have defined a function to connect to my MySQL database and it doesn't work. My $hostname, $username, $password variables are stored in a separate php file which I am including first and the standard mysql_connect function works ok, but I wanted to put it inside another user defined function called "condb" to make things quicker later.

my function looks like this:

function condb(){ 
mysql_connect($hostname, $username, $password) OR DIE ('Unable to connect to database! Please try again later.');
}

and I am trying to run it like this:

condb();

Unfortunately it is not working. Probably a basic error but any help appreciated.
Thanks

Hello,

Using the following code, I'm extracting the $current_solution from my database.  However, if the variable has quotes in it, I get gobbledegook.  Code: [Select]
<input type ="radio" name="solution" <?php  echo 'value="' . $current_solution . '"' ?> id="solution" <?php if ($row['solution'] == $current_solution) {echo 'checked = "yes"';} ?>/><?php echo$current_solution; ?></label>
As an example, if the $current_solution variable is:  A right-side up letter u   then I get:

" id="solution" checked = "yes"/>
A right-side up letter "u".

I know that it's a quote issue but am not sure how to fix it.  I tried adding slashes but I fear that it didn't work.  Any thoughts on this would be appreciated!

Thanks so much,

Eric

Hi...

I'm trying to get this code to work:
echo "<a href='". $row['img_path']."'><img border=0 src='". $row['thumb_bw_path']."' onmouseover='this.src='". $row['thumb_path']."'' onmouseout='this.src='". $row['thumb_bw_path']."'' />". "</a></td> \n";

To get the hover effect that i want there is alot of quotes. The hover effect does not work and i guess it is
because of the wrong use of quotes.
The correct way is:
Code: [Select]
onmouseover="this.src='source_to_image'"
But the use of double quotes " is not possible...
Is there a simple solution to this?

i have some code which checks to see if a username  and an email is in use. from what i can understand, it uses magic quotes to prevent sql injection. i've heard that magic quotes are not going to be in use in php6, so how can i change it so that it uses real escape string instead?

if (!get_magic_quotes_gpc()) {
$_POST['username'] = addslashes($_POST['username']);
}
$usercheck = $_POST['username'];
$check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'") 
or die(mysql_error());
$check2 = mysql_num_rows($check);
if ($check2 != 0) {
die('Sorry, the username '.$_POST['username'].' is already in use.');
}

if (!get_magic_quotes_gpc()) {
$_POST['email'] = addslashes($_POST['email']);
}
$emailcheck = $_POST['email'];
$check = mysql_query("SELECT email FROM users WHERE email = '$emailcheck'") 
or die(mysql_error());
$check2 = mysql_num_rows($check);
if ($check2 != 0) {
die('Sorry, the email '.$_POST['email'].' is already registered to another account.');
}


Thanks

Hi, newbie here.
Could someone show me how to properly escape the quotes in this code so it works properly? I'm having major problems with it, thanks.

echo "<td style="background-color:#fff"
 onMouseover="this.style.backgroundColor='#ff9900';"
 onMouseout="this.style.backgroundColor='#fff';">"

If I put into the database this string: Call the wife's son tomorrow

How do I put it in to keep that apostrohe (wife's) and then when I retrieve it, also keep it without it displaying as wife/'s

If I use stripslashes I think that just gets rid of the slash, but I want to KEEP the slash (but still protecting the database so it is not seen as a quote by the php code).

I hope this is clear :-)