Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
allowing / in an insert
- Thread starter pugs421
- Start date
sleipnir214
Programmer
Insufficient data for a meaningful answer.
Define "allow a user to enter" as you are using it in this context.
Define "doesn't work" as you are using it in this context.
Want the best answers? Ask the best questions: TANSTAAFL!!
Define "allow a user to enter" as you are using it in this context.
Define "doesn't work" as you are using it in this context.
Want the best answers? Ask the best questions: TANSTAAFL!!
- Thread starter
- #3
Sorry, i try to keep my questions short so people will answer. An admin will be enter in the number of bathrooms into a text field.The number of bathrooms could be 2 1/2 but it only gets redisplayed as 2 1. In other words everything after the / is not there after the user/admin enters it into the text field. How would I handle this?
sleipnir214
Programmer
Don't post short questions -- post minimally descriptive questions with apropos subject lines. Some members don't like to play 20 questions.
Either I can't reproduce your error, or I'm not understanding your question.
With the following HTML:
If I enter the string "1 1/2 baths" and submit the form, then the following script:
outputs:
1 1/2 baths
Want the best answers? Ask the best questions: TANSTAAFL!!
Either I can't reproduce your error, or I'm not understanding your question.
With the following HTML:
Code:
<html><body>
<form method="POST" action="show_string.php">
<input type="text" name="string">
<input type="submit">
</form>
</body></html>If I enter the string "1 1/2 baths" and submit the form, then the following script:
Code:
<?php
print $_POST['string'];
?>outputs:
1 1/2 baths
Want the best answers? Ask the best questions: TANSTAAFL!!
- Thread starter
- #5
The problem with the / must be caused from the insertion or retrieval to the database. How can I allow the user to enter the / character and store it in the database and display it correctly. I apologize for my post not being descriptive enough. I made sence to me at the time.
sleipnir214
Programmer
It is best to assume that none of us but you know about the circumstances of your problem.
I still can't duplicate your error. When I input "1 1/2 bath" into the from from my earlier post and submit the form, this script:
Outputs "1 1/2 bath"
Want the best answers? Ask the best questions: TANSTAAFL!!
I still can't duplicate your error. When I input "1 1/2 bath" into the from from my earlier post and submit the form, this script:
Code:
<?php
mysql_connect ('localhost', 'test', 'test');
mysql_select_db ('test');
$query = "INSERT INTO foo(word) VALUES ('" . $_POST['string'] . "')";
mysql_query ($query) or die (mysql_query());
$the_index = mysql_insert_id();
$query = "SELECT word from foo WHERE pkID = " . $the_index;
$result = mysql_query($query);
while ($the_word = mysql_fetch_assoc($result))
{
print $the_word['word'];
print '<br>';
}
?>Outputs "1 1/2 bath"
Want the best answers? Ask the best questions: TANSTAAFL!!
- Thread starter
- #7
- Thread starter
- #8
I'm sorry for wasting your time on a stupid error.When I set up my database field for bathrooms I set the max length to 2 thinking there is no way someone had more bathrooms than 99. Then I realized that a possible value could be ex. 1 1/2 and forgot about the max value. I just assumed it was getting cut off somehow because of the / symbol. All better now.
signed,
Stupid
signed,
Stupid
- Status