[PHP-DB] Job : Looking for a php / mysql programmer in or near Birmingham uk.

Hi I am a looking for a php / mysql programmer in, or within reach, of Birmingham UK I have a variety of work including some very interesting and challenging projects. You can work here or from home, or a bit of both. If you are interested email me [EMAIL PROTECTED] or call 0121 242 1473 I wou

Re: [PHP-DB] Remote DB Connection: Pros and Cons?

Hi You would be better off with the database server and php on the same server - both sites. You will find there is significant lag if there is a poor connection between the web and database server, but if you are just accessing web pages and updating data, even with large pages there is not much

[PHP-DB] spell checking and "did you mean?"

Hi All I am looking to check whether a keyword a user has entered already exists in the database I can find exact matches, but I am having trouble with typos. I am looking for something like Google's "did you mean" if you type in a close match. SO if someone types in saet it returns "did you me

RE: [PHP-DB] last record

hi using mysql as you describe is probably the most elegant and efficient way to do it is there a reason for asking php to do it? Peter > -Original Message- > From: neil [mailto:[EMAIL PROTECTED] > Sent: 25 January 2005 03:12 > To: php-db@lists.php.net > Subject: [PHP-DB] last record >

RE: [PHP-DB] i am lost (php warning)

Hi it means that the query did not produce a result - usually this is because of a problem with the query. $sql_query = mysql_query("SELECT * FROM cm_customer WHERE emial='$user'"); I am guessing you misspelt email and this should be $sql_query = mysql_query("SELECT * FROM cm_customer WHERE e

RE: [PHP-DB] Security Question

one know this for sure to be correct? It sure makes sense this way. > > > On Sunday 16 January 2005 07:27 pm, Peter Lovatt wrote: > > Hi > > > > It is better from a security point of view to have a secure login. The > > secure server encrypts the data betwe

RE: [PHP-DB] Security Question

Hi It is better from a security point of view to have a secure login. The secure server encrypts the data between the browser and the server, making it impossible to read on its journey from you to the server. However whether it is a major security problem is another question. To view the tra

RE: [PHP-DB] Help in learning PHP and MySQL

Hi from php 5 onwards mysql is not enabled by default http://www.php.net/manual/en/ref.mysql.php Note: Windows users will need to enable php_mysql.dll inside of php.ini and either copy libmysql.dll into the Windows system directory, or make it available to the PATH. from memory... (To enab

RE: [PHP-DB] Re: HTTP Auth for PHPMyAdmin

set auth type to cookies Peter > -Original Message- > From: Mark Benson [mailto:[EMAIL PROTECTED] > Sent: 22 December 2004 10:55 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: HTTP Auth for PHPMyAdmin > > > Martin Norland wrote: > > >What do you mean proper HTTP authorization for PHPM

RE: [PHP-DB] forgetting to close db connection

gt; Is not disconnecting on every page going to cause any problems? Are > there any other concerns I should consider? > > Matthew > > > Peter Lovatt wrote: > > >You could use JavaScript > > > > > > >onBlur="dataform.submit()"> &

RE: [PHP-DB] save as you type

You could use JavaScript onblur executes when the user leaves the box, and will submit the form HTH Peter > -Original Message- > From: Matthew Perry [mailto:[EMAIL PROTECTED] > Sent: 12 December 2004 05:12 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] save as you type > > > Is there

RE: [PHP-DB] Problem with script

Try echoing the actual query being run. It will give you more info to work with. Peter > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 02 November 2004 16:42 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Problem with script > > > Hi all, greetings from

RE: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

Hi try $db = mysql_connect("localhost", "myuser","mypassword") - without it you are not submitting a password Peter > -Original Message- > From: Christian Schlaefcke [mailto:[EMAIL PROTECTED] > Sent: 24 September 2004 13:31 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Newbie Question

RE: [PHP-DB] Please help

HI try $result = mysql_query($sql . " " . $sql_ext . " limit 0,1") or die("Invalid query".mysql_error()); which will give more detail on the error. HTH Peter > -Original Message- > From: Stuart Felenstein [mailto:[EMAIL PROTECTED] > Sent: 08 September 2004 20:29 > To: [EMAIL PROTEC

RE: [PHP-DB] Webpage response to selection & $_POST

Hi you need to check for $_POST["user1"], $_POST["user2"] etc - is that what you are doing? Your other variables are done as an array - $firstName[$j] etc, should your check box be echo ' ' . "\n"; (note the []) Otherwise try vardump($_POST) to see exactly what is being returned. If

RE: [PHP-DB] Help, i'm really desperated

Hi php runs as the same user as apache. Depending on any other security/system issues you could set apache to run as postgres. Otherwise why not connect to postgres using the php functions and write the text file using php? You might also be able to su to postgres. HTH Peter > -Original

RE: [PHP-DB] How to forward a POSTed form to another server and catch the return for further processing

hi this should do the trick Peter // this is the script to pass the post onto $server_to_post_to = 'http://www.test.com/somescript.php'; $url = parse_url($server_to_post_to); unset($request_data) ; //run through the data POSTed to this server and build a new POST request foreach ($_

RE: [PHP-DB] require function detail with example

Hi assuming you want to check the variable in php you need gettype() http://uk2.php.net/manual/en/function.gettype.php the text box can only be done with javascript combined with an event eg If you need more on the javascript then a specialist javascript list would be better :) Peter

RE: [PHP-DB] Wrong table name - can it be fixed?

Hi using phpMyAdmin enter the following into a sql box ALTER TABLE `16-05` RENAME `newname` ; HTH Peter > -Original Message- > From: Viorel Dragomir [mailto:[EMAIL PROTECTED] > Sent: 17 May 2004 09:54 > To: Martin E. Koss; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Wrong table name - c

RE: [PHP-DB] RE: [tcphp] Hella fun project I'm about to throw at some tech college students

Hi If the reformating is complex - ABVDFR Co is in the middle of the field - then php $bits = explode (" ", $FieldValue ) ; then each element of $bits is a word, making reworking it easier Just my 2p worth :) Peter > -Original Message- > From: Rafi Sheikh [mailto:[EMAIL PROTECTED]

RE: [PHP-DB] The usual problem

Looks OK to me What error do you get ? try $sql = " INSERT INTO underskrifter ( id , type , navn , epost , tid , ip , domain , sted ) VALUES ( '' , '$_POST[type]' , '$_POST[navn]' , '$_POST[epost]' , '$tid' , '$ip' , '$host' , '$_POST[sted]' ); "; mysql_query($sql) or die (mysql_error());

RE: [PHP-DB] converting scripts for register_globals=Off

Hi There are three main types of data passed by the browser - GET POST and COOKIE. php creates an array for each type, so what is $id now would also be $_GET["id"] or $_POST["id"] There is also $_REQUEST which is a combination of $_GET and $_POST so $_REQUEST["id"] will also work. If it were a

RE: [PHP-DB] passing var array

echo $_GET["some_var"] > -Original Message- > From: Sukanto Kho [mailto:[EMAIL PROTECTED] > Sent: 26 April 2004 09:34 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] passing var array > > > Hi, > > How to pass var array to other page? > > I use $_GET but when I echo it, it appear "array".

RE: [PHP-DB] Re: Using $_SESSION array for large number of variables. Any recommendations?

Hi, I would suggest a mysql table for the data. For large amounts it is probably more efficient - not sure how much resource is needed to manage 100K pieces of information using $_SESSION, but an indexed mysql table is probably much quicker. table CREATE TABLE `session_data` ( `userID` VARCHAR(

RE: [PHP-DB] Double Submission into DB if Hit Refresh

Hi Add a hidden field into the form with a unique transaction ID. When the data is submitted first time save the transaction ID to a table. Before you do anything check to see if the transaction ID exists in the table, if not then you are ok to save the transaction ID and then add/update the dat

RE: [PHP-DB] Use of database

Hi only users with the privileges will be able to access those pages. if you are using mysql 3.xx the link wont show for low privilege users (I think !) 4.xx seems to show the links, but you can still only access them if you have the right privileges HTH Peter > -Original Message-

RE: [PHP-DB] MySQL Multi-DB Join

I think as you are specifying the db in the query you dont need to select it. If you do, mysql still uses DBs as specified in the query. Peter > -Original Message- > From: Rod Strumbel [mailto:[EMAIL PROTECTED] > Sent: 18 March 2004 15:14 > To: 'Peter Lovatt&#x

RE: [PHP-DB] MySQL Multi-DB Join

assuming the dtaabases are on the same server $query = " select db1.table1.field from db1.table1, db2.table2 where db1.table1.field1 = db2.table2.field2 " $result = mysql_query($query,$conection) HTH Peter > -Original Message- > From: Rod Strumbel [mailto:[EMAIL PROTECTED] > Sent: 1

RE: [PHP-DB] Question

Hi I think it may be the { and } which are used in php if they are part of the data you are saving then try adding a \ => \{ and \} if not remove them. Peter --- Excellence in internet and open source software --

RE: [PHP-DB] getting font size from browser

php cannot read the sizes directly, but you can use javascript to pass information to php and then use that This is a routine I use to get screen size