Import CSV File Into Database Table
Are there any programs like phpmyadmin, that allow you to import CSV files without first converting them into mysql statements? mysql front?
I've created the table and fields, and it should be easy enough to import the data into its respective columns.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Import Excel File Into MySQL Database
I am relatively new in this field, and one of my first challenge is the following : Importing an Excel file, containings URL, into a MySQL database. It must be the simplest process possible for the end user, avoiding as far as possible all steps of converting and/or transforming files. Of course, we want to preserve the identity of the URL.
Import A Database
I need help importing a database using MySQL and PHP. I have a file that is tab separated, and I need to import it into a MySQL database.
Import Data From Access Database To MYSQL
I have some data in access database. I wish to import it (keeping the same structure) in MySQL. Also I want to know what will be procedure for importing data from databases like Oracle, Sybase, Informix etc.
Import Sql File Please Help Me!
i have just installed mysql on osx. i think its running ok. i have tried to import my dump file from the remote server to my local mysql. but no luck! please help me tying to use -u -umyusername -pmypassword < path to sql file in the mysql terminal in shell on osx but its not working. to be honest i dont have a clue when it comes to using the terminal. i cant seem to be able to even create a new databse. i have my .sql file and i want to run my local mysql the same as the production mysql online for testing. also my database is called mydomain_com_-_mydatabase not sure why i have _-_ but online all my php works fine. i dont want to have to use two connect scripts, can i use the same connect script to connect local and remotely. some one please help me to get mysql up and running localy!
Import Data From File.sql
i have already backup my database into a file named backup.sql from phpmyadmin.. now i want to make an interface using php to restore it like phpmyadmin too, does anybody know how? when i click submit then file backup.sql will be restored in database, Code:
File Import Script
I currently have an uploader that runs on my site that allows the user to upload a .csv file to the server, it then prompts them to match up each field in the file with the corresponding field in the database table. It works pretty good, but a little bit clunky and with the way I currently have it setup, it will only insert into the database, I can't update. Does anyone know of a good .csv uploader that will let the customer match up the columns in the .csv file with the fields in the database as well as do updates and inserts with records in the database?
Import Data From Text File?
I'm not sure how to do this, can anyone steer me in the right direction? I have a DB table called 'vehicles' It has three columns: ID ¦ vehicle_type ¦ vehicle_make I have a text file containing a list of the vehicle types and makes. Example: Austin Healey - 3000, Sprite Austin Passenger - 1800, Allegro, Ital, Maxi, Mini Bentley - Corniche, Mulsanne, T Series How would I import this into my database?
Trying To Import A .csv File With Usernames And Passwords In Sha-1
can someone give me some advice on how to import a csv file and make the passwords store in a hash form such as md5 or sha-1. It would be to much to code the INSERT VALUES....way. I am trying to find an easier way. Is there a feature in one of these free gui versions of mySQL that will do this?
Content Of Database Table Twice?
Why does this code repeat the content of the database table? It connects O.K. but display table contents twice (I only need it once) Code:
Table Name In Ms Access Database
I'd like to know how can i get and store the table names of an ms access database. I use odbc_result_all but i don't know how to exctract and store information about the table name.
How To Search More Than One Table In A Database
Say I have a user input a search string and they click search. What would my mySQL string look like if i wanted it to search TABLE:'set_01' and TABLE:'set_02' at the same time for the same information?
Delete A Row From A Database Table
I'm trying to delete a row from a database table. I've made a connection yet it's not working. Is there something wrong with the following code? mysql_query("DELETE * from `contactinfo` WHERE Submission_Number = 1 ");
Changing A Database Table
Is it possible to change a table in a database without just dropping it and recreating it. As example, I have a photo column which stores an URL, but it seems to only be accepting about 25 characters. Is there a way I can update the table without starting it over? Also, when I made the photo column I think I put, photo varchar(25), is there any reason I don't want to make it like varchar(1000), although I know that varchar only accepts 255, so what do I change varchar to?
Selecting Whole Database VS One Table
In querying a regular DB you use the following code: $query = "SELECT * FROM table_name"; Well I want to be able to do something like this: $query = "SELECT * FROM database_name"; Here is my reasoning: I have built and intranet for the company I work for. I have imported all of the data requested from an Excel Spreadsheet into the corresponding SQL tables. Now for the page I am wanting to pull off my weird select db_name code works like this: I want to be able to go there and display the Table names within that DB and when a user clicks on one of the links it will reload the page displaying the results for the corresponding Table. Make sense?
Script Not Inserting To Database Table
I submit the form to insert the data into the table, when I submit the form for this script to process, The "if" statement is true because the "echo" statement in the else says so, but the else is what the script is doing. Can't figure out why. PHP Code:
HTML Table Fetched From A Database
I want to generate a HTML table based on names fetched from a database. The tricky part is that I want to generate the table so that the names is written on both the top row and the left collumn. Should look something like this ---------------------------------------------- | ||NAME 1 | NAME 2| NAME3| |NAME 1| | | | ---------------------------------------------- |NAME2| | | | ---------------------------------------------- |NAME3| | | | ---------------------------------------------- Hope that anybody has a idea how to solve this.
Putting Database Results In A 5x1 Table
I have a db of tens of thousands of entries. It's not too hard to pull all the entries and build a table that displays them one at a time, but in my case, that will be a huge waste of space. What I want to do is put one record in each of the columns. I thinks it's possible to do because I have seen very elaborate thumbnail gallery scripts to do this. I just want to be able to put two or three strings of text from each record into each row, and a checkbox. Here's sample of what I mean: <table width="76%" border="1" cellspacing="1" cellpadding="1"> <tr> <td>$record1Line1<br>$record1$Line2<br> <input type="checkbox" name="$record1checkbox" value="checkbox"></td> <td>$record2Line1<br>$record2$Line2<br> <input type="checkbox" name="$record2checkbox" value="checkbox"></td> <td>$record3Line1<br>$record3$Line2<br> <input type="checkbox" name="$record3checkbox" value="checkbox"></td> <td>$record4Line1<br>$record4$Line2<br> <input type="checkbox" name="$record3checkbox" value="checkbox"></td> <td>$record5Line1<br>$record5$Line2<br> <input type="checkbox" name="$record5checkbox" value="checkbox"></td> </tr> </table> I want to pull about 200 records at a time from the db and display as described above. How can I tell php to take five records from my result set and display above, then loop through the result set until I'm done?
Table With Weekly Schedule From A Database?
I'm designing a site for a community radio station and the schedule needs to be generated from the list of programs that are in the database the shows table has the following colums show_id, show_name, day, start_time, end_time (i didn't list the non-relevant ones for this portion of the site) because a table has to be built left to right instead of top to bottom (cell for monday 8am then tuesday 8am instead of all the monday then tuesday etc) and not all the programs are the same length (i think i can use row span="x" depending on the length of the show) I'm quite lost. should i have other colums? how do i query the database to pull the data out in the proper order and build the table?
Deleting A Table From A MySQL Database
I've looked at the manual and a few other php resources, but yet I couldn't find a simple and easy way to delete a table using php. I noticed there is a destroy() function within the MySQL class, but I'm not sure how it's used.
Extracting Database And Building A Table
I have a mySql database with tblDiary DateEmployeeClient 1/1/04SmithBloggs 2/1/04JonesUnited 2/1/04SmithCentral .....etc tblEmployee NumberName 1Smith 2Jones ....etc Thing is I need to get it to display HTML in a date table like this: MondayTuesdayWednesday...etc 1/1/042/1/043/1/04 SmithBloggsCentral_____ Jones______United_____ ....etc and if the user clicks on say Bloggs it takes them to the booking so it can be amended or if they click on _____ it sets up a new entry in tblDiary. I will be using tblDiary.Data and tblDiary.Employee as a compound primary key.
Output Database Entries In A Table
I'm trying to display the entries in a table of two columns, one entry per table cell - in other words, two entries per row, number of rows based on number of entries in the database. But it still doesn't seem to work. It displays one entry per row... I don't know where the problem is. Here's my code:
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.
Database P0c79 - Table Personaldetails Error
I can't create a table in my database. I get the following message: Database p0c79 - table personaldetails Error SQL-query: CREATE TABLE personaldetails (id TINYINT not null AUTO_INCREMENT, firstname VARCHAR (15) not null , surname VARCHAR (15) not null , password VARCHAR (10) not null , teacherstatus ENUM not null , PRIMARY KEY (id)) MySQL said: You have an error in your SQL syntax near 'not null , PRIMARY KEY (id))' at line 1. I can't see what is wrong with this - it looks perfect to me, and there is no room for error as all I am doing is ticking boxes in phpMyadmin.
Error Checking For Unique Value In Database Table?
I am inserting data into user table which contains 5 fields, sounds simple enough normally but 2 of the fields are designated as UNIQUE. If someone does enter a value which already exists, how do I capture this specific error? Would it make more sense to actually run a SELECT query first and if that returned a result, then I use that for error checking and don't run insert until select returns nothing?
PHP Function To Display A Database / Table Structure?
My webhosts cpanel is down for maintenence, including phpMyAdmin, and I need to view my database structure... Is there any function in PHP to display the database structure (like the "Export" function in PHPMyAdmin)?
Display Items From A Mysql Database In A Table
I am trying to display items from a mysql database in a table but I need it to start a new table row each time multiples of 3 rows of the database table have been displayed like the following example: item 1 item 2 item3 item 4 item 5 item 6 Does anybody know how I can make this work using php.
Putting An Array In A Mysql Database Table Field
I want to insert an array into my database but i've got a problem with it. Before i insert the array into the dbase i check if everything is in the array with print_r($array). Everything that should be in the array is in there so i insert it into the dbase. When i check my dbase with phpmyadmin the field that should contain my array has the word array in it so i assume the array is in the dbase. But when i retrieve the data from my dbase and check my array with print_r i get the following error: Warning: Argument to array_values() should be an array in.
Error In Generating Table From Database Select Statment
I am trying to dynamically create a table with the results from a select statement. Below is the code that is not working. Any help would be oh so greatly appreciated. This is for a final at school which is due in an hour. This is the only thing I can't seem to make work. Code:
Valid MySQL Database/table/column Name Regexp
regular expression in PHP which could be used to check that a proposed (My)SQL database/table/column name is valid, i.e. shouldn't result in an SQL error when created? The user of my (hopefully to be opensourced) program has the ability to create database/table/column names on the fly. I'm aware of obvious characters such as ., [space], things like >, etc., which won't work, but haven't been able to source a definitive list, including having googled the MySQL site. Obviously certain characters need to be filtered out, as noted above, but I want to be as unrestrictive as possible; hence just [a-z]* isn't good enough because things like _ are acceptable. Ideally, I'd prefer a regexp that applies to _all_ vendors' databases, not just MySQL as I'm about to migrate the program to being database-independent, probably using PEAR DB, but even a MySQL-specific regexp would do the job. In the longer term, I plan some sort of entity conversion script so that theoretically any character could be used, using some sort of escaping mechanism probably.
Deleting Duplicate Entries From MySQL Database Table
The topic is related to MySQL database. Suppose a table "address" contains the following records ------------------------------------------------------- | name | address | phone | ------------------------------------------------------- | mr x | 8th lane | 124364 | | mr x | 6th lane | 435783 | | mrs x | 6th lane | 435783 | | mr x | 8th lane | 124364 | ------------------------------------------------------- Quote:
Display Database Output In Mutli Column Html Table
I am building an HTML form using data from a mysql query. The data to be displayed on the form is 1 column from the db - but multiple rows. Because there are many rows (well, only about 100+) in the table I want to be able to put 2 or 3 (space permitting) rows from the result on each row of the HTML table with a checkbox beside each entry from the db table. The idea is that the user will scroll down the list and check up to 4 or 5 boxes before submitting the form and I didn't want them to have to scroll ALLLL the way to the bottom (100+ rows). I understand how to get data from a db table and put it into an html table, but I cannot figur out how to put more than 1 row from the result on to the same row of the html table. I hope I haven't confused anyone reading this -- If I am way off base with what I am trying to do please give me alternatives. I am trying to avoid paginating the data for a couple reasons a) clicking a next and/or prev button is more hassle than just scolling down a list and b) the data in the column being displayed is only about 35 - 40 characters and it seems to be if i only placed one result row on each html table row, there would be a lot of wasted space.
Php Import Xls Into Mysql
<?php $target_path = "/home/vol1/example.us/a/ayush/www/virtual/closing/"; $target_path = $target_path . basename( $_FILES['file']['name']); if(move_uploaded_file($_FILES['file']['tmp_name'], $target_path)) { echo "The file ". basename( $_FILES['file']['name']). " has been uploaded"; include ('mysql.php'); require_once 'reader.php' $data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('CP1251'); $data->read('closing/closing.xls'); error_reporting(E_ALL ^ E_NOTICE); for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) { $closing = $data->sheets[0]['cells'][$i][2]; $sql = "UPDATE listedcomp SET closing = '$closing'"; if (mysql_query($sql)) { echo "Done"; } else { mysql_error(); }} } else{ echo "There was an error". $_FILES['file']['error']." uploading the file, please try again!"; }?> PLEASE HELP! This code isn't importing the data properly....when i see the closing column...all the values are set to 1000, idunno why? The column is set to interger type......
Import And Export
Anyone could give me some tips about coding an import and export php script with mysql ?
Directory Import?
I'm developing an interface where I want the user, after logging in, to be able to view files such as images, pdf's, quicktimes. First off, can they view these files within the interface or do they have to open the PDF's and Quicktimes with another piece of software? Also, because the files will be changing every few hours, can I set this up so that they load from a folder rather than from a database. I would need to be updating the database 24 hours a day in order to keep up so it would be much easier for me if they loaded from the folder.
Automating A Datafeed Import
I am integrating an external datafeed that is changing daily. How do I make my MySQL database pull this fresh data daily and update all my pages with new content?
Import Geographical Data
I'm writing an internet marketing application in php and I need to import inside a mysql db all data about countries, district or provinces, towns or cities, villages or other places of interest in the world. Can you suggest me where I can import or grab or simply buy these kind of geographical data?
PHPMyADmin Error CSV Import
I recently upgraded to XP, Latest Mysql and Latest PHP. I run IIS local and used to be able to imprt CSV files to all my external databases as well as my local. Now I can only do it on my local. When I try to import to an external i get the following error using PHPMYADMIN SQL-query : LOAD DATA INFILE 'C:PHPuploadtempphp24.tmp' INTO TABLE `developers` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY ' ' MySQL said: File 'C:PHPuploadtempphp24.tmp' not found (Errcode: 2) Now I thought it was permissions but they are wide open and I have the ini file set up correctly i think for windows - i have tried all combos of slashes so not that: ;;;;;;;;;;;;;;;; ; File Uploads ; ;;;;;;;;;;;;;;;; file_uploads = On upload_tmp_dir = C:PHPuploadtemp upload_max_filesize = 2M
|
TRACKER
