Entering Data From A Form To A Mysql Database
I'm trying to enter data from a form with the fields name and email into a mysql database called newsletter, as you guess it's a newsletter sign up. this what I have at the moment: Code:
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Ok Problems Entering Data Into Database
i am having problems if you look at the script below you will see that it the query has 4 values to insert but the actual values only contain title entry and now() for the date. well i have made the database and the blog_id is a primary auto interger what ever table bascly look below the the insert code block to find the code block that makes the table in the database, // Define the query. $query = "INSERT INTO blog_entries (blog_id, title, entry, date_entered) VALUES ('{$_POST['title']}', '{$_POST['entry']}', NOW())"; // Execute the query. if (@mysql_query ($query)) { print '<p>The blog entry has been added.</p>' } else { print "<p>Could add the entry because: <b>" . mysql_error() . "</b>. The query was $query.</p>"; } --------------------------------------------------------------------------------------------------------------------------------------------------- // Define the query. $query = 'CREATE TABLE blog_entries ( blog_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, title VARCHAR(100) NOT NULL, entry TEXT NOT NULL, date_entered DATETIME NOT NULL )' // Run the query. if (@mysql_query ($query)) { print '<p>The table has been created.</p>' } else { die ('<p>Could not create the table because: <b>' . mysql_error() . '</b>.</p><p>The query being run was: ' . $query . '</p>'); } Quote:
View Replies !
View Related
Entering Data Into Database For Shopping Cart
Assuming all the variable names are spelt correctly etc, is there any reason why this wont insert the data into the database (the cart), yet it goes to URL shopping.php as its supposed to. It was working, but i did one thing trying to fix another glitch and now it wont write the data in, i assume it will be something really simple. (The variables collect data from a previous screen successfully and display it here, so its not that either, and the form has been closed correctly. Code:
View Replies !
View Related
Problem With Entering Data Into A MySQL Db
I have a problem with entering data into a mySQL db. Here is the error I get: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'd share with everyone our a little glimpse of our life here in Delhi. It's def' at line 1 The entry is an array of blog entries, seperated by two semi-colons (;. From the error, it seems that mySQL does not like the ' in the entry.
View Replies !
View Related
Entering/checking Info Into Mysql Database
I have set up a client database where one can view, add, edit and delete entries. I ran into a problem setting up the add page. On this page i have set up forms to add info into the DB, and it works fine, but i dont want duplicate clients. Is there a way to set it up so that when you submit the form with the info it checks for duplicates and if there is one returns "sorry this record exists?"
View Replies !
View Related
Use A Form To Insert Data Into A MySQL Database
When you use a form to insert data into a MySQL database, how can you set it up so that the fields are not sent via the address bar. For example: page1.php ___________ <form action="page2.php"> <input type="text" value="whatever"> <input type="submit" value="Send"> page2.php ___________ // Inserts variable $whatever into database. The problem that I have is that I don't want the address bar to appear as http://web/page2.php?whatever=cheese but as http://web/page2.php
View Replies !
View Related
Insert Data From Form To MySQL Database
I have run createTable.php and everything is created. Now I want to run insertData.php. I want the user to enter stuff in the form & everything must be fill in before they click the submit button. It will call submitData() & all the information was enter will insert into the database. PHP Code:
View Replies !
View Related
Using A Php Html Form With Data Which Is Loaded From A Mysql Database.
I am using a php html form with data which is loaded from a mysql database. Three of the fields are textareas. The data loads into these fields fine, except that the loaded text starts at what appears to be 2 or 3 tab characters to the left. See illustration: +---------<this is a textarea object>---------+ | This is about the way that| |the text loads from the database field. | | | | | +---------------------------------------------+ It's almost as if there's a textarea "align" property which is set to "center" by default unless otherwise explicitly stated. Is there some setting in the wrap property that will fix this, or should I be looking elsewhere?
View Replies !
View Related
Retrieving MySQL Database Data & Updating On The Same Form...
I have managed to perform the following: 1. Adding Data to a MySQL Database. 2. Retrieving/Viewing Data from MySQL Database. I currently need to be able to perform the following: 1. While I view Data coming from the MySQL Database, I can currently edit the data on the same "view" form. Then I want to be able to save the changed data back to the Database. The problem is that when finished editing the data, the "update" button does NOT work... I want to be able to put/save the altered data back to the MySQL Database. And the button I have created does NOT work... Here is the code I use to enter NEW data to the MySQL Database: Code:
View Replies !
View Related
Displaying Data From Mysql Database In A Drop Down List On Form.
I'm trying to do is display data from two different mysql tables from the same database in a drop down list on a html form. I have a fixtures table with the player1(userid), player2(userid), gameid, game, score1 and 2, what I want is to use the userid to get the players first name and surname from the members table (as it is a unique id), I need to do this bit before displaying it in the drop down. I think i need 2 querys to do this but when I have tried it it just echo's a blank value or the userid not the forname and surname that I want. I'm using the fetch_array function but just can't see where I'm going wrong, Code:
View Replies !
View Related
Problem With ""s Entering Stuff Into A MySQL Database
I have a database which is going to be used partly to store articles, which will basically be free-flowing text. So what if someone puts a single comma ' in? Because I am using the PHP: $query = "INSERT INTO quasimodo VALUES ($iNum,'$area','$sec1','$sec2','$sec3','$name','$phone','$email','$body')"; So surely when someone types the words it's or something like that with an apostrophe in the middle, it'll screw everything up? The stuff will be entered through a form. Please, how can I get around this problem? A similar problem would arise if i used "$body" instead of '$body' because someone might put a word in "inverted commas".
View Replies !
View Related
Entering Into Database
i run a gaming clan and want to verify and application before its entered into the database but i dont know how i can do this my initial idea was to get the form to write the data into a text file first then when i click thr link in the e-mail its verifys it gets the data fromt eh text file and inserts it into the database.
View Replies !
View Related
Entering Data Into A Second Table:
Using a script, I able to insert the data into the first table of my mysql db, but when I try to insert the same into second table(duplicate, so same vars, etc.. no prob at that level), it doesn't go through. It doesn't even make an empty row(which would mean wrong vars) Someone told me to check in the logs of both PHP and mySQL. How do I do this?
View Replies !
View Related
Entering Data From One Table To Another
does anyone know how to write a statement where you are able to transfer data from one table to another? I have got one table with user details. and I have another table for creating bulletins. is there a statement which will put the ID of the user from user details to bulletins everytime they create a bulletin?
View Replies !
View Related
String With ' Not Entering To The DataBASE
Am working on a WYSIWYG editor, and while entering some data's containing ' it is not entering into the data base giving me this error message... You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's and would be able to supply a smooth professional service for workers on work' at line 1" In my SQL table the field type is BLOB I changed it in to text but the problem exists!!!! My charset is UTF-8!!! Is this the problem behind it?
View Replies !
View Related
Page Reloads Keep Entering Data In Db
The problem is I have a small form that allows a user to input data into a database. Everything works fine, after a successful submission, the user get a message saying that their info was accepted. The problem is that if that page is reloaded, it enters the info again. There is only going to be one person doing the submitting so I could explicitly say...DO NOT RELOAD the page, but that seems kinda half as**d.
View Replies !
View Related
When Entering A Form...
How do I validate that I came from a certain form (i.e. in a login situation)... I need to make sure that if people hit the URL to a page directly, that the only way they can come in is from the login screen..
View Replies !
View Related
Entering The Date As Default Within A Form
Anyone know how to enter the time into a form or a website that might tell how? I'm using the following html code and trying to get the time to default into the text box. thanks html code <tr> <td><b>Date:</b></td> <td align="left"><input type="text" name="date" size="8" maxlength="8"></td> </tr> php code <? print strftime("%m/%d/%Y"); ?>
View Replies !
View Related
Entering Text Into A Seperate Page Via A Form
I'm doin' a site for a company who wants to enter in some News content themselves. They're not comfortable at all with html, so I'd like to create a simple form so they can enter data into a text box, click submit and that data (just news stories) gets sent to the body of the news section. (The news section is in a table on the home page) Is there a tutorial around that deals with a similar concept? Something I could learn and then use to create my own? Code:
View Replies !
View Related
Form Data Not Stored In DataBase
I was trying setting up these scripts following instructions in a book from 2003, so I thought maybe some of the code might be outdated. Basically this is what Is supposed to happen: 1.- Display a form, enter details into fields and click submit. 2.- After having clicked on submit you're redirected to another page that will display the entered values and store them in the MySQL DB specified. Now what happens is that no errors are displayed after clicking on the submit button in the form, but neither are the entered values. In PHPMyAdmin I can see that the Db is still empty. I created a total of 3 files that reside in the same folder: The form, that when clicking on submit is redirected to the next file: Code:
View Replies !
View Related
Form Data Not Stored In Database ?
This is the code for a Returns form where I am trying to implement these validations: 1. Check if fields aint empty 2. Check if SESSION_username = username from Customer table and get customer ID use that Customer ID to look up Orders table and find if the ORDER NO. that has been entered is = an order no. in the Orders table i.e. see if the oder no. entered was actually an order placed by the user b4 * Customer table has cust id and username. Order table has only cust ID. returns table will store username from Session so that it can display each user's individual returns. Code:
View Replies !
View Related
Insert Data From A Form Into A Database
I am try to insert data from a form into a database. I am not sure of which code i would use for Inserting the data that is sent from the from. a sample script i found for inserting into a DB is this: mysql_select_db($mysql); $query = "INSERT INTO user (host, user, password, select_priv, insert_priv, update_ priv) VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y', 'Y', 'Y')"; mysql_query($query) or die('Error, insert query failed'); $query = "FLUSH PRIVILEGES"; mysql_query($query) or die('Error, insert query failed'); example names from form boxes are "title , date , service"
View Replies !
View Related
Comparing Form Data To Mysql Data
Im interested in building a script that would take form data, a variable like an address, and compare it with a known address in a mysql table (called addresses), then if there is a match log the address information in a separate table called (addresslog), and return the visitor to a certain page. If there is no match between the address entered in the form and known addresses then the information is still logged into the addresslog database but the visitor will be sent to a different page. I'm still new to this, and am working through the logic and the syntax, but I believe I'm close. It's still not working, I have all of the proper tables, maybe I'm way off with the coding so I thought I would seek out some expert advice. Here's the entire script with as much explanation as I could give. PHP Code:
View Replies !
View Related
Error When Importing Form Data Into Database
Here is the code I am using for the import I keep getting this error and am not sure what is causing it. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '','subdiv',ƈ',Ƈ.5',Ƈ.5','Unfinished','Yes','Yes',Ɖ/4 - 1 Ac near as I can tell this chunk of posted data starts at '$subdiv','$NumberOfBedrooms' etc.
View Replies !
View Related
Insert Data To The Database From An HTML Form
i want to insert data to the database from an HTML form but when i run the script it will insert NULL to the database. On that note i like to request for help from anyone. This is my code <?php include "connect.php" $sql = "insert into TEST values(:name)"; // Parse SQL $stmt = OCIParse($conn,$sql); // Bind php variables to Oracle columns OCIBindByName($stmt,"NAME",$name); // Oracle converts all column names into UPPERCASE // Run SQL OCIExecute($stmt);
View Replies !
View Related
Form To Add Other Data To The Same Table And Database After The Session Login
I have a session login that has an submit page to create an account. I want to create another form to add other data to the same table and database after the session login. I want to use hidden fields based on the session data already in the database to asssit the user without re-entering the same data again. can someone show me an example of 3 user entered text inputs and two existing input from the mysql database based on the session information. Code:
View Replies !
View Related
Form Question - Enter Data Which Is Safed In A Database.
i have i site where one must enter data which is safed in a database. There are also drop down lists, which values are database driven. the user can and must sometimes ad values to this drop down list. When he enters data in the fields (and there is a lot of data) and he comes to a drop down list he may see that the option he needs is not in there. Because of that he has to go another site to add the data. (link "add new item" and here i just open a new site) The Problem is how can i actualize the drop down list so that the new item is in there without loosing all the information the user already wrote into the formular?
View Replies !
View Related
Writing Data To MySQL Database Using PHP
Can anyone tell me why the following code isn't working? $dbh = mysql_connect($host,$user,$pass) or die("Couldn't connect..."); $selected = mysql_select_db($db,$dbh); $name = $_GET['name']; $state = $_GET['state']; $desc = $_GET['desc']; $lat = $_GET['lat']; $lng = $_GET['lng']; $result = mysql_query("INSERT INTO re_cities (name, state, description, lat, lng) VALUES ('$name','$state','$desc','$lat','$lng')"); The script doesn't die when I attempt to connect so I'm assuming that isn't the problem. I'm pretty sure I also get a result because the following code echoes "City Add Successful". if ($result) { echo "City Add Successful"; } else { echo "City Add Unsuccessful"; } However, the data doesn't show up in the database.
View Replies !
View Related
Check Mysql Database For Data
Need to check if some info matches from mysql database in two tables to see if the current session user is on a friends list for the profile page he or she is viewing. If they do not exist in field, return an error. Here is the structure and what i got so far: Code:
View Replies !
View Related
Delete Data From MySQL Database
I am new to PHP and MySQL but I have setup a MySQL database. I can view the information in an HTML table using PHP scripts and can delete an entry form the database table, but what i need to do is to be able to delete an entry by selecting a radio button next to the relevent information however when i try to add a form in the PHP script i get an error.
View Replies !
View Related
Selecting Data From Database(php/mysql).
Alright I've come to a point where I only want a DB for settings and nothing based on ID's on a sql table. instead of say: $setting = mysql_query("SELECT * FROM settings WHERE id='1' "); Now i broken up all the sql into seperate settings like so: settingname | value boardonline | no Thats basicaly how I got the sql set up instead of having it all in one table row I have them in seperate rows. So how do I go about selecting data from SQL not based on ID but mainly on setting name? would I do $settings = mysql_query("SELECT * FROM settings"); $settings = mysql_fetch_array($settings); $settings['boardonline'][1];//would echo true/false according to my sql table instead of the row name?
View Replies !
View Related
Retreive Any Data From Mysql Database
I have been struggling to retreive any data from mysql database and then show it on a webpage. <? $username="root"; $password=""; $database="car"; mysql_connect(localhost,$username,$password); mysql_select_db($database) or die( "Unable to select database"); $sql = "SELECT * car"; $query = mysql_query($sql); while($row = mysql_fetch_assoc($query)){ Â Â echo $row['name'].' .........................................
View Replies !
View Related
Recieve Data From MySql Database
I am making a user registration that will automatically make the username the next number after the last username, and I would like after they register for the php to recieve pilot_id from the last row of the table and show it to the user, this is my current code to display successful: Code:
View Replies !
View Related
Pull Data From MySQL Database
I'm running a PHP script called phpOnDirectory on thsi website i'm creating so that people can have their companies listed in our directory. Currently, the script displayes the directory in a left-hand column, and the results in the center column. When you access a category, the script displays the number of listings withing that category in parenthesis next to the title. What my client wants is to take that out(easy enough) and have the totals listed next to the categories on the left. Code:
View Replies !
View Related
Inserting Data Into A Mysql Database Through A Php Interface
This questions relates to inserting data into a mysql database through a php interface that uses a normal html form... If I press return a couple times to make a new paragraph when filling out the text field, it never puts those line breaks into the database.. it always returns the data as one long paragraph.. How do I make it so that when a user presses return in the form, the output of data from the database knows there are supposed to be line breaks there??
View Replies !
View Related
|
TRACKER
