Install Using Book :: Database Driven Website Using PHP And MySql
I've just purchased copy of "Database Driven Website Using PHP and MySql" and have a few problems getting started.
I had tried to install apache via the manual install but could'nt make any sence of it. I them found a program called Xampp. I installed it becuase it included PHP, MySQL and would get apache working as well.
Having read the first part of the book I did'nt think I needed to install any programs and tried to start on Ch 2.
I can't open the msql.exe file or even find it??
View Complete Forum Thread with Replies
Related Forum Messages:
Database Driven Website
We want to develop database driven website. because of enormous amount of data (300GB) customers's tech advisors are insisting on using SAN instead of any direct attached storage method. I want to know what issues need to be considered while using SAN in web solutions.? Which database server/ product is best suited for such kind of job ? Can anyone suggests good informative articles on this subject , available on web?
View Replies !
MySQL Driven Website
I would like to do is create a website that is driven by a MySQL database. The question is, does MySQL have to be installed on the web server by my isp or is there another option. I have read some posts about a MySQL DLL that can be placed on the server instead of a full install, but have not found enough relevent info.
View Replies !
MySQL Versioning Of PHP Data-driven Website
I have a website that I am designing that uses a bunch of PHP scripts to generate pages for a website from data stored in an underlying MySQL database. I have the PHP scripts under CVS, and using Apache and mod_rewrite I am able to access different versions of the website from the CVS project - each with their own set of PHP scripts. The problem is this: I would like to version the MySQL database as well. This means that there would be multiple MySQL databases, with slightly varying schemas on the server. Each PHP version of the website would point to a corresponding MySQL database for its data. Multiple PHP versions could point to the same DB, as long as each PHP version has SQL statements matching the schema of the correspoinding DB. One version of the DB would be a live version of the site (v1 for example, above). Users accessing the site would causes changes to the data in the DB (not the schema, of course). The second version of the DB (v2) would need to basically be a slave replication server, using DB v1 as the master. This will allow DB v2 to be up-to-date with all of the user updates that appear in DV v1. DB v2 is the development copy. As the design matures, schema changes will be made to DB v2. At some point, DB v2 will be made the "live" server, essentially taking the role of DB v1. As long as fields are only added to tables in DB v2 to modify the schema, the developer can easily just feed the updates from DB v1 to v2, to keep the user data current. The complicated part is when schema changes need to be made to v2 where fields are deleted, renamed, moved, etc. What is needed, basically, is a system that can track the ALTER TABLE statements, and appropriately translate the UPDATE statements from DB v1 to the new schema of DB v2. The developer could specify non-obvious and more complicated changes in some sort of syntax in order to clarify the changes to the underlying schema - thus allowing the generation of the proper relational algebraic (SQL) statements from the original UPDATE statements. Does anyone know of an existing system or set of scripts that accomplishes this, or can offer an alternative solution for DB versioning?
View Replies !
Creating A Website Forum: Use Existing Website MySQL Db Or Create A Second Db?
I am getting ready to start coding my own forum.... to seemlessly integrate it into my existing website. My question is this; should I: a) create the new forum tables in my existing database (used for the website user accounts etc.), OR b) create the new forum tables in a separate new database (it would be on the same server with same u/n p/w) Which one is the better option? I've been banging my head over trying to decide which way to go...
View Replies !
Database Driven Listings Section
Im running a small site with weekly listings of bands playing at a venue. I am however fed up of cut and pasting info all the time and changing the HTML whenever a new act is booked etc. Ideally, i want the pages to look and behave pretty much as they already do (www.suicidenotesmusic.net/quidrock/listings.html) but id like me to be able to just have some form that i use to add acts and dates in and it will be put into date order and generate the HTML for me. Hence i could use it as my booking system as well. My server supports MySQL and has PHPmyadmin interface.
View Replies !
Building My First Database Driven Site.
Before I begin, can I just state I have never installed anything on Linux server, so I am very new to this... Okay at the mo I have and using MYSQL version 3.23.58 on my Linux Sever, incase this is important, heres the details of my server: WEB SERVEUR Platform : Small - Fedora Core 3 Control panel : Plesk 100 Config : AMEN 2400 - AMD Athlon XP 2400+ Disk: 80 Gb - Memory: 512 Mb OK, I need to upgrade to the latest MYSQL version. So far, I have downloaded "mysql-standard-5.0.24a-linux-i686.tar" and unpacked the file uner /usr/local This is where I am stuck, I have no idea what to do next.. I need help for someone never done this before, preferbally a guide like... STEP by STEP, type this,
View Replies !
Using MySQL For Website Database Backup / Restor
so apparently MySQL is widely used for web site backup's of databases.....however i cant seem to figure out how that is supposed to work. i am using joomla, and i have a couple ways of makeing .sql backups, but im not sure how i am to put the database on again, or if need be, on a second website. am i making sence? i need a way to "import" my database to a website incase it gets 'nuked' or something. is MySQL the right program for this, or not?
View Replies !
Setting Up A Database And Linking It To A Website ?
Does anyone know how to setup a database linked to a website please ? I would like to setup a database so that when someone fills in their first name and email address to receive newsletters, it can automatically go into a database to be used later to email them their newsletters. The (mysql ?), database in my cpanel is phpmyadmin version 2.8.0.2
View Replies !
Renaming Database, Website Link Problems
I just created a website on a new domain, and created a new database for it. Although I will be modifying the tables, I'm starting off with the same structure and data from the old website, just copied the tables across (export/import). I changed all the references to the old on all the web pages and scripts with the new Username, Password and Database info, but nothing the database info is not coming up, when I run the pages.
View Replies !
How Do You Connect A Phpmyadmin Database To A Website Page
I've worked with websites for a few years, but have never been involved with databases. I've managed to create a database in my phpMyAdmin - the versions are below: phpMyAdmin - 2.8.0.2 * MySQL client version: 4.1.10 * Used PHP extensions: mysql After I created the database, it gave me some code below, but am not sure what the next few steps are: PHP $dbh=mysql_connect ("localhost", "practice_saz", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("practice_test");
View Replies !
Best MySQL Book
I'd like opinions on what is the very best, most thorough MySQL book available--the database equivalent of O'Reilly's "Running Linux". I'm looking for something with lots of reference, a few tutorials, something not as dense as the MySQL manual but not on the For-Dummies level either.
View Replies !
MySQL Book
I was wondering if anybody knows from where I can buy a MySQL book in .pdf, .html, etc. format. Please remember, I do not want a paper book, just a, lets call it virtual MySQL book. I just need some site names or online stores names.
View Replies !
Best MySQL Learning Book?
I've used MySQL for some time now and worked with relational database design enough to know that I don't know enough. Any recommendations for a good learning tool/book? I don't see one from SitePoint... ::gasp!::
View Replies !
MySQL/Perl Book Recommendation For A Beginner?
Here's the situation: I have a Perl-based forum that I wrote myself. It currently supports user accounts, but these are stored in a flat text file (as is everything else for that matter). I'm looking to convert this to a MySQL database so that I can do more with that information, but with less processing time (reading through that huge text file to find something isn't very efficient). In the future I hope to move the whole forum over to MySQL, but I thought a good starter project would be just one aspect of it. At this point I am looking for recommendations on good books for someone moderately experienced with Perl, but who has NO experience with MySQL or anything similar. Since I'd prefer to integrate this with my existing script, I'd rather stick with Perl and not learn PHP at this time. So far it seems like "MySQL and Perl for the Web" is a good - are there others? I prefer reference-style texts with useful code examples, rather than lesson-style books.
View Replies !
MySQL On A Website
I'd like to create a website with a MySQL database to store soccer players details like goals scroed for the season. I want to use it to update my fantasy soccer team through this season, does anyone know of a free host that provides MySQL? Or even better, does anyone have experience of this? I've created an ASP web interface to an Access database and read/written to it like that in the past so I assume it's the same for MySQL.
View Replies !
HOW DO I USE MYSQL WITH MY WEBSITE?
I have an existing website with Netfirms and it comes with "mysql" "php" etc. It is active and have been able to confirm that with tech support. I purchased two books regarding "php & mysql for dummies" and "biginning php5,Apache, mysql Web development" and still I donot have a clear understanding of how to write a script that will allow a website user to interact and or collect information and display information on the website page. I mean this is what it is all about right? Can someone please just give me an example that I can follow on how to actually creat a script to allow mysql to interact with a webpage. And while your add it. whats a good learning tool, book etc to have?
View Replies !
Connect To Mysql From A Different Website?
I have 2 websites that sometimes I want to transfer products from one website to the other. An easy way for me to do this would be site-a connect to site-b DB, select the data, and then reconnect to own site-a DB and save. I dont think security risks would be a big issue because the only thing I would be transfering would be products which dont have any sensitive info connected to them. but is there a way? if not I will just have to do it manually...Im just trying to be sufficient.
View Replies !
Displaying MySQL Data On Website
Currently, our neighborhood directory is in Microsoft Access, and every few years we would have it printed professionally and bound. I have Reports which formats the data for the printed directory. I would like to add the directory to the website, to replace printing it. I can easily create the tables and insert the data. I'm not sure how to go about displaying the directory data. Is there is a way to create a report and display that? Each entry represents a family in the neighborhood, but the fields that contain data may vary from family to family, such as the kids field. Also, I want multiple entries on a page - like a phone book.
View Replies !
Root User And Developing PHP/MySql WebSite
my webhosting company defaulted a root user with no password. I created a user for myself with a password, but wondering if having the root user without a password will leave the database open to intrusion. What's it there for, anyways? On another note, what is a good IDE for developing a PHP/MySQL website that will be served from a UNIX server, but developed on a windows PC?
View Replies !
How To Put Old Database Files Back Into A New Install
I've inherrited a product that is trying to use mysql. Noone seems to recall the root password. I tried all the published methods I could find (--skip-grant-tables and the other one where we set the password in the init files) and none of them work. So, I went to a second approach. I deleted my installation of mysql, reinstalled and reset the root password. Now, I can't figure out how to get the old data into the new installation. Copying the data files into the data directory doesnt work. I assume I need to do some sort of import? I need to import the data and schemas alike.
View Replies !
ODBC Connection To MySQL On Shared Hosted Website
I'm trying to connect to a mySQL database that exists in connection w/ my website. I created the database using c-panel. Everything that I use to access the website from my site uses "localhost" as the host name. I installed the ODBC drivers for Windows on my XP machine and am trying to connect from my local machine. I am not sure what I should use for the hostname in that case -- I tried www.mysitename.com as the host but that didn't work. I also tried the IP address, but that didn't work either. I asked my host's support team, but haven't heard back from them yet. It's a shared hosting service. Any ideas on what the hostname should be?
View Replies !
Import Original Database Files After Clean Install
I am wondering how to import database files stored on a seperate partition into a brand-new MySQL installation. I do not have the old MySQL installation because this is a clean install of XP. I have the actual database folders and table files (the ".frm" and ".opt" files) stored on a seperate partition which were created by a different MySQL installation. Is there a way to do this so the MySQL client will see them? I tried configuring a new datadir and copying the old MySQL data folders and files into the new datadir but that didn't work -- MySQL only sees the default databases created during installation.
View Replies !
JOIN Issue On WIndows Install But Not Linux Install
I am using MySQL 5.0.15 on windows and cannot run this query: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a, building b LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id WHERE a.sortcode=b.sortcode AND a.sortcode like '1,2,1,6%' LIMIT 0, 25 I receive: ERROR 1054 (42S22): Unknown column 'a.createdby' in 'on clause' But this query DOES work under my linux 5.0.0-alpha! I can modify the SQL Statement to the following and it works fine: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id RIGHT JOIN building b ON a.sortcode=b.sortcode WHERE a.sortcode like '1,2,1,6%' LIMIT 0, 25 .
View Replies !
Book Suggestions
I have a couple questions about books. First, let me explain my situation. I have a CS degree, with some basic courses in DB design. I have been a programmer for many years, the last few years in maintaining legacy Clipper applications and CF web programming. We are moving forward, and have chosen mySql as our DB platform. I will most likely become our DBA. What books would you recommend, and in what order? I understand basic SQL, but haven't done anything with triggers, stored procedures, T-SQL, anything like that. Probably the "recipe site" level of design and querying. I think I used an INNER JOIN once
View Replies !
With Php :: Tutorial Or Book?
I have been reading and learning about php for a couple of weeks now and have just gotten to the part where it talkes aboue MySQL. I know very little about MYSQL. I was wondering would you recommend continuing on with where I am in the php book or stop there and read a book about MySQL?
View Replies !
Admin Focused Book
I am looking for a good MySQL book with in-depth coverage of Administration topics. Something written for a DBA, not a programmer. I am trying to expand my skill-set and cannot for the life of me find any books that go into detail enough on Admin Tasks. I was in a few local book stores this weekend and could only find books geared towards the programmer or first time SQL user. That part I know already.
View Replies !
GUI Interface Book By DuBois
I have only read the book by DuBois and used samples at the command line. I would like to use this for work. I am avoiding the IT push to use Microsoft Access. I have 10 people in our group who need to share data (now about 50 excell spreadsheets). What I am really looking for is a GUI that can get me most of the way there. I can have my own server behind the firewall in our corporation so I am free to do my own thing. What I have found on the net so far is: Control Center Front SQLyog NAvicat Any feedback on these? Ease of use and reporting are most important attributes.
View Replies !
Advanced SQL Book Recommendation
I know I've seen requests from time to time for more advanced sql information. I've recently picked up a book I would highly recommend to anyone looking for more than the basics. SQL Hacks (Tips & Tools for Digging into Your Data), it is an O'Reilly book by Andrew Cumming & Gordon Russell. It has 100 tips and covers necessary code tweaks for Oracle, Postgres, MySQL, SQL Server, Access and DB2.
View Replies !
Could Not Load MySQL Driver! Compile Php --with-mysql Or Install The Mysql.so Module.
I am trying to install Media Wiki 1.5.2 on Windows XP and I have already installed apache_2.0.55-win32-x86-no_ssl ,mysql-5.0.15-win32 and php-5.1.1-Win32 . When I am trying to install Media Wiki 1.5.2 I receive the following message : Warning: dl() [function.dl]: Not supported in multithreaded Web servers - use extension=mysql.so in your php.ini in C:Program FilesApache GroupApache2htdocsmediawikimediawiki-1.5.2install-utils.inc on line 17 Could not load MySQL driver! Please compile php --with-mysql or install the mysql.so module.
View Replies !
Mysql RPM Install On FC4
I have just installed MySql 5.0.18 on a fresh installation on RH fedora core 4 using RPMs but the service won't start. Any ideas, can I see a log of why its failing anywhere?
View Replies !
MySQL Install
I am having a program created for me but it is not working. My programmer claims it is because MySQL is not properly running. He says I should see lights from MySQL in the task bar, but I do not.When I run services.msc it says "mysql" "started"
View Replies !
MySQL/PHP Install
Forgive me if I'm being an idiot, this is my first time installing anything on Linux (RedHat 6.2). I successfully installed MySQL (3.23.32) using the rpms (I created a test db that works fine). Now I'm trying to install PHP (4.0.4pl1), but configure gives me the following error: cannot find [mysql] header files under /usr/bin. I'm using the option --with-mysql=/usr/bin because the rpms installed everything there, instead of /usr/local/mysql, which is where I would have installed it if given an option. Poking around I found the header files in /usr/include/mysql, so I tried to specify the option --mysql-includes=/usr/include/mysql, but configure says that's an invalid option.
View Replies !
How To Install MySQL 5.0.37
Please anyone explain step by step to me how to install MySQL 5.0.37 ? I downloded "Windows installer" and "Mysql noinstall 5.0.37".My platform is .NET 2005 with Windows XP professional. Which one is first install? i want to my syatem act as a server and other three systems as client.
View Replies !
Cant Install Mysql
Every time I run the mysql instance config.exe it stops at the 3rd step and it says " can not create windows service for mysql. error 0. I have no idea what this means and why I'm getting this.
View Replies !
MySQL 5.1 Install
I'm a complete newbie and I've just installed MySQL. The application package defaulted the installation to my main drive, but installed the pieces into Adobe Version CS2 Que/data directories. There are pieces of it strewn all over the place. How can I uninstall it, and where should I direct it to be installed. The install 'package' gave me no options other than my main drive.
View Replies !
Cannot 'USE Mysql' In New 5.0.45 Install On Mac
After a new install on a Mac, I cannot USE the mysql database. Even though I cannot USE it, I can select from it. Sean ==================================== $ mysql --user=root Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 6 Server version: 5.0.45 MySQL Community Server (GPL) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+ 3 rows in set (0.00 sec) mysql> use mysql ERROR 1049 (42000): Unknown database 'mysql' mysql> select User,Host from mysql.user; +------+-------------+ | User | Host | +------+-------------+ | root | 127.0.0.1 | | root | 174.6.1.4 | | root | localhost | +------+-------------+ 3 rows in set (0.00 sec)
View Replies !
|
TRACKER
