PhpMyAdmin Confusion: How To Insert?

11-19-2005 04:21 AM #1

XumebKizu

Guest

PhpMyAdmin Confusion: How To Insert?

Hi, I'm trying to get the magnetic poetry board on the vds, and I'm trying to use PhpMyAdmin to do this. I've searched around for an answer, and I've also read through the PhpMyAdmin stuff on the site, and I found their documentation to be unhelpful to me (perhaps I'm a blockhead.)

Here's the situation:
Code:
]------------------------------------------------------------------------

create a table following this structure under any database:

CREATE TABLE poetry (

   fridge varchar(100) NOT NULL,

   data text NOT NULL,

   timestamp varchar(20) NOT NULL,

   ip_address varchar(15) NOT NULL

);



--[ 2 ]------------------------------------------------------------------------

create the following entry in that table:

INSERT INTO poetry VALUES ( 'fridge_name', '0,0:0,5:0,10:0,15:0,20:0,25:0,30:0,35:0,40:0,45:0  ,50:0,55:0,60:0,65:0,70:0,75:0,80:0,85:0,90:0,95:0  ,100:0,105:0,110:0,115:0,120:0,125:0,130:0,135:0,1  40:0,145:0,150:0,155:0,160:0,165:0,170:0,175:0,180  :0,185:0,190:0,195:0,200:0,205:0,210:0,215:0,220:0  ,225:0,230:0,235:0,240:0,245:0,250:0,255:0,260:0,2  65:0,270:0,275:0,280:0,285:0,290:0,295:0,300:0,305  :0,310:0,315:0,320:0,325:0,330:0,335:0,340:0,345:0  ,350:0,355:0,360:0,365:0,370:0,375:0,380:0,385:0,3  90:0,395:0,400:0,405:0,410:0,415:0,420:0,425:0,430  :0,435:0,440:0,445:0,450:0,455:0,460:0,465:0,470:0  ,475:0,480:0,485:0,490:0,495:0,500:0,505:0,510:0,5  15:0,520:0,525:0,530:0,535:0,540:0,545:0,550:0,555  :0,560:0,565:0,570:0,575:0,580:0,585:0,590:0,595:0  ,600:0,605:0,610:0,615:0,620:0,625:0,630:0,635:0,6  40:0,645:0,650:0,655:0,660:0,665:0,670:0,675:0,680  :0,685:0,690:0,695:0,700:0,705:0,710:0,715:0,720:0  ,725:0,730:0,735:0,740:0,745:0,750:0,755:0,760:0,7  65:0,770:0,775:0,780:0,785:0,790:0,795:0,800:0,805  :0,810:0,815:0,820:0,825:0,830:0,835:0,840:0,845:0  ,850:0,855:0,860:0,865:0,870:0,875:0,880:0,885:0,8  90:0,895:0,900:0,905:0,910:0,915:0,920:0,925:0,930  :0,935:0,940:0,945:0,950:0,955:0,960:0,965:0,970:0  ,975:0,980:0,985:0,990:0,995:0,1000:0,1005', '02/22/01 02:04:25', '24.17.1-[ 1 18.141');
I can create the table... no problem there....... I'm lost at step 2. What exactly am I inserting and where (no joke intended) In phpMyAdmin I've got 4 fields now... I don't see any "poetry Values"....can someone please advise

many thanks,

Gator Mirage
More Information:
that I may be able to get phpmyadmin to show data in such a way that our users can at least make some entries using it with too much confusion
Furthermore, when this box is checked, all of the options related to data insertion are no longer relevant and should thus be greyed out to indicate this
12 posts - 11 authors - Last post: yesterdayGo to the MAMP start page; Click "phpMyAdmin"; On the next page click "Databases"; On the "Databases" page enter a name for your Drupal database in the
Under database specific privileges, select a database and select SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP
You can read about our projects on the official Google Summer of Code 2010 site or Planet phpMyAdmin, where all student's blogs all aggregated
Right now I named all the databases "dbNAME" and in phpMyAdmin I used db_ and it 'seems' to work

