Displaying text from a MySQL table which can be modified Post: 302454666

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Homework and Emergencies Homework & Coursework Questions Displaying text from a MySQL table which can be modified Post 302454666 by richeyrich86 on Sunday 19th of September 2010 04:46:20 PM

Old

09-19-2010

Registered User

Displaying text from a MySQL table which can be modified

Hi am creating a website for my third year at uni, am trying to create a website where the client can update the content of the site themselves, i will have a news page and i want the content to be draw from my database and displayed on the front end of the site using php, i also want to have an admin side where the client can see whats in my mysql table an update it but i have no idea where to start any help would be great

cheers richie

richeyrich86

View Public Profile for richeyrich86

Find all posts by richeyrich86

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

MySql: create table error

Hi, iam learning MySql. Iam trieing to create a table in the database "guestbook" at the command line in mysql heres what i type but i get a error mysql>create table guestbook ->( -> name varchar(40) null. -> url varchar(40) null. -> comments ...

2. Shell Programming and Scripting

displaying output in a table.

Hello, I've just finished my first script (about displaying open ports on the computer and who opened them) and everything is fine with it but I want to style it a little bit just for the sake of learning how to do this. What I want to do is make the display like the one of ps, for example,...

3. Shell Programming and Scripting

Help Inserting data in mysql table

Cant understand the error #!/bin/bash temp="" A="" D=$(date +"%Y-%m-%d") H=$(date +"%R") temp=$(wget -q -O - website | grep -o "Temperature:]**" | grep \-E -o "+") mysql -D "weather_wise" -e "INSERT INTO weather (Date, Hour, Degrees) VALUES ($D,$H, $temp)"; my data types for...

4. Programming

API C MYSQL vs lock table ???

(sorry for my english) Hi, i have an app that uses MYSQL API C.. i trying do a timeout until the table is locked by an other thread , in the docs of Mysql i can see that MYSQL_OPT_READ_TIMEOUT is not implemented for linux �?�?.. any body knows a way to do a timeout until the table is locked by...

5. Shell Programming and Scripting

Compare file of hostnames with table in MySQL DB

Hi all, i have a list of files that contains some PC hostname, then i need to enumerate every hostname and check if there's a table with same name of the hosts in MySQL database XYZ. I need this because have to decide automatically if i have to make a create table or a insert into an existent...

6. UNIX for Dummies Questions & Answers

Displaying text from a MySQL table which can be modified

Hi am creating a website for my third year at uni, am trying to create a website where the client can update the content of the site themselves, i will have a news page and i want the content to be draw from my database and displayed on the front end of the site i also want to have an admin side...

7. Shell Programming and Scripting

mysql how to select a specific row from a table

i have a table records ------------ id | user | time | event 91 admin | 12:00 | hi 92 admin | 11:00 | hi 93 admin | 12:00 | bye 94 admin | 13:00 | bye 95 root | 12:00 | hi 96 root | 12:30 | hi 97 root | 12:56 | hi how could i only select and display only the user and event from...

8. UNIX and Linux Applications

mysql table disappear

I have set a mysql file to excute everyday morning to generate a html file displayng 2 tables from the database. Sometime they cannot be shown, and it shows the tables are not existed. I have not drop any table, and those 2 tables are not used by any other excution. Anybody know what is happening?...

9. Web Development

PHP table isn't displaying

I have a PHP script which connects to a MySQL database and should output a table in HTML. I have tired to set up a long-polling AJAX script to poll my PHP script every second. It seems to work based on what I can see in my browser debugger, however the table isn't showing on the page. Can anybody...

LEARN ABOUT PHP

mysql_get_client_info

MYSQL_GET_CLIENT_INFO(3)						 1						  MYSQL_GET_CLIENT_INFO(3)

mysql_get_client_info - Get MySQL client info

SYNOPSIS

       Warning

	      This  extension  is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
	      be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

		     omysqli_get_client_info(3)

		     o PDO::getAttribute

       string mysql_get_client_info (void  )

DESCRIPTION

       mysql_get_client_info(3) returns a string that represents the client library version.

	The MySQL client version.

       Example #1

	      mysql_get_client_info(3) example

	      <?php
	      printf("MySQL client info: %s
", mysql_get_client_info());
	      ?>

	      The above example will output something similar to:

	      MySQL client info: 3.23.39

       mysql_get_host_info(3), mysql_get_proto_info(3), mysql_get_server_info(3).

PHP Documentation Group 												  MYSQL_GET_CLIENT_INFO(3)