I do some website design here and there occasionally for a few clients
and I've got a new one that wants a database with their website that
will display pricelists displayed for their products and they want the
ability to have individual logins for their customers. I'm more of a
designer than a programmer and I've never really done anything complex
with a database before, and certainly nothing with MySQL. I had
someone who I thought was going to do the database part with me, but
he no longer wants to do it. So I was wondering if its possible to
learn MySQL in a motnh or so well enough to allow it to interface with
a website and do what this client is suggesting? Does anyone have any
helpful tips, tutorials, books etc that would help me do this fairly
quickly? Being a full time college student taking summer classes I
already feel swamped! But I want to try to get this working if
possible. Thanks in advance! 2 1645
In my opinion it's not the mySQL part that is difficult but rather the
ASP,vbScript, php or whatever language you'll be using to interface the
webpage with the database.
The database just stores the data. I'm using mySQL now. Once you have it
running on a server and the tables created it is just accessed (to edit,
add, delete data) via your pages.
mySQL has a decent online manual: http://dev.mysql.com/doc/mysql/en/index.html
"David" <dm******@yahoo .com> wrote in message
news:36******** *************** ***@posting.goo gle.com... I do some website design here and there occasionally for a few clients and I've got a new one that wants a database with their website that will display pricelists displayed for their products and they want the ability to have individual logins for their customers. I'm more of a designer than a programmer and I've never really done anything complex with a database before, and certainly nothing with MySQL. I had someone who I thought was going to do the database part with me, but he no longer wants to do it. So I was wondering if its possible to learn MySQL in a motnh or so well enough to allow it to interface with a website and do what this client is suggesting? Does anyone have any helpful tips, tutorials, books etc that would help me do this fairly quickly? Being a full time college student taking summer classes I already feel swamped! But I want to try to get this working if possible. Thanks in advance!
Robin wrote: In my opinion it's not the mySQL part that is difficult but rather the ASP,vbScript, php or whatever language you'll be using to interface the webpage with the database. The database just stores the data. I'm using mySQL now. Once you have it running on a server and the tables created it is just accessed (to edit, add, delete data) via your pages. mySQL has a decent online manual: http://dev.mysql.com/doc/mysql/en/index.html
"David" <dm******@yahoo .com> wrote in message news:36******** *************** ***@posting.goo gle.com...
I do some website design here and there occasionally for a few clients and I've got a new one that wants a database with their website that will display pricelists displayed for their products and they want the ability to have individual logins for their customers. I'm more of a designer than a programmer and I've never really done anything complex with a database before, and certainly nothing with MySQL. I had someone who I thought was going to do the database part with me, but he no longer wants to do it. So I was wondering if its possible to learn MySQL in a motnh or so well enough to allow it to interface with a website and do what this client is suggesting? Does anyone have any helpful tips, tutorials, books etc that would help me do this fairly quickly? Being a full time college student taking summer classes I already feel swamped! But I want to try to get this working if possible. Thanks in advance!
You seem to need a short term reference. I have found O'Reilly's "MySQL
Cookbook" useful. At the link below you can evaluate the book online
free for fourteen days.
Hope this helps. http://safari.oreilly.com/?x=1&mode=...c=1&u=1&r=&o=1 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Don Crossman |
last post by:
Assume a MYSQL table, foo.
One column, bar datetime.
Two rows:
2004-01-01 08:00:00
2004-02-01 08:00:00
select * from foo where extract(day from bar)=1;
2 rows in set...
|
by: craig |
last post by:
RH 9.0
user mysql
command /usr/sbin/mysqld
mysql is being loaded at boot. the previous is listed when I check
what process are running with < ps -aux >
however:
$ ./bin/mysqladmin version
|
by: windandwaves |
last post by:
Hi Folk
Some of you may be interested in a function that allows you to add/substract
from a date in PHP, using a MySql Dateformat (e.g. 2005-10-31) (NOT TESTED):
Any comments appreciated.
<?php
/*
|
by: svein.tjonndal |
last post by:
I have the following query:
select DATE_FORMAT(accountingdate,"%c") as month,sum(totalprice -
freightcost - insurancecost - vat2 - vat3 - vat4) as totalprice from
invoice where cancelled=0 and deliveryagentid=0 and (employeeid=0 or
employeeid=37 or employeeid=53 or employeeid=50) and
DATE_FORMAT(accountingdate,"%Y")="2005" group by month order by month;
Giving the following result in MySQL (correctly):
+--------+--------------+
|
by: Fred |
last post by:
Hello,
Our website is currently developed in ASP/Mysql 4.
The dedicated servers on which it is currently hosted arrive at saturation.
Here is their configuration:
- 1 server PIV 2,8Ghz 1GB RAM with IIS 5 on Windows 2000
- 1 server Bi-xeon 3Ghz, 512 MB with MySQL 4 on Windows 2003
The website makes approximately 10.000.000 of pages seen and 310.000
| |
by: dongletran06 |
last post by:
Hi,
Please help me find out what wrong with my codes in inputting from my form to mysql database using drop down menu. Below is the codes I used. Only the drop down is not working but the "input text" are successfully adding data to mysql. I just try first using the month as drop down. The month data type I used in mysql database is varchar. Im new in PHP please help me. Thanks
<?php /* Created on: 10/12/2006 */ ?>
<html>
<body>
<?php...
|
by: prosad |
last post by:
hi,
have a mysql query that orders entry by complaint category.
this query is then used with mysql_fetch_array to generate table of records ordered by complaint and other parameters.
i can alter color for every even and odd row but how can i alter row color based on each specific 'ORDER BY' mysql query?
so how can i change color for every unique order of
$stat_rec.
my code below:
|
by: dkyadav80 |
last post by:
Hi guys,
I have a form in html , all description below:
first: name of persion (input type box)
second: job profile (input type box)
third: experience from: list box (Month : Jan, Feb,.. format) and
experience to: list box (year: 2008,2007,2006,...)
In Mysql database only 4 filed,
1. Name(data type - varchar),
|
by: janetopps |
last post by:
I have a news website, with asp pages, which was on Access, and i upgraded to MySQL, i used Bullzip to transfer the data. It had about 1000 pages, which im now able to pull up on the public side. Im sorting out a few glitches though.
Since i upgraded from ms access database to MySQL, i have added about 4 articles to test the new setup. I note some fields aren't being added in the new mySql database for the new 4 records. When i ran the MySQK...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |