.josh
-
Posts
14,780 -
Joined
-
Last visited
-
Days Won
43
Everything posted by .josh
-
$galleryrowa = mysql_fetch_array($gallerysqla) or die(mysql_error());//<==Problem
-
well if you have an ip address that you're fairly sure is his (like, a log of before he was causing trouble and had no reason to hide), you could always do a whois on the ip address and contact the isp and report the user.
-
[SOLVED] n00b PHP4 - PH5 form array compatibility problem
.josh replied to bothwell's topic in PHP Coding Help
$_POST['strLocations'][0] -
Basic Database Handling
-
well, ideally your main page will be a controller, and you would store each piece of content as separate files. It would look something like this: content1.html <html> <head></head> <body> BLAHBLAHBLAHBLAH MORE BLAH THIS IS CONTENT 1 </body> </html> content2.html <html> <head></head> <body> BLEHBLEHBLEHBLEH MORE BLEH THIS IS CONTENT 2 </body> </html> main.php <html> <head></head> <body> <a href = 'main.php?id=content1'>Content 1</a> <a href = 'main.php?id=content2'>Content 2</a> </body> </html> <?php // array of allowed content files $allowed = array('content1','content2'); // if there is an id in the url... if ($_GET['id']) { // if id is allowed... if (in_array($_GET['id'], $allowed) { // assign page to $id $id = $_GET['id']; // if id not allowed... } else { // assign a default of first one in array $id = $allowed[0]; } // end if..else // if no id in url exists... } else { // assign a default of first one array $id = $allowed[0]; } // end if..else include "$id.html"; ?>
-
it's to specify a key/value pair for associative arrays. Example: // keys are a, b, c values are 1, 2, 3 $blah = array('a' => 1, 'b' => 2, 'c' => 3); // using a foreach loop to loop through array elements foreach ($blah as $letter => $number) { echo "key: $letter value: $number <br />"; }
-
...
-
Having a portfolio counts more than having a certain "level" of understanding. Learn the basics through tutorials/books/looking in the manual. Go to freelancer type sites and look at what kind of jobs/projects are posted. Read the description. If you feel you can handle it, put a bid on it. If you feel you can't, then read some more tutorials and books and stuff. Or maybe take one of those postings on as a personal project to learn on. That is, you don't post a bid, but decide hey, people are asking for things like shopping carts, etc.. so why don't I try to make one myself? Go back and read more postings. Maybe you'll find one you feel you can do. Wash rinse, and repeat. Eventually you will feel up to the task to bid on something for real. Bid on it. Do it. Add it to your portfolio. Make a website offering your services, showcasing your portfolio. Come to places like phpfreaks.com and help out. Help answer people's questions. Focus on the ones you know, to keep your skills sharp. Focus on the ones you don't know so you can learn something. Write tutorials. Write articles. Write a blog about things. Post them on your site. Submit them to others. All these things are what you would list on your resume to employers.
-
use a bigger char type like blob or longblob
-
okay well I really have no idea what you're talking about because every time you post you have some new piece of code and it seems like you're on an entirely different issue... but anyways, the difference between = and == is that = is an assignment operator, as in you want to assign something to a variable. == is a condition operator, as in, you want to compare two things.
-
remove the single quotes while ($getUpdates = mysql_fetch_array($findUpdates)) { putting single quotes around that causes you to assign a literally interpreted string to $getUpdates, and as long as php successfully assigns it (which there's really no way it won't fail to assign it unless some meteor crashes into the server or something), your loop will always be true and you'll have an infinite loop.
-
no actually you'd do just one query. Look into relational databases and doing queries with JOIN.
-
I almost mentioned that but then I just figured he put something generic in there like most people do with host/name/pw when showing code.
-
$sql=mysql_query("SELECT teams.teamName, teams.Points, contacts.division FROM teams LEFT JOIN contacts ON teams.teamName = contacts.teamName WHERE contacts.division=1 "); while($row=mysql_fetch_array($sql)) { echo "Team: " . $row['teamName'] . " Points: " . $row['Points'] . "<br />"; } the mysql_fetch_array fetches the data 1 row at a time, assigning that row as an array to $row. You access each element by using the column names. Each time mysql_fetch_array is called, an internal pointer points to the next row. When there's no more rows, the loop ends.
-
Well your 2nd query doesn't have quotes of any kind...
-
if ($Submit2) should be if ($_POST['submit2'])
-
some server setups have prefixes added to user names and database names. A common setup is for instance, if you owned www.mycoolsite.com and your assigned account name is mycoolsi that could be the prefix followed by an underscore followed by your username: mycoolsi_pcscript. same with the database name: mycoolsi_testdb. You want to talk to your host or read their documention to find out if they add some kind of prefix.
-
sounds like a plan, so hop to it! or...did you have a problem you forgot to mention?
-
if you have a bunch of numbers you want to loop through, and one of those numbers you want to do something special with, where do you think the condition should be?
-
hmm you say your page is blank but you have stuff like echo('<table border="1">'); echo '<tr><th>Title</th><th>Author</th><th>Pages</th></tr>'; that aren't in any conditions or anything, so you should at least be seeing that. Do you have error reporting turned on? Stupid question, but your filename is *.php not like *.html right?
-
well i have no idea what the point of $val is supposed to be but if you want the "current" one not to be a link then you need a condition to see if ($i == $num)
-
are you wanting to learn how to program this or would you be happy with a prefab program? Because there are plenty of prefab photo album programs out there already, like Gallery2
-
well I think this is what you are trying to do... $num = ((int) $_GET['num']); for ($i = 1; $i < 12; $i++) { $val = ($i - 2 )* 10; if ($val != $num) { if ($i == 1) { print '<strong><a href="index.php">'.$i.'</a></strong> '; } else { print '<strong><a href="index.php?num='.$val.'&var=1">'.$i.'</a></strong> '; } } else { print $i.' '; } }
-
well, you could add a condition to check if $i == 1 and if so, build link without the added stuff, or you could just do a plain echo of it before the loop and start your loop at 2 instead of 1.
-
put backticks around desc like so `desc` the problem is that desc is a reserved word. Though I really recommend you change it to a different name instead of using backticks, as only mysql will support that. And even still, it's just bad coding to use reserved words as column names.