473,320 Members | 1,948 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Reality check

KC
Hi Group, Just joined and would ask if you could give me a reality
check. I have a year left before I take early retirement and would
like to convert some of my work at work from excel (which I know a
reasonable amount) to a database over the firms network. Mostly they
would be simple forms for users to complete, some with lookups for
addresses and existing info. One or two would be more complex
management based databases. I have a couple of books on PHP and MYSQL
but am wondering if I am deluding myself into thinking I can learn and
cover all the bases in the time I have. Is this something a novice
could do? or should I stear clear!

KC

Jul 26 '07 #1
9 1334
KC wrote:
Hi Group, Just joined and would ask if you could give me a reality
check. I have a year left before I take early retirement and would
like to convert some of my work at work from excel (which I know a
reasonable amount) to a database over the firms network. Mostly they
would be simple forms for users to complete, some with lookups for
addresses and existing info. One or two would be more complex
management based databases. I have a couple of books on PHP and MYSQL
but am wondering if I am deluding myself into thinking I can learn and
cover all the bases in the time I have. Is this something a novice
could do? or should I stear clear!

KC
IMHO, go for it...
You are never to old to learn something new.
Basic PHP programming is easy to learn, but
"Good" PHP programming takes a while to learn
if you don't have the basic. (Again IMHO)
Hendri Kurniawan
Jul 26 '07 #2
<comp.lang.php>
<KC>
<Thu, 26 Jul 2007 02:19:31 -0700>
<11**********************@l70g2000hse.googlegroups .com>
Hi Group, Just joined and would ask if you could give me a reality
check. I have a year left before I take early retirement and would
like to convert some of my work at work from excel (which I know a
reasonable amount) to a database over the firms network. Mostly they
would be simple forms for users to complete, some with lookups for
addresses and existing info. One or two would be more complex
management based databases. I have a couple of books on PHP and MYSQL
but am wondering if I am deluding myself into thinking I can learn and
cover all the bases in the time I have. Is this something a novice
could do? or should I stear clear!
www.outerlimitsfan.co.uk/outerlimitsfan.zip

A full php website for you to tinker with - although it only works on
windows web hosting .

But thats no major issue as you can use if offline on your windows pc
with no worrys .

- download and install XAMPP from apachefriends

- put the outerlimitsfan website into the /xampp/htdocs/ folder

- type in http://localhost into your browser

And away you go - thats all their is to it .

Most of the php code on the OLF website was a get the job and some of
the techniques used arnt ideal - but if you track through it - you
should learn some php basics to get you started .
Jul 26 '07 #3
KC wrote:
Hi Group, Just joined and would ask if you could give me a reality
check. I have a year left before I take early retirement and would
like to convert some of my work at work from excel (which I know a
reasonable amount) to a database over the firms network. Mostly they
would be simple forms for users to complete, some with lookups for
addresses and existing info. One or two would be more complex
management based databases. I have a couple of books on PHP and MYSQL
but am wondering if I am deluding myself into thinking I can learn and
cover all the bases in the time I have. Is this something a novice
could do? or should I stear clear!

KC
It depends on how comfortable you are with programming languages (Excel
macros are not a real programming language) and how much you apply yourself.

The more comfortable you are with other languages, the easier time you
generally have picking up a new language such as PHP. Also, the better
chance you'll be comfortable with PHP.

OTOH, if you've never done any programming other than Excel macros,
you'll have a harder time picking up *any* language, and once you get
into it, may find you love it or hate it - it depends on the person.

However - a year is easily enough time to get a good handle on PHP and
MySQL, even if you don't have any previous programming experience (you
will also need to learn HTML). Start out with some of the easier forms
and see how you like it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jul 26 '07 #4
KC
Thank you for help. I used to tutor MS Office and thought I had a
reasonable grasp of the applications. However I soon found out how
little I knew when I moved into my current job and started doing
things for real.

I think its because of that gap, what you think you know and what
there is to know, that I feel somewhat daunted by it all. I will
however give it a go.

Many thanks once again

KC

Jul 26 '07 #5
On 26 Jul, 15:12, KC <GeneralCoc...@gmail.comwrote:
Thank you for help. I used to tutor MS Office and thought I had a
reasonable grasp of the applications. However I soon found out how
little I knew when I moved into my current job and started doing
things for real.

I think its because of that gap, what you think you know and what
there is to know, that I feel somewhat daunted by it all. I will
however give it a go.

Many thanks once again

KC
Just a thought, take a look at a framework like http://www.phppeanuts.org/
Could help you along a bit.

Jul 26 '07 #6
Message-ID: <11**********************@o61g2000hsh.googlegroups .comfrom
Captain Paralytic contained the following:
>
Just a thought, take a look at a framework like http://www.phppeanuts.org/
Could help you along a bit.

I've learned PHP at a fairly late stage in life and with a similar
background to the OP (IT teacher). It wouldn't have helped me.

