Houdini
May 26 2006, 06:30 PM
I generally notice confusion with new users to PHP and or MySQL and first of all I believe that unlike HTML which is automatically associated with a IE browser in a Microsoft system. HTML is automatically rendered with whatever browser is the default browser, be it Internet Expolrer Firefox Netscape or any other browser that has been set. PHP is a different matter to view the output of a PHP file it must be run on a webserver, and if you do not have one set up on your local PC it simply will not work. (Note serverside langauge requies a server) HTML is client side and requires only a browser so it will display by double or single clicing the file itself and the program associated with it will open it, but not so with PHP or ASP (Window servers only) or Perl. You must have a working webserver like IIS PWS Apache Solaris and so on, and the file must be accessed with a browser that sends a request for a page that resides on the server like one of the above mentioned. All webservers have a ROOT where they keep files and other subdirectories. Normally you will have an index.html or index.php file (the server looks for these type files and serves them upon request of that file. With a PHP file the server will look up what you typed into to address bar and try to PARSE it (unlike HTML) to do whatever it is supposed to do, if PHP is not set up properly it will produce either errors or unexpected results or both. The webserver must know where the executable file is and this is set up in the servers sonfiguration file, then there are dlls that the PHP or other langauge will need to perform certain operations when asked to do so, if these are not set they will fail with errors. If you are using astahost as a server usually you do not need to worry about this, but if you have some ideas about creating something that requires PHP on you site it would be best to place a webserver on your home PC or MAC and develop these programs there and when debugged to the point where you are satisfied then upload them to astahost. I am a regular contributor to PHP Builder Forums and Dev Shed here and see these question all the time, I used to answer and try to help, but now it seems that installation of these services. My PAT answer anymore is to just download and install either XAMPP available here or you could use WAMP available here This is not a tutorial but a post to try to help those that are new to PHP to get started in the right direction. While it is possible to install a server and MySQL and PHP on your own (with much frustration and questions) the programs I suggested will help you if all you really want to do is write PHP and MySQL routines to develop a site. This is just my opinion for newbies and I am sure that there will be those that tell me you should actually learn something from doing it on your own, but when I see people getting more and more confused trying to do this then I really wonder if the satisfaction of self installation is really that much a benefit unless that is your desired career.
Reply
lonebyrd
May 26 2006, 10:43 PM
See thats where I think Im making my mistake. I have Xammp installed on machine, but the main reason I did it was so I could see PHP (so I thought). I have been doing all my coding straight on my Astahost site. Now I know that I should be doing it through Xammp first.
Reply
Houdini
May 27 2006, 11:33 AM
Correct, you (or at least I) should develop your new code on your localmachine and when it is working the way you want it to work then upload the now hopefully bug free script up to your working site. Another thing I do with new scripts is have two folders on the internet site one with my real content and another (call it test or something like that) if the script does something wrong or worse (it wrecks your site) then you can correct it while your real site goes merrily along. The only difference you would have is a config.php file, one for your local machine like below CODE <?php
$host="localhost";//this is default
$user="root";//this is a default for a new MySQL
$pass="";//this is the default (no password for 'root')
$connect=mysql_connect($host,$user,$pass)
or die("Could not connect to server, MySQL said: ".mysql_error());
?> and for your astahost it would be something like CODE <?php
$host="localhost":
$user="yourastahostusername";
$pass="yourastahostpassword":
$connect=mysql_connect($host,$user,$pass)
or die("Could not connect to server, MySQL said: ".mysql_error());//good to check for errors
?>
Reply
TavoxPeru
May 29 2006, 09:19 PM
QUOTE(Houdini @ May 27 2006, 06:33 AM)  Correct, you (or at least I) should develop your new code on your localmachine and when it is working the way you want it to work then upload the now hopefully bug free script up to your working site. Another thing I do with new scripts is have two folders on the internet site one with my real content and another (call it test or something like that) if the script does something wrong or worse (it wrecks your site) then you can correct it while your real site goes merrily along. The only difference you would have is a config.php file, one for your local machine like below CODE <?php
$host="localhost";//this is default
$user="root";//this is a default for a new MySQL
$pass="";//this is the default (no password for 'root')
$connect=mysql_connect($host,$user,$pass)
or die("Could not connect to server, MySQL said: ".mysql_error());
?> and for your astahost it would be something like CODE <?php
$host="localhost":
$user="yourastahostusername";
$pass="yourastahostpassword":
$connect=mysql_connect($host,$user,$pass)
or die("Could not connect to server, MySQL said: ".mysql_error());//good to check for errors
?> Excellent suggestions and congratulations for the first post, i think its very helpful for all newbies. A time ago i installed WAMP in my PC for testing and the results were great the only thing was it installs by default other software that i dont need and were very dificult to uninstall. In my case i always like to install by hand PHP, MySql and APACHE in my win 2kpro SP4 machine to have absolute control over this software with great results, when i was a newbie i had a lot of troubles :-( that cost me a lot of time but this help me at the same time a lot. BTW, the above code dont have any code to select a database to use, so, to complete it its necesary to include first a variable with the name of the database and this in both cases: CODE $database="databasename";
my_sql_select_db($database) or die("Error... no database selected, MySQL said: ".mysql_error()); Best regards,
Reply
Houdini
May 29 2006, 09:39 PM
There is a reason for that include not selecting a database, and it is because I test IPB and PHP-Nuke with phpbb2 and phpbb2 (standalone BBS) and other software. If I included a database in my include file then it would be useless because it would only connect to that particular database, in my case it makes no sense and if I can't just do CODE <?php
include("connect.php");
$select=mysql_select_db("ipb",$connect)
or die("Could not delect database ipb MySQL said: ".mysql_error());
//more code...
?> If the code were in the confines of one particular script then it might make sense but as a contributor to a couple of PHP and MySQL related websites, sometimes I need to create a database similar to the one that they have and to see what kind of problems they are having and be able to solve it I will create a database and then run their code after removing the obvious errors to either find the problem with their code or fix it by seeing a simple error. Does that make sense to you?
Reply
TavoxPeru
May 30 2006, 12:30 AM
QUOTE(Houdini @ May 29 2006, 04:39 PM) There is a reason for that include not selecting a database, and it is because I test IPB and PHP-Nuke with phpbb2 and phpbb2 (standalone BBS) and other software. If I included a database in my include file then it would be useless because it would only connect to that particular database, in my case it makes no sense and if I can't just do CODE <?php
include("connect.php");
$select=mysql_select_db("ipb",$connect)
or die("Could not delect database ipb MySQL said: ".mysql_error());
//more code...
?> If the code were in the confines of one particular script then it might make sense but as a contributor to a couple of PHP and MySQL related websites, sometimes I need to create a database similar to the one that they have and to see what kind of problems they are having and be able to solve it I will create a database and then run their code after removing the obvious errors to either find the problem with their code or fix it by seeing a simple error. Does that make sense to you? Of course it make sense, and i think that a more general way to do the database selection is by using an universal function with the database name as a parameter. best regards,
Reply
Houdini
May 30 2006, 01:26 AM
Do you mean by generalized like the MySQLI function of CODE $connect=mysqli_connect($host,$username,$password,$database); That is pretty general and available with newest (or newer versions of MySQL) of PHP 5 but it will not work when in fact instead of selecting test_anita datbase instead of whoknows database so writing such a connection include would not help me at all. It is not like I have to query just one database, it could be any number of them even if I just need to connect to an existing one or create another new one.
Reply
Quatrux
May 30 2006, 08:45 AM
I have the problem when people mistaken HTML with PHP all the time, I am sitting on IRC channels like #phphelp, #mysql and etc. on freenode and my own country irc server. I ask for support and give my support if I have the time and can and a lot of (in my opinion stupid) people come and ask why php is better than html. I used to point them to the truth how the things works, but now I usually put a big grin or a smile, sometimes ban them if they are irritating. In fact, I think those kind of people are lazy and can't read a little on how it is, I also usually say use google, but sometimes those guys say "what kind of support it is if you only can put a smile or say use google or read the php manual and even can start swearing" but why should I answer stupid questions ? I am not paid for that, all I want to do is help with serious problems.. I think you got the point, that most of those kind of people won't even bother to read the first post of this topic - this is the real problem. QUOTE(TavoxPeru @ May 30 2006, 03:30 AM)
Of course it make sense, and i think that a more general way to do the database selection is by using an universal function with the database name as a parameter.
best regards,
In my opinion, the best way is to create a database class, for example class Database { code } and call it $Database = new Database; and play with all the functions in it by using $Database->getContent($var); or call the values of the variables inside the class $Database->mError; 
Reply
minnieadkins
May 31 2006, 01:21 AM
Use a Database Interface class. There are several available and keeps everything nicely organized. However you will still have to include a file that creates your database class ..or simply re-declare your database object in every script. I think the include method is a nice way to accomodate everything. Especially if you're working on personal stuff. I'm not too familiar with working with large-scale site, but I use a Pearl-like dbi to handle all of my database calls. Just connect once in an include file, and make reference to the database handle inside my scripts that need to interact with the db. There's one dbi mentioned on here, and it might be worth looking into. Adodb or something like that. It looks like a very nice dbi to standardize all your db calls no matter the database.
Reply
TavoxPeru
May 31 2006, 06:05 PM
QUOTE(minnieadkins @ May 30 2006, 08:21 PM)
Use a Database Interface class. There are several available and keeps everything nicely organized. However you will still have to include a file that creates your database class ..or simply re-declare your database object in every script.
I think the include method is a nice way to accomodate everything. Especially if you're working on personal stuff.
I'm not too familiar with working with large-scale site, but I use a Pearl-like dbi to handle all of my database calls. Just connect once in an include file, and make reference to the database handle inside my scripts that need to interact with the db.
There's one dbi mentioned on here, and it might be worth looking into. Adodb or something like that. It looks like a very nice dbi to standardize all your db calls no matter the database.
I agree, use a database interface class is the best option in my opinion, and for that in all my future development i will -must- use someone, a few days ago i test the PEAR:DB class, and is very easy to use. best regards,
Reply
Recent Queries:--
how to connect to mysql database in php pag - 23.54 hr back. (1)
-
example select menu using php mysql - 34.84 hr back. (1)
-
php important - 41.60 hr back. (1)
-
creating websites using php wamp - 68.96 hr back. (1)
-
how to connect of textfiled with database in php - 71.45 hr back. (1)
-
using php with mysql - 73.49 hr back. (1)
-
"create user" mysql wamp connect - 80.48 hr back. (1)
-
could not connect to mysql using easyphp - 82.20 hr back. (1)
-
online exam using php and mysql using time - 83.32 hr back. (1)
-
how to retrieve password datbase user cpanel - 111.47 hr back. (1)
-
after installing wamp the pages gives me "no database selected" - 177.92 hr back. (1)
-
online registration sample program using mysql and php - 178.39 hr back. (1)
-
list menu using php with mysql - 200.74 hr back. (1)
-
upload html file in mysq php for news subsciption - 203.38 hr back. (1)
Similar Topics
Keywords : php, mysql
- Letting Users Add Mysql Data With Php
(1)
Mysql Question(inserting Number From A Textfield)
(3) Hey! I am trying to do a "Admin give EXP script". But I can't make it work. The value is
not updating, but the update query is correct.( I think:P) I think the fault is here: CODE
$expcomp=$givexpp['exp'] += $givexp; The $givexp is the
variable for the amount of Xp the admin wants to give. the $givexpp is the variable for the
user info (in this case, the experince he already have). The datatype for the XP in the database is
INT. So I have no idea if it can take data from a normal textfield. If you need to see all....
Making Something In Mysql Happen Only Once
(10) Hey! I know I am asking alot. But much is happening theese days. Sorry if I disturb with my
questions. The thing I am trying to do is: Ex. If the user becomes level 2, he should get 5 skill
points. I can't do this: CODE if($userlevel=5){ mysql_query("UPDATE
user SET skillpoints =$points+5");} because then it would update everytime the code
was loaded. I hope you understand what I am trying to do. If not, tell me /smile.gif"
style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> and i'll try to explain....
Making A Link = Mysql_query
(8) Hey! I will try to make this as clear as possible. how can I make the following. I have a
list, of all members on my site. If I press on a members name(link), I will come to his profile. To
come to his profile, I need to get out some vaule from the database, but to get out some value from
the database, I must tell the code, how it should know who the user is (hard to understand?). To do
that, I must add a mysql_query in the code ( I think), like "SELECT user FROM dbname WHERE
user=link".. This is just how I think it works. I know it is kinda wrong.. but I don'....
Warning: Mysql_result(): Supplied Argument Is Not A Valid Mysql Result Resource In ...
This Is for My attack Script. (4) Hey. I am making a "Version 2.0" For my attack script, but I can't make it work. This is the
error I am gettin: Warning: mysql_result(): supplied argument is not a valid MySQL result resource
in And here is the code: CODE $dbQueryHealth = mysql_query("SELECT
temphealth FROM characters WHERE user =".
$_POST['atkuser'].""); $currentHealth =
mysql_result($dbQueryHealth, 0); $dbQueryExp =
mysql_query("SELECT exp FROM characters WHERE user = ".$....
Warning: Mysql_num_rows()
What is the error :S (1) Hey! I've made a register script.. Some time ago it worked. And I ain't sure if I
changed something since then.. The error I am getting is this: Warning: mysql_num_rows(): supplied
argument is not a valid MySQL result resource in /home/feelay/public_html/regcheck.php on line 31
Here is the code on theese lines: CODE $sqlCheckForDuplicate = "SELECT username FROM
user WHERE username = '". $username ."'"; if(
mysql_num_rows( mysql_query( $sqlCheckForDuplicate ) ) == 0 ) ....
Anyone Know Of A Really Good Mysql Class?
Looking for something easy but full featured. (4) Generally speaking, when I write a script, it either utilizes the MySQL class of the parent system
(like Mambo or Joomla) or I use basic functions and snippets to perform the database queries I need.
I really like the Joomla database class as it allows you to simply pass a regular query string to
it and the data is returned without the need for extra work! The Invision Power Board (IPB)
database class which is what is used for this forum is kind of a pain to use since it wants the
query string in a non-MySQL standard format. Nonetheless, it does work and I could u....
Extracting Mysql Maths Using Php
(2) Right, this is a really simple thing and it has me completely stumped. I'm working on this mini
maths function and for some reason i cannot seem to do some simple math process using mysql. This is
the code: (php btw), now assume that $date is actually a defined mysql date variable already
successfully extracted. $sql = mysql_query("SELECT TO_DAYS('CURDATE()') -
TO_DAYS('$date')"); while ($row = mysql_fetch_array($sql)){ $diff =
$row ; } Can anyone spot what im doing wrong becuase im just thrown by it.....
Too Many Connections?
mysql_connect() (4) I uploaded my PHP game yesterday, and most of my friends tried it out. After a while, I tried to
play as well but it said that mysql_connect() had too many connections already. Can anyone tell me
how to increase the amount of connections or maybe the total amount of connections allowed?....
Basics Of Php For Beginners - Suggestion
Help Needed For Project (5) Hi all, I have a friend who, for his extended IT project is interested in making a website partly
out of php. When he asked for advice my first thought was here. I would like to know some good
websites, tutorials etc that he can use to introduce himself to php (he hasn't done much
before). He is interested in making a simple login/subscription service where you can signup and
then login to a 'members only' page. Any ideas and code samples that you have to share would
be greatly appreciated. /tongue.gif" style="vertical-align:middle" emoid=":P" border="0" a....
Php/mysql And Manual Page Caching?
(4) I am hopefully about to attempt this on the news page of my new site. Every bit counts as far as
I'm concerned and not having "news" portion of my news page re-php and re-mysql everything where
there is no chance seems like a waste. I'm looking for good articles, information or tips on
the process (if I fail to find any good information as I'm looking through now). The way I see
it right now, I have most of my page split up in header, content (some static html in here before
dynamic contend and then a little more static html to close it off) and then a foo....
Sql Injection Prevention (passing Numerical Data Across Pages).
PHP/mySQL (9) Even if your building something as simple as a basic news page for your website, if your passing
along url variable strings like (mysite/index.php?page=1), you may be vulnerable to SQL injection
attacks. For cases like these (passing numerical data in url strings), I have a handy dandy little
function to thwart these attempts silly: CODE // For checking if value is a number, if not
return 1. function isNum($val) { if (!is_numeric($val)) {
$val = 1; } return ($val); } I have this function, within my ....
Php Mysql Errors
Fetching arrays (2) I am deciding to make a Multiplayer Online RPG type game. I will be building it off of PHP and MySQL
to ensure makimum compatibility with Astahost's services (and it makes it easier /wink.gif"
style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" />). I have a database setup with
1 table to hold user data and I have the login system setup properly as well as the registration
form (obviously). All games of course have something similar to gold, units and points. Because
this is a turn-based game, I have turns. Now for the problem: I am trying to echo ....
How To Show Serial Nums In PHP Table For Contents Of MySQL DB
Serial Numbering for output contents of mysql in php table (4) Hello there, I'm looking for some education. How would you show the serial numbering for
outputted contents of mysql database. I used a table created in PHP to output content (i.e. an
alumni database) and I created a column for S/N, so that at a glance anyone can tell how many
members have registered. Thanks house. Neyoo....
PHP & MySQL: Displaying Content From A Given ID
(6) Okay so I got this sample link (not working): http://www.acosta.com/joo.asp?id=654 Now suppose
I have a PHP file that would use MySql in order to get all values in the row where id 654 is found.
Here's a sample DB: Table: demnyc ______________________________________ | id |
Name | Age | Email | *----------------------------------------------------* | 1
| Albert | 17 | no email |
*----------------------------------------------------* | 2 | YaPow | 888 |
no email | |__________....
Re-order MySQL Table
(11) Hello you all, I've got a question /smile.gif" style="vertical-align:middle" emoid=":)"
border="0" alt="smile.gif" /> Let's say I have a database width the table "news". It contains
about 10 items which is ordered by the field "id". Now from my admin page i do this: CODE
<?PHP mysql_query("DELETE FROM news WHERE id=4"); ?> And a few days later
i do: CODE <?PHP mysql_query("DELETE FROM news WHERE id=7"); ?> Now
there are two gaps in the table => 1, 2, 3, 5, 6, 8, 9, 10 (no 4 and 7). It want to real....
Need MySQL Alternative To The Syntax "or die()"
(8) Hello again /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />
I'm facing a problem with PHP and MySQL... I want, when a MySQL error occurs, to let the script
continue. Here's the script: CODE $query = "SELECT * FROM menus ORDER BY id
ASC"; $menus_result = mysql_query($query) or
die("Error!"); while(
$menu=mysql_fetch_array($menus_result) ) { echo
$menu['name']."<br />"; } Now if the table "menus" doesn&....
Php Basics
(5) Hey everybody, I was just wondering of the PHP basics. I fluently know html currently, but am having
trouble understand PHP. I'd like to use PHP for the scripts such as stats, login, etc etc. Any
tips would be much appreciated -Kyle....
Need Help With Php/mysql And Web Servers Such As Asta's.
(4) Within my site I have built my own basic forum using PHP/Mysql, I always test locally now both using
EasyPHP and WAMP5 which both give me no problems what so ever. But when I tryed to run the exact
same code on Asta's hosting services (and possible another I used to use) when creating a new
thread or adding a reply to an existing one it *sometimes* adds an additional thread/reply as a
Guest (someone not signed in) with an empty message. This would lead me to believe that somehow the
page is being refreshed and the variables sent to the database update php file are ....
How Do You Create A Secure Loging?
with PHP and mySQL (4) I've read a few articles, and looked up the code of certain files and some of them seem to work
differently. I'm trying to create a login script, which would require PHP and mySQL to run,
however, I'm not quite sure how to approach it since I'm only just learning PHP. I'd
like to know, what is the most secure and effective login? I've heard you can add a salt to
encrypted passwords, etc, and well as using sessions (sid). It's just like to know what methods
are best for creating a secure login script. Thank yo ufor readin this. ....
[php] Index.php?section=xx&pag=yy
No MySQL or any other database (6) Hi everybody. This is my 3rd script, but this dont use MySQL It does this: divide the site in
SECTIONS and PAGES. Benefits: -You have to create just the text of your pages, no create ech page
with the entire layout again. -If its just the text that is included, you just have to have one page
with the layout, witch is the INDEX.PHP. -If you chanche the layout in the index.php, you DONT HAVE
TO change in the other pages. Here is the code: CODE <?php
//-----------------------------------------// //ACAF Paginação //
//by Alexandre Cis....
[PHP + MySQL] Encrypting Data
To protect the password of your DB, for example. (9) Hi! This is my 2nd code of PHP + MySQL. This code is VERY simple: it encript the data in the
MySQL DB. Here we go! ------------------------------------------------------------------------
CODE <?php $password = "abc"; $new_password = md5($password);
echo $new_password; ?> The password "abc" was codfied using md5() This will be:
900150983cd24fb0d6963f7d28e17f72 CODE <?php $normal_pass = "abc";
$encripted_pass = "900150983cd24fb0d6963f7d28e17f72"; if(md5($norm....
[PHP + MySQL] Separating The Results By Pages
Simple code (0) Hi! I will post here a code for separating the results of MySQL in pages. You ask: Why separete?
I answer: Imagin that you have 1523 results to display. I dont have to say anything. =P Here is it.
------------------------------------------------------------------- CODE <?php $conect
= mysql_connect("host","user","password"); $select_db =
mysql_select_db("database"); $query = "SELECT * FROM mytable";
$results = "15"; //Number of results displayed per page. if (!$p....
Need Some Help Using PHP & MySQL
(4) I wonder if its possible or if anyone know how to : I'm making a website for my soccer team
and every week there are new news, but in the index file i only show some part of the text and the
rest of the news is in Stored in Database, of course that all news are inside mysql database, i only
set a script to get from the Database the text and title and so. My doubt is if there is some how to
attach a link to that news and when i run the link, this show me another page but with FULL news
text ? i Read something like, i've to create a cicle CODE <....
Printing Out A Table
PHP and MySQL (6) I've been designing an online registration page for my univ. The adminstrative section is going
to take care of the registration and they've asked me if I could incorporate a PRINT link on the
page which displays the details of the students so that they can take a printout directly of just
the table and not the extra links and decorations on the page without having to copy the whole thing
into excel or something. Does anyone have any ideas of how to do this? To make myself more clear,
here's a screenshot of the admin page: I want a printout of just the....
Need For PHP/MySQL Creator
(1) need for PHP/MYSQL creator I need a PHP/MYSQL application creator that have php function and
create php codes automatically, for example:Macromedia Dreamweaver MX 2004 have this ability to
create php applications already i downloaded PHP designer but it didn`t applications ....
Need Help With A PHP - MySQL Registration Script
Wont INSERT into the database (13) hey well can some one helpme make this code work it won't INSERT INTO THE DATABSE CODE
<?php # register1.php # common include file to MySQL include("DB.PHP");
$Username=$_POST['Username'];
$Password=$_POST['Password'];
$Name=$_POST['Name']; $Last=$_POST['Last'];
$Sex=$_POST['Sex']; $Month=$_POST['Month'];
$Day=$_POST['Day']; $Year=$_POST['Year&....
Php/mysql Data Display
(3) Okay .. got a bit of a question here, so I'll do some explaining. I was asked to do a site for
an online roleplaying game, specifically, a "blackbook" site. I accepted and began my quest for
knowledge of PHP. I've gotten quite "far" to the point that I can now take a user inputted
search value and query the database with that value, and then display the values in a table. My
MySQL table setup is as below: CODE |Name|Reports|Type1|Type2|Quote|Confirmed| When queried
it displays the following: CODE Violator Name: ['Name'] # Repor....
Help With PHP Basics
I need help (9) Hello i need help.I want to start learning php.I need some gd tutorial site for it which free host
can i use for learning php/??? Thank u in advance....
MySQL & PHP coding
(9) So it seems as though the php docs make it very clear that mysql and mysqli functions will all
connect to the database as a latin1 client. Although i have my server set up with utf8 databases,
tables and fields and the default client connection is utf8, php still connects as latin1. My
xhtml forms and pages are all utf-8, so when i post utf8 data and insert it into the database the
connection assumes that incoming data is latin1 and the data that gets placed in the database is
invalid. phpMyAdmin seems to be able to view, add, edit, and retrieve utf8 strings in the d....
Looking for php, mysql
|
|
Searching Video's for php, mysql
|
advertisement
|
|
