Hi guys,
In my application I wanna create a function which would create a dynamic query.. It can have any number of select columns, table joins, where clauses, order by clauses... Is there any snippets available or is a best way to do this?
Search found 21 matches
- Thu Jul 14, 2011 5:49 am
- Forum: PHP - Code
- Topic: Dynamic query
- Replies: 0
- Views: 430
- Wed Jun 30, 2010 12:36 am
- Forum: PHP - Code
- Topic: Unable to connect to mysql
- Replies: 6
- Views: 856
Re: Unable to connect to mysql
I'm able to access it via command prompt and also db-visualizer is working fine.
- Tue Jun 29, 2010 8:11 pm
- Forum: PHP - Code
- Topic: Unable to connect to mysql
- Replies: 6
- Views: 856
Re: Unable to connect to mysql
I still get this error Warning: mysql_connect(): [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in F:\Program Files\Apache2.2\htdocs\index.php on line 8 Warning: mysql_connect(): A connection attempt failed because the connected pa...
- Tue Jun 29, 2010 12:40 pm
- Forum: PHP - Code
- Topic: Unable to connect to mysql
- Replies: 6
- Views: 856
Re: Unable to connect to mysql
I have been using wamp till date and now have done separate installations..
Stuck badly.. need some help..
Stuck badly.. need some help..
- Tue Jun 29, 2010 12:30 pm
- Forum: PHP - Code
- Topic: Help with an SQL query [Simple..]
- Replies: 2
- Views: 370
Re: Help with an SQL query [Simple..]
Try this...
Code: Select all
SELECT id,name,email FROM intranet.users
WHERE id in (SELECT userid FROM intranet.users_associatedgroups WHERE groupid={$_POST['groupid']})
- Tue Jun 29, 2010 12:25 pm
- Forum: PHP - Code
- Topic: Unable to connect to mysql
- Replies: 6
- Views: 856
Unable to connect to mysql
I'm trying to connect to mysql from php. But i'm unable to connect. I'm getting all these errors instead.. Warning: mysql_connect(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you ...
- Fri Nov 06, 2009 7:50 am
- Forum: PHP - Code
- Topic: Fetching an xml from an external url
- Replies: 7
- Views: 95
Re: Fetching an xml from an external url
I tried and it didnt work 
- Fri Nov 06, 2009 7:38 am
- Forum: PHP - Code
- Topic: Fetching an xml from an external url
- Replies: 7
- Views: 95
Re: Fetching an xml from an external url
Will that work??? I seriously doubt it
- Fri Nov 06, 2009 7:04 am
- Forum: PHP - Code
- Topic: Fetching an xml from an external url
- Replies: 7
- Views: 95
Fetching an xml from an external url
How to fetch an xml from an external url using php???
- Fri Sep 25, 2009 8:47 am
- Forum: PHP - Code
- Topic: Mailing in php
- Replies: 16
- Views: 1172
Re: Mailing in php
Thanx a lot Mike.
'll install Mercury mail and 'll try it.
Hope everything works fine this time.
'll install Mercury mail and 'll try it.
Hope everything works fine this time.
- Fri Sep 25, 2009 5:43 am
- Forum: PHP - Code
- Topic: Mailing in php
- Replies: 16
- Views: 1172
Re: Mailing in php
I tried echoing before and after $mail->send(). Only the content be4 the call has been printed.
- Fri Sep 25, 2009 5:03 am
- Forum: PHP - Code
- Topic: Mailing in php
- Replies: 16
- Views: 1172
Re: Mailing in php
It was throwing me an error till i had the host as ssl://smtp.gmail.com. But i after i changed the host to smtp.gmail.com. It stopped prompting me with error but i couldn't receive a mail.
- Fri Sep 25, 2009 4:40 am
- Forum: PHP - Code
- Topic: Mailing in php
- Replies: 16
- Views: 1172
Re: Mailing in php
I tried using gmail. class gMailer extends PHPMailer { /** CHANGE THESE AS REQUIRED **/ public $From = "rzphpmailer@gmail.com"; //PUT YOUR ADDRESS HERE public $FromName = "rzphpmailer"; //PUT YOUR NAME HERE public $Password = "***********"; /...
- Fri Sep 25, 2009 4:35 am
- Forum: PHP - Code
- Topic: Mailing in php
- Replies: 16
- Views: 1172
Re: Mailing in php
Valid point.
But nope. I thought apache acts as one.
What am i supposed to do,install a smtp server? IF so, any good suggestions.
But nope. I thought apache acts as one.
What am i supposed to do,install a smtp server? IF so, any good suggestions.
- Fri Sep 25, 2009 4:21 am
- Forum: PHP - Code
- Topic: Can anyone help me!
- Replies: 1
- Views: 106