Re: [PHP-DB] MySQL two tables and an uneven number of rows

> On Sep 12, 2016, at 2:53 PM, B. Aerts wrote: > > On 12/09/16 05:24, Karl DeSaulniers wrote: >> Hello All, >> Hoping you can help clear my head on this. I have two MySQL tables for >> custom fields data to be stored. >> >> custom_fields

[PHP-DB] Re: MySQL two tables and an uneven number of rows

On 12/09/16 05:24, Karl DeSaulniers wrote: Hello All, Hoping you can help clear my head on this. I have two MySQL tables for custom fields data to be stored. custom_fields custom_fields_meta custom_fields is the info for the actual field displayed in the html and

[PHP-DB] MySQL two tables and an uneven number of rows

Hello All, Hoping you can help clear my head on this. I have two MySQL tables for custom fields data to be stored. custom_fields custom_fields_meta custom_fields is the info for the actual field displayed in the html and custom_fields_meta is the data stored from

Re: [PHP-DB] Any method to get primary key matching a given value ?

Hi Ratin, working with sqlite, are you ? In that case, take a look at the default table : SELECT sql from sqlite_master where type= "table" and name = "" This query returns the creation query of the table concerned. By parsing it textually, you can find out the field name that was declared

Re: [PHP-DB] Any method to get primary key matching a given value ?

This may also shed some light for you. The accepted answer and possibly the one below it if you are on .NET http://stackoverflow.com/questions/763516/information-schema-columns-on-sqlite HTH, Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Aug 20, 2016, at 5:30 AM, Karl

Re: [PHP-DB] Any method to get primary key matching a given value ?

Hey Ratin, Have you looked into the table column named 'pk' inside table_info? That is where a column is indicated to be a primary key or not. Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Aug 18, 2016, at 6:51 PM, Ratin wrote: >

Re: [PHP-DB] Any method to get primary key matching a given value ?

Hi Karl, Thanks a lot for your response, I think INFORMATION_SCHEMA is not available for sqlite database. I had to built up the whole query with php using PRAGMA table_info(tablename), looking at the pk entry, when its 1, get the column name, and then update the sql statement based on that. A bit

Re: [PHP-DB] Any method to get primary key matching a given value ?

Hi Ratin, Going to take a stab at this one. Have you looked into INFORMATION_SCHEMA.COLUMNS for your query? Might be where you want to look for what you are trying. Sorry can't help more. Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Aug 18, 2016, at 1:27 PM, Ratin

[PHP-DB] Any method to get primary key matching a given value ?

I'm writing the generic get that works on different tables having different primary keys but the argument of get is always the primary key , i.e. get request is - get (column name, value) the value is always the primary key value. It looks like it would be a pretty standard method but I cant

Re: [PHP-DB] Connecting to database fails

On Sat, 13 Aug 2016, Lester Caine wrote: Do you actually have the postgresql PHP driver installed. Database drivers are not installed by default as you only really need the ones you are actually using. Should be installed: /usr/lib/php/extensions/pgsql.so

Re: [PHP-DB] Connecting to database fails

On 14/08/16 00:00, Rich Shepard wrote: > Ah, yes. Pat likes MySQL/MariaDB so he does not build php to support > postgres. I'll rebuild it and that should solve the problem. I've been with Firebird/Interbase since before PHP existed ;) -- Lester Caine - G8HFL -

Re: [PHP-DB] Connecting to database fails

On Sat, 13 Aug 2016, Rich Shepard wrote: Not installed. I'll search the Web to learn how to install it. Ah, yes. Pat likes MySQL/MariaDB so he does not build php to support postgres. I'll rebuild it and that should solve the problem. Thanks again, Rich -- PHP Database Mailing List

Re: [PHP-DB] Connecting to database fails

On Sat, 13 Aug 2016, Lester Caine wrote: Do you actually have the postgresql PHP driver installed. Database drivers are not installed by default as you only really need the ones you are actually using. Lester, Well, that would make a difference. I did not know how to check for this.

Re: [PHP-DB] Connecting to database fails