More:

running scripts in MySQL

temporary columns

viewing privileges

How can i import an Access database to MYSQL?

INSERT INTO...SELECT...

Delphi CGI connection to MySQL in unix

CONNECT BY

Dynamic generation Web Page

interfacing db mysql using servlet java on apache web server

loading data from a text file into a mysql table

Reply With Quote

11-19-2005 05:00 AM #2

redsquare

Guest

If I understand you right, it looks like you're trying to insert values into the 'fridge_name' field but when you created the table you named it 'fridge'.
More Information:
On the last page, we looked at an example of the INSERT INTO statement in SQL
Alias /phpmyadmin /var/www/phpmyadmin <Directory /var/www/phpmyadmin> AllowOverride All Order allow,deny
Note that in the example, I insert the null string in the first column because it is an auto_increment
Ability to limit maximum size of extended insert * Support for searching in the foreign key window
phpMyAdmin: Es un sistema muy popular para gestionar un servidor MySQL a través de páginas web, programado en PHP
The goal of this project is to address and fix this problem along with other usability problems that may cause confusion, reduce efficiency and lead users to make errors
7 posts - 3 authors - Last post: Jul 17, 2003Can anyone tell me why I'm getting this error "Duplicate entry '127' for key 1" when operating MySQL from within phpMyAdmin 2
We're using the same names for the variables as the form fields simply to avoid confusion
Now click the insert button located at the top of the screen
INSERT INTO node_access (nid, gid, realm, grant_view, grant_update, grant_delete) VALUES (0, 0, 'all', 1, 0, 0);

Reply With Quote

11-19-2005 05:18 AM #3

tuanvnconex

Guest

Thank you Crazy Rob for the response: this is the install.txt right here:

I basically don't know much about databases, and I've been searching on-line, and I'm not finding any good solutions. Does this appear like they made an error in the install.txt file? many thanks.......

this is the install.txt right here:
Code:
--[ 1 ]------------------------------------------------------------------------

create a table following this structure under any database:

CREATE TABLE poetry (

   fridge varchar(100) NOT NULL,

   data text NOT NULL,

   timestamp varchar(20) NOT NULL,

   ip_address varchar(15) NOT NULL

);



--[ 2 ]------------------------------------------------------------------------

create the following entry in that table:

INSERT INTO poetry VALUES ( 'fridge_name', '0,0:0,5:0,10:0,15:0,20:0,25:0,30:0,35:0,40:0,45:0  ,50:0,55:0,60:0,65:0,70:0,75:0,80:0,85:0,90:0,95:0  ,100:0,105:0,110:0,115:0,120:0,125:0,130:0,135:0,1  40:0,145:0,150:0,155:0,160:0,165:0,170:0,175:0,180  :0,185:0,190:0,195:0,200:0,205:0,210:0,215:0,220:0  ,225:0,230:0,235:0,240:0,245:0,250:0,255:0,260:0,2  65:0,270:0,275:0,280:0,285:0,290:0,295:0,300:0,305  :0,310:0,315:0,320:0,325:0,330:0,335:0,340:0,345:0  ,350:0,355:0,360:0,365:0,370:0,375:0,380:0,385:0,3  90:0,395:0,400:0,405:0,410:0,415:0,420:0,425:0,430  :0,435:0,440:0,445:0,450:0,455:0,460:0,465:0,470:0  ,475:0,480:0,485:0,490:0,495:0,500:0,505:0,510:0,5  15:0,520:0,525:0,530:0,535:0,540:0,545:0,550:0,555  :0,560:0,565:0,570:0,575:0,580:0,585:0,590:0,595:0  ,600:0,605:0,610:0,615:0,620:0,625:0,630:0,635:0,6  40:0,645:0,650:0,655:0,660:0,665:0,670:0,675:0,680  :0,685:0,690:0,695:0,700:0,705:0,710:0,715:0,720:0  ,725:0,730:0,735:0,740:0,745:0,750:0,755:0,760:0,7  65:0,770:0,775:0,780:0,785:0,790:0,795:0,800:0,805  :0,810:0,815:0,820:0,825:0,830:0,835:0,840:0,845:0  ,850:0,855:0,860:0,865:0,870:0,875:0,880:0,885:0,8  90:0,895:0,900:0,905:0,910:0,915:0,920:0,925:0,930  :0,935:0,940:0,945:0,950:0,955:0,960:0,965:0,970:0  ,975:0,980:0,985:0,990:0,995:0,1000:0,1005', '02/22/01 02:04:25', '24.17.118.141');



