| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> ;Note that MySQL and ODBC support is now built in, so no dll is needed for it.
<0> so i suppose i can directly use the mysqli function without enabling anything, but it seems like i can't
<0> any idea guys? thanks in advance
<1> you're using php4 right?
<0> yea
<1> mysqli is php5 and up
<1> if you are using php4, you use the mysql functions
<1> http://www.php.net/mysql
<0> but the txt file i read said it is supported in php 4 too
<0> wait , let me refresh my memory
<0> does that mean, php4 got mysql built-in, but it can only use mysql function but not the mysqli function, and in order to use mysqli function, i need to comile it with php?
<0> either compile it with php or use the php5.
<0> am i right?
<1> no, mysqli is php5 and greater ONLY
<1> you cannot use mysqli on php4
<1> you use the mysql functions
<0> but here it says :
<0> The mysqli extension allows you to access the functionality provided by MySQL 4.1 and above.
<1> yeah, good for it
<1> mysqli is php5 and greater only
<0> ahhh!! i think i finally got the point!!!
<0> let's say, if i download the php5, then i can directly use it ? or do i still need to compile anything?
<1> you are on windows so you don't need to compile anything
<0> spox : finally i understand already! Thanks!
<0> spox : i mis-read the " MySQL 4.1 and above"
<0> spox : i mean mis-intepreted
<0> spox : i kept on thinking about "php 4.1 and above"
<0> spox : thanks man!!! tonight i can sleep well without thinking about this question again :)
<1> no problem
<0> anything i can do for u?
<0> anyway, cya next time and thanks again!
<2> how to convert hex to bin? i user bin2hex before
<1> look at the comments on the bin2hex man page
<2> ok
<2> thanks spox, it works
<1> anyone that would like to send me espresso is more than welcome to
<1> :/
<2> hehe
<3> does anyone here have experience with load balacers? i'm trying to pick some hardware but have no experience with them.
<4> ?
<3> trying to pick a load balancer :)
<5> whats the best way to sanitize input that is being sent to a database then displayed on another page? I need html and 's removed
<5> or replaced
<3> striptags and mysql_real_escape_string should do it
<5> for some reason striptags isnt removing the html
<5> i'll see if the escape string works any better
<3> you must be doing something wrong then...
<3> escape will just get rid of ' etc
<5> strip_tags($name);
<5> ?
<5> should that not work?
<3> $name = strip_tags($name); // should work
<5> ah, my bad
<5> thanks,
<3> :)
<3> anyone here using object persistence with Propel or soemthing similar?
<3> anyone here working on building high availability projects? need some advice on hardware i.e. loadbalancers
<3> everyone's alseep i guess, yawn
<5> you think i could save myself some coding and use something to the effect of: $fname = strip_tags( $_POST['fname']; );
<5> oops, minus the first semicolon
<3> okso yo uare planning to throw some stuff into db from $_POST?
<3> do this... foreach($_POST as $k=>$v){ $clean_POST[$k] = mysql_real_escape_string(strip_tags($v));}
<3> then pop $clean_POST into your db code/queries
<3> i usually use some db access cl*** that cleans stuff for me, have objects that map what i want from $_POST and then just p*** a $_POST array to db object for insert/update etc.. after some validation ofcourse
<5> im rather new to php,
<5> well, the site im creating is http://www.sponsorpaintball.com , took some time but I've got the database results displaying and sorting properly in the teams section, now im throwing in some security
<6> Guys, I am calling a query from mysql database with php to retrieve a user comment which has been inputed by a form. the problem is that When a user hits enter on the form to create a paragraph the paragraphs are not inserted to the db so when its called and siaplayed everything is on one line.
<6> Can someone aid me with this?>
<6> Will I have to manuall modify the entries already made and tweak the code to prevent it from happening in future, or can I somehow show paragraphs with the query?
<3> use nl2br()
<3> that will convert linebreaks into html <BR> tags and you'll get your paragraphs back (if i understood you correctly)
<6> sounds good
<6> how will that look in a query retrieving something as an array
<6> print $comment['article']
<3> print nl2br($comment['article']);
<3> just becareful with outputting things from db... i.e you don't want to putput any other html as it may use malicious tags/code and allow cross site scripting
<6> inf00: How can I avoid that then ?
<1> mod_spox: urls .*fark.*
<7> incorrect usage, ask for help using 'mod_spox: help urls'
<1> grr
<6> hi spox can you help me please sir?
<1> please state your question in a short, easy to understand sentence please
<6> Ok basically I am calling data from a mysql database, a simple query which returns name, date and comment of a blog. Now the comment gets returend with no line breaks in it, the original breaks which were inserted in the form, do not show on the output query
<6> http://pastebin.com/583806
<1> yeah, so after you query the database and before you print your comment to the browser, run the string through nl2br()
<6> You see the pastebin link
<6> I put nl2br in there
<1> concatenate it in
<1> '<br/>'.nl2br($article['entry']).'blahblahblah';
<6> UnExpected T_STRING
<6> thanks i got it now
<6> cheers spox
<8> Hmm...
<8> I'm kinda missing something in my SQL here...
<8> $db = mysql_query("SELECT * FROM `Task List` WHERE `Due Date` <> 0000-00-00 00:00:00");
<8> SELECT * FROM `Task List` works perfectly...
<8> Adding the WHERE returns nothing.
<4> don't use mysql dates
<4> the only make it more confusing
<4> just write time() to the db
<4> and you can always use date() when you select it back
<8> Will do, fedt.
<8> Thank you.
<8> Store as a string, right?
<8> CHAR, perhaps?
<4> int
<8> Just checked it, saw what it returned :-p
<9> this channel is raving.
<10> DCC SEND "string" 0 0 0
<10> kukuku
<11> hey cv
<10> you ever wake up really really horny?
<10> man, i hate this ****
<11> every morning
<12> hey is an array in php limited in a number of elements?
<10> thecheat841: hello, any ladies on cam?
<13> hello
<12> lol
<10> GiantSausage (lotsameat77) joined the room.
<10> heh
<1> "Marta Stewart prison photos"
<1> good god
<1> the spammers are certainly getting desperate
<11> lol
<11> no kidding
<1> this is sweet
<1> samba and kolab are playing nice through openldap
<1> :-D
<1> now i just got to get my boxes set up with computer accounts on the ldap server and i'll be ready to move data
<1> woohoo!
<10> ***UALLY-EXPLICIT: group course criminals hungary complex the scheme ending negative XpcCMOz6E9M
<1> :-D
<11> wtf
<1> jedzilla: that is english, but that is not english
<10> What are you to do if you have bad erection? Especially
<10> in the forthcoming Saint Valentines Day???
<10> Don t worry, it is not the last of pea-time...
<10> The most simple way is to visit our site, order the
<10> medication and that is all you are to do!
<1> yeah, i'm still getting those too
<1> maybe they are getting a jump on next year
<11> lol
<11> what's pea-time
<14> time to take a leak?
<15> hi, anyone available to give advice on php forums?
Return to
#php
or
Go to some related
logs:
#allnitecafe
#india
#photoshop
#kl
jess laz
qizla tanis olmaq
#kl
#linux
ubuntu acpi=noirq
#india
|
|