On 13/08/16 21:23, Rich Shepard wrote: > With no other PHP applications installed here I have no experience in > determining where this stoppage occurs. Pointers on how to isolate the > source of the problem, than how to fix it, are needed. Do you actually have the postgresql PHP driver

[PHP-DB] Connecting to database fails

I'm trying to install and run an abandoned PHP-based application (xrms found on sourceforge.net last updated a decade ago) on Slackware-14.1 running httpd-2.4.16, php-5.6.24, adodb-5.14, and postgresql-9.3.4. When I try to load the install.php script in firefox-45.3 I see this error: Syntax

Re: [PHP-DB] weird string literal related problem

nvm, I got my answer -- foreach ( $entries as $column => $value ) will give the column names .. which simplifies my task a lot. On Mon, Aug 1, 2016 at 12:52 PM, Ratin wrote: > Just curious why the values can only be accessed by column names and not > an array subscript, like :

Re: [PHP-DB] weird string literal related problem

Just curious why the values can only be accessed by column names and not an array subscript, like : $i=0; $result = $db->query('select * from DecoderUser'); while ($entries = $result->fetchArray()) { $value=$entries[i]; $i = $i + 1; } On Mon, Aug 1, 2016 at 12:25 PM, Ratin

Re: [PHP-DB] weird string literal related problem

Thanks Aziz, that works. Somehow i thought the ' needed to be included just like you quote all strings on an interactive DB shell or even when you get the value directly by column name. On Mon, Aug 1, 2016 at 11:47 AM, Aziz Saleh wrote: > But if i print

Re: [PHP-DB] weird string literal related problem

But if i print $entries['decoderUserGUID'] I get the correct value This means the key value is decoderUserGUID NOT 'decoderUserGUID', try creating $strIndex without the quotes, just the key value. On Mon, Aug 1, 2016 at 2:31 PM, Ratin wrote: > Hi I am new to this list, not

[PHP-DB] weird string literal related problem

Hi I am new to this list, not sure how active this list is but i have a question regarding php-sqlite integration. I am using a string variable where I put the column name and trying to use that varible to get its value, in a loop. So here is what I have (simplified version): $strIndex='\'' .

[PHP-DB] How to use mysqli with php5.6

Hi, I have installed php5.6 by command "pkg install php-56“ in solaris 11 x64,and I want to use mysqli extension to connect mysql 5.5 database,but I found that I can’t find any mysqli extension.Any one can tell me how to use mysqli extension?Any suggestions should be appreciated!

[PHP-DB] ANN: PHP Generator 16.3 released

Hi! SQL Maestro Group announces the release of PHP Generator 16.3, a family of GUI frontends for Windows that allow you to generate feature-rich CRUD web applications for your databases. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2, SQL Anywhere and

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

Your answer in the part of SAP HANA (J)ODBC driver not supporting named parameters actually makes sense. However I don't understand why would there be a difference between PDO and regular odbc (odbc_connect, etc.) commands since they're obviously using the same driver. My testing machine is on

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

On Jan 26, 2016, at 7:10 AM, Alko Kotalko wrote: > Hi, > > I have a working connection from PHP to SAP HANA through PDO and regular > ODBC commands. > > The issue is that through PDO I can not get any prepared statements to > work. None of the notations (?, $, :) work.

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

Greetings, On 01/26/2016 08:18 AM, Karl DeSaulniers wrote: > On Jan 26, 2016, at 7:10 AM, Alko Kotalko wrote: > >> Hi, >> >> I have a working connection from PHP to SAP HANA through PDO and regular >> ODBC commands. >> [...snipped...] >> >> For example: >> "SELECT *

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

On 26/01/16 13:10, Alko Kotalko wrote: > ODBC commands actually work with the ? and colon ($) notations. But not > with colon (:). I suppose this is due to the lack of named parameters > support in ODBC commands (haven't actually confirmed that though). The $ > notation brings me the closest to

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

I've tried all the notations with PDO as well and none of them work with SAP HANA. It works with MySQL though. So I presume that there is either a bug in PDO driver or there is some mismatch between PDO and SAP HANA. The queries get executed but the returned result (if I fetch one) is an

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

It shouldn't be like that because I'm preparing a statement, which would later have had parameters passed to. I'm not trying to concatenate a string. (Sorry, forgot to reply to all before) On Tue, Jan 26, 2016 at 8:18 AM, Karl DeSaulniers wrote: > On Jan 26, 2016, at 7:10

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

This (my code) actually works so it's not part of the problem. The problem is that I can NOT use the colon notation for named parameters, even though that's my goal :) If I use the colon notation with MySQL (PDO) it works fine. With ODBC and SAP HANA database it doesn't. I have to use either ? or

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