--[ 3 ]------------------------------------------------------------------------

modify magnetic_poetry.inc.php with you MySQL server, login, pass, and the

database/table you created.
More Information:
7 posts - 3 authors - Last post: Dec 21, 2005Hey I am just starting out on PHP & MySQL too, so I understand pretty much any and all confusion
5 Each time I want to insert or change a record or drop a database or a table, an error 404 (page not found) is displayed or, with HTTP or cookie authentication
The SELECT UNIX_TIMESTAMP(CreationDateTime) AS CreationDateTime seems to work but only if I format the date manually with phpmyadmin
As you can see we are inserting in the table called TestTable and were are inserting
Nice idea - It should be simple enough to insert a call to restore_execute() in backup/restorelib
9 posts - 4 authors - Last post: Jul 31, 2006However, how do I insert the data into the table? I made a lot of my fields blobs becuase some of them will have a lot of text in each cell, there
Edit the root user privileges by clicking on the corresponding Edit Privileges button; On the Change Password section insert the desired password and press
1 post - 1 author - Last post: Mar 5, 2008add/strip slashes confusion
The strange thing is, I can use phpAdmin and the same SQL command that didn't work with the jbdc driver in SFS works fine in phpMyAdmin

Reply With Quote

11-19-2005 06:38 AM #4

trongkhai

Guest

if you are using phpmyadmin then when running the this insert.sql that have this line

INSERT INTO poetry VALUES ( 'fridge_name', '0,0:0,5:0,10:0,15:0,20:0,25:0,30:0,35:0,40:0,45:0 ,50:0,55:0,60:0,65:0,70:0,75:0,80:0,85:0,90:0,95:0 ,100:0,105:0,110:0,115:0,120:0,125:0,130:0,135:0,1 40:0,145:0,150:0,155:0,160:0,165:0,170:0,175:0,180 :0,185:0,190:0,195:0,200:0,205:0,210:0,215:0,220:0 ,225:0,230:0,235:0,240:0,245:0,250:0,255:0,260:0,2 65:0,270:0,275:0,280:0,285:0,290:0,295:0,300:0,305 :0,310:0,315:0,320:0,325:0,330:0,335:0,340:0,345:0 ,350:0,355:0,360:0,365:0,370:0,375:0,380:0,385:0,3 90:0,395:0,400:0,405:0,410:0,415:0,420:0,425:0,430 :0,435:0,440:0,445:0,450:0,455:0,460:0,465:0,470:0 ,475:0,480:0,485:0,490:0,495:0,500:0,505:0,510:0,5 15:0,520:0,525:0,530:0,535:0,540:0,545:0,550:0,555 :0,560:0,565:0,570:0,575:0,580:0,585:0,590:0,595:0 ,600:0,605:0,610:0,615:0,620:0,625:0,630:0,635:0,6 40:0,645:0,650:0,655:0,660:0,665:0,670:0,675:0,680 :0,685:0,690:0,695:0,700:0,705:0,710:0,715:0,720:0 ,725:0,730:0,735:0,740:0,745:0,750:0,755:0,760:0,7 65:0,770:0,775:0,780:0,785:0,790:0,795:0,800:0,805 :0,810:0,815:0,820:0,825:0,830:0,835:0,840:0,845:0 ,850:0,855:0,860:0,865:0,870:0,875:0,880:0,885:0,8 90:0,895:0,900:0,905:0,910:0,915:0,920:0,925:0,930 :0,935:0,940:0,945:0,950:0,955:0,960:0,965:0,970:0 ,975:0,980:0,985:0,990:0,995:0,1000:0,1005', '02/22/01 02:04:25', '24.17.1-[ 1 18.141');

