The Little Guy
Members-
Posts
6,675 -
Joined
-
Last visited
Everything posted by The Little Guy
-
Maybe if we register for the beta thousands of times they will let us in.
-
On October 9th, they will have a broadcast of live gameplay more details here: http://www.simcity.com/en_US/blog/article/anticipation-builder-maxis-live-broadcast?src=fb01
-
For anyone interested, Maxis has posted a new gameplay video (I am even more excited now, after watching this): http://www.simcity.com/en_US/blog/article/laying-the-foundation-SimCity-gameplay?src=fb01
-
Yes! Its like watching a TV Show or movie with a long drawn out scene, at some point you just might want to fast forward through it because it is too long, and boring. If you make your page the same as that scene, people will want to pass over it. I really like this guide, it is really helpful in making attractive sites and how to use your explains ways to use your white space. http://www.webdesignfromscratch.com/web-design/web-2-0-design-style-guide/
-
Delete Multiple *selected* Fields/columns/rows
The Little Guy replied to White_Lily's topic in PHP Coding Help
Yup! -
1. Your home page has way too much information on it, keep it simple. 2. The color choices are Yellow/Blue don't match too well, I would recommend using http://kuler.adobe.com or something similar 3. Bigger is better. Bigger text bigger images. 4. Simple. Make the home page very simple yet still get the point across. Don't throw lots of information in someones face. 5. Use css3 for some gradients (http://www.colorzilla.com/gradient-editor/) and drop shadows. 6. Use fun attractive fonts for headers, I use a font on my site called Bebas which always looks nice (http://ryannaddy.com/media/fonts/bebas.ttf) One thing I like to do is go to http://www.templatemonster.com/ and find 3+ layouts that I like and build a nice layout combining the 3+ layouts into one layout with lots of my own ideas.
-
Remove Wysiwyg Editor
The Little Guy replied to The Little Guy's topic in PHPFreaks.com Website Feedback
Gracias! Too bad it disables all the buttons though. -
Is there a way to get rid of this stupid WYSIWYG editor? It keeps messing up my posts. I went to post some code for support for someone and it completely messed it up, by adding font/color bbc tags.
-
Checking For Duplicates In Mysql -- Not Working
The Little Guy replied to Enso's topic in PHP Coding Help
$sql = mysql_query("INSERT IGNORE INTO `users` (`fname`, `lname`, `email`, `username`, `password`, `insert_time`) VALUES ('$fname', '$lname', '$email', '$uname','$password' ,'$date')"); Sorry, the query is wrong. you need "INSERT IGNORE" in there -
Checking For Duplicates In Mysql -- Not Working
The Little Guy replied to Enso's topic in PHP Coding Help
The easiest way is to place a "Unique" key on the username column, then do an "INSERT IGNORE" <?php $sql = mysql_query("INSERT INTO `users` (`fname`, `lname`, `email`, `username`, `password`, `insert_time`) VALUES ('$fname', '$lname', '$email', '$uname','$password' ,'$date')"); if(mysql_affected_rows($sql) == 0){ // Duplicate found }else{ // Success } -
I know the thread is is closed, but wouldn't a cookie be a better choice? You can set it to expire when the browser closes, and you wouldn't have to store the session information on your end.
-
Delete Multiple *selected* Fields/columns/rows
The Little Guy replied to White_Lily's topic in PHP Coding Help
POST was initially meant for: Saving/Updating/Deleting data and GET was initially meant for retrieving data. They are not required for that use though. There is no security difference between the two, as they are both passed as a key/value string split by "=" and each group is split by "&". -
Need Help Stringing Some Php Commands Together
The Little Guy replied to FUNKAM35's topic in MySQL Help
Just put it in a sql file and run from the commandline: mysql -h localhost -u myUserName -pMyPassword myDatabase < mySQLFile.sql -
Delete Multiple *selected* Fields/columns/rows
The Little Guy replied to White_Lily's topic in PHP Coding Help
Ah, yes you are correct, so I modified so it would work. <?php function sanitize($array){ array_walk($array, function(&$val){ $val = (int)$val; }); return $array; } $userid = (int)$_SESSION["userid"]; $values = implode(",", sanitize($_POST["imAnArray"])); mysql_query("delete from my_table where my_table_id in($values) where userid = $userid"); ?> -
Delete Multiple *selected* Fields/columns/rows
The Little Guy replied to White_Lily's topic in PHP Coding Help
It would look something like this: <input type="checkbox" name="imAnArray[]" value="1" /> <input type="checkbox" name="imAnArray[]" value="2" /> <input type="checkbox" name="imAnArray[]" value="3" /> <?php function sanitize(&$value){ $value = (int)$value; } $values = implode(",", array_walk($_POST["imAnArray"], "sanitize"); mysql_query("delete from my_table where my_table_id in($values)"); ?> -
What happens when you connect remotely? Two things I can think of off the top of my head are: 1. Your web server (such as Apache) has anyone (except the localhost) trying to access phpMyAdmin locked out. (This is a good thing) 2. You haven't granted yourself proper permissions in mysql
- 1 reply
-
- phpmyadmin
- remote connectio
-
(and 1 more)
Tagged with:
-
How To Protect Data In Mysql From Peskey Users ?
The Little Guy replied to vincej's topic in Miscellaneous
If they do the same queries all the time you could run it for them, and then do less clean up afterwards. -
Any Idea Why Str_Replace Isn't Working?
The Little Guy replied to MySQL_Narb's topic in PHP Coding Help
After removing all the errors from the code posted: - CURLOPT_RETURNTRANSFER -- Missing the "F" in transfer - Added a check to see if the file exists (not 100% need, but added) - Added a comma to the str-replace function I came up with this: <?php //accounts $file = 'proxy.txt'; $data = ""; if(is_file($file)){ $data = file_get_contents($file); } $ips = explode("\n", $data); $ch = curl_init('http://serverlist.us/index.php?in=17'); curl_setopt($ch, CURLOPT_REFERER, 'http://serverlist.us...x.php?server=17'); curl_setopt($ch, CURLOPT_TIMEOUT, ; curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20100101 Firefox/14.0.1'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $returned = curl_exec($ch); $opt = str_replace('securimage/securimage_show.php', 'http://www.serverlis...rimage_show.php', $returned); curl_close($ch); echo $opt; ?> -
How To Protect Data In Mysql From Peskey Users ?
The Little Guy replied to vincej's topic in Miscellaneous
Build a php page that gives them only the functionality that they need. -
http://www.htmldrive.net http://viralpatel.net
-
I am not sure If this has been posted or if it is on the "todo list", but if it is possible, could you make the font for the code boxes a little bigger, and also can the syntax highlighting be changed?
-
I would do something similar to this: http://phpsnips.com/snip-39 The code would need to be canged to instead of logging a user out, disable the counter till they load a new page.
-
One of my friends just got a job at the Nerdery (if you have heard of them). Anyway, he told me they have a beer tap right in the cafeteria! I work 1 block from a "Gentlemen's Club" and me and my co-workers have been there, it was no big deal.
-
Hot Scripts have tons of scripts, and there are free and paid ones: http://www.hotscripts.com/search/php/image+host
-
Like and Done!