[PHP-DB] neebee: on table designs.

Hi All, I have 5000+ individual clients, each clients may have 100+ records. Each client can modify to their own records. In the order of maintenance, robustness, scalability then performance, which of the following do you think is best. i)1 big table with 50+ records ii)

Re: [PHP-DB] mysql db dump with php

On Wednesday 17 November 2004 13:51, Nate Nielsen wrote: > i need a script that will connect to a db with a username and password, and > then export to the screen scripts to both recreate the database structure > (the create table commands) and then create insert statements to populate > that info

[PHP-DB] mysql db dump with php

hi all, i need to transfer the database from one site (structure and data) to another. i've been running into some issues. i need a script that will connect to a db with a username and password, and then export to the screen scripts to both recreate the database structure (the create table co

Re: [PHP-DB] OOP vs Functions and includes

I agree with Bruno. It depends on the project and project's situation. Your request for clarification is about Prcedural Programming VS OOP It realy depends on the situation and project scope. And this is general not only in PHP but in all the programming languages where prcedural programming is

Re: [PHP-DB] OOP vs Functions and includes

Hi Pablo, The 3 main strong points of using OOP are: 1. Encapsulation 2. Inheritance 3. Polymorphism I like using OOP instead of includes because of these points. It helps me alot in doing maintenance releases using this technique instead of having to deal with thousands of codes which can be a

[PHP-DB] OOP vs Functions and includes

Hi, This is my first post. English is my 2nd language so I apologize for any mistakes I might have. I would describe myself as an intermediate self-thaught PHP programmer, which means I can do lots of stuff but probly my coding techniques sucks :P Anyway, Im reading a lot about OOP lately, an

RE: [PHP-DB] Numeric question

> I am fairly confident that in this particular case the opinion(s) contained within this email would nicely coincide with those of St. Jude Children's Research Hospital. > > We live in a world full of geometry. > > Ignatius Reilly ... Not to be outwitted ... I'm quite certain my statements in t

Re: [PHP-DB] Numeric question

Brent Baisley wrote: round() rtfm. I would agree, rtfm is a good choice in this regard but the wrong rtfm. This is something that should be done IN the database not in PHP. If you are using PostgreSQL you can do this: select column::numeric(10,2) from foo; Sincerely, Joshua D. Drake On Nov 16,

[PHP-DB] PHP on an Windows intranet with MSOffice-like templates

I don't even know if this is possible, or if I'll have to go the route of .NET development to get this sort of functionality (I'm sure it's possible if I jump through enough hoops). But here's what I'm trying to accomplish... - users are all on a local intranet with access to a shared drive (no pr

Re: [PHP-DB] Numeric question

I am fairly confident that in this particular case the opinion(s) contained within this email would nicely coincide with those of St. Jude Children's Research Hospital. We live in a world full of geometry. Ignatius Reilly _ - Original Message - From: "Norland, Mar

Re: [PHP-DB] Extending MySQLi_Result object

Am Di, den 16.11.2004 schrieb Joe Bandenburg um 21:15: > i there, > > It's my first post here, so go gentle. It's your 2nd post - you sent the same post one Nov. 8th, but I was on a conference and not able to answer :) > > I have run into a problem when trying to extend the MySQLi_result object

Re: [PHP-DB] Numeric question

round() rtfm. On Nov 16, 2004, at 3:38 PM, Chris Payne wrote: Hi there everyone, Just a quick question, I’m having to calculate some values from an existing database, but on some of the results I get (For example) 0.5907 How can I limit the result to only 2 digits after the decimal poi

[PHP-DB] Extending MySQLi_Result object

i there, It's my first post here, so go gentle. I have run into a problem when trying to extend the MySQLi_result object because the MySQLi object's method "query" always returns a MySQLi_result and, to my knowledge, it is impossible to make it do otherwise. So, my question is, how do I alter th

RE: [PHP-DB] Numeric question

