FW: Help keep the Internet free -- MySQL petition to EU

-----Original Message----- From: Michael Widenius [mailto:monty@askmonty.org] Sent: Tuesday, December 29, 2009 5:00 AM To: mysql@lists.mysql.com Subject: Help keep the Internet free Hi! We have just launched a worldwide, multilingual petition at http://helpmysql.org to get signatures to show the regulators in the EU and other places that it's important that MySQL continues to be available and developed as a strong Open Source product for all database needs. If you care about the future of MySQL as an Open Source product, please go and sign the petition and tell others abou

Displaying Password

--Apple-Mail-2--316273016 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=WINDOWS-1252; delsp=yes; format=flowed Never mind. Got it. $replaceArray =3D array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', =20 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', =20= 'x', 'y', 'z', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0'); $replaceWith =3D array=20 ('=95','=95','=95','=95','=95','=95','=95','=95','=95','=95','=95','=95','= =95','=95','=95','=95','=95','=95'=20 ,'=95','=95','=95','=95','=95','=95','=95','=95','=95','=95'

Trying to make site map

I am trying to create a ui for a page management script. During this step the user chooses which existing page the new page will link under. Each record has a field called Page_Above, which references the primary key number (id) of the page above it. Currently I have 4 records in the database: (id, name, Page_Above) 1, Page1, 0 2, Page2, 1 3, Page3, 2 4, Page4, 1 Here is the pertinent snippet: include "config.php"; $conn = mysql_connect($server, $DBusername, $DBpassword); mysql_select_db($database,$conn); $sql = "SELECT * FROM $Gen WHERE Category =

object return [object XMLDocument] instead of xml data

--0016e6d58f7ff08801047b389aa0 Content-Type: text/plain; charset=ISO-8859-1 Hi All I am working on a application in which i need to pass data in API and api return me xml data when i am passing data the out put is coming *[object XMLDocument]* if i am calling it at browser its showing correct xml. Can any one please tell me what may be problem. -- Regards Yogendra Kaushik --0016e6d58f7ff08801047b389aa0--

Redirect upon successful form submission

--0016e64ee34c39a97a047ac7fef5 Content-Type: text/plain; charset=ISO-8859-1 Hi, I have 2 pages on php, the first page has a small form to accept a membership number from the user, which checks for membership number in the DB, if the membership no does not exist, gives an error saying 'you are not a member click here to become a member now', this bit works fine. The problem is the following bit 'if the user is a member, i want the user to be directed to another page. this is what i did to get the result since header("Location:....") wont work, as already the form has been prin

EZPDO Replacement

One of our programmers had done a fair amount of coding using the EZPDO ORM library and it is no longer supported, Does anyone have any experience migrating from EZPDO to another ORM library. Any recommendations?, Thanks in advance for your help.

Mysql query

The query from my previous post was only part of a larger query. This is the entire query: SELECT GREATEST( IF( CURDATE( ) >= DATE_SUB( DATE( FROM_UNIXTIME( 1239508800 ) ) , INTERVAL LEAST( 14, ( SELECT COUNT( * ) FROM `verse_of_the_day_Bible_verses` WHERE seasonal_use =1 ) ) DAY ) AND CURDATE( ) <= DATE( FROM_UNIXTIME( 1239508800 ) ) , 1, 0 ) , IF( CURDATE( ) >= DATE_SUB( DATE( 2009 -12 -25 ) , INTERVAL LEAST( 14, ( SELECT COUNT( * ) FROM `verse_of_the_day_Bible_verses` WHERE seasonal_use =2 ) ) DAY ) AND CURDATE( ) <= DATE( 2009 -12 -25 ) , 2, 0 ) ) AS verse_applicatio

Multiple MySQL schemas

