PHP - Entering Numbers In Different Formats

$name value is coming through from form submission.

<?php
if(isset($_POST['Submit']))
{
$name=$_POST["Name"];

}

If statement is not working properly. Whether $name is empty or not, it adds the where clause.

?>

<?php
    $sql = "SELECT * FROM dirCsv_500" ?>
 <?php if (!empty($name)) {
    " where name like '%".$name."%'";
} ?>;

What's the best way for putting actual quotations into a database?

I was using...

$quote = htmlspecialchars(mysqli_real_escape_string($dbc, $_POST['quote']));

Should I be?

Hi,
I need to sort variables in groups of up to 15 and put it in an array. For example:
$exstract['center_tabOpBody_0'] =5
$exstract['center_tabOpBody_1'] =6
$exstract['center_tabOpBody_2'] =8
$exstract['center_tabOpBody_3'] =1


Should yield:
ARRAY(
          = center_tabOpBody_1,center_tabOpBody_2,center_tabOpBody_3 // <-----15 [1] = center_tabOpBody_0 //<----5
)

Is there some simple function do do the "efficiency" sort?

Thanks,
Vadim

How would I incorporate a function to simply check the "name" and "message" for a certain amount of chars, like 15 & 150?

Code: [Select]
<form method="post" action="chat.php">
<p><input name="name" type="text" id="name" value="your name" size="10" maxlength="15">
<input name="message" type="text" id="message" value="your message" size="20" maxlength="150">
<input name="submit" type="submit" id="submit"></p>
</form>
</body>
</html>
<?php

// when the submit button is clicked
if(isset($_POST['submit']))
{

// strip any html tags before continuing
$name=strip_tags($_POST['name']);
$message=strip_tags($_POST['message']);

// stop if nothing was entered
if($name!='')
if($message!='')
{

// trim any extra whitespace
$data=trim($name)."\n";
$data.=trim($message)."\n";

//open the text file and enter the data
$file_ar=file("db.txt");
$fp=fopen("db.txt","w");
fputs($fp,$data);
if($file_ar!=NULL)
{
$loop=0;
foreach($file_ar as $line)
{

// do not store more than 20 messages
if($loop>=19*3) break;
fputs($fp,$line);
$loop++;
}
}
fclose($fp);
}
}

// display the messages
$fp=fopen("db.txt","r");
while(!feof($fp))
{
$name=trim(fgets($fp,999));
$message=trim(fgets($fp,999));
if($name!='')
{
echo "<p><b>$name: </b>$message</p>";
}
}
fclose($fp);
?>

I have a text firld to enter amount af a book,But i need to check whether the data entering is numeric only eg:70.98 etc.
how can i achieve this.

my code is
echo"<table><tr><td></td><td>Amount  in USD</td><td></td><td><input type='text' name='amnt' id='amnt'  /> </td><td></td></tr></table>";

 I have written code in php to connect and insert rows into a MSSQL database. i used odbc to connect database.user can enter his details through the form. after submitting the form the details are getting stored into a database. while inserting rows into a database am not trying to insert duplicate values . for this i have given if conditions.these conditions are able to notice the user cname and name exist in the database if the same name exist. but the else part after these conditions are not working i.e rows are not getting inserted. i put everything inside the while loop. how can i correct it? This is my php code.

          $connect = odbc_connect('ServerDB','sa', 'pwd');
          //connects database 
         $query2="select count(*) from company";//this is needer for loop through 
         $result2=odbc_exec($connect,$query2);   
        while(odbc_fetch_row($result2));   
        {     $count=odbc_result($result2,1); 
           echo "</br>","$count";     } 
          $query1="select * from company";     
          $result1 = odbc_exec($connect, $query1);
          # fetch the data from the database         
          while(odbc_fetch_row($result1))
           {          $compar[$count] = odbc_result($result1, 1);     
           $namearray[$count] = odbc_result($result1, 2);
          if($compar[$count]==$_POST['cname'])   
          {          echo "<script> alert(\"cname Exists\") </script>";   
          }         
          else   if($namearray[$count]==$_POST['name'])     
         {        echo "<script> alert(\"Name Exists\") </script>";        }   
         else
         {     
         $query=("INSERT INTO company(cname,name) VALUES ('$_POST[cname]','$_POST[name]') ");   
          $result = odbc_exec($connect, $query);   
          echo "<script> alert(\"Row Inserted\") </script>"; 
         } 
         }

