That's how I learnt....after learning the basics, you can vary the way you make your dish based on the ingredients you use to flavor it...and Presto! you've made your most delicious dish...lol...
I am not sure if this is correct...but the code below is where I would like the file that was selected in the code above to be read, and have the data inserted into the MySQL database. When I try to upload a file, nothing happens...as well as, where <? upload(); ?> is located, the code after it doesn't display... (It's like it's blocked)
uploadBill.php
<?php
include "./connect.php";
function upload()
{
global $conn;
if(isset($_POST['btnSubmit']))
{
$filename=$_FILES['file']['tmp_name'];
$import = "load data local infile ".$filename." INTO table testtsttbills FIELDS TERMINATED BY …
I love to drink tea as well.....I like to try out new flavours too....I drink coffee only when I am out of tea...in the soda category, I like cokes, but not too often...lol...
How could I put the following sql statement into a php variable?
load data local infile ".$filename." INTO table testtsttbills FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'(account,service,date,time,timebandtype,destination,callednumber,mins,airtimecharge,tollcharge,amt,privatenumber)
when I tried to putting it in the variable...it's showing not working because it recognizes the double quote in ENCLOSED BY '"' as an open double quote and not as what it is enclosed by...
Peanut Punch 1/3 cup smooth peanut butter 14 oz. can evaporated milk 14 oz. can condensed milk 1 cup water 1 tbsp. sugar 1 egg pared peel of lime or lemon 1 tsp. vanilla extract 2 cups white rum (for example: vodka) or 1 cup milk
Mix the peanut butter with the evaporated milk. Add condensed milk and water, mix well. Taste, if not sweet enough add sugar. beat egg with peel, disacard peel. Add egg mixture, vanilla, and milk (or rum) to peanut mixture. Bottle and chill. Serve with ice.
So that piece of code works, I am able to upload the data into a table in the database....but that was done through MySQL Query Browser...I gotta get that piece of code to work with my upload button now...
Hi, Ok, I'll give it a try and keep you all posted...:) Oh, and nope, I do not want that everything be done for me...I was merely stating what I want to get done, and if there's anyone who can guide me along....:)...if it came across that way, then I must say that that was not my intention... so, like I said, I'll give niek_e's example a shot, and I'll let you all know...:) Thanks much in advance...:) May
Well I did look at the links you gave and the phpmyadmin isn't what I was looking for, and as for the website link, I actually looked at that site before, and it helps me understand a lil bit about the uploading but it does not allow the user to actually select a file (with a browse button...sorta like thos picture uploader, but this time it's a CSV uploader)...I hope I am not confusing you...
I have a CSV file with thousands of rows of data, and I want to have this data uploaded into a table in a MySQL database. I also want an area where the file could be selected from the computer for the data to be uploaded.
Could this be done? If it could, kindly guide me through getting it done...
I typed the incorrect page name in the header....I corrected it, and now it works...I just want to make sure and enter it into my other pages, and verify that they all work... I'll keep you posted... May
So I created secure.php and also in my apHome.php script, i added the code snippet you told me to...and when i typed the direct link into the address bar to open apHome.php....I am getting the "Internet Explorer cannot display the webpage" message..so this is how it is done? the hiding/protection of the page "apHome.php"?
i have other pages linked from this homepage, and i want to include them in this session ( so that even if i type the direct link in the address bar, i would ot be able to access the page)...
How do I set the session on a page, so that if I were to type the direct link for the page into the address bar, it doesn't display, instead the user would be redirected to the homepage or login page?
ok, well...I have the searchUser.php script which displays the input box and submit button...just under the submit button, there is a call for the validateData function in the validateUser.php script, when the submit button is pressed, the validateData function checks the input box (validation code) and in the midst of the validateData function, the confirmData function is called; that is where I put the results to show provided the data was confirmed...it is within these results that I want the form for the update, i.e. alongside the results, there is a select box with the update button, so that when I choose from my options and press the update button, it updates the particular field in the table in the database with the value of the selection...
Yes, it did update the data in the table, setting it to a blank (which means the update works)...but like you said...$accessType doesn't hold any values...but I do not understand why that's so, did I code it correctly?
What I have noticed is that whenever i press the 'submit' button from the searchUser.php page, I get the results in the table as well as the die message...even though I had an 'if' statement with respect to the 'update' button...
but the die message still shows... 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 'WHERE EmployeeID =114301' at line 1
I echoed $q2, and this is what I see: UPDATE Operators SET accessLevel= WHERE EmployeeID =114301 it seems as though it's not seeing anything for $accessType
Where do I print the query with the dynamic variables? The place where I entered the query with the static variables before was in the MySQL Query Browser...
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 'WHERE EmployeeID =114301' at line 1
I did try the query in the phpmyadmin/mysql console with static variables though, and it executed properly, it updated correctly, but I will now try the mysql_error() in the die...
My intentions are to enter the employee id in the search page, and have the results displayed below the area to enter the search criteria with the select box and update button( i only want to update 1 field) here are the codes.....
My problem is whenever i enter the employee id in the search box, apart from the results being displayed, the die("Update not successful"); message is also displayed, therefore my update doesn't work...
please help me, i am not sure what else to do (due to my lack of php knowledge)...
Here's my problem, I have a searchUser.php which allows the user to enter the Employee ID and submit (which searches for the user). The result is displayed from the chunk of code below. I want to allow the user to append a particular field, therefore i added the select to the table...whenever i click the update button, nothing happens....
Oho....well actualy the image works...it displays on the web page as a confirmation msg to the user that their info was sent....but the email with the link part was the problem.... Ok....well thank you...
Could anyone help me with respect to why when this email is sent, the hyperlink in the message doesn't work?
//send email
$to = $myrow['FirstName'].".".$myrow['LastName']."@petrotrin.com";
$subject = "TAIS Application - New Randomly Generated Password";
$from = "TAIS Application";
$msg = "Dear User ".$myrow['FirstName']." ".$myrow['LastName']." (".$empNo."),\n\nYou have requested that your password be changed due to unforeseen circumstances, and by doing so you acknowledge that you are no longer going to be using the old password.\n\nYour temporary password is: ".$pass."\n\nYou can change your temporary password by clicking the following link and follow the instructions. [B]<a href='resetPassword.php' title='Change Password' target='_blank'>Change Password</a>[/B]\n\nRegards\nTAIS Administration";
$mailsend = mail("$to","$subject","$msg","From: ".$from);
echo $mailsend ? "<img src='images/emailGone.gif' /> Random Password Sent." : "<img src='images/emailNotGone.png' />Random Password Not Sent.";
Well, It's supposed to be a java desktop application that upload/loads the data from the MS Excel file (which is also on the desktop) into the specified table in a MySQL DB...
I need some help....I have to create part of an application that uploads an MS Excel file, and stores the data into a MySQL db...and I have no clue where to start...
It is the same, I double checked it, but what I also realized is that the PHP file(which contains the form) is probably the problem, since all I did was replaced my changes on the PHP file with the old copy(the one without the changes)...and it worked, so I think the problem lies in the PHP file...
I am just curious to find out...is there anyone out there who've encountered the same problem or similar...please help me...
I got a working .js file, and I tried to edit the code, when I tested my edit, it doesn't work, since the system is already up and running, I decided to set the code back to the way it was, before I edited it.......now it totally doesn't work, and there is no validation control on the particular field...
can anyone tell me why it doesn't work now, when it was totally working before I edited it....
