Welcome! Log In Create A New Profile

Advanced

PHP 12 : PHP and mySQL

Posted by Gaia77490614 
Announcements Last Post
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
Forums Messages New
Gaia77490614
PHP 12 : PHP and mySQL
February 16, 2012 07:04PM
I have completed this section.
Now getting closer to the real thing!! Very excited!!!
Reply Quote
avatar
77553055
Re: PHP 12 : PHP and mySQL
February 17, 2012 11:18AM
I actually had issues connecting mysql with the links 
Language: HTML
"http://127.0.0.1/mysql/" and "http://127.0.0.1/home/mysql/"
. error 403 was coming up on my internet explorer, not until I changed the alias /home/mysql path and directory "${path}/phpmyadmin" to where the main phpmyadmin folder is located on my hard drive in the apache config file. (You should find something similar to the following line:

Alias /home/mysql “specify your phpmyadmin folder location path”

Just add, to the next line, the following string:

Alias /mysql “specify your phpmyadmin folder location path”

Restart EasyPHP. Now try the links above out. It should work.

I hope its useful if you are having similar problem. Still on the section. Cheers!
Reply Quote
avatar
77553055
Re: PHP 12 : PHP and mySQL
February 17, 2012 02:12PM
the table images shown in the course file section(Setting up Fields in your phpMyAdmin database tables) is different from the one am using. Also, I can not find the "Extra field" to set my increment for the ID. Any suggestions on how to set the increment in mysql?
Reply Quote
Gaia77490614
Re: PHP 12 : PHP and mySQL
February 17, 2012 05:24PM
Mine is also different, which is a bit unfortunate. If yours look the same than on my sid =>. Click on Create Table on the left and then under Column, type the Name of your Field.
Look at the headings in Bold below each other :
Column
Type
Length
Default
Collation
Attributes
Null
Index
and then AUTO-INCREMENT - you just tick it (select it)

I hope this was your question and that your screen looks similar than mine !
Let know if this is not what you need
Reply Quote
avatar
77553055
Re: PHP 12 : PHP and mySQL
February 17, 2012 07:31PM
Thanks Gaia, the table abbreviated the auto increment as A_I because the columns are much. cheers!
Reply Quote
Gaia77490614
Re: PHP 12 : PHP and mySQL
February 20, 2012 02:17PM
You're very welcome!! How on Earth were you supposed to guess that!!
(A_I)
Reply Quote
avatar
77553055
Re: PHP 12 : PHP and mySQL
February 20, 2012 08:06PM
thats coding for you Gaia.
Reply Quote
avatar
77553055
Re: PHP 12 : PHP and mySQL
February 21, 2012 12:25AM
Just finished this section.
Reply Quote
77586182
Re: PHP 12 : PHP and mySQL
February 22, 2012 08:53PM
Completed this section.
Reply Quote
avatar
mm77509382
Re: PHP 12 : PHP and mySQL
February 25, 2012 10:15PM
Completed this section.
Reply Quote
77570952-Sian
Re: PHP 12 : PHP and mySQL
February 26, 2012 11:46PM
I completed this section. Also got confused as my phpMyAdmin looks like a newer version to the tutorial. So it is the same format mentioned by Gaia77490614. But I figured it out and it seems to be working fine so far.
Reply Quote
Fulu-72924640
Re: PHP 12 : PHP and mySQL
March 01, 2012 08:29PM
Q1. How do we resolve the following error "Connection for controluser as defined in your configuration failed." when using phpMyAdmin?
Q2. Gaia can you please be open about the creation of new table, I dont see where it says "Create Table".
Reply Quote
avatar
77553055
Re: PHP 12 : PHP and mySQL
March 01, 2012 08:45PM
What causes this error? and also try to read through your study material properly on how to create a table.
Reply Quote
avatar
Mac
Re: PHP 12 : PHP and mySQL
March 02, 2012 07:57AM
Fulu-72924640 Wrote:
-------------------------------------------------------
> Q1. How do we resolve the following error
> "Connection for controluser as defined in your
> configuration failed." when using phpMyAdmin?

http://www.techdiscuss.net/xampp/xampp-error-connection-for-controluser-as-defined-in-your-configuration-failed.htm


> Q2. Gaia can you please be open about the creation
> of new table, I dont see where it says "Create
> Table".

You will not until phpmyadmin is working
Reply Quote
Fulu-72924640
Re: PHP 12 : PHP and mySQL
March 04, 2012 09:32PM
Finally, Im done with this section.
Reply Quote
77471466_Alwyn
Re: PHP 12 : PHP and mySQL
March 07, 2012 09:33AM
I had to uninstall XAMPP and install EASY-PHP as I just couldn't get mySQL working on XAMPP for some reason...
Reply Quote
77471466_Alwyn
Re: PHP 12 : PHP and mySQL
March 07, 2012 03:22PM
When I created my database, I'm supposed to see the files for addressbook in mysql/data/

but I don't? Any ideas where my files can be?
Reply Quote
Fulu-72924640
Re: PHP 12 : PHP and mySQL
March 07, 2012 09:01PM
I also struggled a lot to get mine working but no luck until I install the one I was using and install the one from - http://www.apachefriends.org/en/xampp-windows.html#641";.
and is working well and fine. My files are in xampp/mysql/data.
Reply Quote
77586492
Re: PHP 12 : PHP and mySQL
March 16, 2012 09:53AM
Completed this section
Reply Quote
77528204
Re: PHP 12 : PHP and mySQL
March 16, 2012 01:30PM
Getting interestingspinning smiley sticking its tongue out, completed section 12.
Reply Quote
L Dhladhla
Re: PHP 12 : PHP and mySQL
March 20, 2012 08:14PM
I'm currently doing mysql my problem is when I run the addressbook script I get this message "Warning:mysql_fetch_assoc() expects parameter 1 to be
resource,boolean given line number 15". Because of this I can not continue,any ideas?
Reply Quote
avatar
77553055
Re: PHP 12 : PHP and mySQL
March 20, 2012 08:46PM
Quoting Mac's words... Have you got data in your table? When there is no data, you will get this. To suppress the error, add an if statement 

Language: PHP
$result = mysql_query($SQL);
 if($result){
 while ($db_field = mysql_fetch_assoc($result)) {
Reply Quote
L Dhladhla
Re: PHP 12 : PHP and mySQL
March 22, 2012 12:44PM
Thanx alot 77553055 it's working!
Reply Quote
avatar
77553055
Re: PHP 12 : PHP and mySQL
March 22, 2012 01:56PM
Always a pleasure! smile
Reply Quote
77585607
Re: PHP 12 : PHP and mySQL
March 23, 2012 04:12PM
I have completed this section.
Reply Quote
77582950
Re: PHP 12 : PHP and mySQL
April 24, 2012 10:19PM
Done.
Reply Quote
franky71713913
Re: PHP 12 : PHP and mySQL
May 08, 2012 01:06AM
77471466_Alwyn Wrote:
-------------------------------------------------------
> When I created my database, I'm supposed to see
> the files for addressbook in mysql/data/
>
> but I don't? Any ideas where my files can be?

I have found it in the folder, I had the exact same problem as you have had.
i haven't a clue on how to fix it, but it is there, it is 'hidden', but not hidden.

I'm running Windows 7, and it is as if the file/folder is "owned by someone else,

I think if you carry on, you'll still get it working though.

After i have found it through a dialog of a program: Notepad2, i found it,

So therefore, i have completed this section.
Reply Quote
Newer Topic Older Topic
Sorry, you do not have permission to post/reply in this forum.