john010117
-
Posts
492 -
Joined
-
Last visited
Never
Everything posted by john010117
-
I designed this bully site for a Client
john010117 replied to Guardian-Mage's topic in Website Critique
You got a nice, CSS layout which is great. But I agree with samus. It needs graphics. -
Replace with your values. $sql = "insert into Contact (someField, someField2, someField3) values ('$newEntry', '$newEntry2', '$newEntry3')"; Get the pattern?
-
PHP is a server-side script.
-
Put: extract($row); after: while ($row = mysql_fetch_array($result))
-
I'm glad you used CSS for your layout. The loading times are good. I'll let others comment about the layout (I'm not proficient in creating/commenting layouts... lol)
-
htmlentities() and/or htmlspecialchars().
-
Remove the first set of brackets. function session_defaults() { If you have copied that from a tut, look for a different tut.
-
I think it's called mod_rewrite.
-
Change the first query to this: $userquery = mysql_query("SELECT user_id FROM users WHERE user_id = '$_POST[username]'") or die(mysql_error()); I have removed the ' from Username. Do that for all the queries.
-
First of all, http_referer is NOT reliable (as said in the documentation). You could use str_replace (or parse_url) to strip out the front characters of the url...
-
Please wait at least an hour before double-posting. We all have lives, you know. Just to simplify things, use the second code. It's guaranteed to work.
-
I'll be talking about the technical issues. All the links on the top nav bar doesn't work (except for tipsntricks.html). There is no link to the registration page (if there is a registration page). I just typed in a dummy user/pass, and all I got was text. You should add a layout to the processing page also.
-
You would be interested in reading about mysql_real_escape_string().
-
Then call it in your flash program.
-
Just do another if statement... PHP process a script until it reaches the first TRUE elseif statement, and stops there. But if you put an if there instead, the script will keep on processing all the statements that are TRUE.
-
Ok... The home page and the other pages should have the same layout. The hovering links on the left should have their hovering color exactly in the black background. The main content table looks ugly. Everything explained
-
Since I only speak English, I can't really understand the purpose of your website.
-
I downloaded the package from wampserver.com, and ran the installation exe file. I "turned off" Apache and MySQL (I meant to say MySQL, not PHP) by clicking the wamp icon in the taskbar, and selecting "Stop service" for each one.
-
about using & and ' in fields beingh processed by PHP
john010117 replied to hempknight's topic in PHP Coding Help
On the second script that you've posted... <body bgcolor="#000000" text="#FFFFFF"> <table width="500" border="1" bordercolor="#FFFFFF"> <?php $link = mysql_connect("localhost", "****", "****"); if (!$link) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("mitact_mitact"); if (!$db_selected) { die ('Can\'t use foo : ' . mysql_error()); } $genre = null; $result = mysql_query("SELECT * FROM `Bands_Genre`"); if (!$result) { die('Invalid query: ' . mysql_error()); } while ($row = mysql_fetch_array($result)) { $genre[$row["gid"]] = $row["name"]; } mysql_free_result($result); $band_name = urldecode($_GET['band']; $band_name_escaped = mysql_real_escape_string($band_name); $result = mysql_query("SELECT * FROM `Bands_Confirmed` WHERE `bandname` = '$band_name_escaped'"); if (!$result) { die('Invalid query: ' . mysql_error()); } addslashes($result); while ($row = mysql_fetch_array($result)) {//while fetch BEGINS ?> <tbody> <tr> <td colspan="2"> <h2><?php echo $row["bandname"];?></h2> </td> </tr> <tr> <td colspan="2"> <ul> <li>Genre 1: <?php echo $genre[$row["genre1"]];?></li> <?php if ($genre[$row["genre2"]]<>"") {echo'<li>Genre 2:',$genre[$row["genre2"]],'</li>';}?> <?php if ($genre[$row["genre3"]]<>"") {echo '<li>Genre 3:',$genre[$row["genre3"]],'</li>';}?> <li>Original music, Covers or Both: <?php echo $row["type"];?></li> </ul> </td> </tr> <tr> <td colspan="2"> <div> <dl> <dt><?php echo $row["contact1"];?></dt> <?php if ($row["contact1number"]<>"") {echo '<dd>',$row["contact1number"],'</dd>';}?> <dd><?php echo $row["email1"];?></dd> <dt><?php echo $row["contact2"];?></dt> <dd><?php echo $row["contact2number"];?></dd> <dd><?php echo $row["email2"];?></dd> <?php if ($row["managerdetails"]<>"") {echo '<dt>Manager details</dt>'; echo '<dd>',$row["managerdetails"],'</dd>';}?> <?php if ($row["managerdetails"]<>"") {echo '<dt>Booking agent</dt>'; echo '<dd>',$row["bookingagentdetails"],'</dd>';}?> </dl> </div> </td> </tr> <tr> <?php if ($row["myspace"]<>"") {echo '<td width="250">','MySpace: <a href="'; echo $row["myspace"]; echo'">',$row["myspace"],'</a></td>';}?> <?php if ($row["website"]<>"") {echo '<td width="250">','Website: <a href="'; echo $row["website"]; echo'">',$row["website"],'</a></td>';}?> </tr> </tbody> <?php } //END WHILE mysql_free_result($result); mysql_close($link); ?> -
Hi. I'm not really used to having servers installed on my [old] comp. I've installed WAMP successfully, and verified that it runs correctly. But when I turn of both the Apache server and PHP, the process named httpd.exe is still running. When I try to end the process, it says that I don't have the permission to do that (even though I'm the only admin on the comp). How do I turn it off? BTW, I have Windows 2k.
-
about using & and ' in fields beingh processed by PHP
john010117 replied to hempknight's topic in PHP Coding Help
Use mysql_real_escape_string() on your strings. -
I don't know nothing about PHP. I want to learn how.
john010117 replied to logged_with_bugmenot's topic in PHP Coding Help
Another quick hint: Google is your friend. -
If you want to do it like that, use sessions. Start a session at the form, and check to see if the session's there on the processing page.
-
[SOLVED] pagination results won't get past ten. Why?
john010117 replied to mrelliott's topic in PHP Coding Help
I've had this problem before. Use mysql_real_escape_string() on the string the user's searching for. -
I don't know nothing about PHP. I want to learn how.
john010117 replied to logged_with_bugmenot's topic in PHP Coding Help
PHP