| 00:07.32 | *** join/#uphpu newinphp (n=tec@rrcs-70-61-249-146.central.biz.rr.com) |
| 00:12.22 | newinphp | hi guys I need help with some php code to create a userdatabase for mySql please help |
| 00:13.17 | bradym | what's up? |
| 00:18.44 | newinphp | bradym can u help? |
| 00:19.16 | bradym | I'll give it a shot, what's your question? |
| 00:20.06 | newinphp | I'm trying to create a user database and also I wrote a code that my seql is not understunding |
| 00:20.35 | newinphp | CREATE TABLE 'USER'[ |
| 00:20.35 | newinphp | <PROTECTED> |
| 00:20.35 | newinphp | <PROTECTED> |
| 00:20.35 | newinphp | <PROTECTED> |
| 00:20.35 | newinphp | <PROTECTED> |
| 00:20.36 | newinphp | <PROTECTED> |
| 00:20.38 | newinphp | <PROTECTED> |
| 00:20.42 | newinphp | ] ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1; |
| 00:21.13 | newinphp | that is the code that i should put in mysql fist |
| 00:22.59 | bradym | ok.. |
| 00:23.50 | burnin | PRIMARY KEY ('Id') and yet you have 'id' int(10) unsigned NOT NULL auto_increment, isn't mysql case sensitive? |
| 00:23.58 | Lone_Wanderer | no |
| 00:24.03 | Lone_Wanderer | err, yes |
| 00:24.09 | Lone_Wanderer | the field names are, but the commands aren't |
| 00:24.12 | Lone_Wanderer | (iirc) |
| 00:24.25 | Lone_Wanderer | Although, tbh, you should probably be using phpmyadmin to set up your databases. |
| 00:24.39 | Lone_Wanderer | (on the other hand, doing them this way will make you learn SQL, which is a good thing.) |
| 00:25.06 | newinphp | hahaha yeah |
| 00:25.23 | Lone_Wanderer | phpmyadmin is a good program, but if you're new at php then setting it up might be a bit of a challenge |
| 00:25.38 | newinphp | I'm actually working with it |
| 00:25.51 | Lone_Wanderer | Oh. Well, then just use it to create your DB's |
| 00:26.25 | newinphp | but its not taking the code |
| 00:27.06 | Lone_Wanderer | Well, the idea behind phpmyadmin is that you don't have to type DB creation SQL in manually. |
| 00:27.27 | newinphp | hi guys I need help with some php code to create a userdatabase for mySql please help |
| 00:27.40 | Lone_Wanderer | ... |
| 00:27.43 | Lone_Wanderer | You already said that. |
| 00:27.50 | bradym | we can help you better if you ask specific questions, newinphp |
| 00:28.02 | Lone_Wanderer | And, just to be strictly correct, your php code isn't (we hope) creating the database. |
| 00:28.39 | Lone_Wanderer | Anyway. In phpmyadmin, if you're using it, click the little house on the left side, then in the main frame you should have two columns |
| 00:28.41 | newinphp | to create a user credential you need to use some coding that is what I'm doing |
| 00:28.54 | Lone_Wanderer | It's not PHP code though. It's SQL. |
| 00:29.18 | Lone_Wanderer | In the left column on the main frame, there's a box labeled "Create new database". Type your DB name in there and hit "Create". |
| 00:30.16 | newinphp | that is how the not said it should be done @ this level |
| 00:30.38 | Lone_Wanderer | What is "it"? |
| 00:30.45 | Lone_Wanderer | Also, may I ask where you're from? |
| 00:30.45 | bradym | the problem with your sql query, though, is that you're using single quotes ( ' ) around field names -- change those to backticks ( ` ) or just get rid of them |
| 00:31.01 | bradym | a ` and a ' are different creatures to mysql |
| 00:31.55 | burnin | CREATE TABLE USER ( |
| 00:31.55 | burnin | id int unsigned NOT NULL auto_increment, |
| 00:31.55 | burnin | username varchar(20) NOT NULL default '', |
| 00:31.55 | burnin | password varchar(50) NOT NULL default '', |
| 00:31.55 | burnin | email varchar(40) NOT NULL default '', |
| 00:31.55 | burnin | ip varchar(20) NOT NULL default '', |
| 00:31.57 | burnin | PRIMARY KEY (id) |
| 00:31.59 | burnin | ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1; |
| 00:32.01 | burnin | that works |
| 00:32.26 | Lone_Wanderer | Sure, just hand him the answer ;) |
| 00:32.27 | bradym | also, you don't beed to specify AUTO_INCREMENT=1 twice ;) |
| 00:32.40 | bradym | need* |
| 00:32.49 | burnin | hmm, what was the int(10)? |
| 00:33.19 | bradym | int(10) was with the id field |
| 00:33.46 | burnin | but what does the (10) do? |
| 00:33.57 | Lone_Wanderer | specifies the size of the int |
| 00:34.04 | Lone_Wanderer | 10 is the largest it goes I believe |
| 00:34.10 | Lone_Wanderer | for the normal integer type |
| 00:34.16 | burnin | oh, interesting, I didn't know you could specify the size of ints. |
| 00:34.36 | newinphp | great guys that work |
| 00:34.48 | burnin | hehe |
| 00:34.52 | Lone_Wanderer | burnin: you've fed the kitten, now it'll never go away |
| 00:34.55 | burnin | I guess I should read up on it. |
| 00:35.06 | bradym | yeah, i don't really know what the point of having a size on an int size is either |
| 00:35.13 | burnin | I'll step on its head next time. ;) |
| 00:35.17 | Lone_Wanderer | Size concerns. |
| 00:35.22 | Lone_Wanderer | Which seems silly. |
| 00:35.42 | Lone_Wanderer | If you've got to worry about disk usage, there are better ways than by chopping a few bits off every int field in your DB. |
| 00:35.55 | bradym | yeah, definitely |
| 00:36.11 | Lone_Wanderer | Head stepping is usually my first instinct, so I just shut up and let nicer people talk. |
| 00:36.18 | burnin | I knew there were different sizes of ints, but I didn't know you could specify the size by the number of bytes. |
| 00:36.30 | Lone_Wanderer | Also, I should probably resist the urge to sing along with this song out loud, since it's "Rape Me". |
| 00:36.44 | burnin | lol |
| 00:36.52 | Lone_Wanderer | RAPE ME! RAPE ME! *killer drums* |
| 00:36.52 | burnin | depends on who is in the room with you |
| 00:37.05 | Lone_Wanderer | Well, no-one, but the office down the hall has lots of small-framed women. |
| 00:37.20 | Lone_Wanderer | Wow, now that I think about it, they're all really small. |
| 00:37.37 | burnin | http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html |
| 00:37.48 | burnin | tinyint, smallint, mediumint, int, bigint |
| 00:38.08 | Lone_Wanderer | cool, thanks |
| 00:38.14 | Lone_Wanderer | I hate trying to find stuff in the MySQL docs. |
| 00:39.15 | burnin | oh, the number has something to do with how the number is displayed. |
| 00:39.26 | Lone_Wanderer | On a completely separate topic - one of the thing that constantly throws me about being Grown Up is knowing, doing, and working on things I can't talk about. |
| 00:40.20 | Lone_Wanderer | Oh cool, I see. |
| 00:59.32 | Lone_Wanderer | Oh man. |
| 00:59.45 | Lone_Wanderer | What I wouldn't give for one of PostgreSQL's sequences right now. |
| 01:09.53 | bradym | i really need to play around with PostgreSQL, but it's so easy to use what i've always used |
| 01:16.17 | wps | according to thebigdog, it'll help you get chicks |
| 01:16.49 | bradym | lol |
| 01:17.01 | wps | dang, he's not even here to appreciate that |
| 01:17.04 | bradym | well.. if that's the case.. |
| 01:17.18 | *** join/#uphpu _psychic_ (n=_psychic@c-67-186-222-175.hsd1.ut.comcast.net) |
| 01:17.19 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 01:18.43 | Lone_Wanderer | http://www.specialoperations.com/Army/Special_Forces/earning.html |
| 01:19.09 | Lone_Wanderer | It sounds like it's harder than ballet. |
| 01:20.31 | wps | what's the "C" in the two word Special Operations acronym? |
| 01:20.41 | Lone_Wanderer | Which acronym? |
| 01:20.45 | wps | SOC |
| 01:20.56 | Lone_Wanderer | I don't know. I'd guess command. What's the context? |
| 01:21.02 | wps | don't tell my it's "com" |
| 01:21.13 | wps | http://www.specialoperations.com/imagepool/specopslogo.gif |
| 01:21.25 | wps | http://www.specialoperations.com/images/banners/specopsban3.jpg |
| 01:21.37 | wps | s/my/me/ |
| 01:22.04 | Lone_Wanderer | Yeah, it's command. |
| 01:24.14 | Lone_Wanderer | Did you read the article I linked Wade? |
| 01:24.46 | wps | no |
| 01:24.53 | Lone_Wanderer | meh, ok |
| 01:25.02 | wps | <PROTECTED> |
| 01:25.08 | Lone_Wanderer | no worries |
| 01:25.29 | Lone_Wanderer | I'm just wondering if my reaction (makes me want to try it just to see if I can make it) is typical |
| 01:25.34 | wps | I'd like to, but if I have time to do that, my wife we'd like me home |
| 01:26.30 | wps | I'm entering the twelfth hour at the office |
| 01:26.34 | Lone_Wanderer | ouch |
| 01:26.36 | Lone_Wanderer | get to work man |
| 03:17.30 | *** join/#uphpu unum (n=unum@70.89.247.221) [NETSPLIT VICTIM] |
| 03:17.47 | *** join/#uphpu optikal (i=optikal@optikal.org) [NETSPLIT VICTIM] |
| 03:17.47 | *** mode/#UPHPU [+v optikal] by ChanServ |
| 03:41.38 | *** join/#uphpu jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 03:41.38 | *** topic/#uphpu is Utah PHP Users Group | uphpu.org |
| 03:41.39 | *** mode/#UPHPU [+v jbot] by ChanServ |
| 03:48.23 | *** join/#uphpu Ritter (i=ritter@unstoppable.chpass.net) |
| 11:07.25 | *** join/#uphpu xilch (n=xilch@c1.broadweave.net) |
| 12:57.58 | *** join/#uphpu fungus (n=fungus@mailhub.sosstaffing.com) |
| 12:58.06 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 14:00.02 | *** join/#uphpu jsmith-dinner (n=jsmith@h46057ae7.area3.spcsdns.net) |
| 15:19.12 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 15:19.12 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 15:54.45 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 17:18.33 | *** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
| 17:18.33 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 17:59.38 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 17:59.38 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 18:36.04 | *** join/#uphpu wps (n=wps@208.53.47.251) |
| 18:36.04 | *** mode/#UPHPU [+o wps] by ChanServ |
| 19:43.46 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 19:43.46 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 20:17.23 | *** join/#uphpu jsmith-dinner (n=jsmith@h46057ae7.area3.spcsdns.net) |
| 22:59.27 | *** join/#uphpu ash_is_me (n=Amanar@AAmiens-157-1-95-169.w86-208.abo.wanadoo.fr) |
| 23:04.45 | *** part/#uphpu ash_is_me (n=Amanar@AAmiens-157-1-95-169.w86-208.abo.wanadoo.fr) |
| 23:27.53 | *** join/#uphpu fungus (n=olsonl@mailhub.sosstaffing.com) |
| 23:27.53 | *** mode/#UPHPU [+o fungus] by ChanServ |
