willing to learn php basics
Bernard
How can I learn how to make first steps in PHP ?
I run Debian Lenny, and I lately got acquainted with MySQL : I installed
a server on my system, built a few databases there, using basic SQL
scripts. I also learnt to manage those MySQL databases with
OpenOffice.org_base.
Now, I wish to try managing those MySQL bases from a web page that would
contain PHP scripts. I have found a short document, a kind of a FAQ,
that explains a few PHP basics, still I miss some down-to-Earth knowledges :
Have I got to install one or more Debian packages for PHP ? '$apt-cache
search PHP' gives too many results for a choice. If the MySQL server and
databases end up to the webspace that my Internet Provider allows to me,
I suppose that the PHP interpreter and/or compiler will have to be
there, not on my system ? Still, I suppose that I must install
something locally so as to be able to send meaningfull commands using
appropriate scripts ? Prior to run tests on distant web space, I first
wish to carry trials with connexions to my local mysql server.
Thanks in advance for your help
--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Kelly Clowers
> Hi to Everyone !
>
> How can I learn how to make first steps in PHP ?
>
> I run Debian Lenny, and I lately got acquainted with MySQL : I installed a
> server on my system, built a few databases there, using basic SQL scripts. I
> also learnt to manage those MySQL databases with OpenOffice.org_base.
>
> Now, I wish to try managing those MySQL bases from a web page that would
> contain PHP scripts. I have found a short document, a kind of a FAQ, that
> explains a few PHP basics, still I miss some down-to-Earth knowledges :
>
> Have I got to install one or more Debian packages for PHP ? '$apt-cache
> search PHP' gives too many results for a choice. If the MySQL server and
> databases end up to the webspace that my Internet Provider allows to me, I
> suppose that the PHP interpreter and/or compiler will have to be there, not
> on my system ? Still, I suppose that I must install something locally so
> as to be able to send meaningfull commands using appropriate scripts ?
> Prior to run tests on distant web space, I first wish to carry trials with
> connexions to my local mysql server.
I am not a PHP dev, but I believe installing "php5", "php5-mysql" and
"mysql-server" should drag in most of what you need to get started
(including libapache2-mod-php5, mysql-client, etc). This would let you
do any/all testing locally. You could do it all on the web server with an
ssh session, if you wanted to though (you wouldn't do that with an in
use service, but if you only set it up for testing, it's fine).
Cheers,
Kelly Clowers
M. Milanuk
of my php/mysql stuff thus far on a XAMPP installation on Windows. As
such, I'll be keeping an eye on this thread as well ;)
I will say that the book 'Head First: PHP & MySQL' from O'Reilly
(http://www.headfirstlabs.com/books/hfphp/) has been very helpful for me
as far as getting going with these two technologies.
HTH,
Monte
Avi Greenbury
> Have I got to install one or more Debian packages for PHP ?
> '$apt-cache search PHP' gives too many results for a choice.
You want to do
# apt-get install php5 php-mysql apache2
Which will also pull in the php5 apache module.
By default, the web pages live under /var/www, the php config file
is /etc/php5/apache2/php.ini and the apache config is all
under /etc/apache2/, with apache2.conf being the 'main' config file.
There're several howtos on the net to talk you through it, howtoforge
is a bit of a goldmine for them.
>If the MySQL server and databases end up to the webspace that my Internet
> Provider allows to me, I suppose that the PHP interpreter and/or
> compiler will have to be there, not on my system ?
Interpreter, and yes.
If you want to serve the pages to the outside world, you can do so from
your PC by opening the relevant ports on your firewall.
> Still, I suppose that I must install something locally so as to be
> able to send meaningfull commands using appropriate scripts ?
If you want to test locally and then upload to your ISP-provided
webspace, you can do that by ftping the .php files. You'll want to know
how their php/mysql environment is configured, though, and configure
yours likewise. Also check database names.
You can transfer database data by 'exporting' it through mysqldump,
uploading the resulting file, and then 'importing' it - the dump is
just a list of the SQL commands required to populate the database.
--
Avi Greenbury
http://aviswebsite.co.uk ;)
http://aviswebsite.co.uk/asking-questions
Cassiano Leal
> Hi to Everyone !
>
> How can I learn how to make first steps in PHP ?
>
> I run Debian Lenny, and I lately got acquainted with MySQL : I installed a
> server on my system, built a few databases there, using basic SQL scripts. I
> also learnt to manage those MySQL databases with OpenOffice.org_base.
>
> Now, I wish to try managing those MySQL bases from a web page that would
> contain PHP scripts. I have found a short document, a kind of a FAQ, that
> explains a few PHP basics, still I miss some down-to-Earth knowledges :
>
> Have I got to install one or more Debian packages for PHP ? '$apt-cache
> search PHP' gives too many results for a choice. If the MySQL server and
> databases end up to the webspace that my Internet Provider allows to me, I
> suppose that the PHP interpreter and/or compiler will have to be there, not
> on my system ? Still, I suppose that I must install something locally so
> as to be able to send meaningfull commands using appropriate scripts ?
> Prior to run tests on distant web space, I first wish to carry trials with
> connexions to my local mysql server.
>
> Thanks in advance for your help
What I do when I need to run php on top of apache is to install
libapache2-mod-php5. It will pull everything you need to have a basic
apache2+php5 setup running.
Then, you can install whatever php modules that you need. THey are
usually called php5-<modulename>.
You configure apache2 by editing the files under /etc/apache2 and php
by editing /etc/php5/apache2/php.ini and the files under
/etc/pgp5/apache2/conf.d .
Cassiano
jagginess
> Hi to Everyone !
>
> How can I learn how to make first steps in PHP ?
>
> I run Debian Lenny, and I lately got acquainted with MySQL : I
> installed a server on my system, built a few databases there, using
> basic SQL scripts. I also learnt to manage those MySQL databases with
> OpenOffice.org_base.
>
> Now, I wish to try managing those MySQL bases from a web page that
> would contain PHP scripts. I have found a short document, a kind of a
> FAQ, that explains a few PHP basics, still I miss some down-to-Earth
> knowledges :
>
> Have I got to install one or more Debian packages for PHP ?
> '$apt-cache search PHP' gives too many results for a choice. If the
> MySQL server and databases end up to the webspace that my Internet
> Provider allows to me, I suppose that the PHP interpreter and/or
> compiler will have to be there, not on my system ? Still, I suppose
> that I must install something locally so as to be able to send
> meaningfull commands using appropriate scripts ? Prior to run tests
> on distant web space, I first wish to carry trials with connexions to
> my local mysql server.
>
> Thanks in advance for your help
>
>
the most basic thing to do is to see if phpinfo(); displays support
for mysql-php..
if it does, then the next basic test is to see if you use an phpmysql
dbconnect command and print a "1" or "0" to the html page..
and do a dbdisconnect phpcommand for any open closing before finishing
the php page.
after this, you can try learning more from help online.. notably this
might help
http://www.php.net/manual/en/indexes.php
and go to the start of mysql_* named functions.. that should give a
slight hint ;-)
good luck..
Bernard
Avi Greenbury wrote:
> Bernard wrote:
>
>> Have I got to install one or more Debian packages for PHP ?
>> '$apt-cache search PHP' gives too many results for a choice.
>>
>
> You want to do
> # apt-get install php5 php-mysql apache2
>
> Which will also pull in the php5 apache module.
> By default, the web pages live under /var/www, the php config file
> is /etc/php5/apache2/php.ini and the apache config is all
> under /etc/apache2/, with apache2.conf being the 'main' config file.
>
> There're several howtos on the net to talk you through it, howtoforge
> is a bit of a goldmine for them.
>
I have now got to a point that I have a working MySQL database system on
my localhost machine. I thought that I would not have any problem
migrating this to my ISP appropriate MySQL space, but so far I have
failed to do so. Local doc is very scarce, and I did not find any
relevant FAQ. I did find the relevant paths though, and succeeded
installing a short php script which displays the current date, using
strftime(), but there is no way I can access databases. From the online
doc, I learnt that I can't create databases, and that I can just create
tables under the database that already exists. If I import a table, only
its structure gets imported, not its content, and then an error message
says that I don't have privileges for this... so I am surely missing
something as far as setting up is concerned, or initialization. In my
efforts to fetch info, I got a few hints, but they were negative ones,
for instance someone kind of said that most ISP did not allow their
customers to more than one authenticated user. This would mean that I
could not expect to install a database that would be available to the
members of a club, each of them having a login and password.
Could someone tell me where I could find relevant information and docs ?
And maybe mention one or more ISP that would provide suitable mysql
facilities ?
>
>
>> If the MySQL server and databases end up to the webspace that my Internet
>> Provider allows to me, I suppose that the PHP interpreter and/or
>> compiler will have to be there, not on my system ?
>>
>
> Interpreter, and yes.
> If you want to serve the pages to the outside world, you can do so from
> your PC by opening the relevant ports on your firewall.
>
>
>> Still, I suppose that I must install something locally so as to be
>> able to send meaningfull commands using appropriate scripts ?
>>
>
> If you want to test locally and then upload to your ISP-provided
> webspace, you can do that by ftping the .php files. You'll want to know
> how their php/mysql environment is configured, though, and configure
> yours likewise. Also check database names.
> You can transfer database data by 'exporting' it through mysqldump,
> uploading the resulting file, and then 'importing' it - the dump is
> just a list of the SQL commands required to populate the database.
>
> --
> Avi Greenbury
> http://aviswebsite.co.uk ;)
> http://aviswebsite.co.uk/asking-questions
>
>
>
--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Monique Y. Mudama
> I have now got to a point that I have a working MySQL database
> system on my localhost machine. I thought that I would not have any
> problem migrating this to my ISP appropriate MySQL space, but so far
> I have failed to do so. Local doc is very scarce, and I did not find
> any relevant FAQ. I did find the relevant paths though, and
> succeeded installing a short php script which displays the current
> date, using strftime(), but there is no way I can access databases.
> From the online doc, I learnt that I can't create databases, and
> that I can just create tables under the database that already
> exists. If I import a table, only its structure gets imported, not
> its content, and then an error message says that I don't have
> privileges for this... so I am surely missing something as far as
> setting up is concerned, or initialization. In my efforts to fetch
> info, I got a few hints, but they were negative ones, for instance
> someone kind of said that most ISP did not allow their customers to
> more than one authenticated user. This would mean that I could not
> expect to install a database that would be available to the members
> of a club, each of them having a login and password.
Maybe I'm misunderstanding the question, but ... typically you would
have *one* login that the website uses to talk to the database.
Website users would not authenticate by logging into the database -
they would authenticate by having a username and (possibly encrypted)
password stored in the database, which you would somehow retrieve and
compare.
> Could someone tell me where I could find relevant information and
> docs ? And maybe mention one or more ISP that would provide suitable
> mysql facilities ?
As for hosting companies, I have been very happy with www.pair.com for
years. They provide I believe three database users - read-only,
read-write, and full access. You would only use the full access user
to create the database structure - tables, indexes, etc. You would
use either a read-only or read-write user in your web code, depending
on what you were doing.
They also have a nice library of help documents, which are apparently
freely available without requiring a login:
http://www.pair.com/support/knowledge_base/
And I think the command you want is "mysqldump" ... with the correct
parameters you should be able to tell it to create a file that
includes everything necessary to both create your table structures
*and* populate them with your data. This of course assumes that
you're running the same version of mySQL on your local server as is
available on your host machine.
--
monique
--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Archive: http://lists.debian.org/20100416001...@mail.bounceswoosh.org
Joe
I use 1&1 (http://1and1.com) for a web database. They have several level
of package, the one I use has MySQL facilities, ftp and also ssh access
to the virtual server that runs apache.
As Monique said, you can use MySQL to store passwords and write your own
login script, but you should also be able to use basic authentication
(with .htpass files) in the web server to require a user name and
password for access to web pages, which may well be enough for your
purposes. The advantage is that it's simple to set up, the disadvantage
is that you have to set the passwords and communicate them to the users,
they cannot change them. Neither of these techniques count as
authentication to the operating system or MySQL itself, so the single
user isn't a problem.
The MySQL installation at 1&1 is accessible by a public IP address from
the virtual server, but this is not guaranteed to be available from
outside their own network. They advise that the database be accessed
only from the virtual server, either through ssh or the web server.They
recommend installing phpmyadmin, which is a script which runs on the web
server.
Monique and Avi mentioned mysqldump, and phpmyadmin offers similar
features remotely through a web page, including uploading of .sql files,
by which you can create and populate entire databases if necessary. It
can also backup the database to a file on the client computer. You can
access phpmyadmin from anywhere, and you need to login to it using the
MySQL credentials. The phpmyadmin information page can also tell you
quite a lot about how the apache and MySQL installations are configured.
One last point: even if you don't advertise the website outside your
club membership, it will be found by others, and you need to understand
at least SQL injection and cross-site scripting attacks on web servers,
and the facilities that PHP offers to help defend against them. You
should also regularly check your web server directory structure and
files for signs of tampering. And a whole load of other things, but web
server security is a career in itself...
--
Joe
--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Bernard
Thanks for your help Monique. I hadn't thought of that, but it makes
sense that the ISP only allows one user to log into databases. Problem
is that outside users will have to connect to my database through a php
script that will contain my password !
>
>> Could someone tell me where I could find relevant information and
>> docs ? And maybe mention one or more ISP that would provide suitable
>> mysql facilities ?
>>
>
> As for hosting companies, I have been very happy with www.pair.com for
> years. They provide I believe three database users - read-only,
> read-write, and full access. You would only use the full access user
> to create the database structure - tables, indexes, etc.
Prior to subscribing to an expensive hosting, I wish to test the system
on free ISP. I have two of them here. I tested them both, but testing
did not go far as for now, since I am far from having understood how it
is supposed to work. No doc is provided, except links for general docs.
As previously said, I have been able to connect and succeed in a few
requests, but, obviously I lack a "full priviledge" (root) status. I do
have mysqladmin installed on both ISP machines, but I can do very little
with it : '... denied for user bdebreil...'. Reading the general
mysqladmin doc tells me that I have to create a super user (as I did in
my local mysql machine on my PC), but nothing works. Same thing with my
other ISP. Using php scripts, some sql request do work, for instance I
can manually add content to an empty database that I have imported using
phpmyadmin (import with no data, data refused: 'access denied...'), but
I have no such thing as 'FILE' privilege, so that I cannot import data
using 'LOAD DATA [LOCAL] INFILE ...' as I do on my local machine. Of
course, anything such as 'GRANT [privilege] does not work either. The
mysqladmin doc says that one has to create a config.inc.php file in the
same folder as 'Mysqladmin documentation.html'... but I have no access
to that folder... I would be tempted to write to my ISP system
administrator, but, since I found that I have the same config at both my
ISPs, I imagine that this is the way it is supposed to be..
By the way, just in case I would decide to subscribe to pair.com, would
you know if it is possible to subscribe for a short time, 3 months for
instance ? I know of an ISP in Switzerland that is quite a bit cheaper,
but then you have to subscribe for at least two years (80 Euros for the
first year, 120 Euros for each following year)
--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Bernard
but I lack super user privileges, and most functions are therefore
unavailable to me, as explained in my previous post.
--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Joe
>
>
> Thanks for your help Monique. I hadn't thought of that, but it makes
> sense that the ISP only allows one user to log into databases. Problem
> is that outside users will have to connect to my database through a php
> script that will contain my password !
That is normal. If your users can enter data, then the script must have
at least some write privileges on the database.
In the real world, you deal with the security aspect by placing the
password (and database and user names) in a second php script outside
the web server's document root, so that no web request can return it.
Apache will normally be configured not to allow download of scripts,
even when a user knows the right filename, but placing the script
outside the directory tree which apache can reach adds to security. You
'require' this mini-script in the main php script, which must of course
be placed within the web document tree. While apache cannot reach
outside its docroot, php/perl/etc. can, though with the same permissions
that apache runs under.
In order to achieve this, you need write access to that directory tree
above apache's docroot, with the ability to set permissions correctly.
From what you say, it does not seem that you have that with your
current ISP. You would seem to need to spend some money, even before you
are sure you will have the access you need.
>By the way, just in case I would decide to subscribe to pair.com,
>would you know if it is possible to subscribe for a short time, 3
>months for instance ? I know of an ISP in Switzerland that is quite a
>bit cheaper, but then you have to subscribe for at least two years (80
>Euros for the first year, 120 Euros for each following year)
1&1 appears to offer a 60-day guarantee which may meet your needs:
"The 1&1 60-Day Money Back Guarantee applies to the Instant Mail and
Beginner packages as well as all shared hosting, Virtual Server and
eShop packages. You will receive a full refund of the fees if you are
not completely satisfied within 60 days' of the activation of your
package. Guarantee starts on the date of initial registration of the
contract number.
"There is no refund for packages ordered with the software bundle,
software shipping and handling fees, domain name registration fees, or
any unused bandwidth. 1&1 considers that customers upgrading from an
existing package have already experienced the 60-Day Money Back
Guarantee. In addition, each customer can only use the Money Back
Guarantee once, and for only one contract number per account."
In practice, you'll need to pay a small amount for shipping of
documentation and to register at least one domain name, so you wouldn't
get much back out of two months' payment, but you wouldn't be tied into
a long contract.
I'm on the Business Pro package, at GBP 15 per month, most of which I
can charge on to customers. There's a Business at GBP 9 per month, about
the same as your Swiss one, which offers two 100MB MySQL databases plus
perl and PHP. It doesn't have ssh access to the server, but I've very
rarely used that. It also doesn't have cron scripts, but I've never used
them. If you need something timed, you can write it into a script and
call it as a web page on a timed basis from outside.
As I recall, you don't need ssh access to install phpmyadmin, it's just
another web script. You FTP the files to a suitable directory. You need
to give phpmyadmin the local address and port number of the MySQL
server. Certainly, you are free to create users at various privilege
levels, you have full control of the databases. You can then logon to
phpmyadmin using any of the MySQL user credentials, though normally you
will be doing administration and you will use the root logon.
--
Joe
--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Monique Y. Mudama
>
> In order to achieve this, you need write access to that directory
> tree above apache's docroot, with the ability to set permissions
> correctly. From what you say, it does not seem that you have that
> with your current ISP. You would seem to need to spend some money,
> even before you are sure you will have the access you need.
There are a few different ways to deal with not exposing your password
to the world, but one thing I do want to note: in a hosted situation,
you should have a user home directory in addition to the directory for
your website. If you need a file to be inaccessible from the web, you
can just put it in your home directory. There's no need for root
level permissions.
--
monique
--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Archive: http://lists.debian.org/20100418041...@mail.bounceswoosh.org
Monique Y. Mudama
>
> Thanks for your help Monique. I hadn't thought of that, but it makes
> sense that the ISP only allows one user to log into databases.
> Problem is that outside users will have to connect to my database
> through a php script that will contain my password !
Nope. There are a few ways to deal with this; Joe mentioned a common
one, which is to have your password stored in a file that's outside of
your website directory.
Bear in mind, many, many people and businesses have successfully built
websites using both their own servers and host providers. So for
almost any "wait, that can't be right, because it causes this
problem!" situation - there's almost certainly a readily available
solution.
> >>Could someone tell me where I could find relevant information and
> >>docs ? And maybe mention one or more ISP that would provide
> >>suitable mysql facilities ?
> >
> >As for hosting companies, I have been very happy with www.pair.com
> >for years. They provide I believe three database users -
> >read-only, read-write, and full access. You would only use the
> >full access user to create the database structure - tables,
> >indexes, etc.
Given that this is a Debian list, I should mention that Pair runs
FreeBSD systems, not Linux.
> Prior to subscribing to an expensive hosting, I wish to test the
> system on free ISP. I have two of them here. I tested them both, but
> testing did not go far as for now, since I am far from having
> understood how it is supposed to work. No doc is provided
*snip*
In my experience paying for web hosting - you do get what you pay for.
Pair is not the cheapest host in the business, but they have
had phenomenal uptimes, excellent support, and provide reasonable
access to the system. I've been burned by cheap web hosts before -
including a company that cancelled a friend's account because he'd
typed "ls /etc" and they found it in his bash history file. Wow. I'm
not saying that you can't find a good host cheaper than Pair - for me
personally, Pair is cheap enough and good enough that I haven't looked
further since I started using them. I should also note that I'm only
running a personal vanity site, not a business or service. And if
you're not based in the US, I don't know how much sense it makes to
work with a US host provider.
I've never installed mysqladmin, so I can't speak to that. I've
always just used command line tools for mySQL.
Anyway, I don't mean to sound like an advertisement for one particular
company. I'm sure there are many reputable, reliable hosting
companies out there. It does sound like you need a fair amount of
information to do this for the first time, so you might want to choose
a host provider that explicitly includes support as part of the deal.
--
monique
--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Archive: http://lists.debian.org/20100418044...@mail.bounceswoosh.org
Bernard
successfully mastered, but I can't find the appropriate links. What
about my WS 3500 ? the MSWIN driver that I got with it, is called
"Heavy Wheather 3600", as it is supposed to manage both WS3500 and WS3600.
There is a SERIAL connexion between the wheather station and the PC.
Thanks in advance for any advice.
--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Stan Hoeppner
> I've read somewhere that a Lacrosse WS2300 or 23?? was being
> successfully mastered, but I can't find the appropriate links. What
> about my WS 3500 ? the MSWIN driver that I got with it, is called
> "Heavy Wheather 3600", as it is supposed to manage both WS3500 and WS3600.
>
> There is a SERIAL connexion between the wheather station and the PC.
What, exactly, _specifically_, is the question you would like us to answer?
--
Stan
--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Archive: http://lists.debian.org/4BE82705...@hardwarefreak.com