PHP - Curl Spaces Errror?

ok so when my code dipsplays i get the spaces i add in the db but when i updae it dispalys this rnrnrn and its all together
Code
Code: [Select]
<?php
include "scripts/connect.php";

if(isset($_GET['edit'])){

$newid = $_GET['edit'];

$query = mysql_query("SELECT * FROM news WHERE id='$newid' LIMIT 1");
$rows = mysql_fetch_array($query);

$newstitle = $rows['title'];
$newsby = $rows['by'];
$newsbody = $rows['body'];

}

if(isset($_POST['saveedit'])){

$newid = mysql_real_escape_string($_POST['saveedit']);
$newstitle = mysql_real_escape_string($_POST['title']);
$newsby  = mysql_real_escape_string($_POST['by']);
$newsbody = mysql_real_escape_string($_POST['body']);

if ($newstitle && $newsby && $newsbody){

$query = mysql_query("UPDATE news SET title='$newstitle', 'by'='$newsby', body='$newsbody' WHERE id='$newid'") or die(mysql_error());

echo "UPDATE SUCCESFULLY!";

}else
   $msg = "<font color=red>YOU DID NOT FILL ALL OF THEM IN!</font>";
}
?>
<form action='enews.php' method='POST'>
<table>
<tr>
<td></td>
<td><?php echo "$msg"; ?></td>
</tr>
<tr>
<td>Article Title</td>
<td><input type='text' name='title' size='45' value='<?php echo $newstitle; ?>'/></td>
</tr>
<tr>
<td>By:</td>
<td><input type='text' name='by' size='30' value='<?php echo $newsby; ?>' /></td>
</tr>
<tr>
<td>Article Body</td>
<td><textarea cols='45' rows='25' name='body'><?php echo  stripslashes($newsbody); ?></textarea></td>
</tr>
<tr>
<td><input type='hidden' name='saveedit' value='<?php echo $newid; ?>'/></td>
<td><input type='submit' name='updatebtn' value='Update' /></td>
</tr>
</table>
</form>
</div>

echo $first$last;

how would i add a space it comes out like this

JoeJackson
i want it like this Joe Jackson

I have a form which has a drop down menu select box, which retrives the makes of cars from a database, which once clicked submit will go to another page post that info. Then a if statment says if the variable that has been posted == a certain word that matches the one in the database then display content. However, my issue is when I have a car make such as "Land Rover" saved in the database as typed it just comes back with the final else statement.

In the 1st section I have included the form which is posting the information across and in the second I have the if statement. Any ideas of how to get around / make this work?

[
<form method="post" action="details.php" enctype="multipart/form-data">
                              <table class="search_nav">
                                 <tr>
                                    <td>
                                       <select name="manufacture" id="manufacture">
                                          <option value=" " selected="selected">Car Manufactures&nbsp;&nbsp;</option>
                                          ';
                                          $query = "SELECT DISTINCT make FROM cars ORDER BY make ASC";
                                          $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());                                             
                                          while ($row = @ mysql_fetch_array($result))
                                          {
                                              print '
                                                    <option value='.$row["make"].'>'.$row["make"].'</option>
                                                   ';
                                          }
                                       print '
                                    </select>
                                  </td>
                              </tr>
                              <tr>   
                                 <td colspan="2">
                                    <input type="image" src="images/go.gif" alt="Go" name="submit" id="submit" value="Submit"/>
                                 </td>
                              </tr>
                           </table>
                           </form>
]

[

if ($manufactures == "Land Rover")
               {
echo "test";

}
]

How can I block a text that contains only spaces?
Right now I have done

if ($body == "") {
die("<font color='red'><font size='15'><strong><center>Your post did not contain any text!");
}

But that's extremely insufficient, as any user can easily post "         "
Any ideas?

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'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?

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'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 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");
}

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'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>

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