|
|
Posted by Jerry Stuckle on 09/13/07 11:33
Jim Carlock wrote:
> "Jeff Johns" wrote...
> : Do you need to build the array? Are you building this array
> : from a file? If so why not format the file and do a LOAD FILE
> : query or better yet use PhpMyAdmin to upload your file. Not
> : sure if you need to make the array then upload from the array.
> :
> : Any possibility we can see some of your code?
>
> Well, it's easy to convert to a .csv format, but I don't mess
> with PhpMyAdmin. I took a look at that once a while back but I
> end up seeing too many hacks against it, which creates a rather
> insecure feeling.
>
I have PHPMyAdmin on several sites and never have a problem. They're
just in password protected directories so no one can get to them.
As for the hacks - just keep it updated, like everything else.
Or, you can continue to make things difficult for yourself. Your choice.
Or, are you confusing PHPMyAdmin (a web-based tool) with MySQL (a
database)? Again, I've had zero problems with MySQL on the systems I
have. But I have security in place, also.
> The array is easy enough to convert to a regular CSV file and
> other database formats from that. No I don't need to build the
> array. That's just the way it started out.
>
> Thanks for asking. I won't have any code to show for awhile.
> I'm just creating an array which will create a database. I
> suppose I can get to know the file (line) reading functions of
> PHP as another way to get this done, but that's not my interest
> right at the moment. I'm playing around with big arrays.
>
Generally a sign of a poor implementation. Use a database.
> I'm curious to others suggestions. I think I'll end up using
> SQLite IF I get done with this.
>
I'd highly recommend MySQL or PostgreSQL over SQLite. Much more robust.
> // over 6000 API definitions...
>
> // index, Win32APIFunctionName, ParameterList, ParameterListDesc, ReturnValue, ReturnValueDescSuccess, ReturnValueDescFailure,
> Purpose_URI, Purpose_desc
>
> return(array(
> array(0, "AbortDoc", "(hdc:DWORD)", "plist_desc", "eSuccess:DWORD", "32-bit", "Upon success, the return value is greater than zero
> (0).", "Upon failure, the return value is SP_ERROR.", "http://msdn2.microsoft.com/en-us/library/ms535758.aspx", "<p>AbortDoc() stops
> the current print job and erases everything drawn since the last call to StartDoc().</p>\n<p><b>Windows NT/2000/XP:</b> Call
> GetLastError() for extra error information.</p>"),
>
>
You definitely need a database.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|