and phpmyadmin will automatically insert the data above to the db and if you want to do it manually then

go to your poetry table in phpmyadmin and you will find an "Insert" text link near to a browse link. click the insert link

and insert in the four fields:

fridge: fridge_name

data:0,0:0,5:0,10:0,15:0,20:0,25:0,30:0,35:0,40:0, 45:0,50:0,55:0,60:0,65:0,70:0,75:0,80:0,85:0,90:0, 95:0,100:0,105:0,110:0,115:0,120:0,125:0,130:0,135 :0,140:0,145:0,150:0,155:0,160:0,165:0,170:0,175:0 ,180:0,185:0,190:0,195:0,200:0,205:0,210:0,215:0,2 20:0,225:0,230:0,235:0,240:0,245:0,250:0,255:0,260 :0,265:0,270:0,275:0,280:0,285:0,290:0,295:0,300:0 ,305:0,310:0,315:0,320:0,325:0,330:0,335:0,340:0,3 45:0,350:0,355:0,360:0,365:0,370:0,375:0,380:0,385 :0,390:0,395:0,400:0,405:0,410:0,415:0,420:0,425:0 ,430:0,435:0,440:0,445:0,450:0,455:0,460:0,465:0,4 70:0,475:0,480:0,485:0,490:0,495:0,500:0,505:0,510 :0,515:0,520:0,525:0,530:0,535:0,540:0,545:0,550:0 ,555:0,560:0,565:0,570:0,575:0,580:0,585:0,590:0,5 95:0,600:0,605:0,610:0,615:0,620:0,625:0,630:0,635 :0,640:0,645:0,650:0,655:0,660:0,665:0,670:0,675:0 ,680:0,685:0,690:0,695:0,700:0,705:0,710:0,715:0,7 20:0,725:0,730:0,735:0,740:0,745:0,750:0,755:0,760 :0,765:0,770:0,775:0,780:0,785:0,790:0,795:0,800:0 ,805:0,810:0,815:0,820:0,825:0,830:0,835:0,840:0,8 45:0,850:0,855:0,860:0,865:0,870:0,875:0,880:0,885 :0,890:0,895:0,900:0,905:0,910:0,915:0,920:0,925:0 ,930:0,935:0,940:0,945:0,950:0,955:0,960:0,965:0,9 70:0,975:0,980:0,985:0,990:0,995:0,1000:0,1005

timestamp: 02/22/01 02:04:25

ip_address:24.17.1-[ 1 18.141
More Information:
Then abstract a PHP function to modify dates before an insert, similar to what this article mentions
(To avoid any confusion it is highly recommended that you use the P-Synch utility to synchronize your multiple PU system passwords before attending
12 posts - 3 authors - Last post: Aug 11, 2006I have been trying to learn some php and a lot of the tutorials say to import some lines to the SQL tables via phpmyadmin
I mean it's simply called "mysql", not that it's called "simply mysql" :) I apologise for resulting confusion
I'm fairly sure I used the same settings when exporting in phpMyAdmin (e
Next we are going to create the query that will insert a new row in the database
14 posts - 6 authors - Last post: Jun 13, 2008I prepare new installation, new db and before from my existing site I export from phpmyadmin whole db to myname
What's a safe maximal query length when using Extended Inserts? The server I'm working on lets me upload about 16 MB before the script times out (256kbps upload)
10 posts - 4 authors - Last post: Jun 6, 2006MYSQL problems in phpmyadmin from godaddy Scripting & Backend