| |
| |
| |
|
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
Comments:
<0> I have been trying to get it working for a day now. exec-ing works just find but prepare ...
<1> MarkR42: there might be quite a lot. but if i don't do it that way i have to make a mysql-query inside every loop.. and that's bad for preformance, i supose?
<2> mugger: When you reload the page you'll want to fill the select boxes appropriately
<0> I have a simple query that does not seem to produce any results and it should
<0> because If I insert the value I search for litterally I get results
<2> mugger: Anything preselected, you can fill in the boxes with the same value as the default. You can make it submit the form with GET method.
<3> MarkR42: Right, but I also have a whole bunch of <input> boxes where they've entered their name, phone number, street address, etc already
<0> here is the code http://pastebin.com/745681
<2> mugger: You can p*** them through as hidden fields (or non-hidden) fields and repopulate them with the same values.
<2> using a form with GET or POST
<4> hmm, how can i go to a new line in my die function?
<2> (If it's just a simple search, I'd say use get, if it saves anything server-side, use post)
<4> die("Cannot establish connection with MySQL. /n Please contact Technical support."); It doesn't work :(
<5> jbrimble, insert a '<br>' ?
<0> add \n and use "
<4> haha, wrong slash
<5> jbrimble, if it's html, you might still want the <br>
<0> And drakas, any ideas ?
<4> Thanks, Nomikos. I'll do that
<6> oh
<6> i don't use pdo
<4> one more thing on that subject, is there a way I can get a mysql error code into my die function?
<6> though it looks nice
<0> what do you use then ?
<6> wimpies: my own cl***
<0> but what do you use in your cl*** ?
<0> dbx ?
<6> wimpies: normal mysql
<5> jbrimble, easily: die('there was an error:<br>'. mysql_error());
<2> wimpies: yes, I use prepared queries with PDO
<2> they are easy.
<6> wimpies: if the cl*** ifs for mysql, then mysql, if it's for something else - it's for somehting else.But it still is accessible the same way :]
<4> Thanks so mcuh
<6> MarkR42: so you could help wimpies on #http://pastebin.com/745681
<6> MarkR42: so you could help wimpies on http://pastebin.com/745681
<0> so MarkR42 perhaps they you can explain what is wrong with my pastbin
<0> drakas : I use dbx_ before but it seems to be obsoleted and I got advice on this channel to switch to PDO
<2> wimpies: I don't normally use bindparam, I use the optional parameters to exec(), but do parameter indices start at 0 or 1 ?
<6> eeh :/
<6> wanna see my database cl***?D:
<0> According to the samples I pasted 1 but I can try ...
<5> Drakas, i'll look :)
<0> If I use 0 I get an exception
<6> not finished, but documented, Nomikos : http://rafb.net/paste/results/wrluzV45.html
<2> wimpies: What symptom do you get?
<0> No errors but no results
<6> so.. to make a query i make an array of fields that i want and clauses, which can be used on any database engine which is even not mysql, such as Xpath :)
<2> And you do actually have a row with that ID?
<0> yes I have
<7> xshad: :)
<0> I have run the query with ID = 'HourAdmin' (so without the ?) and then it works
<7> xshad: TML got me the rest of the way here :)
<8> I wonder why "y-windows" never took off
<9> itrebal :)
<6> itrebal: http://repository.itrebal.com/uploads/miniitx << I am jeallous
<10> where is the php help page on writing functions?
<7> Drakas: haha - i am too! i wish i could get it :/
<9> "XML Parsing Error: not well-formed" oh crap
<11> Hey, you tell me you're going CLI, I'll move heaven and earth to make it happen. :)
<7> TML: :D
<2> wimpies: I take it you've got the PDO error mode set to something useful like Exception
<6> eeh :]
<0> Yes I have this to open the database
<0> $DB_Link = new PDO(
<0> "mysql:host=$FY_DBHost;dbname=$FY_DBName",
<0> $FY_DBUser, $FY_DBPwd
<0> );
<0> $DB_Link->setAttribute(
<0> PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
<6> :)))))
<7> !tell wimpies about pastebin
<9> !tell wimpies about pastebin
<6> :D
<7> haha
<9> lol
<7> we're getting good at this
<9> yeah
<9> quite fast
<6> ;]
<12> team effort
<6> ::D
<12> go team
<8> yeah :)
<7> now you guys should start doing tricks, like de-oping eachother
<6> you could have been there when about 10 bots came today ;]
<9> damn... I didn't get +o :(
<7> Drakas: but they got KLined, its alright :)
<6> i know itrebal
<6> but it would be more fun to see kick and bans
<6> :D
<7> hehe
<2> wimpies: I don't know what to suggest, except that I normally call $sth->execute(array($someparam))
<13> should I learn PDO now instead of the mysql_* functions?
<2> rather than using bindValue
<7> my terminal's font-size is really quite large..
<6> voltagex: mysql is still good
<13> Drakas: but if I want to support multiple databases?
<6> voltagex: in my case, let me show you something
<14> Morning
<6> voltagex: if you wanna use pdo, then there's no problem
<6> but i suggest that you create your own query builders for each type of database
<6> let's say msaccess and mysql are different
<7> mornin' lig
<14> hey itrebal
<6> you'll use the same functions in everything.
<15> hmmm
<13> Drakas: but then p*** 'mysql' or
<6> except... something like $db = DB::Open("mssql://user:p***word@host/database/")
<13> 'access' as a parameter?
<2> voltagex: Using PDO is quite nice, but I recommend you don't plan to support multiple databases. Using PDO may make it easier if you ever want to migrate though.
<6> voltagex: http://nopaste.php-q.net/215726
<14> ;)
<6> this is how I make a query
<13> MarkR42: I guess that's what I meant. It's only my little pet projects, so nothing too important but I haven't settled on a dbms yet
<6> it doesn't matter what is behind Query() function because it does different things for different databases.
<2> I've never made an app which supported more than one db, but I have migrated them
<13> I really should get more ram for my little dev box
<13> it's swapping to disk like mad
<6> voltagex: how much have you got?
<6> [RAM]
<13> Drakas: 256mb because I'm broke.
<6> not that bad
<13> 3mb free atm.
<6> :O
<13> stupid java memory leaks
<6> java is evil
<6> i don't like it
<13> but the best torrent client is written in it :P
<6> voltagex: what is it?
<6> :]
<13> Azureus
<9> ctorrent rock
<13> /offtopic
<6> qtorrent bittornado ;]
<6> Opera !!:D
<16> voltagex: Why are you running torrents off a dev box?
<9> lol
<13> FlamingCows: because I only have one linux box.
<16> Java: Write once, debug anywhere.
<16> I mean, run.
<13> FlamingCows: and I don't do any commercial programming
<13> Write once, memory leaks anywhere.
<9> Wolfpaws 'twckid' using B6 ?
Return to
#php
or
Go to some related
logs:
#lisp
ubuntu clone mac
msort.c: In function ‘msort_with_tmp’: ubuntu
#debian
#perl
xolphin.net
#math
Public key for freshrpms is not installed
drm.ko needs unknown symbol
#php
|
|