8,966 Posted Topics

Member Avatar for mmcdonald
Member Avatar for logicaweb
Member Avatar for Sanchixx
Member Avatar for almostbob
0
309
Member Avatar for abhisek.bharadwaz
Member Avatar for pritaeas

Below is a documented code example showing how to use the [MySQLi](http://php.net/manual/en/book.mysqli.php) (MySQL improved) classes/objects to connect and query your database (and check for errors). If there are any questions, or you want to see different features, let me know.

5
4K
Member Avatar for dinhunzvi

AFAIK MSSQL does not support ENUM's. What you can do is create a table for the values, and use a FK instead.

Member Avatar for BitBlt
0
208
Member Avatar for LastMitch

Change line 3 to: $radius = isset($_GET['radius']) ? (float)$_GET['radius'] : 0;

Member Avatar for LastMitch
2
197
Member Avatar for pritaeas

Below is a documented code example showing how to use the [MySQL functions](http://php.net/manual/en/book.mysql.php) to connect and query your database (and check for errors). Please note that using the MySQL extension is **NOT RECOMMENDED**. This extension is no longer maintained and will be deprecated soon. If you want your scripts to …

3
865
Member Avatar for visham
Member Avatar for adam321

> The connection name 'ConnectionString' was not found in the applications configuration or the connection string is empty. Add the correct connection string for your database to the config file.

Member Avatar for JorgeM
0
257
Member Avatar for BadManSam
Re: Logs

I can recommend [log4php](http://logging.apache.org/log4php/). Makes it easy to swap to database, if you change your mind.

Member Avatar for retrax57
0
106
Member Avatar for eburlea

What local server are you using (XAMPP, WAMPServer)? Is it set to be publicly accessible? Perhaps the firewall on your computer does not allow incoming connections. Did you try the computer's IP address, did you try the computer's network name ? Give more information, as you can see, it can …

Member Avatar for AndreRet
0
643
Member Avatar for varun004
Member Avatar for vivekanandaan

Are you sure you uploaded all files (including the binaries) ? Follow the guidelines in the error, and turn custom error reporting off. If you do, you'll get a decent exception.

Member Avatar for JorgeM
0
194
Member Avatar for garyjohnson
Member Avatar for pritaeas
0
106
Member Avatar for onofej

> it does not give error message to prompt the user to enter it again That is up to you. You should redirect back to the page and make a nice prompt. Personally, I'd go with the date picker, much less chance of trouble.

Member Avatar for diafol
0
6K
Member Avatar for mmcdonald

Since you marked this solved, any chance you will share your solution to help out others?

Member Avatar for pritaeas
0
195
Member Avatar for ericjw316

Check the Javascript forum. There are several threads on the subject. It is not possible using PHP only, AJAX is required.

Member Avatar for dcdruck
0
192
Member Avatar for Rizi004

You can use DATEDIFF in your query. That would eliminate the need for the isExpired column.

Member Avatar for pritaeas
0
70
Member Avatar for makibao

You did not show the message you got, so I'll guess `$name=$_POST['search'];` does not have a value set. The best way is to use the following construct: $name = isset($_POST['search']) ? $_POST['search'] : '';

Member Avatar for pritaeas
0
776
Member Avatar for heshanm

Bukhari is right. Try that to see if it works, just substitute the variables. Perhaps there are just no results. Anyway, it would be difficult to advise on your query without your table structure and any sample data.

Member Avatar for smantscheff
0
224
Member Avatar for Levizer

Inspect what kind of class/object `SQL.Query` returns. It must be enumerable to be able to use foreach.

Member Avatar for pritaeas
0
115
Member Avatar for zatix16
Member Avatar for daniel36

Imagick is for manipulating images, not PDF's. You'll need to search a PDF tool that does what you want.

Member Avatar for pritaeas
0
112
Member Avatar for manaila

Content length should always match the amount of data you send. If it is shorter, you'll miss data, if it is longer then the receiver may wait for data that will never be sent.

Member Avatar for pritaeas
0
141
Member Avatar for DelphiGuy

You probably need to do the downloading in a separate thread, so the main thread (which displays the icon) is not blocked by it (or use a different asynchronous method of downloading).

Member Avatar for pritaeas
0
501
Member Avatar for pritaeas

Recently bought "Regular Expressions Cookbook 2nd ed." and wanted to share my findings. The book is divided into two parts. The first part (3 chapters) describes tools, skills and programming. The tools chapter shows you what's out there (including his own software). The skills chapter is a tutorial. It describes …

Member Avatar for pritaeas
1
251
Member Avatar for prisacariualex

Apparently `SHOW TABLES` fails, you may not have permission to execute that query, but it could be that the credentials are incorrect. Add some error checking, to find out where the problem is.

Member Avatar for prisacariualex
0
186
Member Avatar for extjac

MVC is an architecture, while PDO is a database class. You can move to MVC and use PDO. They are not mutually exclusive.

Member Avatar for jkon
0
198
Member Avatar for nada_fateha

If I remember correctly, Amazon has an API you can use to retrieve product information. Check their website.

Member Avatar for Stefano Mtangoo
0
1K
Member Avatar for MMadhavi

http://www.daniweb.com/web-development/javascript-dhtml-ajax/threads/429805/populate-dropdown-with-ajax-php-html

Member Avatar for rpv_sen
0
439
Member Avatar for Lynne Good

What does this do ? <select name="header"> <?php foreach(options_typography_get_google_fonts() as $face2) { echo "<option "; if ($_SESSION['header'] == $face2) echo ' selected="selected"'; echo ">$face2</option>"; } ?> </select>

Member Avatar for Lynne Good
0
294
Member Avatar for pritaeas

Just noticed that I was no longer logged in in IE9 after a period of doing nothing, but having the website open? Did something change? I don't store cookies or history or whatever, but this never happened before.

Member Avatar for pritaeas
0
109
Member Avatar for garyjohnson

If you are looking for just color schemes (and play around with them), have a look at the Adobe Kuler website.

Member Avatar for JorgeM
0
161
Member Avatar for oksam

I think you should use only line 5. It looks correct, what problem do you have with it? But if you add it after the one you mentioned first (the one that works), then possibly this new one never gets triggered.

Member Avatar for pritaeas
0
155
Member Avatar for kshahnazari

`^` indicates the start of a string, `$` indicates the end. You can [read more about anchors here](http://www.regular-expressions.info/anchors.html).

Member Avatar for kshahnazari
0
176
Member Avatar for phpHelp

You need a (partial) Javascript solution. I've removed your previous thread. Please do not cross-post again.

Member Avatar for pritaeas
0
141
Member Avatar for sanjeewa.abeywardana
Member Avatar for sanjeewa.abeywardana
0
120
Member Avatar for abhi287

Do not reply to old threads with a new problem, start a new thread. When you do, use code tags to highlight your source (and highlight the offending line).

Member Avatar for aj4mq
0
565
Member Avatar for Tko_1
Member Avatar for Tko_1
0
116
Member Avatar for bo0ga

An ASP.NET web application does not use messageboxes. That is something for a WinForms or WCF application.

Member Avatar for hollystyles
0
167
Member Avatar for andyy121

Line 16 and 21 still have single quotes around keywords and description. Change them to backticks.

Member Avatar for LastMitch
0
269
Member Avatar for harsha.netpem
Member Avatar for dwlamb

Can you show what the output should be? And what tool are you using to for the replacements? Something like `/UNUSED([^,{]+)/` could work.

Member Avatar for dwlamb
0
118
Member Avatar for HunainHafeez

Sure you can. If your user has access to both databases then you can just use a query (after creating the same table on the other database). If you don't, just make a backup with SSMS and restore it on the other database. Simplest way is probably in SSMS, right …

Member Avatar for HunainHafeez
0
146
Member Avatar for GazzaCurran
Member Avatar for broj1
0
139
Member Avatar for HunainHafeez
Member Avatar for nitin1

If you had read the [Member Rules](http://www.daniweb.com/community/rules) you would have known. In your case the "Keep It Organized" rule: "Do not post the same question multiple times".

Member Avatar for nitin1
0
371
Member Avatar for satia

Can you provide some more information about what you are looking for?

Member Avatar for pritaeas
0
59
Member Avatar for Elmo_loves_you

The End.