[Retrieve Data From Mysql And Send Email To User]

That would be a good place to start.

 

http://www.phpfreaks.com/tutorials/68/0.php

[[SOLVED] reading authorization packet]

Ok so that doesnt mean my code is buggy or anything ? Its more like server/link/connexion issue ?

[[SOLVED] reading authorization packet]

Hi guys,

Anyone ever get this error from a mysql_connect?

 

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL

server at 'reading authorization packet', system error: 0 in

/var/*www/web2/web/comment_post.php on line 163

 

I tried to look at the error on internet but there is not much discussion about it, nothing on the forum either.

If anyone have any hint on this one please let me know.

 

This problem doesnt happen all the time, we got an email today from a customer getting that.

[Inserting country list in mysql from file?]

Allright, Ill give a try! Never seen it before, Ill look for it.

Thanks much!

 

[Inserting country list in mysql from file?]

thats what I was thinking, just wanted to be sure there was no other fast way right in mysql or pma.

Thanks Neo

[how to create and store in multiple database?]

Or that but why would you want to use 2 DB ?

[how to create and store in multiple database?]

You dont really want to use multiple DB for that, juste use 2 different Table

Tbl_Male

Tbl_Female

store in there.

[2 database's limit is it more than 1 database's limit?]

2 database limit mean you can create 2 database for you site, If they didnt put any size restriction on the DB then you actually can use as much table as you want, wich mean you can use prefix to separate your table from a website a & b. IE:

[MyTable]

a_ExampleID

a_ExampleName

...

b_ExampleID

b_ExampleName

...

Thats not the best, but it work well and keep you out of confusion.

 

 

Was that you question ?

[Inserting country list in mysql from file?]

Good day,

Is there an easy way to insert a list of country (from a txt file) in a mysql database? Or does it have to be done one by one (I doubt it ).

 

Thanks in advance!

[hack this...]

Thats very smart, if whoever that tested it get reported... never thought about that ?!

[hack this...]

I dont think this is an appropriate place to talk about how to hack with XSS there is a lot of doc on xss hacking on the net, just google it.

 

[hack this...]

Oh didnt know that, and in that case, the xss is made from right after index.php like this one, there is no  $_GET really right ? How can you fix it?

 

Sorry I dont wanna bum someone else post but since we're on it

[hack this...]

what do you mean by fixed with a single word ? htmlentities

Dont you need to parse and replace the chars and stuff ?

[hack this...]

ouhahaha

Thanks Ob that was H.I.L.A.R.I.O.U.S lolol

Seriously, awesome.

[[SOLVED] Fixing XSS ?]

Ok I found out ... thanks both of you for your help! Didnt think about the .htaccess, there was one of my $_GET that wasnt htmlspecialchars and I forgot it was directed by my htaccess

 

Thanks again for your help

[[SOLVED] Fixing XSS ?]

Yes that I understand, but in that case

http://www.domain.com/file/"><marquee><h1>vulnerable

there is no variable posted? or is it simply $_GET['']?

[[SOLVED] Fixing XSS ?]

Hi guys,

Lets say there is a xss vuln in my script at

http://www.domain.com/file/"><marquee><h1>vulnerable

How can I fix it ? I have no trouble with fixing the one that affect a variable ie file.php?var=xxx

But how do I fix the one right at the end of a file like the one up here? I dont get the /">.

 

Thanks in advance!

 

[www.writebush.com]

kk tx Agent, gonna fix this

[www.writebush.com]

how do you fix the path disclosure please?

[www.writebush.com]

Can anyone test www.writebush.com we put it online but im not sure if its secure.

 

See if there is any bugs/sql injection etc.

 

Thanks

[[SOLVED] MATCH / AGAINS non exact match?! (not fulltext error :P)]

Sorry I found it, just had to use boolean but add my own operator ... duh.

 

$sql = "SELECT * FROM Comment WHERE MATCH(CommSubject, CommText, PartCountry, PartCity)  AGAINST ('*".$searchstring."*' IN BOOLEAN MODE) ORDER BY CommDT DESC";

[[SOLVED] MATCH / AGAINS non exact match?! (not fulltext error :P)]

Hey guys,

Im having a litle problem with a query, I was reading about searching in multiple field with non exact match and the query should look like this in FULLTEXT

 

$sql = "SELECT * FROM Comment WHERE MATCH(CommSubject, CommText, PartCountry, PartCity)  AGAINST ('".$searchstring."') ORDER BY CommDT DESC";

 

The thing is I dont want the user to use boolean expression is the look for lets say

Sold

insteed of

Soldier

 

but if I try it with only sold, I get no query result. Does anyone have an idea what is wrong with it ?

 

Thanks in advance.

[How can I create a php login page]

google it 

http://www.google.ca/search?hl=en&q=php+login+page+tutorial&meta=

 

[Php exploit, bug, sql injection tester]

oki I use eral escape all the time to be safe, will look at strip_tags

thanks for your answers!

[Php exploit, bug, sql injection tester]

naw, its not that I need to secure it right now, still in alpha phase. But Id like to know if there is something we can find as a first mesure before betaing it