Hi all. We are wanting to create an app that contains multiple clients. Each = clients has anywhere from 1 user to more than a hundred. We had the idea = of separating each client into its own database schema. This reduces the = single point of failure - if 1 client db dies, it doesn't kill the = others. This keeps the individual schemas smaller, which will allow us = to asynchronously (for lack of a better word) transfer our backups to = our network w/o causing bottlenecks. It also guarantees the separation = of data (even though the application takes care of this, it's *that = ext

mySQL query syntax error

I am getting the following error message: #1054 - Unknown column 'customers.email' in 'order clause' from the query below --- I don't understand why. Would someone help me please? Ron SELECT 'first_name', 'last_name', 'email' FROM ( ( SELECT `firstname` , `lastname` , `buyer_email` FROM `paypal_payment_info` WHERE `datecreation` = '$two_weeks_ago' GROUP BY `buyer_email` ) UNION ALL ( SELECT `mail_order_address`.`first_name` , `mail_order_address`.`last_name` , `mail_order_address`.`email` FROM `mail_order_address` INNER JOIN `mail_order_payment` ON `mail_

Multiple instances of mysql_connect() in single PHP document.

Hello, Is it wrong to have mysql_connect() called twice within a single PHP document, such as this? I have been running into some fairly annoying query failures that commute when I change the order of these two blocks of code. I am currently working around this by repeatedly using mysql_select_db() to change the databases as I am needing to change to a different database. To be more specific, I can use the $db_material handle in doing a query, but it will always try to search in the Labor_Log table and thus fail because the tables have different and names. Swapping these bloc

PHP Update query

--=-nC6baOS/wqkoA6Q4gGZA Content-Type: text/plain Content-Transfer-Encoding: 7bit How do I test if an UPDATE query worked $query = "UPDATE `clients` SET `company` = '$company', `contact` = '$contact', `phone` = '$phone', `city` = '$city' WHERE `clients`.`reference` =$client LIMIT 1"; $client_result=mysql_query($query); ??? Ron --=-nC6baOS/wqkoA6Q4gGZA--

Re: [PHP-DB] How to: Include identifier with a query

I looked into this years ago for something I was doing, but don't remember looking for a solution in MySQL. Just wanted to share that.. um.. I think it was with MS SQL Server.. there was a way to put a tag in your DSN connection string that would show up on the process list. I don't know if that helps, but just to add to the list of "how *some* people do it". Good luck! -TG ----- Original Message ----- From: listread <listread@cze.com> To: php-db@lists.php.net Date: Mon, 02 Nov 2009 07:16:23 -0600 Subject: [PHP-DB] How to: Include identifier with a query > Greetings

Search function query

--=-QBTrAoXxEgBscmmv8ocu Content-Type: text/plain Content-Transfer-Encoding: 7bit I am writing a search function. Is there a way to enhance this query so it will display the best matches first down to the least matches? As well I don't know how to handle if the user types in more than 1 word to search. SELECT * FROM `store_product_profile` WHERE `product_name` LIKE '% $search_string%' AND `product_description` LIKE '%$search_string%' AND `keywords` LIKE '%$search_string%' Ron --=-QBTrAoXxEgBscmmv8ocu--

Showing search results with links

