RE: [PHP-DB] Re: [PHP] SQLITE

[Bronislav Klucka]

That's my code:
$dbfile=db.sdb;
$db=sqlite_open($dbfile);
$res=sqlite_query($db,select a.*,b.* from a left join b on a.id=b.id_a
where a.name like \%1%\ or b.street like \%1%\ order by cellphone);
echo sqlite_num_rows($res).CRLF;
sqlite_close($db);

It's realy just benchmark I've done. I'm pretty much aware of system
sqlite is useing to store the data, and I also find obvious that if it would
be runnig like web database module, users will ask the same table ata the
same time (like with other db system, they are looking at the same page) but
I find it not good, I was only asking if there is a way to change it


Bronislav Klucka


  Is this some feature of sqlite or an I doing something wrong?

 Without seeing any code or being given any details, all I can make is an
 educated guess. SQLite uses the filesystem for storage. If your queries
 are needing to access the same file (maybe you're querying the same
 table), SQLite is going to serialize those queries to help you avoid
 threading problems. So, your queries are going to basically take turns.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Downloading PHP source from a PHP filename, possible?

[Bronislav Klucka]

Only just to say:
There is no way how to grab PHP source code from remote computer!!!
1/ As I said: communicating with another computer is always using some
protocol (HTTP,HTTPS,FTP,GOPHER,SMTP) And using http protocol always
pass the code through php parser before it's sended to you. Always, there is
no way how to escape this.
2/ Try to imagine, what should be possible if you are able to do it... you
can steal every source codes... with passwords, dataabse administrator
access.. We are all glad it's not possible to do it


But there is way if the remote computer, you want to grab the codes from is
under your control (or part of it).



 There *must* be some way, because when you point your
 web-browser to domain1.com it loads the source, so
 windows reads the source to display and the webserver
 handles the requests.  So there must be some way to
 actually grab it?  Or no?  I don't mean the HTML
 source I mean the entire PHP source.

As I wrote, no way unless you have that code under your control

And be really carefull, what are you doing NEVER do this customizable from
users to prewent downloading other sources, that you you want them to
download


Brona

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php