| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
Comments:
<0> fare = far
<1> babo: I build a table for each 'entity' I track. Users, trucks, shipments, parts, functions, etc. Then I create a relationship table for each relationship. So a user+truck+shipment table would be a 'route' table. I have a Route driven by UserA in TruckB hauling ShipmentA. But if my users and trucks were locked-teams, I'd have a team table, User+Truck, and then a Team would drive a Shipment.
<2> stormchas3r3: yes i know... but ... then change your change include ini
<3> to?
<1> babo: I kinda take the best of the ER system and merge it with the best of the logical formula system.
<4> anyone got good tutorials on optimisation for mysql and php? or how many queries for one page would be over the top? how far should i normalise data?
<5> Jemt: consider http://us3.php.net/manual/en/types.comparisons.php
<0> philip: Checking :)
<1> maxer: 3NF no matter what. Further if transactions, time, or heavy usage requires.
<6> Ahroun: so just one key/value table then, to translate between vertical and horizontal storage ??
<1> maxer: Rarely is it difficult to push 3NF to BCNF, so go for it if you have time.
<2> stormchas3r3: now it works,
<2> ?
<1> babo: I suppose I'm not quite understanding your question.
<3> include.ini?
<5> stormchas3r3: the php manual is a useful tool, it talks about include_path, and it talks about how to define it for relative includes
<3> why thank you philip
<5> all php directives are set in php.ini
<4> my database will be extremely heavy use and im thinking of using multiple servers tbh... im just wondering how far is it reasonable to normalise data and balance it with performance(number of queries)
<6> Ahroun: well I'll have a personal table, then an email store table ... and then a key/value table to translate the keys in the personal table to multiple values in the email table ... ? that sounds about right yeah ?
<1> maxer: Extremely heavy use? Take it to BCNF and if possible, 4NF. 5NF really only matters if you're doing time-critical transactions.
<4> its going to be a online cuminity site and i have it normalised out o about 120 tables at the minute... i think its a bit extreme
<1> if by personal you mean, "table that holds people data" and by email store you mean, "table that holds the messages to send", then you have that right. But your third table will have NO values, only keys. "key to a person, key to a message"
<7> i've got $sub=array("one","two","three");, $data=array(); how do i make so $data["one"]["two"]["three"] would be some value?
<1> maxer: Sounds about right for a heavy trafficed community system.
<0> Is it correct when I state that == dosn't take notice on types where as === only returnes true if both types is of the same kind and same value?
<8> hello
<5> Jemt: yes
<9> is anyone using this cake framework?
<0> philip: And thanks for the link - it's great.
<7> !tell joab about g10
<0> philip: Great, thanks
<5> Drakas: why would you do such a think with an array?
<0> Is there any chance that PHP might become strongly typed in the future?
<6> Ahroun: yes indeed ... I can have one such 'key' table to handle all the data translations between all tables for my apps right ?
<5> Jemt: no, people who want strong types use === everywhere, so, we have our choice
<7> philip: working on something complicated.
<5> also, php is pretty anal about BC
<0> philip: Ok, great. So PHP is also all about choice - almost like Gentoo :)
<0> (I'm using Ubuntu though :)
<1> babo: Negative. You'll want an all-key table for each relationship. In the simple schema I gave you, there's only one relationship -- emails to send to people. --- This is getting DB heavily oriented, do you mind if I /msg you and move this off channel?
<5> choice is good althogh == is abused
<5> for example a function will return true or false, nothing else, yet most still use ==
<7> so... nobodY?
<6> Ahroun: no of course not ...
<8> I want to learn php and mysql on my computer can you tell me if phptraid is good for learning purposes
<10> I noticed in my script when I comment out all header() functions, it doesnt seem to prompt me to download/save a specific content, is there anyway to check if a header runs fine, to do a certain task?
<0> philip: Ah, yes, that's true
<5> plika: yes, although xamp is the most popular
<0> philip: Good example - thanks
<11> Using a switch. can I put conditions in the case, like "case 'googlemail' || 'gmail':"
<5> or actually, xampp
<12> hi
<10> cause Im trying to make my script do something specifically only if the content requested downloads successfully
<5> Jemt: btw, i've grown up using php for many years, and only php, but am now going back to school and just took C, and now C++, and will say... it's strange ;-)
<13> Stormx2: no.. use case 'googlemail' and don't break it and use case 'gmail' right under that
<14> Stormx2: You can use something like case in_array() and test that way.
<11> niraj: OK
<5> Stormx2: there is no reason, just have two cases
<14> There is a reason. Duplicated code is bad.
<0> philip: Hehe, yea - I did it the same way. A little ASP => PHP for several years => C#, Java, C, C++ etc.
<5> DrBacchus: no, there is no reason
<13> DrBacchus: there is no duplicated code in what i said
<14> I just gave the reason. Duplicated code is bad.
<5> it is not duplicated code
<14> If you have two cases that do the same thing, then you're duplicating code.
<0> philip: Do you use typecasting or do you set the type using settype() ?
<5> case 'a': case 'b': do stuff; break; case 'c':
<0> Type casting produces a copy == performance issue
<14> Ah. I misunderstood what you recommended. Apologies.
<7> ;]
<10> anyone?
<5> Jemt: i don't cast much, but when i do, do (int) or (string) ...
<0> philip: Ok :)
<7> i've got $sub=array("one","two","three");, $data=array(); how do i make so $data["one"]["two"]["three"] would be some value?
<15> beerdeliveryguy - the browser only knows that the content is sent, past that, you can't tell anything
<10> well, how can I have it just perform the fucntion if the content has been sent
<16> hm..
<10> like I know it has to do with the headers.
<17> hi, I omitted a semicolon ; at the end of a php statement on purpose to see what the error looks like. I ran the script and a blank page just came out.No error message. I then edited php.ini and set Display_errors = On then restarted httpd. Ran the script again and the same thing happens. My question is:- how do I make php to show me a simple error like omitting a semicolon?
<10> cause i comment em out, and no download prompt appears, anyway to check if headers = true?
<10> and then perform function
<18> i write a in my db via insert into, now it displays an 1/4 there , why ?!
<13> liinuxmaster: did you also check the error_reporting value in php.ini?
<17> no
<13> well, do that :)
<17> niraj:let me checkthat one too
<19> "MySQL extension cannot be loaded" ...means I need to move a file into a particular system folder, I remember that much. someone want to enlighten me what and where?
<13> libmysql.dll
<13> windows\system32
<5> [1]Freak: php.net/mysql tells all
<13> (if it's on windows)
<19> that it is Nira.
<19> regretfully
<13> hehe
<10> enygma - anyway to tell if the header properly sent out and sent out the content to perform a function if it properly set itself?
<20> Rio___: can yoyu save those characters in mysql alone?
<19> and libmysql comes out of the php folder, eh?
<21> yes
<13> i think it's in one of the mysql folders too
<20> Rio___: ergo try saving those characters directly to mysql, if it doesn`t work it is mysql`s fault, if it works it is php`s fault.
<19> is it the same one then?
<5> the php manual was created so we don't have to repeat the same words over and over
<21> redduck676 its php's faul
<13> they might not be the same version, but they're the same thing
<19> alright
<19> thanks.
<12> when inserting an array as a row into a db table, how can i handle NULL values? i'm using implode("', '", $row) to get a list like 'bla', 'foo', ... for the values, but NULL fields become '' which is not NULL db wise, any idea?
<22> ronino, str_replace it? :)
<17> niraj: error_reporting = E_ALL but still no change
<20> Rio___: :'( sorry can`t help you.
<21> damn
<12> Davey|Work: like '' => NULL?
<13> liinuxmaster: restarted your webserver again?
<20> ronino: fix it in mysql? iirc it has `is null' and `is not null'
<1> liinuxmaster: change it to E_ALL | E_NOTIFY and see if you get any notifications.
<22> ronino, yup
<23> <18>
<23> charset
<21> ?!
<5> if display_errors is on, and all the various error logging directives are on, it still ouputs the error to the screen right? i forget
<23> utf-8-fr
<21> it is
<13> liinuxmaster: is the missing ; on the last line?
<12> redduck676: fix in MySQL?
<5> aholmes: why? E_ALL alone is fine, and E_NOTIFY you meant E_NOTICE :)
<21> ill get the string to input by a form
<5> Ahroun: rather
<21> <meta http-equiv="content-type" content="text/html;charset=utf-8" />
<20> ronino: yes, when selecting things select only non null values.
<1> Yeah, notice, my bad. And because he's having trouble with something and he says E_ALL isn't giving him info, so maybe he'll get some from E_NOTICE.
<23> rio in the mysql i mean
<21> urm...
<12> Davey|Work: hmm, but i have to check where the '' is it can also be inside a string
<5> Ahroun: E_ALL includes E_NOTICE
<23> or if its to output in a html, u can use the code for special char
<1> Philip: which one is it that E_ALL doesn't include then?
<5> E_STRICT
<12> redduck676: i want to insert something and i want to have a NULL value be inserted, it's not about selecting the data later
<23> é
<5> but nobody uses that :)
<17> niraj: no. second from last line of the php script
<21> if i add the query via phpmyadmin its correct viewing the
<1> 'k, I stand corrected. And I do use E_STRICT.
<24> philip, nobody & ^me :)
<5> oh, you guys use php 5? php 4 until i die! :)
<21> if i put the form value via post in a string , its turning to /4
<13> liinuxmaster: then do a php_info() and make sure the php.ini values are being applied
<20> ronino: ugghh.. rtfm, mysql has a nice manual. insert into (colum1, colum2.....) values ("value1", "value2"....)
<13> err
<13> phpinfo()
Return to
#php
or
Go to some related
logs:
echolinux Ubuntu
fc6 fglrx Operation not permitted
dvdauthor freezing
#gaim
maxdata eco3150x
httpd-secure fedora
openembedded openttd segmentation
#web
intall eclipse + linux
3DCC nvidia
|
|