PHP - Mysql & Spaces

Hi,
I am trying to parse a html page, but i get a lot of empty spaces, please any idea how can i remove spaces, here is my text:
Code: [Select]
         
       
         
this          goes here

 

   
   
     








one line here

 







some other line here










see there is a lot of space between text,

thanks for any help

Code: [Select]
Address: 351 Hougang Ave 3 (769057)
Contact No: 6752 5513
Operating Hours: 8.00am - 9.30pm (Thursday to Tuesday & Public Holidays)
Background: Opened to the public on 30 Mar 88
Hi good day, if I paste the above address into one of the mysql field, I found out that I cannot fetch it using php. It give me a blank page.

Code: [Select]
Address: 351 Hougang Ave 3 (769057) Contact No: 6752 5513 Operating Hours: 8.00am - 9.30pm (Thursday to Tuesday & Public Holidays) Background: Opened to the public on 30 Mar 88

When I sort it together then i can see mysql working, very strange.. Can anyone help?

I am trying to use CURL on a site., to send SMS/TXT messages.

HERE IS THE CODE

Code: [Select]
$name = $_POST['name']; 
$emsg = $_POST['emsg'];

           $ch = curl_init("https://www.smsfun.com.au/api/login.php?mobile=emma&password=123456&send_to=$name&message=$emsg&send=1");
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        $output = curl_exec($ch);       
        curl_close($ch);


Then i use my form like this

Code: [Select]
<form method="post" action="" value "">
  <p align="center"><strong><font color="#0000FF" size="5" face="Courier New, Courier, mono">MOBILE
    NO<br>
    <input name="name" type="text">
    </font></strong></p>
  <p align="center"><strong><font color="#0000FF" size="5" face="Courier New, Courier, mono">message</font><font color="#0000FF" size="5" face="Courier New, Courier, mono"><br>
    <textarea name="emsg" value "$emsg" rows="5" wrap="VIRTUAL"></textarea>
    </font></strong><br>
    <input type="submit" name="submit" value="SEND">
  </p>
</form>

This all works fine but if the user needs to put a space after a word i.e  "hello this is a test" this wont work only "hellothisisatest" will.

Am i missing somtink here? I tryed googleing etc cannot find the answer.

Please help

Thanks

g-netUK

I'm looking for a function that will check a string for letters and spaces...boolean preferibly

How do I get directory names to display with spaces. My script sticks them into arrays just fine, but when trying to echo from a checkbox selection, it only displays the first word. How would I fix this?

Ok so I'm still having problems. This is what I need:
I want a function to echo a message if a username does not pass my requirments.

  - Only letters and / or numbers
 - Must start with a letter (not a number)
 - No spaces