--0-1338178994-1256855364=:52036 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi there i`got this php script that shows results when the user type letter= s in a searchbox, stretching the results every time the user enters a new l= etter. But i would like every result shown, to have a link to a specific ht= ml page, how can i do that. I mean i am using a small guestbook example tha= t i found there, that uses mysql php ajax to do the job of polling the resu= lts out of the mysql database, but i have to implement this with a very lar= ge databas

DB interface problem

I started having trouble with a DBI interface to my PostgreSQL database after I built a new Ubuntu machine. The Postgres version is 8.3 and the DBI was written several years ago (by someone else). I'm using PHP version 5.2.6-3ubuntu4.2 with apache2. The problem is that I get the error: Warning: pg_num_rows(): supplied argument is not a valid PostgreSQL result resource in /var/www/lib/dbi_pgsql.php on line 202 I don't know what to check next to figure out why this is happening. Here is what I have done so far: - Updated the old PHP commands in the dbi file to reflect new ones

UPDATE lot of registers

------=_NextPart_000_001A_01CA50B5.E07A6220 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello everyone=85 =20 I dont know how to update a lot of registers on one table. =20 I have two tables: Students and Signatures =20 STUDENTS has got: id / name / signature SIGNATURES has got: id / name / classroom =20 I want to use words and not numbers to write the signature on the = STUDENTS table. I=92ve got a long list with signatures, and I must to change one = signature... How do I do update SIGNATURE AND STUDENTS

Search

Hello I=92m using this code to a search: $sql =3D "SELECT empresas.id, empresas.nombre, rubros.id, rubros.nombre, cupones.empresa, cupones.rubro, cupones.titulo, cupones.descripcion FROM cupones INNER JOIN empresas INNER JOIN rubros ON (empresas.id =3D cupones.empresa OR rubros.id =3D cupones.rubro) WHERE (empresas.nombre = LIKE '%$_GET[busqueda]%' OR rubros.nombre LIKE '%$_GET[busqueda]%' OR cupones.titulo LIKE '%$_GET[busqueda]%' OR cupones.descripcion LIKE '%$_GET[busqueda]%')"; I have a input text with name =93clave=94. I have three tables: empresas, rubros anda cupones. Th

DATETIME

------_=_NextPart_1150_00027350.00012052 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi All, I have a DB that is storing the date/time an event happens in DATETIME form= at, i.e. 1254252889, which translates to Tue, 29 Sep 2009 19:34:49 UTC I am trying to write a query in PHP that will look for any row that falls w= ithin a range of dates, i.e. between Sep 1 and Oct 1, but there doesn't see= m to be a way to search, since you would never be able to specify a match b= etween what date range you put in, and the time stamps??

How exactly do I get UTF-8 data into SQL Server on Windows via ODBC SQL Native Client 10.0?

Hi. I'm trying to get data into an MS SQL Server 2005 database. The data is coming to me as UTF-8 encoded data. The data is primarily European languages (so I've got a few accented characters), but I know I've got Korean, Vietnamese and some Japanese coming later. I'm using PHP 5.3.2-dev. The SQL Server is 2005 and the ODBC driver I'm using is SQL Native Client 10.0 I've cut'n'pasted my table and SP below... I'm calling the SP (all the phone numbers have been edited) ... EXEC PhoneBilling.dbo.usp_HandleDirectory @s_PhoneNumber =3D 'nnnnnnnnn', @s_Recipient =3D N'Ve

Sorting MYSQL results Paging and column heads

Hi All, I am working on a PHP page to display results from a MySQL db and I am havi= ng a problem getting my results to page properly. When the page loads, it looks fine, but hitting next/previous does not chan= ge the data? Any thoughts appreciated - Edward Ebrooathealthydirectionsdotcom <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.= w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns=3D"http://www.w3.org/1999/xhtml"> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Du= tf-8" /> <titl

PDO and PostgreSQL - RAISE NOTICE

Hi ! I'm new on this mailling list, so i don't realy know if you know the response and if it is realy here that I have to ask my question :-) I'm working with PostgreSQL (8.3 form sources) and PDO (PHP 5.2.10 from sources). In a Postgres function, I have a "RAISE NOTICE" command. My function works like that in console: => SELECT * FROM public.test_info(); NOTICE: An information... test_info ------------ ok (1 line) There's a NOTICE, like I want ! :-) But, when i'm using PDO, I don't know how I can get this NOTICE, which will provide me some informations about the usag

Potential changes for the OCI8 extension for Oracle 11.2

Now that Oracle Database 11.2 has been released (http://blogs.oracle.com/opal/2009/09/oracle_database_11gr2_enhancem.html), we'd like to make some enhancements to PHP OCI8 for PHP 5.3.2 & PHP 6: 1. Allow the oci_set_prefetch() count to be 0, i.e. just fetch/buffer one row at a time and don't prefetch any extra rows. Passing REF CURSORS back and forth between PL/SQL and PHP is one case where you might not want any extra rows prefetched. 2. Add a few oci_set_* functions to set database "attributes" including the new EDITION (useful for application upgrading, h

Parse error

The following code gives me this error message: Parse error: syntax error, unexpected ':' in /home/thev4173/public_html/test.php on line 8 It is referencing the : that follows EasterDate (and will eventually get mad at ChristmasDate) mysql_connect('localhost',$username,$password); @mysql_select_db($database) or die( "Unable to select database"); IF(CURDATE() >= DATE_SUB(CONCAT(@EasterDate := DATE(FROM_UNIXTIME(easter_date(date('Y'))), INTERVAL LEAST(14, (SELECT COUNT(*) FROM `verse_of_the_day_Bible_verses` WHERE seasonal_use = 1)) DAYS) AND CURDATE() <= @EasterDate, 1, 0)

more than one mail separate with comma or space insert one register for each mail

------=_NextPart_000_0031_01CA3C4C.8A63D560 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello=85 =20 I must do a form with only one input text. In this the client want to write more than one mail, separte with comma = or white space. But each mail must be a register in the table in the data base. How do I do this? =20 + = _ // Emiliano Boragina _ // Dise=F1o & Comunicaci=F3n ////////////////// +

Local version of php/mysql site

--000e0cd25d2292250604741da42c Content-Type: text/plain; charset=ISO-8859-1 Hi all, I've developed a web site where users complete a web form which pushes their data into a MySQL database. At the back end they can run reports of their input from this database. At the high end, users enter input into the form a few hundred times a day. Our site has about 99% uptime, but users have been asking for the development of a local version for them to use during the 1% downtime. Basically, I need to recreate the form so that upon submission is writes the data to a file on the users machine,

for laptop

--0-1601832619-1253347138=:83041 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi/AOA i hope all of you are fine. i have lost my laptop and now i want to buy laptop new or second hand. i li= ve in belgium. anyone can suggest me good but cheapest laptop either buy vi= a internet or in belgium via shop waiting for swift response Asim Jamil =A0 =A0 PRAY FOR WHOLE MUSLIM UMMAH AND ASK HELP FROM ALLAH A= ND HAZRAT MUHAMMAD (SAW) =A0 ALLAH HAFIZ=0A=0A=0A --0-1601832619-1253347138=:83041--

Need PHP developers in Hyderabad

--000e0ce0ee1c6424d10473a1c57e Content-Type: text/plain; charset=ISO-8859-1 Hi All, I need some PHP-mysql developer who lives or can work in Hyderabad. Please contact me ASAP. You can mail me back or you can call me on my cell:9949817253. Best, -- Guru Prasad Ubuntu Voice GTK+ Forum --000e0ce0ee1c6424d10473a1c57e--

recover values independently of GET or POST used

I am using some expressions to load the value of a parameter when called, independently if used GET or POST method, using something like: <?php $mydata = (isset($_GET["mydata"])) ? $_GET["mydata"] : (isset($_POST["mydata"])) ? $_POST["mydata"] : 0; echo $mydata; ?> The problem occurs with above code if I call it like: thispage.php?mydata=something , the answer is null (not even '0'). But If I change it to: $mydata = (isset($_POST["mydata"])) ? $_POST["mydata"] : (isset($_GET["mydata"])) ? $_GET["mydata"] : 0; It works, but only with GET method, not post.

PgSql PDO

I am not able to get this working... 1. pdo_pgsql.so exists in the extensions directory and is referenced in the ini file. 2. phpinfo() shows that support for both pgsql and pdo_pgsql is enabled. 3. PDO::getAvailableDrivers() lists pgsql as avilable driver. 4. I am able to connect via pgsql_connect() pdo_pgsql::_construct() is throwing an PDO_Exception "could not find driver" am I missing something here ? pls help