Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by gandalf458
-
Cannot get php to parse
If you have both Apache and IIS running there may well be some conflict between to two. I'm not a number, I'm a free man- gandalf458
- Post #2
- Forum: PHP
-
HTML LINK ON IPHONE
Not sure how this relates to PHP? I'm not a number, I'm a free man- gandalf458
- Post #2
- Forum: PHP
-
Trying to find is a null is True False
The mysql_* functions were deprecated some years ago and don't even exist in the latest version of PHP. It is better to use mysqli_* or PDO. I'm not a number, I'm a free man- gandalf458
- Post #3
- Forum: PHP
-
Newbie Python (CGI) question
Hi Feheke That's just the kind of feedback I was hoping for. Many thanks I'm not a number, I'm a free man- gandalf458
- Post #3
- Forum: Python
-
Migrate website from PHP 5.3 to 5.5
There's a migration guide at http://php.net/migration55 for upgrading 5.4 to 5.5 and another for upgrading 5.3 to 5.4. These may help you find what to look for. I'm not a number, I'm a free man- gandalf458
- Post #3
- Forum: PHP
-
Newbie Python (CGI) question
Hi. I'm new to Python, trying to teach myself. I have the following script which works fine but I'm wondering if there are better ways of doing some things. print("Content-type:text/html\r\n") import cgi, cgitb form = cgi.FieldStorage() # Get data from form fields # text fields tname =...- gandalf458
- Thread
- Replies: 2
- Forum: Python
-
SELECT single record
Many thanks for explaining. I'm not a number, I'm a free man- gandalf458
- Post #6
- Forum: PHP
-
SELECT single record
Thanks for your reply. Is using fethcAll() and a foreach loop really more efficient than fetch() and no foreach loop? It sounds counter-intuitive. I'm not a number, I'm a free man- gandalf458
- Post #4
- Forum: PHP
-
SELECT single record
Okay. Dimwit that I am, this seems to do the job: $query = 'SELECT * FROM talks WHERE id=:id;'; $stmt = $db->prepare($query); $stmt->bindValue(':id', $id); $stmt->execute(); $result = $stmt->fetch(); $address = $result['address']; $num_views = $result['num_views']; I'm not a number, I'm a...- gandalf458
- Post #2
- Forum: PHP
-
SELECT single record
I'm using SQLite and I have the following to get a single record: $query = 'SELECT * FROM talks WHERE id=:id;'; $stmt = $db->prepare($query); $stmt->bindValue(':id', $id); $stmt->execute(); $result = $stmt->fetchAll(); foreach ( $result as $row ) { $address = $row['address']; $num_views =...- gandalf458
- Thread
- Replies: 5
- Forum: PHP
-
Resizing image with same aspect ratio
Thanks spamjim. I'm not a number, I'm a free man- gandalf458
- Post #4
- Forum: PHP
-
Resizing image with same aspect ratio
I have a script that uploads and if necessary resizes an image. It works fine except that if the uploaded image is not the same aspect ratio as the source image it gets distorted. Can anyone help me work out what I need to add to change the aspect ratio please? $image =...- gandalf458
- Thread
- Replies: 3
- Forum: PHP
-
SQLite count rows in table
Great - many thanks. I'm not a number, I'm a free man- gandalf458
- Post #5
- Forum: PHP
-
SQLite count rows in table
I've tried $query = 'SELECT count(*) FROM talks;'; $result = $db->query($query); which I assume is much the same thing? But then I need to get the value out of $result! I'm not a number, I'm a free man- gandalf458
- Post #3
- Forum: PHP
-
SQLite count rows in table
I simply want to count the number of rows in a table. I have: $query = 'SELECT count(*) FROM talks;'; but then how do I get the result of the select? I'm using PDO. Thanks- gandalf458
- Thread
- Replies: 4
- Forum: PHP