Oh ok, thanks for the clarification. Sorry for the noise. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Jan 26, 2016, at 1:07 PM, Alko Kotalko wrote: > It shouldn't be like that because I'm preparing a statement, which would > later have had

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

On 26/01/16 19:06, Alko Kotalko wrote: > I've tried all the notations with PDO as well and none of them work with > SAP HANA. It works with MySQL though. So I presume that there is either a > bug in PDO driver or there is some mismatch between PDO and SAP HANA. Firebird does not support named

[PHP-DB] PDO and SAP HANA prepared statements issue

Hi, I have a working connection from PHP to SAP HANA through PDO and regular ODBC commands. The issue is that through PDO I can not get any prepared statements to work. None of the notations (?, $, :) work. The response from the server (fetch) gets me empty field values for all selected columns

[PHP-DB] 40 حديث از منتخب براي تدبر و مطالعه

بسم الله الرحمن الرحيم امام صادق (ع)فرمود: کسى که چهل حديث از احاديث ما را حفظ کند خدا او را روز قيامت عالم و فقيه مبعوث کند. اصول کافى جلد 1 ص :62 روايت : 7 1- امام صادق عليه السلام مى‏فرمود: همه علم مردم را در چهار چيز يافتم: اول اينکه پروردگار خود را بشناسى . دوم اينکه بدانى با تو چه

[PHP-DB] Issue using IBM iAccess, ODBC, and PDO

I am unsure if this is an iAccess issue, an ODBC issue, or a PDO issue so I'll likely contact both this and the ODBC mailing list to see what comes of it. Using the iAccess connector and ODBC, with PDO, I am able to insert, update, and delete records without issue. That said, calling

[PHP-DB] ANN: PHP Generator 15.12 released

Hi! SQL Maestro Group announces the release of PHP Generator 15.12, a family of GUI frontends for Windows that allow you to generate feature-rich CRUD web applications for your databases. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2, SQL Anywhere and

[PHP-DB] :جذب نمايندگي فعال در سراسر کشور

جذب نمايندگي فعال در سراسر کشور انواع بسته هاي خلاقيت و رباتيک ويژه کودک و نوجوان انواع بسته ها و قيمتها را در سايت فروشگاه اينترنتي bazareq.com ببينيد سايت اصلي panex.ir جهت اخذ نمايندگي با شماره زير تماس بگيريد جناب آقاي مهندس صدري 09131252855

[PHP-DB] ibase_query - in php 7 is required the "link identifier"?

Hello I'm migrating from PHP 5.2 to PHP 7.0.0 VC14 x64 TS and using Firebird 2.5 on windows >From Manual << ibase_query (PHP 5) ibase_query — Execute a query on an InterBase database Description resource ibase_query ([ resource $link_identifier ], string $query [, int $bind_args ] )

[PHP-DB] Re: Select on Group

On 17/11/15 01:02, Karl DeSaulniers wrote: Hello All, Hoping someone can help me with this query. I want to select some custom fields from my database that are part of a group of custom fields. There are several of these groups. I want to (in one sql statement) grab these fields, all of them

Re: [PHP-DB] Correct Syntax?

make vehicle licence the unique key On 14 Oct 2015 00:28, "Karl DeSaulniers" wrote: > > Quick question. Is this viable in MySQL? > > UNIQUE KEY `Vehicle_Name` (`Vehicle_Make`+`Vehicle_Model`+`Vehicle_Style`+`Vehicle_License`) > > TIA > > Best, > > Karl DeSaulniers > Design

[PHP-DB] Correct Syntax?