I know this problem comes up a lot but it can be for various reasons so after reading up I can't decide what might be wrong. I'm still learning!
I have a simple php registration form (first name, second name, email address) and every time a user submits an entry a second blank record is created in the MYSQL database after it.

Any help would be great. (php code in red)


Code: [Select]
[color=red]<?
$firstname=$_POST['firstname'];
$surname=$_POST['surname'];
$email=$_POST['email'];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO register VALUES ('','$firstname','$surname','$email')";
mysql_query($query);

mysql_close();
?>[/color]



Here is the section on the html HTML page that submits the form

Code: [Select]
<form action="register.php" method="post" class="BagTitle">
        <table width="700" border="0" cellpadding="0" cellspacing="2">
  <tr>
    <td width="100">First Name: </td>
    <td width="594"><input name="firstname" type="text" size="50" /></td>
      </tr>
  <tr>
    <td>Last Name: </td>
    <td><input name="surname" type="text" size="50" /></td>
      </tr>
  <tr>
    <td>E-mail:</td>
    <td><input name="email" type="text" size="50" /></td>
      </tr>
  <tr>
    <td colspan="2">&nbsp;</td>
      </tr>
  <tr>
    <td colspan="2"><input type="Submit" value="Send" />
        <input name="Reset" type="reset" value="Reset Form" /></td>
      </tr>
    </table>
      </form></p>
Also I have no idea about securing this information. Are there any basic steps I can take?