As far as possible I like to know what everything does. It's very easy
to get a lot done in a short time using a framework but whenever I've
used one I've always found it equally daunting when I try to tweak the
output to suit my needs.

I suppose it depends what type of person you are. I've written a lot of
code that doubtless re-invents the wheel, and it's probably crappy code
to boot. But it's /my/ crappy code and I know how it works and more
importantly, how to change it if somebody wants something different..

It's a bit like building a house. You could build a prefabricated house
with lots of large components but your options would be limited. Or you
could learn a lot of individual skills and have it exactly how you
liked.
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
Jul 26 '07 #7
KC
Thanks for all comments! In the excel world I use both my own VBA
code and borrowed stuff. and think I'll turn to my books to learn some
basics first and trawl through the archive of this group to pick stuff
up and try to make sense as I go along. I'm sure I'll have to ask
when I get stuck so look forward to your future responses. Many
thanks for the input so far.

Regards

KC

Jul 26 '07 #8
KC wrote:
Thanks for all comments! In the excel world I use both my own VBA
code and borrowed stuff. and think I'll turn to my books to learn some
basics first and trawl through the archive of this group to pick stuff
up and try to make sense as I go along. I'm sure I'll have to ask
when I get stuck so look forward to your future responses. Many
thanks for the input so far.

Regards

KC
I have always found it extremely useful to work with "real" code, as
opposed to samples. Just as you discovered with VB, you'll see tons of
"real" PHP code around. Even better, there are any number of actual
working applications for which the PHP code is easily available.

It's a lot easier to work with an application that one understands, and
I think you might find it useful to take a look at WordPress. It's an
open source blog software with quite a sizeable user base, which
stretches across a large spectrum of people whose programming expertise
ranges from zero to high-octane.

WP's code is mostly PHP, with some javascript thrown in, and it uses
MySQL for its database management. Setup is negligible: create an empty
database in your MySQL server, download the WP code, install it in a
subdir off your website, and go to your browser and navigate to that
subdir... and away you go. The main site (wordpress.org) has a well-laid
out plan with plenty of user doc and lots of "themes" and plugins with
still more code. Even better, one of the themes is a purely skeletonized
one, so you can easily work with it and get immediate feedback. IIRC,
it's called "default-empty".

Jul 26 '07 #9
On 26 Jul, 18:58, Geoff Berrow <blthe...@ckdog.co.ukwrote:
Message-ID: <11**********************@o61g2000hsh.googlegroups .comfrom
Captain Paralytic contained the following:
Just a thought, take a look at a framework likehttp://www.phppeanuts.org/
Could help you along a bit.

I've learned PHP at a fairly late stage in life and with a similar
background to the OP (IT teacher). It wouldn't have helped me.

As far as possible I like to know what everything does. It's very easy
to get a lot done in a short time using a framework but whenever I've
used one I've always found it equally daunting when I try to tweak the
output to suit my needs.

I suppose it depends what type of person you are. I've written a lot of
code that doubtless re-invents the wheel, and it's probably crappy code
to boot. But it's /my/ crappy code and I know how it works and more
importantly, how to change it if somebody wants something different..

It's a bit like building a house. You could build a prefabricated house
with lots of large components but your options would be limited. Or you
could learn a lot of individual skills and have it exactly how you
liked.
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDshttp://www.ckdog.co.uk/rfdmaker/
I'm like you there Geoff, I get on far better with raw code than
frameworks! The only framework I sort of work within is Mambo/Joomla.

Jul 27 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: Craig Bailey | last post by:
Someone please explain what alternate universe I fell into this afternoon when PHP started telling me that 2 doesn't equal 2. Not sure about you, but when I run this, it tells me 59001.31 doesn't...
27
by: mrbog | last post by:
Tell me if my assertion is wrong here: The only way to prevent session hijacking is to NEVER store authentication information (such as name/password) in the session. Well, to never authenticate...
7
by: Tony Johnson | last post by:
Can you make a check box very big? It seems like when you drag it bigger the little check is still the same size. Thank you, *** Sent via Developersdex http://www.developersdex.com ***...
2
by: Travis.Box | last post by:
I have an MS Access userform with 16 Check Boxes. Each of the checkboxes has a different option value, which coincides with the Check Box name (eg. cb01.OptionValue = 1). At the bottom of the...
1
by: scprosportsman | last post by:
Please help guys, i am trying to set up a database here at work and im fairly new to access in terms of writing functions and queries and stuff. I have 2 different places on my design that will...
16
by: Brian Tkatch | last post by:
Is there a way to check the order in which SET INTEGRITY needs to be applied? This would be for a script with a dynamic list of TABLEs. B.
5
by: starke1120 | last post by:
Im creating a check in – check out database for RF guns. I have a table that contains models. ID (primary key) Model A table that contains Gun Details ID (primary key) Model_id...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.