kobra500
Mar 7 2008, 08:56 PM
| | Hi I was reminded of this earlier by a post in a topic, meant to post it but forgot and the topic on php books reminded me.
Well anyway there is tyhschools for learning php (unless someone else knows a better 1) but I wan't to know what is the best site for using php with mysql (using phpmyadmin) also whats the difference between postgresql and mysql? though I must admit the postgresql version of phpmyadmin whatever it's called looks better (visually)! |
Reply
jlhaslip
Mar 7 2008, 09:24 PM
1. MySql and PostGre are both Open Source - Relational Database Management Systems. I don't think the Trap continues to support PostGre, but I might be wrong. The Cpanel includes all that junk regardless of whether they are installed or not. 2. For a Beginner's Tutorial on php and/or mysql, check over at w3schools.com or tizag.com. After you master a few things, use google to find a few more sites that are different or more challenging.
Reply
rvalkass
Mar 8 2008, 09:05 AM
QUOTE(kobra500 @ Mar 7 2008, 08:56 PM)  Well anyway there is tyhschools for learning php (unless someone else knows a better 1) but I wan't to know what is the best site for using php with mysql (using phpmyadmin) If you want to use PHP with MySQL, you wouldn't be using phpMyAdmin. phpMyAdmin is basically a user-interface to MySQL, that allows you to manage your databases easier than using the command line, and it happens to be written in PHP. For using PHP with MySQL there are a whole load of possibilities. Personally, I find learning by example incredibly useful, and the PHP site has plenty of documentation and examples for MySQL and for MySQLi (the improved version, allowing for lots of new functions). I also quite like using the Zend Framework, as it has excellent support for databases and makes everything much much easier than if you tried to do everything yourself with straight PHP functions. There is plenty of documentation with examples. The O'Reilly series of books are also an excellent resource if you don't mind shelling out a few quid for a second hand copy. They have loads of titles relating to PHP, MySQL, and specifically to combining the two effectively. QUOTE(kobra500 @ Mar 7 2008, 08:56 PM) also whats the difference between postgresql and mysql? Not a massive amount to the average user. If you intend to have thousands and thousands of rows in your tables, you might like to look into performance differences, and there are a few other small differences between the two, but nothing that will really cause you any problems.
Reply
kobra500
Mar 8 2008, 01:13 PM
I was talking more when i said php mysql about connectivity between them
Reply
rvalkass
Mar 8 2008, 02:05 PM
Take a look at the links in my last post - they all deal with using PHP and MySQL together to create database-driven websites. The links to the PHP website focus on the various functions available to you to connect to a MySQL database, and to run SQL code on that database. The Zend Framework link does exactly the same, but using the popular Zend Framework, which makes life a lot easier (for example, it has functions to build SQL queries for you). W3Schools have a comprehensive reference and tutorials for dealing with PHP and MySQL, and make a good introduction to combining the two. Lots of people start with W3Schools for HTML and CSS, and we can assume their PHP help is also fairly similar to what people are used to learning from. Pixel2Life has a PHP section, and if you pick a tutorial dealing with databases too, you will be introduced to the basics of connecting to MySQL and using it in your own development. However, as all the tutorials are independent, I cannot vouch for their quality or usefulness. Personally, I don't think a website can compensate for a good book. Take a look at the following, which deal with using PHP and MySQL together to create database-driven websites and web-based applications: http://www.amazon.co.uk/Learning-PHP-MySQL...3591&sr=1-1http://www.amazon.co.uk/Web-Database-Appli...3591&sr=1-2http://www.amazon.co.uk/PHP-MySQL-Web-Deve...3591&sr=1-1
Reply
Recent Queries:--
mysql - 1.22 hr back. (1)
Similar Topics
Keywords : sites, learning, php, mysql
- How Did You Start Learning Php?
(2)
Best Way To Start Learning Php
(7) So Im fully versed in pre-fab php models like e107 and php nuke but I lack the intimate knowledge of
the code itself. Whats the best way to immerse myself into the details of constructing and
designing code? Im thinking about hitting up the books a million, any rec. on books? links?....
Xampp How Can I Generate "automatic Start Sites"
(7) I am new using XAMPP and PHP. I am trying to build website using Joomla which is required my
computer to have php. So i installed this XAMPP and install my joomla website. My questions is
everytime i type localhost is not going to my joomla website that i built. it always goes to
localhost/xampp. i know i have to configure the httpd.conf but i have no idea how to configure this.
can anyone help me with this. my website folder called "test". how do i redirect to this test folder
so that everytime i type local host it will open the test website. I really appreciate your he....
Learning Php
(9) hey People ... i m really interested in Learning PHP Programming .. so plzz cud u suggest me from
wher should i learn PHP .. There r no Institutes that teach PHP in India ! .. So could u all
suggest me some real good stuff from wher i cud learn PHP .. As u trapsters r good in PHP ..
!! .. Thnxzzz `` ! ....
Create Table - Mysql Code - Help
(1) I need your feedback about setting the database issues. Please, review them and correct some entries
in the code if they got some mistakes. This is the code itself: SQL CREATE TABLE
`news` ( `id` int(250) NOT NULL auto_increment, `title` varchar(255)
NOT NULL default '', `text` text NOT NULL, `author` varchar(255) NOT
NULL default '', `valid` varchar(255) NOT NULL default '',
`date` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE = ....
Mysql Error
(3) ok i need some more help from the wonderful coders here at Trap. I'm almost done with my CMS
script, but i'm having a problem with the installer.php file, when it trys to inseret the user
data into the database i keep getting the following error: CODE mySQL Error: You have an
error in your SQL syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near ';INSERT INTO `members` (`id`, `name`,
`username`, `password`, `email`, `title`) ' at lin....
Html Form!
Using MySQL?! (4) Hey, I need your help again! I need some good working tutorial how I can update my SQL through
HTML form. I did use some tutorials online found with the help of google; but they do not work
properly; I mean there are still small mistakes. I need to have a good tutorial to follow. It
should be based on security and more things. It has to be done in proper way.......
Best Php And Mysql Editor For Noobs
anyone any php or mysql editor that is good for noob (6) hi there guys, from my previous posting, i am a noob in php and mysql programming. I want to know
if there are any php and mysql editors which are best for me as a noob. i appreciate your kindness
....
Php And Mysql Programming
anyone knows a code for mysql and php (2) hi everyone! I am making a program using php and mysql...I am a noob on this so i need your
help guys...I want to make a simple program that will some values and then store them on a database
and then retrieve them...uhmm let me give an example out put of what i need. This is the example
say..: Enter First Name: Enter Last Name:
Enter Age: Enter Address: ..those
are the data needed for input values...my question now is how can I make a database....
Php Calculator That Calculates Genetic Percentages?
I need help finding sites or tutorials. (2) Okay, I have created, looked, and generally studied simple PHP calculators. However, I can not seem
to find any tutorials on how to create a genetic calculator. One that calculates genetic percentages
similar to that of Punnette Squares. I have seen plenty of websites that have these types of
calculators, but I have yet to see any websites offer tutorials on how to create these types of
calculators. So.. does anyone know of any tutorials I can find or sites that might have the tutorial
I am looking for? Maybe even a tutorial here? Reason for asking: I am creating a webs....
What Are The Best Books For Learning Php
Please suggest a book (8) I would love some recommendations on what books are most helpful for learning PHP. I know XHTML,
CSS, some Javascript. I do know some PHP as well. Also can someone also recommend some books on
Advanced PHP, that actually shows how to create a fully functional and somewhat complex
website/application. (Like RailSpace does for Ruby on Rails)....
Tools Needed!
PHP & MySQL (9) Hello, everyone! I need some tools for those two things to test PHP scripts coming together with
database on my laptop, instead checking them on a web-server which takes time.....
Php + Mysql Question!
While inserting data into MySQL, how can I know if the data I'm in (4) Basically, I want to know if the Data I'm inserting through a Form is already there or not. Sort
of a Username registration page. I have this, but it doesn't appear to work... CODE
$result = mysql_query("SELECT * FROM users WHERE
username='$username'"); if($result == 1) { echo
'<h1>ERROR!</h1>The username you have chosen already exists!'; }
....
Mysql Won't Update
(4) Ok, so I'm making some arcade administration software so I don't have to add games the hard
way, well anyway, one of the features I have is that on the homepage is a featured author and as
such I just have it so it updates one line in the mySQL. Well, the page with the form passes on the
varibles fine and the updating page recieves them because I echoed everything, then I build the
query and I even echo the query and it comes out exactly how I want it to, but for some reason, the
database itself won't update even though all the varibles are there. Here's....
[php/mysql]id Trouble [resolved]
(3) session_start(); include "database.php"; if (!$_SESSION || $_SESSION { // User
not logged in, redirect to login page Header("Location: main.php"); } $result =
mysql_query("select * from users order by id asc"); while($r=mysql_fetch_array($result))
{ $username=$r ; $info=$r ; $msn=$r ; $email=$r ;
$id=$r ; $password=$r ; $userlevel=$r ; echo "
user ID User Level U....
[mysql/php]need Som Basic Help
(13) QUOTE session_start(); include "database.php"; include "edit.inc.php"; if (!$_SESSION
) { // User not logged in, redirect to login page Header("Location: main.php"); }
if(isset($_POST )){ $email = $_POST ; $msn = $_POST ; $info =
$_POST ; $updateemail = "UPDATE users SET email = '$email', msn =
'$msn', info = '$info' WHERE username = '$username'";
mysql_query($updateemail) or die("culd not edit your info"); echo "info updated"; } //
Display log....
[mysql]get Id Of Loged In User?
(7) how to get the id number of the loged in user? my db is id. username. password. i have tryed a
few things.. but i never seem to get it right /ohmy.gif" style="vertical-align:middle" emoid=":o"
border="0" alt="ohmy.gif" />....
The Artists Tutorials :mysql Basic Commands
The Artists is an online programming unit and gfx designing clan. (0) Let's Talk about basic mysql commands used in php. I will now show you a list of the most common
MySQL FUNCTIONS : QUOTE mysql_connect(MySQL server name,username,password) - opens a connection
to a MySQL server. mysql_select_db(database name,connection id) - selects a database residing on
the MySQL server. The database name parameter referes to an active database on the MySQL server that
was opened with the mysql_connect function. The connection identifier is a reference to the current
MySQL connection. mysql_query(sql query) - sends a query to the currently ac....
Problem With A Mysql Join
Problem with a mysql join (2) Hello I am trying to write a script whereby I can pull an image out of one database table and
display it in relation to its category_id in another table. I am using a my_sql join function that
is joining the tables correctly, however it only shows the one same image from the top field of
those combined rows on every single page. I need it display the image according to its category_id
for that particular page. I am thinking I need to set variables to represent those specific rows but
I'm not sure how to do that. Here is my code CODE { $result = mysql_que....
Some Mysql Basics
(4) Greetings this tutorial will show you some mysql basics.. MySQL is one of the most used database. a
simple config file at the top add this CODE <?php ?> after <?php add
$username= "root"; // Username that has access to your database $password=
""; //Password that has access to your database $host = "localhost"; // The
host where the database is (mostly this is localhost) $db = "databasename"; //
The name of the database where you want to work with //connect to the database mysql_connect(....
Learning Php -- Where Do I Start?
I want to learn PHP (16) Ok so i have been using html for about two weeks and i was wondering what PHP is and if there is a
website that you can go to, to learn it. I heard that it is better than html but I'm not really
sure.....
Good Source For Learning Php
(13) http://www.bicubica.com/ This website explains everything about PHP, right from the basics. it
also explains about Installing apache and PHP and configuring them. The site is very useful for
newbies and also experts.....
Php Search Engine Script For Mysql Database
(11) A search engine is provided to facilitate the user with undemanding and clear-cut search options.
The search facility includes simple search, search by title, search by word/phrase, ect… Thus, the
user is at a safe distance from the risk of selecting files/folders ambiguously. In addition, a
history of recent searches can be preserved for future perusal. Now
day’s visitors have a large option for his needs on internet and so visitors are not vesting their
time by following the dead links on your site. So a search engine is essential for your....
Creating Profiles In Php/mysql ?
(7) i've started to learn php..im familiar to basics of php and mysql now.Now for example i want
that some user can register to my website , and after that he can Login and log out , and he can see
his profile.is there any tutorial about this ? or any helping url .. or any helping answer please
/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />....
Subquery In Mysql
(5) Is there anyway to make subqueries work in MySQL? I'm pretty certain someone out there knows
how. /smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /> Can anyone help?
CODE Select * from ITEMS where ID="Select Max(ID) from ORDERS"; This works
for MSAccess and SQL Server but why not in MySQL? I'll be writing some reports and I've
shifted database from MSAccess to MySQL. Help! Thanks.....
Can You Add Images Into A Mysql Database?
Using Php? (20) I'm learning php in class right now, but I'm still not that good at it, what I'm
wondering is when I write the php so that it can connect with a database, can I at the same time
have it that it is able to display back images that I choose. Like, I want a search feature, where
you can search for a keyword, and it will bring back a list of all the possible entries with that
keyword, but each of these entries will have a photo associated with it. Now, do I put these image
files directly into the database, or do I write the code to link them from my files to th....
Increment A Mysql Column
how to increment a MySQL column one unit (7) Hi, I have a column in a MySQL table which contains a counter of the views of the object described
by this table. I would like to increment this value by one everytime the object is viewed. Obviously
came into my mind the possibility of retrieving the value of this field, store it in a variable
increment this value by one and perform an UPDATE query again with this new value. My question is if
there is a MySQL option to update the field with its actual value plus an unit increment. I hope you
understand the issue.....
Php News Script
how to make news script that uses MySQL writen in PHP (19) How to make a News script with PHP + MySQL So..in this tutorial i will explain how to create PHP
news script. first we have to create the table in My SQL.. with the code below you will do this (
you have to enter it into SQL field ..in PHPmyADMIN) CODE CREATE TABLE news ( id
int(10) unsigned NOT NULL auto_increment, postdate timestamp(14) NOT NULL, title
varchar(50) NOT NULL default '', content text NOT NULL, PRIMARY KEY (id),
KEY postdate (postdate), FULLTEXT KEY content (content) ) >>....
Many Php Script Sites
(16) Hi I find many sites has PHP scripts :: http://www.proxy2.de/scripts.php http://www.free-php.net
http://knubbe.t35.com/ http://www.ngcoders.com/ http://www.oxyscripts.com/
http://www.phparena.net/ http://www.1phpstreet.com/ http://px.sklar.com/
http://www.scoznet.com/ http://php.resourceindex.com/ /blink.gif' border='0'
style='vertical-align:middle' alt='blink.gif' /> ....
Problem On Mysql "order By"
(5) Can someone please help...? I have a problem with using "ORDER BY" in mysql... CODE SELECT *
FROM `foo` WHERE b='abc' ORDER BY 'number' ASC i want to sort the table out by
the value in "number" which is a number.. but it came out to be sort by like this way...
1->10->2->20 it only sort out the front digit.... but what i want is it will sort by how great the
number is like this... 1->2->3........->10....->20 sorry my english isn't good enough...to
describe my problem properly... hope you can understand and help me on this.....thx....
Looking for sites, learning, php, mysql
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for sites, learning, php, mysql
*MORE FROM TRAP17.COM*
|
advertisement
|
|