The dreadful apostrophie problem... This search form returns an error whenever searching with an apostrophie (')

Here's the code on the form (html)

      <td align="center" width="135"><form method="post" action="srch_advert.php"><input type=text name='search' size=15 maxlength=255><br><input type=submit></form></td>
      <td align="center" width="135"><form method="post" action="srch_details.php"><input type=text name='search' size=15 maxlength=255><br><input type=submit></form></td>
      <td align="center" width="135"><form method="post" action="srch_artist.php"><input type=text name='search' size=15 maxlength=255><br><input type=submit></form></td>
      <td align="center" width="135"><form method="post" action="srch_track.php"><input type=text name='search' size=15 maxlength=255><br><input type=submit></form></td>


and heres the code on srch_advert.php


if ($search)   // perform search only if a string was entered.
   {
    mysql_connect($host, $user, $pass) or die ("Problem connecting to Database");

    $srch="%".$search."%";

    $query = "select * from tvads WHERE advert LIKE '$srch' ORDER BY advert, year DESC, details ASC LIMIT 0,30";

 $result = mysql_db_query("cookuk_pn", $query);
    if(mysql_num_rows($result)==0) {
        print "<h2>Your search returned 0 Results</h2>";
   }

    else if  ($result)
    {

Hi, i need to run this past you guy's. I need a way to effectivly check if a user has entered correct "real" details in my registeration form and check if email is already in my database to prevent the user from registering twice?

I need this as some unknown person is using the form and entering there details like this:

Username: 1
Password: 1
email: 1

It's really annoying as they are doing this several times so i have around 13 rows of just "1" in my table now! grr!! 

so far ive got:


Form:
<input name="upassword" type="password" class="style7" id="upassword">
<span class="style7">Email</span>
<span class="style7">:</span>
<input name="email" type="text" class="style7" id="email">
<span class="style7"></span>
<span class="style7"></span>
<input name="Submit" type="submit" class="style7" value="Register" />
</form>


Script:
Code: [Select]
<?php if ($db_found) {

$SQL = "INSERT INTO users (username, upassword, email) 
VALUES ('" .$username. "', '" .$upassword. "', '" .$email. "')";
$result = mysql_query($SQL);




header( 'Location: http://www.removalspace.com/index.php' );  exit();
}
else {
print "Database NOT Found ";
mysql_close($db_handle);
}
?>

But i need it to perform the checks aswell as drop the "real" data in to MySQL? Any ideas please?

I have a calendar select date function for my form that returns the date in the calendar format for USA: 02/16/2012.  I need to have this appear as is for the form and in the db for the 'record_date' column, but I need to format this date in mysql DATE format (2012-02-16) and submit it at the same time with another column name 'new_date' in the database in a hidden input field.  Is there a way to do this possibly with a temporary table or something?

Any ideas would be welcome.

Doug

can you have something like..

echo $whatever;

this putput
1.2

can you split this number so the first integer will be in $val"(1)" or whatever and the second integer after the "." will be in $val2"(2)"

I have a cards array, and I have this function which will shuffle the cards for me. How can I edit this to 'deal' 12cards (6 & 6) until all the cards are a specific 6 & 6 I pick out?

Code: [Select]
   function ShuffleCards(&$cardsArray, $times)
   {
    // Randomizes where to split within center (-3 to +3 from dead center)
(MINIMUM 10 CARDS IN DECK)
    // Splits into two array. Randomizes how many cards from left and how
many cards from right (between 1 and 3)
    // Alternates sides. Continues until both arrays are empty.
    $arraySize = count($cardsArray);

    if($arraySize<10)
     return;

    $deadCenter = $arraySize/2;

    for($i=0;$i<$times;$i++)
    {
     reset($cardsArray);

     $cutVariant = rand(-3, 3);
     $cutLocation = $deadCenter+$cutVariant;

     $firstArray = array();
     $secondArray = array();

     for($z=0;$z<$arraySize;$z++)
     {
      if($z<$cutLocation)
       array_push($firstArray, $cardsArray[$z]);
      else
       array_push($secondArray, $cardsArray[$z]);
     }

     $bottomFirst = rand(0, 1);
     $cardsArray = array();

     while(count($firstArray) && count($secondArray))
     {
      $leftNewCards = array();
      $rightNewCards = array();

      $leftVariant = rand(1, 3);
      if($leftVariant>count($firstArray))
       $leftVariant = count($firstArray);

      $rightVariant = rand(1, 3);
      if($rightVariant>count($secondArray))
       $rightVariant = count($secondArray);


      for($x=0;$x<$leftVariant;$x++)
      {
       array_push($leftNewCards, array_shift($firstArray));
      }

      for($y=0;$y<$rightVariant;$y++)
      {
       array_push($rightNewCards, array_shift($secondArray));
      }

      if($bottomFirst==0)
      {
       $newCardsArray = array_merge($leftNewCards, $rightNewCards);
       $bottomFirst = 1;
      }
      else
      {
       $newCardsArray = array_merge($rightNewCards, $leftNewCards);
       $bottomFirst = 0;
      }

      reset($newCardsArray);

      while(count($newCardsArray))
      {
       array_push($cardsArray, array_shift($newCardsArray));
      }
     }

     if(count($firstArray))
     {
      while(count($firstArray))
       array_push($cardsArray, array_shift($firstArray));
     }
     if(count($secondArray))
     {
      while(count($secondArray))
       array_push($cardsArray, array_shift($secondArray));
     }
    }
   }

Hi Guys   I have a regex conundrum that at first I thought would be very easy but then appears to be quite hard :/   I want to match a string with a regex where the regex can only pass if it contains letters and numbers (nothing else) and it has to contain at least one of each.   I've been trying out lookaheads but just can't get it right.     Any help is appreciated.    Drongo

if (preg_match($fname [0-9])) 
    {
    echo "invalid FirstName"; 
}

 
want the user to only be able to enter letters this is the code i have assuming that preg_match will spot any number in the $fname field and print "invalid firstname" if the user entered a number.
how can i get the users to only insert letters?

hello again

how to get ratio with result max 3 numbers such as 3.00 or 0.11


if im do $mynumbers = 1000 / 400;

so reusult to be 1.00 ?

and how to put full stop if it is more then 4 numbers

result instead of 1000 to have 1.000