The current code is not working for me. Please help
Code: [Select]
}else if (!(eregi('/[A-Za-z0-9-]+',($_POST["username"])))){
echo "<p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><br />Must only contain numbers and letters and cannot exceed 10 characters.<p>&nbsp;</p><p>&nbsp;</p><a href='javascript:javascript:history.go(-1)'>Click here to go back to previous page</a>";

I've got the following code:

echo <<<myStringEcho

<script src="$myPluginPath/jquery.dummy.js"></script>
myStringEcho;

The problem is that $myPluginPath already has a / character at the end, so I don't need to put it in above
But, I can't just remove it, otherwise I'll get $myPluginPathjquery.dummy.js

How can I insert and have no spaces?

Thanks


OM

I'm having some trouble with displaying my white space between words. I have a table that holds records for resumes, and the administrator can access each record and edit them. I have the record displayed in text boxes for editing, but the white space between words is not showing up. Only the first word will show up. I have tried changing the field type in the table to text or blob instead of varchar, and I have tried using the nl2br function when displaying the records, but that isn't working either. What am I doing wrong? Here is my edit page:

Code: [Select]
<?php

$applicant = "SELECT * FROM applicants WHERE id = '$_GET[id]'";
$applicant_res = mysql_query($applicant, $conn) or die(mysql_error());

$display_block = "<h3>Edit Entry</h3>
<p>To edit the entry, change any relevant information below:</p>

<form method=post action=update_U3IP.php><table>";

while ($applicants_list = mysql_fetch_array($applicant_res)){
$id = $applicants_list['id'];
$firstname = $applicants_list['firstname'];
$lastname = $applicants_list['lastname'];
$address = $applicants_list['address'];
$city = $applicants_list['city'];
$state = $applicants_list['state'];
$zip = $applicants_list['zip'];
$phone = $applicants_list['phone'];
$position = nl2br($applicants_list['position']);
$file = $applicants_list['resume'];

$display_block .= "
<table>
<tr>
<td><label for=id><b>ID:</b></label></td>
<td><input name=id type=text size=2 id=id value=$id /></td>
</tr>
<tr>
<td><label for=firstname><b>First Name:</b></label></td>
<td><input name=firstname type=text size=20 id=firstname value=$firstname /></td>
</tr>
<tr>
<td><label for=lastname><b>Last Name:</b></label></td>
<td><input name=lastname type=text size=20 id=lastname value=$lastname /></td>
</tr>
<tr>
<td><label for=address><b>Address:</b></label></td>
<td><input name=address type=text size=20 id=address value=$address /></td>
</tr>
<tr>
<td><label for=city><b>City:</b></label></td>
<td><input name=city type=text size=20 id=city value=$city /></td>
</tr>
<tr>
<td><label for=state><b>State:</b></label></td>
<td><input name=state type=text size=20 id=state value=$state /></td>
</tr>
<tr>
<td><label for=zip><b>Zip:</b></label></td>
<td><input name=zip type=text size=20 id=zip value=$zip /></td>
</tr>
<tr>
<td><label for=phone><b>Phone:</b></label></td>
<td><input name=phone type=text size=20 id=phone value=$phone /></td>
</tr>
<tr>
<td><label for=position><b>Position:</b></label></td>
<td><input name=position type=text size=20 id=position value=$position /></td>
</tr>
<tr>
 <td><b>Uploaded Resume:</b></td>
 <td><input type=text name=file id=file value=$file /></td>
 </tr>
 <tr>
 <td colspan=2>&nbsp;</td>
 </tr>
 <tr>
 <td colspan=2 align=center>
 <input type=hidden name=hidden_id id=hidden_id value=$id />
<input type=submit value=Submit />
<a href=admin_U3IP.php><input type=button name=back id=back value=Back /></a></td>
</tr>";

}

$display_block .= "</table></form>";

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>KulaE_WDP4451_U3IP</title>
</head>
<body>
<?php echo $display_block; ?>
</body>
</html>

How can I check if the text entered in a textarea field equals the text I have stored in a mysql table?

Code: [Select]
$submitted_description = trim(mysqli_real_escape_string($db,$_POST['description']));

$query = "SELECT description FROM pets";
$result = $db->query($query);
$row = $result->fetch_assoc();
$sql_description = $row['description'];
Here's what they echo:

Quote

submitted_description:
Testing...\r\n\r\n1\r\n\r\n2\r\n\r\n3

sql_description:
Testing... 1 2 3


I tried adding the following to get rid of \r\n from $submitted_description but they both still don't equal but echo the same text.

Code: [Select]
$submitted_description = str_replace(array("\r","\n",'\r','\n'),' ', $submitted_description);
They following code only matches when no spaces are entered in the textarea field.

Code: [Select]
if($submitted_description == $sql_description)
{
     echo "Match!";
}
else
{
     echo "Don't Match!";
}
How can this be done?

I also tried adding nl2br() to both variables but that didn't work either.

Hi, the problem that I have goes like this. If i do a regular Select query and display it in a table everything is there but if i am filling a input box of a form to use for modifying the values it does not return the entire value:

Exemple with the same value
in a table = product_name : Amd Athlon X2
In input field : Amd

Here is my code
Code: [Select]
<?
$sql = "SELECT * FROM tbl_product WHERE product_code = '$_POST[productcode]'";
$result = mysql_query($sql);
if(!$result){
die("Error running $sql:" . mysql_error());
}
?>


<?
 while($row = mysql_fetch_array($result))
 {
echo "
<form action='functions/moditem.php' method='post'>
<input type='hidden' name='productid' value=". $row['product_id'] .">
Product code : <input type='text' name='productcode' value=". $row['product_code'] ." /><br />
Product Name : <input type='text' name='productname' value=". $row['product_name'] ." /><br />
Product Price: <input type='text' name='productprice' value=". $row['product_price'] ." /><br />
<input type='submit' value='Modify' />
</form>
";
}

I am using a standard form to mail script and have a few fields that I need to be required to be filled in.
This is working fine until someone enters a space character in a required field, which is being let thorugh.

How can I stop this? here the code for required fields -  I thought the trim function in the below would have taken care of this???

// This is because I originally had it require but too many people
// were used to Matt's Formmail.pl which used required instead.
if ($required)
   $require = $required;
// handle the required fields
if ($require) {
   // seperate at the commas
   $require = ereg_replace( " +", "", $require);
   $required = split(",",$require);
   for ($i=0;$i<count($required);$i++) {
      $string = trim($required[$i]);
      // check if they exsist
      if((!(${$string})) || (!(${$string}))) {
         // if the missing_fields_redirect option is on: redirect them
         if ($missing_fields_redirect) {
            header ("Location: $missing_fields_redirect");
            exit;
         }
         $require;
         $missing_field_list .= "<b><font color=\"#990000\">Missing: $required[$i]</font></b><br>\n";
      }
   }
   // send error to our mighty error function
   if ($missing_field_list)
      print_error($missing_field_list,"missing");
}

Hi - I'm using Wordpress gravity forms plugin. I'd like to force capitalise and remove the spaces within a specific field. This is what I have but its not working.  $_POST[$each] = strtoupper(rgpost($each)) works for making the characters capitals but adding && str_replace(' ', '', $each) after doens't work. What am I doing wrong? Thanks

add_action('gform_pre_submission_22', 'capitalize_fields');
function capitalize_fields($form){
      
        $fields_to_cap = array(
                     'input_64'
										);
        foreach ($fields_to_cap as $each) {
              
                $_POST[$each] = strtoupper(rgpost($each)) && str_replace(' ', '', $each);
				        }
        
        return $form;
} ?>

Hi, I have a problem with Internet Explorer converting spaces into underscores:

The problem occurs using PHPRtfLite.

When I run the script I want the file name to contain spaces, however in Internet Explorer these spaces are converted into underscores. This does not happen in ff, chrome, safari or opera.

Any help on how to fix this would be much appreciated as I am stuck. Thanks.
Joe

p.s.
Here is how the file name is created
$filename = "Mysite - ".$u-ID."' (".$user_name.").rtf";

people on my forum (speakwhatsreal.com)
submitting blank spaces

Code: [Select]

like they just copy/paste the blank space in the textarea and how do I check input on that, does strlen work?

hi,
i have a search engine that searches keywords in mysql database...

i have a simple form but if someone enters a load of spaces it displays the whole database contents.. also i wanna remove any words less then 3 characters being searched for..
i have

(strlen($search)<=3)

what else should i add??

cheers