Quick question. Is this viable in MySQL? UNIQUE KEY `Vehicle_Name` (`Vehicle_Make`+`Vehicle_Model`+`Vehicle_Style`+`Vehicle_License`) TIA Best, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Correct Syntax?

instead of +, use ",' 2015-10-13 20:21 GMT-03:00 Karl DeSaulniers : > Quick question. Is this viable in MySQL? > > UNIQUE KEY `Vehicle_Name` > (`Vehicle_Make`+`Vehicle_Model`+`Vehicle_Style`+`Vehicle_License`) > > TIA > > Best, > > Karl DeSaulniers > Design Drumm >

Re: [PHP-DB] Zero Values

On Sep 1, 2015, at 10:36 PM, Ethan Rosenberg wrote: > Dear List - > > I have a payment/charges table - > > mysql> describe Charges; > +--+--+--+-+-+---+ > | Field| Type | Null | Key | Default

Re: [PHP-DB] Zero Values

On Sep 2, 2015, at 11:02 PM, Ethan Rosenberg wrote: > Dear list - > > I know that I am making a mistake somewhere. but am lost for an answer. > > mysql> select Payments from Charges where if(Payments, Payments, 0); > +--+ > | Payments | >

Re: [PHP-DB] Zero Values

On 09/01/2015 11:43 PM, Aziz Saleh wrote: On Tue, Sep 1, 2015 at 11:36 PM, Ethan Rosenberg < erosenb...@hygeiabiomedical.com> wrote: Dear List - I have a payment/charges table - mysql> describe Charges; +--+--+--+-+-+---+ | Field| Type

[PHP-DB] Zero Values

Dear List - I have a payment/charges table - mysql> describe Charges; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | Indx |

Re: [PHP-DB] Zero Values

On Tue, Sep 1, 2015 at 11:36 PM, Ethan Rosenberg < erosenb...@hygeiabiomedical.com> wrote: > Dear List - > > I have a payment/charges table - > > mysql> describe Charges; > +--+--+--+-+-+---+ > | Field| Type | Null | Key |

[PHP-DB] تامين امنيت در فضاي مجازي

امنيت در فضاي ديجيتال اين روزها داشتن امنيت در دنياي ديجيتالي مقوله اي بسيار پيچيده است. حفظ و صيانت از اسناد، عکس‌هاي شخصي و فايل‌هاي خصوصي براي اشخاص و همچنين محرمانگي اطلاعات، اسناد و داده هاي سازماني براي شرکت‌ها و سازمان‌ها بسيار حائز اهميت مي‌باشد. به علاوه، در عصر حاضر انجام

[PHP-DB] problems with googlecalender event-insert

Hi I have some problems with the Oauth by inserting a testevent into my Google-Calender. I changed the script for reading from my calendar a little bit and was trying the insert. The old Google-login with email was disabled from Google some time ago and the only way to use the Api is via Oauth.

Re: [PHP-DB] For my understanding

On Sat, Jul 25, 2015 at 9:33 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hello, This might be a question better suited for the general php list. If it is, please let me know. I have inherited some pages that have a code on it I don't recognize. Can anyone enlighten me as to what this

[PHP-DB] For my understanding

Hello, This might be a question better suited for the general php list. If it is, please let me know. I have inherited some pages that have a code on it I don't recognize. Can anyone enlighten me as to what this code is doing? [code] array_walk($Options, create_function('$val', '$val =

Re: [PHP-DB] Grouping results

Well, I figured it out. It took two queries. Probably a better way I'm not thinking about, but this works in case anyone needs/wants. Was hoping to do it all in the SQL statement I guess. $FieldGroups = $wpdb-get_results(SELECT DISTINCT Field_Group FROM .table_name); foreach($FieldGroups as

[PHP-DB] Grouping results

Hello All, How can I group database results in a foreach loop? I have a field_group column that can have a value or not. I want to read from the database then display results and if the results have a matching field_group, I want to have them group in the html. This is my current SQL. I am

Re: [PHP-DB] How Do I Enter a Defect Against PHP ODBC Extension?

