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
wrote:
> *Description*
>
> The PHP function odbc_fetch_array returns uninitialized values for
> PostgreSQL boolean values. On o
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
wrote:
>
> On 03/06/15 09:37, Aziz Saleh wrote:
> > On Wed, Jun 3, 2015 at 1
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 code.
> >
> > On Fri, Feb 13, 2015 at 12:03 AM, Ethan
> Rosenberg
> > >
> > <mailto:erosenberg@ <mailto:erosenberg@>__
> hygeiabio__medical.com
> > <htt
Generally input names shouldn't have spaces, use underscores if needed
On Tue Feb 17 2015 at 4:34:55 PM rahul bhola wrote:
> Can you post some code snippet here
>
> cheers
> Rahul
>
uction and
replaced it with a proper client / server app. Its not safe, its not secure
and to code a POS on a single machine that the user has access to is just
dumb.
I would strongly suggest that your client have a look at square or similar
if he wants to process CC data.
Bastien
On Thu, Feb 5, 201
tion so that if something happens
to the working box (and likely all tech products, its not IF its WHEN) you
can restore the code and database with minimal data loss
Bastien
On Thu Feb 05 2015 at 9:39:43 AM Omar Muhsin wrote:
> You forgot this one "keep the box OFFLINE ... best security"
d. Or could you
perhaps do an ajax request back to the server to fire off the script?
Bastien
On Thu, Jan 1, 2015 at 11:59 PM Ethan Rosenberg <
erosenb...@hygeiabiomedical.com> wrote:
> Bastein -
>
> Correct 100%. I feel rather stupid. A POST or GET will cause session
> vari
t;
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Bastien
Cat, the other other white meat
Why do you have to tables with products? Couldn't you have a type or
category column and then have to only query one table?
Bastien
On Fri, Aug 9, 2013 at 11:52 AM, Niel Archer wrote:
> > Hello.
> > I am newbie in this and need som basic help.
> >
> > I have
Bastien Koert
On 2013-05-15, at 12:32 PM, "Charlie Lewis" wrote:
> I have a bookseller database list read into a PHP array with dimensions
> [row][field]. There are 32 fields in each record/row and up to 500 records.
>
>
>
> What is the neatest way to sort th
Try It And See
Bastien Koert
On 2013-01-15, at 7:43 AM, Karl DeSaulniers wrote:
>
> On Jan 15, 2013, at 5:31 AM, David Robley wrote:
>
>> Karl DeSaulniers wrote:
>>
>>> Hello Everyone,
>>> Hope your 2013 is treating you well.
>>> Quick q
Bastien Koert
On 2013-01-08, at 1:00 PM, "Ethan Rosenberg, PhD"
wrote:
> Dear List -
>
> Does anyone know how to set up Netbeans?
>
> I've tried and am unsuccessful.
>
> Thanks
>
> Ethan
>
It's a simple installer for the OS you'r
Bastien Koert
On 2012-11-26, at 7:43 PM, Karl DeSaulniers wrote:
> Hello all,
> Quick question.
> What is the best way to store a comma separated list of discount codes in a
> InnoDB?
> Text, varchar, blob, ? I want to be able to store discount codes offered to
> users in
ome comments to see what you guys think.
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Bastien Koert
On 2012-10-14, at 5:57 PM, "Ethan Rosenberg, PhD"
wrote:
> Dear list.
>
> I am running Debian 6 (sid) and Firefox 15.0
>
> I have three debuggers:
>
> Firebug - I have never been able to make it step thru the code.
>
> Aptana - "A
cases where you run a select * from ...
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
t/unsub.php
>
Check to see if mysqli_functions are enabled with phpinfo()
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ld never
have access to the values since there is no access to the post array
to get the values sent from the form.
on your insert page, do you have code like
$image = $_POST['image'];
$year = $_POST['year'];
...
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
you want?
>>
>>
>>
>> Cheers
>>
>>
>> Interesting idea. I gave it a try, but got the same result!
>> I think PDO::ERRMODE_WARNING tells PDO to give PHP warnings versus
>> throw exceptions when there are problems (if
Bastien Koert
On 2012-06-15, at 12:35 AM, "Ron Piggott"
wrote:
>
> I have setup the following echo after a database query:
>
> echo " $email_template['description'] . "\"
> class=\"contact_center_email_template_maintenance_user_inp
Bastien Koert
On 2012-05-19, at 2:36 PM, "Ron Piggott" wrote:
>
> How do I connect to multiple mySQL databases using Prepared Statements ?
>
> I have the syntax
>
> ===
> $dsh = 'mysql:host=localhost;dbname='.$database3;
> $dbh = new PDO($dsh,
Bastien Koert
On 2012-04-16, at 2:21 AM, Karl DeSaulniers wrote:
> On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote:
>
>> Hello,
>>
>> I've always been left wondering what Engine to use while creating tables,
>> I've read quite a few times abo
>>
>> Hope your all enjoying your 2012!
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
Neil's solution is the best. Storing a comma separated list will involve using
a LIKE search to find
on mysql performance is High Peformance MySQL
http://www.amazon.com/dp/0596101716?tag=xaprb-20 which is chockful of
great options and info about gaining performance.
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Tue, Nov 8, 2011 at 1:33 PM, Bastien Koert wrote:
> On Tue, Nov 8, 2011 at 1:31 PM, Ron Piggott
> wrote:
>> What is the preferred method used to export mySQL to Excel within the
>> context of PHP? I have looked on Google and found a wide variety of
>> options
yadmin supports this easily
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
d additional filters to reduce the data sets. A cardinality of two
on a status will always return tons of records and you want to reduce that,
maybe with a date range
Bastien Koert
905-904-0334
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
w.TheVerseOfTheDay.info
A simpler option maybe to use the dbname.tablename syntax to donthe query
Select db1.somefield, db1.anotherfield...
Select db2.somefield, db2.someotherfield
Bastien Koert
905-904-0334
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
terms not to search on and then use that array
to remove any terms that I don't want.
Thanks
Bastien Koert
, the,
> at, on etc..". For example: Hotels in India or Car for rent etc.. How will I
> ignore these words and take just the main words? Please help me.
>
> --
> Best,
> Guru™
>
When I built one, I kept an array of words not to be searched on and then
removed any of those terms from the search string
Bastien
Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
Try echoing out the SQL and then runningnit thru some GUI like phpmyadmin. It
is usually pretty self evident where the problem is at that point
Bastien Koert
Sent from my iPhone
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
t;
> Richard Quadling.
>
> --
> Richard Quadling
> Twitter : EE : Zend
> @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
Bastien Koert
Sent
a LIKE but it may update more than what you want to
update table set toll_free = '$some_value' where toll_free like '%800-###-'
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> “Encouragement from God’s Word”
> http://www.TheVerseOfTheDay.info
>
http://www.phpclasses.org/package/3539-PHP-Check-whether-a-given-year-is-a-leap-year.html
http://www.freeopenbook.com/mysqlcookbook/mysqlckbk-CHP-5-SECT-28.html
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
--
Day.info
>
Ron,
Why not do a mktime for -15 days...that should cover the calendar back
into last year
www.php.net/mktime
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
uot;);
>
> i catch{} a "could not find driver" error.
>
> Any help with this?
>
> I think the proper modules were set up in the php.ini by default.
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
&g
ally
> remove duplicates.
>
> Toby
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Though from the sounds of it, there is a problem with the table design
if you have multiple results in multiple tables
-
lude` = 1 GROUP BY `rss_feed_include`
>
> Ron
>
> The Verse of the Day
> “Encouragement from God’s Word”
> http://www.TheVerseOfTheDay.info
>
SELECT `reference`, ifnull(COUNT(`reference`),0) AS currently_in_rss
FROM `ministry_profiles` WHERE `rss_feed_include` = 1 GROUP BY
`rss_feed
the db to store unicode characters
2. send the html with a utf-8 character header
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ction like param, param_array,
> fetch_assoc, fetch_all_assoc, etc. where is the correct place to ask for this
> method? here?
>
> Thank for your advice
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
t;
> Thanks in advance !
>
> Vinay Kannan.
>
codeigniter works this way. But they have a lot of extra functionality
to keep the data safe for inserts. Check it out.
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I use utf-8 for that it works well
Bastien Koert
905-904-0334
Sent from my iPhone
On 2010-11-10, at 10:03 AM, "Ron Piggott"
wrote:
>
> I have a column that is VARCHAR 250. I need it to be able to accept french
> and spanish accents. The purpose of the column is organ
//designdrumm.com
>
> PS: I'm on google now..
Karl,
A better solution might be to add a temp flag or status field and avoid the
need to move data. When the user clicks the link in the email, then you would
only need to update that one field to activate the user.
Bastien Koert
gt; Sent: Thursday, October 28, 2010 2:02 PM
> To: Bastien Koert
> Cc: Max E.K; php-db-lists.php.net; rquadl...@googlemail.com
> Subject: Re: [PHP-DB] Incrementing Primary Key
>
> At 01:17 PM 10/28/2010, Bastien Koert wrote:
>>On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg
> w
>
>> Here is some pseudo code. Please help me to set it up properly.
>>
>> Table Intake
>> SiteID char(2) primary key not null, //
>> This is A for site1, B for site 2
>> RecordNum int(10,0) primary key not
>> null auto_increment, // increme
On 2010-10-27, at 8:20 PM, Ethan Rosenberg wrote:
> Dear List -
>
> Is anybody aware of any books on PROCEDURAL PHP programming, NOT OO.
>
> Thanks.
>
> Ethan
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
Php progra
profiles`.`toll_free`,
> `ministry_profiles`.`fax`, `ministry_profiles`.`email`,
> `ministry_profiles`.`website` )
> AGAINST
> ('$search')
Ron,
Try using a left outer join from the table that has records. The inner join
won't return any rows if one record in one table is nul
FKs are constraints. They really are there to ensure that the data in the FK
exists in the other table. They do not operate like a conventional index that
is there to aid in selecting data.
Bastien Koert
905-904-0334
Sent from my iPhone
On 2010-10-21, at 7:24 AM, Karl DeSaulniers wrote
Alternatively, you could try setting that index on each table and use a UNION
to join multiple queries together provided each query returns the identical
data set structures ( or the column types have to match)
Bastien Koert
905-904-0334
Sent from my iPhone
On 2010-10-21, at 7:06 AM, Artur
Mysql_real_escape_string($bar)
Bastien Koert
905-904-0334
Sent from my iPhone
On 2010-10-16, at 10:41 PM, "Ron Piggott"
wrote:
> For a query similar to:
>
> SELECT * FROM `tablle` WHERE `column` LIKE 'Sally's Hair Parlor'
>
> how do I escape the &#
n script.
>
> Best,
> Guru.
>
I suggest you google for search engine script and start from there
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
f searching? Is
> it the best solution for my problem or is their any other solution?
>
> Best,
> Guru.
>
What are you :
a) searching on
b) have mysql indeces on
Also have you run an explain plan on the query to see if its using any indexes?
--
Bastien
Cat, the other othe
fe or the life ?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Cookies are shared too
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
subscribe, visit: http://www.php.net/unsub.php
>>
>> --
>> Niel Archer
>> niel.archer (at) blueyonder.co.uk
>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
>
$SQL = "SELECT * FROM tablebtemp WHERE sid =
> $sid";
> $result = mysql_query($SQL);
>
> if (mysql_num_rows($result) ==0) {
> $errorMessage = "Please check
> your username and/or password is correct";
> }
> else (mysql_num_rows($result) ==3) {
> $errorMessage = "You are
> blocked, please contact us to get unblocked.";
> }
> /* END */
> [/php]
>
create it as a function and call that function where you need to. It
seems to be recording failures/logon attempts, so a call at else on
the checks of the initial logon would make sense.
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
, I tend to prefer not using spaces in the field names. I prefer
to have an underscore to avoid any issues if I ever have to move
databases
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
the folder in the correct
place in the mysql data folder. Note that this works best if the
engine type is MyIsam.
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
.
If no row is returned, then access is not granted. If there is a row,
then access is granted.
HTH
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[snip]
[/snip]
PS We will now proceed to fire some 20,000 employees as they will no
longer be needed.
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
where each value is an on / off 1/0 permission
set. This is mapped to a constant for each position so that each
module can have a set of permissions like ADD, DELETE etc.
This scheme then controls the menu / buttons to produce a workflow for
the application.
Bastien
On Monday, January 25, 2010
PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
You can try using an ajax call paired with the js onunload function to
call the server. The other option is to time the user out via cron on
the server after x number of minutes
--
Bastien
the result set is carried through or
> reacquired in the pagination process.
>
> Sorry if this is phrased very clumsily.
>
> Thank you,
>
> Joe Keenan
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Sent from my mobile device
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Christoph Rosse wrote:
>>
>> you could also validate the form in a seperate php file with no output and
>> then redirect to the "error" and the "another page" ?
>>
>>
>> Bastien Koert schrieb:
>>>
>>> On Tue, Dec 15, 2009 at 12
>
What about holding the form in the buffer, and then dealing with the
buffer before sending the form?
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
maintenance headaches for you, but will keep the
data safer, as there is no need to have the user account have admin
privileges on the db for any reason.
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
mysql_select_db("Labor_Log", $db_labor);
>
>
>
> Tim Legg
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
If the databases are in the same mysql server, then you could qualify
OM table
ORDER BY field DESC
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Postgresql & php tutorials
> http://www.designmagick.com/
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
You should be able to access this by creating a shared mysql account
and setting the different domains to use it.
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
gt; $foundTrackingRows=mysql_query("SELECT DISTINCT
>>> DATE(solarLandingDateTime)
>>> solarLandingIP, solarLandingDir, solarLandingDateTime FROM
>>> ".$whichTable."
>>> ORDER BY solarLandingDateTime DESC LIMIT $Maxrecs2Show") or die("qu
a
try
foundTrackingRows=mysql_query("SELECT DISTINCT
DATE_FORMAT('%Y-%m,%d',solarLandingDateTime)
solarLandingIP, solarLandingDir, solarLandingDateTime FROM ".$whichTable."
ORDER BY solarLandingDateTime DESC LIMIT $Maxrecs2Show") or die("query
failed: " .mysql_error());
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Sorry for top posting, a little flaw in the web version of gmail.
Restart the web server to get the ini change to take effect
bastien
On Thursday, July 23, 2009, Ankur Singh wrote:
> Please add mysql dll to you php extension directory
>
> 2009/7/23 yi wang :
>> Hi, all!
>&g
On Wed, Jul 15, 2009 at 4:40 PM, Govinda wrote:
>
> On Jul 15, 2009, at 7:37 AM, Bastien Koert wrote:
>
>> On Wed, Jul 15, 2009 at 9:21 AM, Govinda
>> wrote:
>>>
>>> Reading docs.. I want to be sure of things... have your verification of
>>> my
&g
oal use the REPLACE INTO sql syntax
You really don't want to allow duplicates in primary keys, that
completely negates the usefulness of that key
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Mon, Jul 13, 2009 at 1:33 PM, Patrick Moloney wrote:
> Bastien Koert wrote:
>>
>> On Mon, Jul 13, 2009 at 11:52 AM, Patrick Moloney
>> wrote:
>>>
>>> I've had no success trying to execute any stored procedure from php.
>>> I'm just tryi
get no other error back or
> logged. I'm using root as the user, which is the only defined user. Should
> this work, or are stored procedures not working well?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
&
.id = table3.id
The first statement only does INNER JOINS, the seconds allows for
INNER and OUTER joins, so its more flexible in terms of what you want
the data to be
Bastien
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
PHP-mysql works fine.
>
> Can you figure it out and give me the possible solution?
>
>
>
> Thank you.
>
> suthan
>
>
>
> _
> Windows Live™: Keep your life in sync. Check it out!
> http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_al
there who can support this and give me some hints ?
> Thanks in advance for any comment !
>
> Best regards,
> Björn Lemke
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
odbc is likely the best way to estab
e already returning just the one row
since there can only be one primary key record
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
2009/6/3 Martin Zvarík :
> "SELECT * FROM xxx WHERE primary_id=123 LIMIT 1"
>
> Is it useless (LIMIT 1) ?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Bastien
Cat, the other othe
On Thu, May 28, 2009 at 4:19 PM, Wilson Osemeilu wrote:
> I need a simple php mysql image upload script with display script too and
> to make this easier the mysql database table to use
>
>
>
>
STFW
--
Bastien
Cat, the other other white meat
26,25752#msg-25752
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
cross tab query?
--
Bastien
Cat, the other other white meat
help!!
Can you post the code snippets for the sections that matter?
Also, have a look at the variables you are calling, maybe one is overwriting
the other
--
Bastien
Cat, the other other white meat
ction? This is something worth reading, as it indicates that
the application should manage it (
http://stackoverflow.com/questions/319788/how-do-detect-that-transaction-has-already-been-started)
and that transaction fall outside of OO scope.
--
Bastien
Cat, the other other white meat
/ run query
>
> mysql_query($query) or die ("GRRR");
>
>
> echo $query;
>
> It inserts two records and dies half way thru the 3rd?
> Thanks in advance for clues to fix this.
> T.Miller
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
>
ilto:m...@matya.hu] Sent: Monday, March
> >> 02, 2009 9:29 AM
> >> To: php-db@lists.php.net
> >> Subject: Re: [PHP-DB] Retrieving Image Location in MySQL
> >>
> >> Fortuno, Adam írta:
> >>
> >>
> >>> //Write a query to pull out the picture's path
> >>> $sql = "SELECT path FROM Image WHERE ID = %s";
> >>> mysql_real_escape_string($value);
> >>>
> >>
> >> Sorry, but this won't work, since you don't map the value of the
> >> escaped $value to the %s, lets say with sprintf()...
> >>
> >> Regards,
> >> Matya
> >>
> >>
> >
> >
>
>
> --
> ~
> ~
> Sashikanth Gurram
> Graduate Research Assistant
> Department of Civil and Environmental Engineering
> Virginia Tech
> Blacksburg, VA 24060, USA
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
What I normally do is to use php to create the main page and then reference
the image in the img tag like this
where the 1234 is the image I want to fetch. Then that page just handles the
image is something like
0) {
$row = @mysql_fetch_array ($result);
$image_type = $row["image_type"];
$image = $row["image"];
Header ("Content-type: $image_type");
print $image;
}
?>
--
Bastien
Cat, the other other white meat
Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
i mentioned mysql tools, but special mention to mysql workbench...which is a
really nice tool
--
Bastien
Cat, the other other white meat
, visit: http://www.php.net/unsub.php
>
>
GIYF ... mysql has tools, navicat is another...just effing google it
--
Bastien
Cat, the other other white meat
r to the form page to get the data
from the user. Or create an application account that the rest of the
application would use. Frankly there is no way that I would ever ask the
user for the credentials, if they need different user accounts, I would
create each one on the server and allow the application to control what
accounts are used.
--
Bastien
Cat, the other other white meat
stack. I have searched php.net, and cannot find a
> download for mysqlnd.dll.
>
> Thanks for your help.
>
> Regards,
> Eddie Eyles
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
The docs state that it is part of the php 5.3 release, not the 5.2.8
--
Bastien
Cat, the other other white meat
re People Matter
> 12 Burton Street
> Belleville, Ontario, Canada
> K8P 1E6
>
> ron.pigg...@actsministries.org
> www.actsministrieschristianevangelism.org
>
> In Belleville Phone: (613) 967-0032
> In North America Call Toll Free: (866) ACTS-MIN
> Fax: (613) 967-9963
>
s kicking in here and I would really like to understand what the
>> problem is rather than just reinstalling everything... That just seems too
>> M$ to
>> me.
>>
>> Any suggestions?
>>
>> Thanks,
>>
>> Alex
>>
>>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
In the new version of php, mysql is not enabled by default. Check the ini
file for the modules section and ensure that the mysql is uncommented.
--
Bastien
Cat, the other other white meat
On Fri, Nov 28, 2008 at 5:52 PM, Fergus Gibson <[EMAIL PROTECTED]> wrote:
> On Thu, Nov 27, 2008 at 11:19 AM, Bastien Koert <[EMAIL PROTECTED]> wrote:
> > 2. It is possible to use the application to handle the keys instead of
> the
> > database, it involves
e, so you will need to
change the engine type if the tables are anything else
2. It is possible to use the application to handle the keys instead of the
database, it involves more work around key checking / validation before
creating or updating records, but it can be done if the INNODB table type is
not accessible to you for some reason. Inserting / reading from the table
would be handled by an order precedence where you first select something
from something like the users table to get the user id (or store it in
session when logging the user in) and then adding that key to the other
table.
--
Bastien
Cat, the other other white meat
ient and contacts into two tables. Its likely
that the client info will not change often, but people will changes roles
much more frequently. Or you may have multiple people for multiple areas for
larger clients
--
Bastien
Cat, the other other white meat
The best bet is to handle the errors properly
$num_rows = -1;
if (!$result || mysql_err_no($result) != 0)
{
$num_rows = mysql_num_rows($result);
}
if ($num_rows >-1){
//do something here
}
--
Bastien
Cat, the other other white meat
t;unset($_SESSION['userid']);
>unset($_SESSION['passwd']);
>
>echo "Login Failed Try Again!";
> include(INC_DIR."user_login.php");
>
> }
>
>
> Please help.
>
> Thanks.
>
> Velen
Use the TARGET attribute and make you link a submission to the other frame
in the set
--
Bastien
Cat, the other other white meat
eferences the Customer table as a FK on the CustomerID
field, the CustomerId record MUST exist in the table before the order table
can be filled.
It does not alleviate the need to have a primary key on the other table.
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.htmlfor
more details
--
Bastien
Cat, the other other white meat
& php tutorials
> http://www.designmagick.com/
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
If possible, see if you can have the sort space on the db table made bigger.
You could gain a lot of performance
1 - 100 of 795 matches
Mail list logo