$number = 0.5907; Round($number,2); YAY! :) -TG > -Original Message- > From: Chris Payne [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 16, 2004 3:38 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Numeric question > > > Hi there everyone, > > > > Just a quick ques

RE: [PHP-DB] Numeric question

> Just a quick question, I'm having to calculate some values from an existing database, > but on some of the results I get (For example) > 0.5907 > How can I limit the result to only 2 digits after the decimal point with PHP? > Thanks > Chris Let the manual guide you: http://www.php.net/ro

[PHP-DB] Numeric question

Hi there everyone, Just a quick question, I’m having to calculate some values from an existing database, but on some of the results I get (For example) 0.5907 How can I limit the result to only 2 digits after the decimal point with PHP? Thanks Chris --- Outgoing mail i

RE: [PHP-DB] IIS/PHP question

Sessions work fine with IIS. Check you php.ini file for register_globase if that is off (default) you can only access your variables through $_SESSION[] - Frank > can you show some code? > > bastien > > >From: "Adil" <[EMAIL PROTECTED]> > >To: [EMAIL PROTECTED] > >Subject: [PHP-DB] IIS/PHP que

RE: [PHP-DB] odbc quest

>$sql = "SELECT * FROM users WHERE username='$username' AND password='$password'"; >$result = odbc_exec($dbConnection, $sql); > >while ($rows = odbc_fetch_array($result)) { > //This doesn't work with odbc_fetch_object either > print $rows->COLUMNNAME; >} It's returning an array, not an obj

RE: [PHP-DB] IIS/PHP question

can you show some code? bastien From: "Adil" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] IIS/PHP question Date: Tue, 16 Nov 2004 11:16:40 -0500 I'm having a weird issue with sessions on IIS running PHP. I was finally able to use sessions on IIS by setting the save_path to "/temp" an

[PHP-DB] odbc quest

Hey people, Again, thanks to anyone whose answered my questions, its helping out a great deal. I figured out the sessions issues thanks to some of the replies I received but if its not one thing its the other it seems. Anyone know much about odbc_fetch_array() or odbc_fetch_object() functions in

RE: [PHP-DB] Re: Subject: Javascript Question (Was PHP / Javascri pt question)

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 16 November 2004 15:12, Neil Smith wrote: > That > > if (df[i].checked=true) { > > should of course read > > if (df[i].checked==true) { No it shouldn't -- it should read

[PHP-DB] IIS/PHP question

I'm having a weird issue with sessions on IIS running PHP. I was finally able to use sessions on IIS by setting the save_path to "/temp" and that seems to work. However, I can register a variable using session_register, but when I go to the next page, it doesn't seem to see the session varaible ev

[PHP-DB] Re: Subject: Javascript Question (Was PHP / Javascript question)

That if (df[i].checked=true) { should of course read if (df[i].checked==true) { Cheers - Neil function validate_form() { valid=true; df=document.forms["myform"]; var regex="del\[\d+\]"; for (i=0; i

[PHP-DB] Re: Subject: Javascript Question (Was PHP / Javascript question)

Yes it can be a bit tricky first time. You'll be using numeric indexes (it's the easiest) so probably like this : Iterate through the form's elements array, check if each one is a [checkbox / radio / other] and then check the name for the element against a regex. If it matches then you need to u

[PHP-DB] oci8 cannot connect after restarting DB

Every evening, for whatever reason, our Oracle db (9.2.0) is restated. After it is restarted, I am unable to build a connection with Oracle from PHP untill Apache is restarted. Whenever I do an ociplogon() or ocilogon() following an Oracle DB restart, it fails but I am unable to get a descripti

[PHP-DB] PHP 5.0.2 bug

I am getting this: [Tue Nov 16 06:55:31 2004] [notice] child pid 25537 exit signal Segmentation fault (11) When I call this: header("Location: main.php"); It only appears to happen when I'm making an Oracle database call and it takes awhile to come back. When I take the Oracle call out, it does

RE: [PHP-DB] PHP / Javascript question

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 16 November 2004 03:03, Chris Payne wrote: This is OT, really, but because it's an easy answer: > if ( document.removeitems.del.value == "" ) > BUT because the tickboxes in

[PHP-DB] talking Robots

Hi folks, I'd luv to know: 1. if it is possible to write a robot in PHP; 2. how a query can be ran faster in mysql. i heard of hasing but i seem not to understand the whole concept. 'd be glad if someone can help though. Tahnks for the usual cooperation. -