https://bugs.php.net/ -- Подпись: (добавляется в конце всех исходящих писем) 2015-07-08 21:25 GMT+03:00 Bruce Bailey brucebailey...@gmail.com: I have discovered a defect in the PHP extension, odbc.so. Specifically the function odbc_fetch_array is not properly handling boolean values from

[PHP-DB] How Do I Enter a Defect Against PHP ODBC Extension?

I have discovered a defect in the PHP extension, odbc.so. Specifically the function odbc_fetch_array is not properly handling boolean values from postgresql on 64bit systems. I'd like to enter a defect, how can I do this? Thanks, Bruce

Fwd: [PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans

systems. Bruce -- Forwarded message -- From: Bastien Koert phps...@gmail.com Date: Mon, Jun 29, 2015 at 7:21 PM Subject: Re: [PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans To: Bruce Bailey brucebailey...@gmail.com, php-db@lists.php.net

[PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans

*Description* The PHP function odbc_fetch_array returns uninitialized values for PostgreSQL boolean values. On older systems, this function returned '1' for true and '0' for false values. On our 64 bit system, the boolean values appear to be uninitialized data. *Additional information*

Re: [PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans

Is it a truly a three state field (true, false, null) or just T/F? Perhaps a default value for the field might be better? On Mon, Jun 29, 2015 at 11:42 AM Bruce Bailey brucebailey...@gmail.com wrote: *Description* The PHP function odbc_fetch_array returns uninitialized values for PostgreSQL

Re: [PHP-DB] Re: سلام دوست من

It's spam message, been sent almost every other day. 2015-06-23 11:06 GMT-04:00 Jim Giner jim.gi...@albanyhandball.com: On 6/2/2015 2:17 PM, Mahsa Ehsani wrote: زمان ثمردهي‌اش گذشته بود و دوره بازنشستگي را طي مي‌كرد. روزگاري طراوت و سرسبزي داشت و كودك و بزرگ از قِبَلِ او مرزوق بودند. اما

[PHP-DB] Re: سلام دوست من

On 6/2/2015 2:17 PM, Mahsa Ehsani wrote: زمان ثمردهي‌اش گذشته بود و دوره بازنشستگي را طي مي‌كرد. روزگاري طراوت و سرسبزي داشت و كودك و بزرگ از قِبَلِ او مرزوق بودند. اما اكنون تمام دلخوشي‌اش اين بود كه پيامبر اعظم ـ صلي­الله­عليه­و­آله ـ چون به ايراد سخن مي‌ايستاد بر او تكيه مي‌كرد و اين براي

[PHP-DB] سلام دوست من

زمان ثمردهي‌اش گذشته بود و دوره بازنشستگي را طي مي‌كرد. روزگاري طراوت و سرسبزي داشت و كودك و بزرگ از قِبَلِ او مرزوق بودند. اما اكنون تمام دلخوشي‌اش اين بود كه پيامبر اعظم ـ صلي­الله­عليه­و­آله ـ چون به ايراد سخن مي‌ايستاد بر او تكيه مي‌كرد و اين براي او از هر افتخاري بالاتر بود. نخل خشكيده‌اي

[PHP-DB] SQL injection

OK - this had no chance of success since publish_date_desc is processed using the _desc ( or _asc ) and any invalid data stripped

Re: [PHP-DB] SQL injection

Date: Sunday, June 21, 2015 12:39:06 PM -0400 From: Aziz Saleh azizsa...@gmail.com On Sun, Jun 21, 2015 at 9:19 AM, Lester Caine les...@lsces.co.uk wrote: OK - this had no chance of success since publish_date_desc is processed using the _desc ( or _asc ) and any invalid data stripped

Re: [PHP-DB] SQL injection

On Sun, Jun 21, 2015 at 9:19 AM, Lester Caine les...@lsces.co.uk wrote: OK - this had no chance of success since publish_date_desc is processed using the _desc ( or _asc ) and any invalid data stripped

Re: [PHP-DB] SQL injection

But what does your application do when it gets an invalid SQL statement? Maybe it is telling the attacker something important about your database so that they can compromise it with the appropriate injection. On 2:36PM, Sun, Jun 21, 2015 Lester Caine les...@lsces.co.uk wrote: On 21/06/15 18:55,

Re: [PHP-DB] SQL injection

On 21/06/15 20:14, Mark Murphy wrote: But what does your application do when it gets an invalid SQL statement? Maybe it is telling the attacker something important about your database so that they can compromise it with the appropriate injection. It just defaults to the first news article in

Re: [PHP-DB] SQL injection

On 21/06/15 18:55, Richard wrote: OK - this had no chance of success since publish_date_desc is processed using the _desc ( or _asc ) and any invalid data stripped sort_mode=publish_date_desc%20or%20(1,2)=(select*from(select%20n

[PHP-DB] php56-mysqli needs dhparam support

Hi, It appears that the php56-mysqli port uses a weak dhparam which is causing SSL connections from PHP mysqli clients to fail when connecting to a FreeBSD MySQL 5.6 server that requires SSL. For example, from my web server I can run mysql from the command line, and am able to connect to the

Re: [PHP-DB] About PDO::fetchObject

Something like this should get you started ?php // NOT TESTED !!! class SimpleMapper { private $metadata = array(); private $stmt; public function __construct(PDOStatement $stmt, array $metadata) { $this-stmt = $stmt; $this-metadata = $metadata; }

Re: [PHP-DB] Fwd: About PDO::fetchObject

On Thu, Jun 11, 2015 at 1:53 AM, Octopus Puras zlk1...@gmail.com wrote: I have a MySQL table, whose name is Items: ItemID ItemName ItemDescription I also have a PHP class: class Item { public $id; public $name; public $description; } If I execute $stmt-fetchObject(), I will get

[PHP-DB] About PDO::fetchObject

I have a MySQL table, whose name is Items: ItemID ItemName ItemDescription I also have a PHP class: class Item { public $id; public $name; public $description; } If I execute $stmt-fetchObject(), I will get an object with fields of ItemID, ItemName, etc. But I want to adapt the name of the

[PHP-DB] Fwd: About PDO::fetchObject

I have a MySQL table, whose name is Items: ItemID ItemName ItemDescription I also have a PHP class: class Item { public $id; public $name; public $description; } If I execute $stmt-fetchObject(), I will get an object with fields of ItemID, ItemName, etc. But I want to adapt the name of the

Re: [PHP-DB] Removing slashes from the database

Ron, If this is a display issue, have you tried running stripslashes($outputstring) on the output from the database? That is the usual way to handle it Bastien On Thu, Jun 4, 2015 at 7:29 AM Ron Piggott ron.pigg...@actsministries.org wrote: On 03/06/15 09:37, Aziz Saleh wrote: On Wed, Jun

Re: [PHP-DB] Removing slashes from the database

On 03/06/15 09:37, Aziz Saleh wrote: On Wed, Jun 3, 2015 at 12:25 AM, Ron Piggott ron.pigg...@actsministries.org mailto:ron.pigg...@actsministries.org wrote: On 02/06/15 23:20, Aziz Saleh wrote: On Tue, Jun 2, 2015 at 11:08 PM, Ron Piggott ron.pigg...@actsministries.org

Re: [PHP-DB] Removing slashes from the database

On Wed, Jun 3, 2015 at 12:25 AM, Ron Piggott ron.pigg...@actsministries.org wrote: On 02/06/15 23:20, Aziz Saleh wrote: On Tue, Jun 2, 2015 at 11:08 PM, Ron Piggott ron.pigg...@actsministries.org wrote: On 02/06/15 22:58, Aziz Saleh wrote: On Tue, Jun 2, 2015 at 10:50 PM, Ron

Re: [PHP-DB] Removing slashes from the database

On 02/06/15 23:20, Aziz Saleh wrote: On Tue, Jun 2, 2015 at 11:08 PM, Ron Piggott ron.pigg...@actsministries.org mailto:ron.pigg...@actsministries.org wrote: On 02/06/15 22:58, Aziz Saleh wrote: On Tue, Jun 2, 2015 at 10:50 PM, Ron Piggott ron.pigg...@actsministries.org

Re: [PHP-DB] Removing slashes from the database

On 02/06/15 22:58, Aziz Saleh wrote: On Tue, Jun 2, 2015 at 10:50 PM, Ron Piggott ron.pigg...@actsministries.org mailto:ron.pigg...@actsministries.org wrote: I am working through the process of removing \'s from the database. I am trying to get this query using a variable

[PHP-DB] Removing slashes from the database

I am working through the process of removing \'s from the database. I am trying to get this query using a variable starting with $query1 =EOF UPDATE `TABLE_NAME` SET `COLUMN_NAME` = REPLACE(REPLACE(REPLACE(`COLUMN_NAME`,'\\\'','\''),'\\\',''),'','\\'); EOF; But when I go to execute

Re: [PHP-DB] Removing slashes from the database

On Tue, Jun 2, 2015 at 10:50 PM, Ron Piggott ron.pigg...@actsministries.org wrote: I am working through the process of removing \'s from the database. I am trying to get this query using a variable starting with $query1 =EOF UPDATE `TABLE_NAME` SET `COLUMN_NAME` =

Re: [PHP-DB] Removing slashes from the database

On Tue, Jun 2, 2015 at 11:08 PM, Ron Piggott ron.pigg...@actsministries.org wrote: On 02/06/15 22:58, Aziz Saleh wrote: On Tue, Jun 2, 2015 at 10:50 PM, Ron Piggott ron.pigg...@actsministries.org wrote: I am working through the process of removing \'s from the database. I am trying

Re: [PHP-DB] SQL Injection

On 16/05/15 10:00, Karl DeSaulniers wrote: That does clarify things a bit better on both the @ question and prepared statements. Thank you for the link as well. So new question.. what is the best type of database to use for someone who wants to start small and grow big? My findings led me

Re: [PHP-DB] SQL Injection

On May 16, 2015, at 8:42 AM, Lester Caine les...@lsces.co.uk wrote: On 16/05/15 10:00, Karl DeSaulniers wrote: That does clarify things a bit better on both the @ question and prepared statements. Thank you for the link as well. So new question.. what is the best type of database to use

Re: [PHP-DB] SQL Injection

On 16/05/15 14:51, Karl DeSaulniers wrote: Interesting. I program in MySQL on a hosting plan by a third party. I have heard/read MySQL is not an enterprise solution, but for the basic business with say less than 100,000 customers, it does the job and well. Larger than that I had hear Postgres

Re: [PHP-DB] SQL Injection

On 15/05/15 06:21, Karl DeSaulniers wrote: Oh ok. Now it makes a little more sense. I have worked in ASP before, but I am programming in PHP and MySQL at the moment. I am going to look into Prepared Statements. Thanks for your feedback. Just to clarify things a little here and explain

Re: [PHP-DB] SQL Injection

On May 16, 2015, at 3:51 AM, Lester Caine les...@lsces.co.uk wrote: On 15/05/15 06:21, Karl DeSaulniers wrote: Oh ok. Now it makes a little more sense. I have worked in ASP before, but I am programming in PHP and MySQL at the moment. I am going to look into Prepared Statements. Thanks

Re: [PHP-DB] SQL Injection

On 15.05.2015 07:21, Karl DeSaulniers wrote: On May 14, 2015, at 11:11 PM, Onatawahtaw onatawah...@yahoo.ca wrote: Hi Karl, If you look at the link you provided you'll notice that some of the code is for ASP.net and some is for PHP. I have looked in the link. Most problems by inject an

Re: [PHP-DB] SQL Injection

-Kevin Waddell Proverbs 3:5-6 On Fri, 5/15/15, Ruprecht Helms rhe...@rheynmail.de wrote: Subject: Re: [PHP-DB] SQL Injection To: php-db@lists.php.net Date: Friday, May 15, 2015, 10:16 AM On 15.05.2015 07:21, Karl DeSaulniers wrote: On May

[PHP-DB] SQL Injection

Hello Everyone, Have a quick question. Was reading some material and wanted some Players perspective. I know w3schools is not the de-facto on everything, so I wanted to know how reliable is the information on this page. http://www.w3schools.com/sql/sql_injection.asp Namely the @ symbol before

Re: [PHP-DB] SQL Injection

On Thu, May 14, 2015 at 9:05 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hello Everyone, Have a quick question. Was reading some material and wanted some Players perspective. I know w3schools is not the de-facto on everything, so I wanted to know how reliable is the information on this

Re: [PHP-DB] SQL Injection

On May 14, 2015, at 8:09 PM, Aziz Saleh azizsa...@gmail.com wrote: On Thu, May 14, 2015 at 9:05 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hello Everyone, Have a quick question. Was reading some material and wanted some Players perspective. I know w3schools is not the de-facto

Re: [PHP-DB] SQL Injection

On 15/05/14 18:19 , Karl DeSaulniers wrote: On May 14, 2015, at 8:09 PM, Aziz Saleh azizsa...@gmail.com wrote: On Thu, May 14, 2015 at 9:05 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hello Everyone, Have a quick question. Was reading some material and wanted some Players perspective.

Re: [PHP-DB] SQL Injection

On May 14, 2015, at 8:37 PM, Jigme Datse Yli-Rasku jigme.da...@gmail.com wrote: On 15/05/14 18:19 , Karl DeSaulniers wrote: On May 14, 2015, at 8:09 PM, Aziz Saleh azizsa...@gmail.com wrote: On Thu, May 14, 2015 at 9:05 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hello Everyone,

Re: [PHP-DB] SQL Injection

On May 14, 2015, at 11:11 PM, Onatawahtaw onatawah...@yahoo.ca wrote: Hi Karl, If you look at the link you provided you'll notice that some of the code is for ASP.net and some is for PHP. What of the two are you programming in? If you are programming in ASP.net you are asking your

Re: [PHP-DB] SQL Injection

Hi Karl, If you look at the link you provided you'll notice that some of the code is for ASP.net and some is for PHP. What of the two are you programming in? If you are programming in ASP.net you are asking your question to the wrong mailing list as this list is for PHP. If you are programming

Re: [PHP-DB] Input Mathematical symbol in HTML textbox

#94; is the caret in ascii Best, Karl Sent from losPhone On May 7, 2015, at 9:18 AM, Guru nagendra802...@gmail.com wrote: Hi All, I need help with a tool I am developing for my client. What I want is, how can I type X^2 square or M Cube (M^3) in html text box. Is there any method I can

[PHP-DB] Input Mathematical symbol in HTML textbox

Hi All, I need help with a tool I am developing for my client. What I want is, how can I type X^2 square or M Cube (M^3) in html text box. Is there any method I can follow. Also it should store in mysql database in same format. If I echo out the same variable it should print the same format.

[PHP-DB] Re: Input Mathematical symbol in HTML textbox

Use the sup tag? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] php x64 VC11 ThreadSafe (experimental) and Firebird x64 support (on windows x64)

dear members php x64 VC11 (experimental) does not yet support x64 firebird? When it will support? environment Windows Server 2012 R2 Datacenter x64 = OK Firebird 2.5.4 x64 = OK Apache Lounge 2.4.12 VC11 x64 = OK PHP 5.6.8 VC11 x64 = OK In the php.ini file extension=php_interbase.dll and

Re: [PHP-DB] Re: [PHP-WIN] Need Help with 2 MYSQL Table

Combine them in SQL and loop through the dataset select c.*, cd.* from customers c inner join customer_details cd on c.id = cd.customer_id [where clause as needed] loop thru the recordset from that query just as you would with a query from a single table and link the id to the edit page while

[PHP-DB] Re: [PHP-WIN] Need Help with 2 MYSQL Table

On 25 April 2015 at 06:13, Guru nagendra802...@gmail.com wrote: Hi All, Hope everyone is doing well. I need some help regarding a project. I have a huge list of customers in a ledger in a mysql table (Table A). And in another table I have their names and their ID number (Table B). What I

[PHP-DB] Need Help with 2 MYSQL Table

Hi All, Hope everyone is doing well. I need some help regarding a project. I have a huge list of customers in a ledger in a mysql table (Table A). And in another table I have their names and their ID number (Table B). What I want is when I click on a customer name from Table A, I want php to

<    1   2   3   4   5   6   7   8   9   10   >