Using XML To Send Info From The Web Page To MySQL Database.
I am trying to undestand XML and the resion for it and if i should be using XML to send info from the PHP web page to mySQL database.
if so how would i send for example
$xml = mysql_query("INSERT data WHERE stuff = stuff");please excuse the bad code.
View Complete Forum Thread with Replies
Related Forum Messages:
Sessions And Redirects - Send Info From Page One To Page Two.
I have a two part form, each part on a seperate page. I want to send info from page one to page two. Thought ok, I use session variables. The problem is that they don't get sent to the second page. All works fine on my local testing server, but when I go live session varables don't show. Has this something to do with header? Is there another way to get to the second page? Code:
View Replies !
How To Send Info To Database
im wondering how to submit info into a database. i know the code goes something lie $sql = "UPDATE <tablename> set $var = "var" but i know that is wrong and i want to put it in form so on submit it posts it in the database.
View Replies !
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 !
Uploading Info From A Text File Into A MySQL Database
what would the PHP and SQL code be to say basically: make a new row and put this in the field, what comes after each comma goes in a new field, and each new line should be a new row. I have a huge text file that i don't have a way to upload directly into a MySQL database because my webhost isn't allowing it for some reason.
View Replies !
Upload & Query MySQL Info Database With Image Files
I want a database I can enter information and upload a photo from a web form. Then I want to query that database for the text info with its related photo and display it (formatted) in a browser (html). Summary: 1. upload photo's and text information to database with my add article form. 2. Query the database and page the results with the text and related photo. It comes in three parts: 1. add_article.php [Text / Photo Upload Form] 2. insert_article.php [Inserts into database] 3. articles.php [View Output] Here is what I have this far:
View Replies !
Send Information To A MySQL Database
I have been tinkering with this script for a while now. I am creating a form and am trying to use this form to add data into a database, but nothing happens when I click submit. The address bar changes to show the values that are being sent, but nothing gets sent. I am hoping that someone here can point out the blatant stupid mistake that I have made, cos I can't see it. PHP Code:
View Replies !
Security - Encrypt Data Using Php Functions Before Send It To Database (mysql)
What is more secure ? Encrypt data using php functions before send it to database (mysql), or Encrypt directly on database, using encryption functions of database server ? Ex: $key = "this is a secret key"; $input = "Let us meet at 9 o'clock at the secret place."; --- $encrypted_data = mcrypt_ecb (MCRYPT_AES, $key, $input, MCRYPT_ENCRYPT); or $query = "insert into myTable (text) values(AES_ENCRYPT('".$input."','".$key."'))"; I think encrypt data directly with php is better because the information is sent directly encrypted to database server, but i not sure.
View Replies !
How To Send Info From A Php Script To A Server Running Javascript
I'm new to php. i'm trying to send information from my php (client) script to a website that is running javascript. Here is an extract of the server's response to my initial http request. I need to know how to communicate further with the server. <META name="description" content=""> <META name="keywords" content=""> </HEAD> <script language="JavaScript" type="text/javascript"> if (top != self) top.location.replace(self.location); </script> <link rel="shortcut icon" href="/system/images/mypage.ico"> <FRAMESET FRAMEBORDER=0 FRAMESPACING=0 BORDER=0 ROWS="90,*"> <FRAME NAME="VIEW_TopFrame" ..........
View Replies !
User's Register, And Send Mail With The Account Info...
i desire send mail to the new user than he register in my web. i have 2 codes. 1 is registra.php that one is in charge to verify fields and to register the new user, and other that sends a mail to the user, but this I complete not where to place it within registrar.php. Code:
View Replies !
Send This Page Script Used To Send Spam.
I had installed a simple php script (obtained for free from the web) that allows a visitor to forward a page to a friend. It worked great but now a spammer is using it to send thousands of emails. I have deleted the feature and also the php file but no successs. What can I do? Please help. While I have some responsibilities of a webmaster, my technical abilities are very limited.
View Replies !
Email Me This Info Page From A Order Confirmation Page?
How do i make a "email me this info" page from a order confirmation page? Basically someone enters some info in a form, then on submission is comes to my email. After submission, i want to have a text area where they can enter an email address to have the info emailed to them if they wish. You can see the page here, you have to enter info first, the email nbox on the second page (process.php) is non fuctional.
View Replies !
Pull Data From MySQL Database And Display On Web Page.
I am trying to pull specific data from MySQL database using PHP and have it displayed on my web page. Go to my web page to see exactly what I want to do. Right click on the link and open it in a new browser or else you will get stuck in the page. Please come back and post a reply with your knowledge. Code:
View Replies !
Apache / PHP Page Built From A MySQL Database Diplay Problems
Here is the basic scenario: - Configuration data is gathered from Oracle servers then ftp'd to my apache / mysql server. - The apache / mysql server receives the datafile from the Oracle clients and loads the data into a MySQL database. - The webpages are coded using PHP, SQL, and some JavaScript. Now here is where it gets weird.... - When the data is displayed (pages are based upon the configuration of each Oracle <server-name>+<database-instance-name>, some times the data displays other times the page is simply blank? It is only for a few out of the many that we have in the MySQL database. It is always the same ones with the problem. Re-loading the data for those problem <server-name>+<database-instance-name> does not fix it. Anyone see this before? Could it be a special character that the web browser cannot handle? I am at a loss on this one.
View Replies !
Simple Login Page To Delete And Edit Things In Mysql Database
How do I build a simple login page on my site? I need a way to login to my admin area in my webshop, so I can add, delete and edit things in mysql database. I don't need help with add, delete and change things, only the login thing. The users should not even know that there is a admin login page. The users don't login to shop, they just shop so I can't use the user login page because there is no such page. Can someone please give me some guidelines for this?
View Replies !
Send Email - Page Where You Enter An Email Address And Click Send.
I am interested in creating an "email -this" type ability for a website. I am sure most people have seen an "email -this story" type link that is standard on most news web sites. You click such a link and then it takes you to a page where you enter an email address and click send. The link for the story and the title are not editable. Does anyone know where I can find example code of how to do this with php, and any explanation of how this works.
View Replies !
Info From My Database
So now basically I have this script that gets info from my database. You can see the page here and you can view the code here. Now here's what I want to do: I want the edit button and delete button to work How would I get php to load a new page, when I click the edit button, with in that page all the info of that row of the db in there?
View Replies !
No Mysql Info Through Info();
I am trying to install mantis, and I get errors when I try to run the install script saying that mysql is not configured to run on php. I call the phpinfo() function and I see nothing relating to mysql. I open the php.ini file, and, to be honest, it looks alright. the extension_dir points to /usr/lib/php4 which includes the mysql.so extension. Furthermore, I located the mysql.sock file and pointed the default socket to it, but nothing. what exactly am I missing? Code:
View Replies !
Recall Database Info
Hi, I want to create a page where users can put in certain information like you normialy would in a form but when they click submit another page will load that will look like the original form the signed up with and everything they filed in that time will be there and they can make changes to that and then click submit and the changes are made to databse automaticialy.
View Replies !
Info Deleted Itself From Database?
I got some info (news system) in a SQL database but after some days it deletes by itself it happened to me once but i thought i didnt remembered that i deleted it but today it happened again...it deleted by itself! lol I have other tables in the same database so its a table problem... How can i fix this? Did i miss something at the table configuration?
View Replies !
Get And Insert Info Into Database
I have one table (form) that has multiple fields. Here are few fields we need to know: ID, NAME, CITY, STATE, PROFESSION, x, y, z (x, y, z means more than 50 fields that give me more information about each name). The ID and NAME are unique and they don't change (each name has it's own ID). A NAME and its ID can be in any CITY, STATE or PROFESSION but this is fixed. That means if ID# 123 for Mr JOHN is Austin, TX, that will stay in Austin, TX for ever. I have more than 5000 NAME and it's ID, 9 professions, all US States and all Cities in my database. Here is what I need to do: I want to have a form on my site that my visitor finds his name first and then enters more information about him/her that will complete my database fields of x,y,z. What I'm thinking to do is to create a drop down list that the visitor first selects the profession. Based on the profession the second list shows the states that has that profession. Then by selecting the state, all the available cities will show up in the third list, and by selecting the city all the names related to that profession in that city, state will show up and he can select the name from the forth list. Then he enters other required information about him that will be send and saved in the database. Here is what I have done and I know to do so far: I have created the database with all the information in one table. I also know how to send data to database to be saved. But my problem at this point is how to create this list selection that narrows the search to find the right person.
View Replies !
Retrieving Info From A Database
I would like the code below to fetch and display in an html table the Ad_Id, Date, and Type_Job fields from the 1st 10 rows of a table called employment. I'd like the results to be sorted first by date and then by the Ad_Id #. I have replaced my username and password with "user" and "password". Currently, the script returns the error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource Also, the script is ignoring the css info that I have supplied. Code:
View Replies !
Inserting Info Into Database
I am trying to realize a function that after a user logged in, he/she can send comments. Hence, I am trying to get the session()'s user_id information, and insert it into the database. But somehow, the user_id could not be retrieved. Code:
View Replies !
Server/Database Info
I've been ever-so-slowly working my way through a book on PHP and I've started using databases. When I began, I installed Apache and MySQL on my Win XP computer to access my files without having to upload them. Unfortunately, I've forgotten my login, password, and database names - I can't connect to my DB or see if my code runs without them! Anyone know where/how to look for this information on my computer? I've had no luck so far digging through the files.
View Replies !
Sending Page Info
for several different .php files (file1, file2, file3 ...) i want to have page numbering, ie, this is page 1, this is page 2... the files are accessed in different order order 1: file1, file2, file3 order 2: file2, file3, file1 but the page numbering should always be 1, 2, 3 regardless of actual file order. any ideas how this can be done?
View Replies !
Passing Info From One Page To Another
I have a dynamically generated list of check boxes with ids email1, email2, up to the end of the list of addresses. This list is then passed to the next page where all the addresses are concatenated and added to a database. At least that's the theory. I can't figure out how to dynamically get all the $_POST[emailx] variables, with x being 1, 2, to the end of the list.
View Replies !
Populating A Form Wth Database Info
I've coded a piece of code which populates a form with data read from the database: $connection=mysql_connec ("localhost", "f2821842", "f2821842"); $result=mysql_select_db("QUERIES"); $query=mysql_query("Select * from Emp_Details where emp_num = '$employnum'"); while($row=mysql_fetch_array($query)) {$empname=$row['emp_name'];} <form name="webregform" action="webadmin2.php" method="post"> <input name="requiredname" type="text" size="30" value="<?php echo "$empname"; ?>"> </form> When I echo the $requiredname, I get spaces and no data, and I know that $empname is not a space-it does read a value in a database. 1. How can I get $requiredname to print a value?
View Replies !
Ordering Info Returned From Database
I have a PHP page on my site which pulls back info from my MySQL database and displays it in a table under appropriate headings. Is there code that I could add to these headings so that a) the same page could be redisplayed with the information sorted by the third column instead of the first b) information in the columns could be displayed in reverse order (maybe Z to A or highest figure to lowest figure)
View Replies !
Session Variable Info To Database
I have a 2 page form. The first page page of the form POSTS to the 2nd page which, after being filled out, should send all the information (from pages 1 and 2) to the database. I have created a session variable and have placed it at the top of the 2nd page. For brevity´s sake I have placed only one of the variables in this example: <?php session_start(); $_SESSION["sessanimals"] = $_POST["animals"]; ?> After filling out the remaining variables on page 2, I want all the information (the info from page 1 brought over in the session variable and the info from page 2) sent to the database. I tried creating an INSERT RECORD on page 2 but only the variables on page 2 are subsequently sent upon submission. How do I get all the info into my database?? Here are a list of my questions: 1. Is there any way of creating one session variable for all my page 1 form variables (I have 20+ variables)? 2. is there a way to denote ALL the variables in = $_POST[]; or do they have to be listed separately? 3. How do I post all the data from page 1 and 2 into my database at once?
View Replies !
Filling Form With Database Info
I have a table with 5 fields for a tour business activity list : (1) id -table key (2) name (3)description (4)picture -text link not binary(5) country. I would like to create a form that takes all the activitys an puts it neatly down on site in checkboxes so user can select activtys.this will be linked to form mail.i would like the activitys to be seperated by the country they r in?
View Replies !
Update Database Info Using Forms
i have a page uses select and cases. i already have setup and working, auth/login to the page, create a new row in the table. i am now trying to have the user alter the information that the just put into the table. this is the code where i have setup to modify the info, $id is passed over. this puts the correct information into the form field. when i hit submit, the information, $name, $content, $id are not passed over. echo-ing results blank. PHP Code:
View Replies !
Hiding Database Connection Info
In a php script, I have to connect to a remote mysql database. I'm a bit worried that some user might be bale to retrieve the source of the page and see the user name and password to connect to the db. Is this resonable? What's the best way to avoid it?
View Replies !
Obtaining Info From Database Table
How do you obtain fields from a table and assign each field to a variable to be used as needed. An example: Say i had: table name : user Field 1 : User name Field 2: Password then i wanted: $username = field 1 $password = field 2.
View Replies !
How To Obscure Database Info In PHP Pages
I'm moving from Cold Fusion to PHP and I have a question that none of the books I have answers adequately: In Cold Fusion, database connection parameters like the table, username and password are configured on the server. Since they are at the backend, nothing is exposed on the page except the queries themselves. In PHP, from what I see, the database info is on the page. Is this not a security risk? How can one be sure that this info is not on the page sent to the user?
View Replies !
Displaying Daily Info From Database.
I run a site specifically about a theme park, and am looking for a simple script to display current info on the main page out of a database. It would look something like this... Today's Park Information Operating Hours: (Hours Here) Regular Live Shows: (Show/Time) (Show/Time) etc Special Events/Concerts: (Event/Time) etc Problem is I'm a complete newb, all I know of PHP is how to use include to put my navigation bar and such onto a page, and to do extremly simple adjustments to forum interface scripts, etc...
View Replies !
Sending Mail With Info From Database
Can anyone explain the best way to retireive info from mysql and then send it in an email? I'm completely lost on this. I can run a query of the database just fine, and I know how to use the mail function. The problem is I cannot figure out how to use them together. Anyone?
View Replies !
Simple Database Info Retrieval
I am trying to simply pull some code from my database and I keep getting either empty responses or an error saying that "$TableName" does not exist if I try to use that instead of the actual "company_profile" name in the query. The name of the page is test.php & am linking to it with a text link that links to "test.php?id=1". The id being one is obviously my first record in the database. Anybody have any idea what I am doing. I am just learning PHP, so I can't see anything wrong with it. All the database information is correct: <?php $Host = "localhost"; $User = "getitdon_warzol"; $Password = "jemy45"; $DBName = "getitdon_testing"; $TableName = "company_profile"; $link = mysql_connect ($Host, $User, $Password); $query = 'SELECT * FROM company_profile WHERE id="'.$_GET['id'].'"' $result = mysql_db_query ($DBName, $query, $link) or die(mysql_error()); {print ("Hello $result[name]</br>"); print ("Your email is $result[email]</br>"); } mysql_close ($link);?>
View Replies !
Obtaining Specific Info From A Database
i have a products table that contains all the products i will have on my website however for the configurator i want to select only the items, accessories extras that i want to selected the computer. i don't want to send out a SELECT query for each item...is there a way to send out one query that will fetch all the items i need? I thought it would be good to have an array of product id's and the have a query which would grab the info i require based on these id's Code:
View Replies !
Page Info Change On Submit
I have a menu on my site that is all pulled out of a MySQL database. So the links actually look like this: <a href="about">About Us</a> And when the user clicks on this link I want the page to go to the database and get the info for "about" and then refresh the page and display the info.
View Replies !
Opening A Page To Display The Right Info
I'm making a website where registered users can upload a photo as well as information. The main page will display all of the users' photos. When user1 clicks on, say, user5's photo i want a page to open up and user5's information. How do i do this? Every user has a username stored in the database along with their information and the url to their photo. Code:
View Replies !
|
TRACKER
