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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
Displaying My Mysql Data
$query2 = $DB->query( "SELECT post FROM mkp_blog_post WHERE id_blog='2485' ORDER BY 'id'"); I simply want the results of this query to show up on my page. I know the query works, because I tried it in PHP Myadmin, and it gave two results. However, when I go the page, it doesn't work.Yes, I have more lines of code after that, but nothing I have tried has worked. Does anyone know what I would need to write afterwards as so this would appear on my page? Thanks!
View Replies !
ASP Not Displaying Time Stored In Mysql Displaying Date Instead.
I seem to be having a problem displaying time stored in mysql. The format stored in the database is 13:15:05. The database data type is time. I'm using asp vbscript and sql to retrieve the time store in the database. However asp recognizes the data type as date and displays the date instead of the time. If I change the data type in mysql to varchar then asp will display the time correctly, but I cannot do it this way. I want to be able to convert the data type in asp to string from date.
View Replies !
Displaying Data
I have a database with about 20 names in it. I need to be able to create a php query that will show the data one at a time so the user will have to click a button to show the next record. Any ideas on how this is done?
View Replies !
Displaying Column Data As Bin
We have Designed a Table with 80+ Columns with Engine MYISAM We have declared some of the Columns as the Datatype Varchar(200) , int(11) etc. When we retrieve the Data using Select Query with Union Clause we see some of the Column Data displayed as bin but we do not declared any Column as Data Type Blob Or Long blob etc.
View Replies !
Displaying Data From Two Tables
have two tables table 1 = "product_list" with the following fields: ID prodct_name unit_price parent_category_id data displays as follows: id product_name unit_price parent_category_id optional_stock_id 1233 Brunsfelsia 20lt 125.50 344 table 2 = "category_structure with the following fields: Id category_name parent_category_id id category_name parent_category_id 341 Plants & Trees 0 342 Conifers 341 343 Plugs & Trays 341 344 Standards 341 345 Shrubs & Ground Covers 341 346 Palms 341 347 Toparies 341 ........
View Replies !
Displaying Data From Three Tables
I have three tables I am working with. There is one table I would consider the "main table" which includes log entries. The log entries in the "main table" store username as a number. A second table has a primary key of a number and the number maps to an actual active directory username. How can I select data from these three tables but have it display the actual username instead of just the userid number (which in and of itself doesn't mean anything)?
View Replies !
Displaying Certain Amount Of Data
I have created a script. This script of mine takes data off of a table and displays it on a web page. What I want is for the script to display only data that matches the id of another section of the web page. For example, the script would first point to another factor in the database, perhaps the value of a row in another table. Let's call that value 025. In a second table, I have a few rows of data. Their ids were 025, 026, 027 and 028. The web page would only display rows with the ids of 025. However, if that value in the other table was 026, then in the second table, the rows with id 026 would only be displayed.
View Replies !
Displaying Data From Db Onto Webpage
I have jus created my test database with one table and 5 rows of data using phpMyAdmin. Now I want to display this data on a webpage using php. Any ideas on how I can do this? database name is "test" table is called "users"
View Replies !
Displaying Data From A Row With SELECT
When someone clicks on a thumbnail image in my gallery.php page it takes them to my view.php page which is where this code is. The large image displays properly and the "im_name" is printed in bold. But from the database I have comments "im_comments" about this image that I would like to also to print and that part of the code is not working. Can someone see the mistake? Code:
View Replies !
Displaying Row Data Only When Occuring First Time....
Please have a look at the following query: mysql> select * from t1 where person in ('G.W. Bush', 'Saddam Hussein'); +----------------+-------------+ | person | disease | +----------------+-------------+ | G.W. Bush | dyslexia | | G.W. Bush | cretinism | | G.W. Bush | alcoholism | | Saddam Hussein | sore throat | | Saddam Hussein | dyspnea | +----------------+-------------+ 5 rows in set mysql> Now my question: Is it possible to format the output in a way, that only the first occurrence of 'person' is displayed? Like: +----------------+-------------+ | person | disease | +----------------+-------------+ | G.W. Bush | dyslexia | | | cretinism | | | alcoholism | | Saddam Hussein | sore throat | | | dyspnea | +----------------+-------------+ 5 rows in set mysql>
View Replies !
PHP Catalogue: Displaying Data Issues
I had to try and create a series catalogue script. Basically, each series listed has a category it is sorted into, various tidbits of data on it, a description and a genre it is sorted into. To sort each series into one or more genres, I did the same as I did to sort it into categories, thus the genre is basically a category. What I want to do is display the tidbits of data, the description and the genres on one page. Code:
View Replies !
Displaying Data With Sequenced Serial Number
Im fetching some data from database using select query where it lists all names but i like to have that list along with some serial number or id in sequence. I dont have any serial number or id as column but I want it to be like this select names from table_name; id Names ------------------- 1 Peter 2 Rose 3 Jack Is it possible, if yes how..
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 !
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 !
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 !
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 !
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 !
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 !
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 Replies !
Displaying MySQL Dates In PHP
I have several fields in my database that are of type 'date'. I want to display this in a browser, but the display seems to ignore the data in each field and uses the following dates only. Jan 19 2038 jan 1 1970 I have been using PHP's date() function to display the data.
View Replies !
Displaying Mysql Search Results
I am hoping someone can help me with this. I have a php listing page that displays all records in my database. Each listing has an expiration date (in mysql format: 0000-00-00). How would I write code to only display records with an expiration date of today or later? I don't want to delete expired records, but I do not want them to appear on the listings page.
View Replies !
Dreamweaver Displaying MySQL Error
DW is behaving strange... In short, recordset is not allowing the ussual user to connect to a DB, DW displays an alert box saying: "Acces denied for user: database_user@localhost (Using password: YES)". This user have a working password, checked by running the web application with this user and no problems, but inside DW it only allows root user. It doesnt allow the other user even if I set up that user equal as the root in privileges.
View Replies !
Displaying Picture From A Mysql Table
I have a database named dmtp with tables cities and markers. I need to display an image stored as mediumblob in markers, in dmtp. now I am using the syntax like this - $result = mysql_query("SELECT cities.cityname, cities.citybuslink,markers.picture, markers.information FROM cities, markers where markerid = 1 AND markers.cityid = cities.cityid "); while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" .$row['picture']. "</td>"; echo "<td>" . $row['information'] . "</td>"; echo "</tr>"; } However, the part where the picture should be displayed shows all garbage values, any idea on how to display the actual image stored inside the database ??
View Replies !
Uploading Images To MySQL And Displaying Them
I am working on a site that is heavy on template usage and therefore am in the position to use one template to grab content (including images) from a database. This seems like an easy enough question, but none of the materials I have cover the basics on how to accomplish something like this.
View Replies !
Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row = mysql_fetch_row(result)) != NULL) { printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL")); } I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.
View Replies !
Using MYSQL For Displaying Images... Google Maps
I am working on a google map application, and would like to display image thumbnails in the little white info window. I would like to get these from the database... has anyone done anything with images and databases? I need some help getting going on how to set up the database and make it run smooth and quick. Right now I have a db table called files with these fields: ID ShortName MimeType MimeName FileContents
View Replies !
Problem: Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row = mysql_fetch_row(result)) != NULL) { printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL")); } I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.
View Replies !
Using A DB In A Website
I want to create a website where users can select (from a dropdown box) and then view various PDF files. I also need the capability to upload and store these PDF's. What's the best way to accomplish this?
View Replies !
Website Error
I have image hosting website. When I type in the the website name in the address bar of the browser, I get the following error: Couldn't connect to database server: Access denied for user: 'imgbiz@linhost120.prod.mesa1.secureserver.net' (Using password: YES) I am not very familiar with PHP or MySQL. Could someone let me know if it makes any sense or what I should be doing to correct this error? (it would help if someone might have had this error and resolved it, could help me out here) I have changed the username, because it was much more easier to remember. Does this cause any problems in the website being displayed? I have changed it going through phpMyAdmin/admin. Is there any other file that I need to change this information so that it works?
View Replies !
How Do I Set The Tables For My Website
I have usually done my websites with Access and all I had to do was transfer a MDB file, and put the path in the data connection and it was working. How do I do this with mySQL? Do I upload a file(s) and change the datapath or??? I am using ASP (not .NET) and the server is hosted elsewhere by a local company.
View Replies !
Website & Intranet - 1 DB Or 2?
I've been working on our company intranet for some time now and it's finally (more or less) been completed. The next phase is working on our internet website. The website will offer merged functionality (ie online quoting that is available to employees on the intranet, etc) and I was wondering the best way to tackle this project. My first thought is that the databases should be separate. That is, one for the intranet, one for the website. If at such time I need to gather data from both I can run a query and simply select the database to use. My question is: is there a reason that I should use two separate databases instead of just using separate tables - besides perhaps the fact it might be easier to manage? If anyone out there has done similar in the past, what did you find out/learn? As mentioned, some of the functionality will cross. For example, when a potential client enters information to be provided a quote, that information, based on certain characteristics (name, etc) will be made available to certain employees for the purposes of quoting and providing that quote to the applicant. I can see where I would need to be able to use information from both databases to run a query for this, so it might be easier if it's all in one table. However, there will be personal information so security is of concern also. Does using two separate dbs help in this regard? Either way, there are security measures in place to protect the integrity of the data but I'm curious if this "extra" layer is necessary. (This is a php/mysql integration btw which may have been obvious.)
View Replies !
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 !
Double Quotes Appear As ? On Website
I have an Excel file (which is converted to csv by a tool and then uploaded to a MySQL database) and then php is used to display the data on the website. In the Excel file i have text fields which has data containing double quotes. They end up appearing at ? question mark on the website. Any idea how to dispaly the quotes Should i be carefull of any other invisible characters in Excel which can mess up the data.
View Replies !
Website Suddenly Freezes
mysql> show processlist; +------+--------------+-----------+--------------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+--------------+-----------+--------------+---------+------+-------+------------------+ | 1851 | root | localhost | admin_soccer | Query | 0 | NULL | show processlist | | 2538 | admin_soccer | localhost | admin_soccer | Sleep | 8 | | NULL | +------+--------------+-----------+--------------+---------+------+-------+------------------+ 2 rows in set (0.00 sec)
View Replies !
Website Freezes Due To Locks
I have used this command for database back up mysqldump -u USER -pPASSWORD --skip-extended-insert --lock tables DATABASE | gzip dump.sql or mysqldump -u USER -pPASSWORD --skip-extended-insert DATABASE | gzip dump.sql But even though i use lock tables or not , my website freezes for that period of time untill backup is finished. Is there anyway that users should be able to use website during backup
View Replies !
Moving DB/website To Another Server
I exported my database so that I can move my website to another server PC. Upon importing into the new MySQL server I get this error messsage. I had a look at MySQL website but to no avail I still did not know what it means or how to solve it. Code:
View Replies !
User Interactive Website
I want to make an interactive website where people have to register to interact. (like fill out a form giving loging information and stuff). I want to do this using PHP/MySQL. Would anyone please show me how to do this, or give me a link to a website/tutorial that will?
View Replies !
Creating Website Search
I am attempting to create a search engine for my website. I have found a php script that should help me accomplish what I am trying to do, but I cannot get any search results to appear which means I have one or several or all of my parameters incorrect. Right now, I have the search included on a separate page, and while I have connected the script to the database so that it no longer says 'Could not connect to database' or 'Access denied,' I cannot get any search results to display. Code:
View Replies !
How To Use The Store Procedures For My Website?
As we all know that mysql is available with store procedures. But i dont know how to use the store procedures for my website. as i heard that we cannot use the store procedures for live site. we can only use store procedures for desktop application.
View Replies !
|
TRACKER
