Johns3n

<tr> <td input type="textarea" class="fieldset"><div class="tbl_lbl">FUND STRATEGY</div> <div class="tbl_input"> <input size="57" name="fund_strategy" id="fund_strategy" value="<?php echo $arrayFund[0]['fund_strategy']?></textarea> </div></td> </tr> That looks confusing as hell? Shouldn't it be more like this? <tr> <td class="fieldset"> <div class="tbl_lbl">FUND STRATEGY</div> <div class="tbl_input"> <textarea size="57" name="fund_strategy" id="fund_strategy"> <?php echo $arrayFund[0]['fund_strategy']?> </textarea> </div> </td> </tr>

It could also even just be: example.com/page So it just uses the ?slug=page variable and the first ?path=something variable is just defined as: if(!isset($_GET['path'])){ $_GET['path'] = NULL; } in the PHP app.

Indeed!! But it could also just be: example.com/a/path/this/is/page or even example.com/path/to/page

Hello PHPFreaks Been a long time since i've been here last time! (hopefully it means that i'm getting better However! I'm playing around with "new" technology the mod_rewrite for the .htaccess file. I'm writting a php app where the url has 2 parameters. example.com?path=this/is/a/path/to/this/&slug=page NOW my dilemma is that my .htaccess rules work IF there is NO / (slash) in the ?path= var (since I separate the 2 vars at a /). my question is now! (bear in mind here that i'm a ROOKIE at .htaccess rewriting) how do i go about in the .htaccess file to make it reconize that whatever comes after the last slash the $2 variable and everything is $1 - even if there is no $path defined in the url? BTW! I'm not looking for free handouts and do my coding here! I'm willing to learn here but just need pointers!! I've pasted my .htaccess file here: Options +FollowSymlinks RewriteEngine On RewriteCond %{REQUEST_URI} !=/index.php RewriteRule ^([^/.]+)/([^/.]+)/([^/.]+)/([^/.]+)$ /index.php?slug=$1&type=$2&view=$3&action=$4 [L,PT] RewriteRule ^([^/.]+)/([^/.]+)/([^/.]+)$ /index.php?slug=$1&type=$2&view=$3 [L,PT] RewriteRule ^([^/.]+)/([^/.]+)$ /index.php?path=$1&slug=$2 [L,PT] RewriteRule ^([^/.]+)$ /index.php?slug=$1 [L,PT] RewriteRule ^(.+)/$ /$1 [R=301,L] Thanks in advance

Solved this myself should have used mysql_num_rows($result); instead of count($result); =)

Hi PHPfreaks.com I'm having some trouble with some code that should be straight forward! When i run following code: <?php $content->query(mysql_real_escape_string($_GET['slug'])); ?> it does the following: <?php class content { public function query($slug){ if(empty($slug)){ $slug = "forside"; } $query = sprintf("SELECT id FROM komoono_sider WHERE slug = '".$slug."'"); $result = mysql_query($query); echo count($result); } } $content = new content; ?> If the slug variable is empty it should be set to "forside" and when i set it to some values that i KNOW are in the database it all works perfectly and the count is correct! However when i set the slug variable to something i KNOW that isn't in the database it returns the wrong count it still says 1 record found when it should say 0! I think i starred myself blind at the problem, but i'm not sure! Hope you guys can help me with something that should have been straight forward EDIT: You can try it here: http://johns3n.net/none/classes/ ?slug=forside AND ?slug=underside are both in the database so there the count returned should be 1 if you use those, but using i.e ?slug=randomthing still returns 1 on the screen.

Hi PHPfreaks! I'm having some problems with a Jquery script that i've wrote! What it suppose to do is animate a top menu with some background positions when mouseenter() and animate some divs on mouseenter and mouseleave. It works PERFECT in every browser! Except Internet Explorer 7 and 8 (IE9 works perfect). In Internet Explorer 7 and 8 it takes forever to load and when it finally loads, none of the javascript works and the page seems sluggish and unresponsive! And my deadline for this project is coming up and i've been using way to long to try and fix this error in Internet Explorer 7 and 8! Which is now why i turn to you! for YOUR HELP! and don't make me beg, because I will, with boot licking and everything! below here is a copy pasta of the javascript that i've written! I based it of this code: $(document).ready(function() { /* -- CUFON JAVASCRIPT -- */ Cufon.replace('ul#nav li a, span.produkt_pris, span.produkt_solv_pris, span.produkt_bronze_pris'); Cufon.replace('h1, h2, h3', { textShadow: '#1371a4 0px 2px' }); /* -- JQUERY SCALE -- */ $(function() { $('#box-1, #box-2, #box-3, #box-4, #box-5, #box-6, #box-7, #box-8').bind('mouseenter', function() { /* ENLARGE CHILDREN OF $this */ $(this).children('img.produkt').stop(true, true).animate({ width: '160', height: '121' }, { queue: true, duration: 'fast' }) $(this).children('img.firma').stop(true, true).animate({ width: '130', height: '85' }, { queue: true, duration: 'fast' }) $(this).children('img.cta').stop(true, true).animate({ width: '110', height: '39', top: '218', left: '80' }, { queue: true, duration: 'fast' }) /* ENLARGE $this ON MOUSEENTER */ $(this).css("z-index", "5000000") $('#box-1, #box-2, #box-3, #box-4, #box-5, #box-6, #box-7, #box-8').not(this).stop(true, true); $(this).stop(true, true).animate({ width: '270', height: '270' }, { queue: true, duration: 'fast' }) }); $('#box-1, #box-2, #box-3, #box-4, #box-5, #box-6, #box-7, #box-8').bind('mouseleave', function() { /* SHRINK THE CHILDREN OF $this */ $(this).children('img.produkt').stop(true, true).animate({ width: '132', height: '100' }, { queue: true, duration: 'fast' }) $(this).children('img.firma').stop(true, true).animate({ width: '87', height: '57' }, { queue: true, duration: 'fast' }) $(this).children('img.cta').stop(true, true).animate({ width: '96', height: '34', top: '175', left: '102' }, { queue: true, duration: 'fast' }) /* SHRINK $this ON MOUSELEAVE */ $(this).css("z-index", "5000") $('#box-1, #box-2, #box-3, #box-4, #box-5, #box-6, #box-7, #box-8').not(this).stop(true, true); $(this).stop(true, true).animate({ width: '218', height: '218' }, { queue: true, duration: 'fast' }) }); }); /* -- JQUERY HOVER -- */ $('ul#nav li a') .css( {backgroundPosition: "0 64px"} ) .mouseenter(function(){ $(this).stop().animate( {backgroundPosition:"0 0"}, {duration:200}) }) .mouseleave(function(){ $(this).stop().animate( {backgroundPosition:"0 64px"}, {duration:200}) }); }); And yes this is the code because that makes IE 7 and 8 seem slow, because when I remove it, the site instantly loads! And thank you soooo much for the help in advance everyone!

This is now solved! the script I included from <script type="text/javascript" src="https://raw.github.com/razorjack/quicksand/master/jquery.quicksand.js"></script> wasn't being recognized by IE because of a mimetype mismatch! I downloaded the script myself and ran it locally instead and it worked as a charm!

Hi PHPfreaks.com I'm having some problems getting the Jquery Quicksand Plugin to work in Internet Explorer 7 to 9. The Plugin works flawless in all other browsers but IE seems to make it hickup! Below is the code block that I use for the quicksand plugin: <ul class="filterClients"> <li class="active"><a href="#" class="all">All</a></li> <li><a href="#" class="media">Media</a></li> <li><a href="#" class="retail">Retail</a></li> <li><a href="#" class="travel">Travel</a></li> <li><a href="#" class="sports">Sports & Health</a></li> </ul> <ul class="hover_block"> <li class="item" data-id="id-1" data-type="media"><a href="#"><img src="http://placehold.it/300x200"><br />TEST 1</a></li> <li class="item" data-id="id-2" data-type="retail sports"><a href="#"><img src="http://placehold.it/300x200">TEST 2</a></li> <li class="item" data-id="id-3" data-type="sports"><a href="#"><img src="http://placehold.it/300x200">TEST 3</a></li> <li class="item" data-id="id-4" data-type="media"><a href="#"><img src="http://placehold.it/300x200">TEST 4</a></li> <li class="item" data-id="id-5" data-type="travel"><a href="#"><img src="http://placehold.it/300x200">TEST 5</a></li> <li class="item" data-id="id-6" data-type="travel"><a href="#"><img src="http://placehold.it/300x200">TEST 6</a></li> <li class="item" data-id="id-7" data-type="media"><a href="#"><img src="http://placehold.it/300x200"><br />TEST 1</a></li> <li class="item" data-id="id-8" data-type="retail sports"><a href="#"><img src="http://placehold.it/300x200">TEST 2</a></li> <li class="item" data-id="id-9" data-type="sports"><a href="#"><img src="http://placehold.it/300x200">TEST 3</a></li> <li class="item" data-id="id-10" data-type="media sports"><a href="#"><img src="http://placehold.it/300x200">TEST 4</a></li> <li class="item" data-id="id-11" data-type="travel"><a href="#"><img src="http://placehold.it/300x200">TEST 5</a></li> <li class="item" data-id="id-12" data-type="travel retail"><a href="#"><img src="http://placehold.it/300x200">TEST 6</a></li> </ul> and here is the javascript where I initiate the plugin along with a few extras such as animate the <img> tag in the <li> tags: // ---------------- JQUERY QUICKSAND ----------------- // // REGISTER UL CLASS THAT HAS SORTABLE LI TAGS. $clientsHolder = $('ul.hover_block'); $clientsClone = $clientsHolder.clone(); // WHEN USER CLICKS ON FILTER METHODE. $('.filterClients a').click(function(e) { // PREVENT BROWSER FROM DOING IT'S STANDARD THING WHEN HASHTAG IS APPLIED. e.preventDefault(); $filterClass = $(this).attr('class'); // REMOVE ACTIVE CLASS AND APPLY IT TO CLICKED LI TAG. $('.filterClients li').removeClass('active'); $(this).parent().addClass('active'); // SORT LI TAGS BASED ON CLICKED VALUE. if($filterClass == 'all') { $filters = $clientsClone.find('li'); } else { $filters = $clientsClone.find('li[data-type~='+ $filterClass +']'); } // REPLACE UL TAG WITH CLICKED LI TAGS. $clientsHolder.quicksand($filters, { duration: 1000, easing: 'easeInOutQuad' }); }); // ---------- JQUERY MOUSEOVER & MOUSELEAVE ---------- // // ANIMATE IMG TAGS IN LI TAGS WHEN MOUSEOVER. $("ul.hover_block").delegate("li", { // DEFINE ANIMATIONS. mouseenter: function() { $(this).find('img').animate({top:'-200px'},{queue:false,duration:300}); }, mouseleave: function() { $(this).find('img').animate({top:'0px'},{queue:false,duration:300}); } }); And at the bottom of my html I have following javascripts running: <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.14/jquery-ui.min.js"></script> <script type="text/javascript" src="https://raw.github.com/razorjack/quicksand/master/jquery.quicksand.js"></script> <script type="text/javascript" src="javascript.js"></script> The Javascript.js file has the contents which I pasted above. Now i've been trying to fix this problem for a while now. but I think i've looked at it too much to see the problem anymore.. hope you guys can help me out! Thanks in advance

Solved it myself! When targeting a specific <ul> as i were, delegate() was a better option! ^^ So the solution is as it follows: <script type="text/javascript"> $("ul.hover_block").delegate("li", { mouseenter: function() { $(this).find('img').animate({top:'50px'},{queue:false,duration:500}); }, mouseleave: function() { $(this).find('img').animate({top:'0px'},{queue:false,duration:500}); } }); </script>

Hi PHPfreaks.com I'm having some trouble with Jquery's Hover() event! I'm currently creating a portfolio where i need a image to shift it's position, once it's hovered, for that purpose i've written this small script! <script type="text/javascript"> $("ul.hover_block li").live("hover", function() { $(this).find('img').animate ({top:'50px'},{queue:false,duration:500}); }, function() { $(this).find('img').animate ({top:'0px'},{queue:false,duration:500}); } ); </script> Now the scripts works 50% because it correctly shifts the image once it's hovered, however once mouse leaves, the image doesn't shift back, it just stays in it's hovered position! Hope you can help me! (and yes I need the live() function, because i'm running this hover() script along with a Jquery Quicksand Plugin!

Okay thanks for the help mate, it gave me some good insight to file structure and paths when using includes ^^ This is now solved! (once again PHPfreaks delievers!)

And this would work with files that i include using variables? i.e: include('menu.php?itemid=2') Because i know that include REQUIRES a absolute path to the file, when you are using URL $_GET variables

Yes i do, i have a config.php file which calls connection to my mySQL db and set a variety of other variables

And just to be a total noob here, how would i do that? Because in my book absolute URL path == Server Path

Hello PHPfreaks! I build a website for a company way back when I was still learning basic PHP! Now unfortunaly the webhost has decided to change their security settings, specifically chaning the allow_url_include and allow_fopen_include to off! That however breaks the website that I did, since i am using the following code in calling the various menus around the website: include(''$site_url'menu.php?menuid=1'); Now I am well aware that this is not the best way to include a menu! ohhh yeah btw, the code for the menu.php file is: <?php include('config.php'); $menuid = mysql_real_escape_string($_GET['menuid']); $menu_categories = mysql_query("SELECT * FROM " .$db_prefix. "menucategories WHERE id='".$menuid."'"); while($menu_cat = mysql_fetch_array($menu_categories)) { if($menu_cat['display_name'] == "") { $menu = mysql_query("SELECT * FROM " .$db_prefix. "menu WHERE cat = ".$menu_cat['id']." ORDER BY placement ASC"); echo "<ul>"; while($menu_rows = mysql_fetch_array($menu)) { echo "<li><a href='" .$menu_rows['URL']. "' class='".$menu_cat['name']."' >" .$menu_rows['name']. "</a></li>"; } echo "</ul>"; } else { echo "<h4>" .$menu_cat['display_name']. "</h4>"; $menu = mysql_query("SELECT * FROM " .$db_prefix. "menu WHERE cat = ".$menu_cat['id']." ORDER BY placement ASC"); echo "<ul>"; while($menu_rows = mysql_fetch_array($menu)) { echo "<li><a href='" .$menu_rows['URL']. "' class='".$menu_cat['name']."' >" .$menu_rows['name']. "</a></li>"; } echo "</ul>"; } } ?> So i build the website so that you call the various menus around in the website using the menu.php include and setting a variable based on a ID (i.e menu.php?menuid=2) and of course using variables in the URL name you need to define a complete URL in the include, which now with the hosting companies new security policy doesn't work! SO BASICALLY! What I am trying to ask: Is there any alternative to include menu.php?menuid=XX without using the absolute URL?

I actually managed to solve it myself after much trial and error ^^ this is the code that saved my webproject: div#menu { background-image:url(gfx/footer_bg.gif); background-position:center; background-repeat:repeat-y; width:980px; height:100px; margin-left:-10px; } div#menu > ul { text-align:center; width:100%; height:100%; } div#menu > ul > li.topmenu { font-family:'helvetica black','arial black','helvetica','arial',sans-serif; font-size:22px; font-weight:bold; text-transform:uppercase; letter-spacing:-2px; float:left; width:180px; height:100%; display:inline-block; margin-left:13px; } div#menu > ul > li.topmenu > a { text-decoration:none; color:#fafafa; min-width:180px; min-height:65px; display:inline-block; padding-top:35px; } div#menu > ul > li.topmenu > a:hover { background-image:url(gfx/navigation.gif); background-position:-15px -444px; text-decoration:none; color:#9ac83d; } This thread can be closed and marked as solved now ^^

Hi PHPfreaks! (those that maybe are more closet CSSfreaks) ^^ I'm currently designing a webpage which you can see at http://www.johns3n.net But i'm really having some trouble with CSS inheriting it self like a mother¤#%"?!, i spent all night trying to solve it and went to be angry and watched two and a half men instead deciding that i would start from stratch again the next morning using proper CSS selectors to make sure that NO inheritance should be possible, but much to my chargrin it was still inheriting styles where it shouldn't be. i will include the css here as i set my wordpress to minify CSS output which could be very annoying to find heads or tails in html, body, div, span, applet, object, iframe, h1, h2, h3, h4, h5, h6, p, blockquote, pre, a, abbr, acronym, address, big, cite, code, del, dfn, em, font, ins, img, kbd, q, s, samp, small, strike, strong, sub, sup, tt, var, b, u, i, center, dl, dt, dd, ol, ul, li, fieldset, form, label, legend, table, caption, tbody, tfoot, thead, tr, th, td { margin:0; padding:0; border:0; } ol, ul { list-style:none; } table { border-collapse:collapse; /* <table> tags skal stadig have 'cellspacing="0"' i XHTML markuppen */ border-spacing:0; } html, body { height:100%; } #wrapper { position:relative; left:50%; width:960px; min-height:100%; height:auto !important; /* Fixer <div id='footer'> problemmet i Internet Explorer 6 */ height:100%; margin-top:0; margin-right:auto; margin-bottom:-330px; /* Margin-bottom skal være <div id='footer'>s højde i negativ værdi */ margin-left:-480px; } #footer, #push { height:330px; /* #push og #footer SKAL have den samme værdi i højden */ clear:both; /* Fixer Multi kolonne layouts */ } #footer { width:980px; left:50%; background-position:center; background-repeat:repeat-y; background-image:url(gfx/footer_bg.gif); margin:auto; } /* XHTML/CSS FRAMEWORK SLUT */ /* TAGS START */ body { font-family:Verdana, Geneva, sans-serif; font-size:12px; color:#222; background-image:url(gfx/body.jpg); background-position:center; } a, a:active, a:visited { font-size:12px; color:#618521; } a:hover { font-size:12px; color:#9ac83d; } blockquote { background-image:url(gfx/quote.png); background-color:#fafafa; background-repeat:no-repeat; background-position:0px 12px; font-weight:normal; font-size:17px; line-height:1.5em; font-style:italic; font-family:Georgia, 'Times New Roman', Times, Serif; margin-top:10px; margin-right:20px; margin-bottom:10px; margin-left:20px; padding-top:15px; padding-right:15px; padding-bottom:30px; padding-left:45px; } blockquote > strong { float:right; } blockquote > em { float:right; font-size:12px; } /* TAGS SLUT */ /* ID'S START */ #menu { background-image:url(gfx/footer_bg.gif); background-position:center; background-repeat:repeat-y; width:980px; height:100px; margin-left:-10px; } #menu > ul { display:inline; } #menu > ul > li[class="topmenu"] { float:left; display:inline; padding-top:50px; padding-bottom:50px; } #menu > ul > li[class="topmenu"] > a, a:active, a:visited, a:hover { font-size:28px; } now the problem is that I set the "#menu > ul > li[class=topmenu] >" <a> tags to be shown a certain, the problem is that if you go to for instance the (web)blog page on my website you can see that the <a> tag rules from #menu > ul > etc... are applied to the <a> tags outside aswell DISPITE that i clearly stated in the CSS file that all other <a> tags should just have a simple color and text size, but it inheritis completly at random! and this is just a little part of trouble i'v been having with the css, so i hope you can help, before I have an accident and quit web buisness and become a school teacher ^^ in advance thanks!

Thanks for the explanation mate.. So just to verify I got this right! (again novice at serverside) I need a "unique identifier" in the URL? Like lets imagine I was creating a dynamic link: echo "<a href='post.php?category="$row['cat_title']"-"$row['cat_id']"&"$row['item_name']"="$row['item_id']"' title='Go to "$row['item_name']"'"; And then $_GET the URL into a $variable and like explode(); it at "-" so that I get the unique identifier and then run the query? And in the mean time have mod_rewrite remove the filename, "category=" and "itemid="? Is it something along those lines?

Preferably I would love if this could be done with PHP.

Okay, just realized I wasn't clear on a certain thing sorry about that, your suggestion would only replace that ONE article right? I need to make it automatically convert my links, to a clean URL with category and article title, and I can't really sit and type each new article into the .htaccess file, so I need it to do something along those lines automatic.

Hey all you guys at PHPfreaks.com How would YOU make this URL "cleaner" because I'm currently writing a website (from scratch) and I would really like to improve my SEO, by having the website output much more cleaner URL's? At the moment the website I'm creating is a kind of blog based system, and whenever I link dynamically, I make it write a link with this structure: http://www.sitename.com/post.php?categoryid=22&itemid=33 Now lets imagine here for a moment, that link above linked to a article that has the title "Lady Gaga is wonkers" and it has the unique id of "33" (as you can see above) and it is in the category called "Music" and that category has it's own unique id that is "22" (as you can also see in the above link) Now I wan't to clean that link up so that it removes the file name (post.php) and write the category name AND the article name instead of the $_GET queries! So that I might end up with a link that looks like this: http://www.sitename.com/Music/Lady-Gaga-is-wonkers Furthermore I wan't the cleaned up link to be "bookmarkable" so the end users, won't have to save the ugly and unclean link. I have been looking into a few solutions, before posting here, but being the COMPLETE NOVICE at PHP, Serverside that I am. I thought that I would see what you pros maybe had of ideas? =) </bootlicking> Whatever your advice/solutions are, remember it has to work with the first mentioned link structure! In advance! Thanks alot

Actually i'm writing a new system from stratch so it is possible to change this I'll mark this as solved for now mate and give your code a try! Thanks again for all the help

Structure dump for table Rowname Datatype Nullvalue Standardvalue id int(11) No title varchar(250) No content text No end_date datetime No 0000-00-00 00:00:00 tags varchar(250) No is_active varchar(20) No Data dump for table 3 | ARGHHH! | <p>gsdgdsgdsgsdgsdgd</p> | 2010-09-16 02:00:00 | Musik Jam Plug Play Scene | Ja 4 | What? | <p>Testing testing!</p> | 2010-11-08 14:00:00 | Musik Jam Plug Play Scene | Ja Is this what you mean mate? Because I actually spotted that little error myself before you replied so i'm still running blank here But i really appreciate that you are taking your time to help me!

Thanks for the awesome amount of info and it was really enlighting! And i actually understood it! ^^ Unfortunally when I try to put this new code into praksis, the related updates just doesn't find any updates at all now I tried switching around a little the SQL sentence aswell but didn't work out either.. SO if you wan't to maybe take a look over my code? and maybe you can see where it goes wrong? Of course i understand if you better things to do So if no just don't reply First off.. i made sure that 2 updates in the DB have the exact 5 same tags "Musik Jam Plug Play Scene" all seperated with a space. So these two posts should show up in their related... i run multiple pages from the same PHP file using a $action variable and then a $_GET to determaine which page you end up on... and it's on the $action=update page im having some trouble elseif($action == "update") { // Get update id from URL to see which update we are viewing $updateid = mysql_real_escape_string($_GET['updateid']); // Make a SQL call to get the data to the update that needs viewing $update_data = mysql_query("SELECT * FROM " .$db_prefix. "updates WHERE " .$db_prefix. "updates.id = ".$updateid."" ); // Run while loop for all found results (should always just be ONE result never the less) while($update = mysql_fetch_array($update_data)) { echo "<body> <div id='wrapper'> <div id='header'> </div>"; echo "<div id='update'> <h2>" .$update['title']. "</h2> <p>" .$update['content']. "</p> <div class='related'><b>Relaterede updates:</b><br /><br />"; // Explode tags in the update that er being viewed at the space between the words $tags = $update['tags']; $tags_explode = explode(" ", $tags); // Variable needed to determaine which update the user is already viewing so it doesn't show up in the related updates. $self = "".$update['id'].""; // Make SQL query to get the related updates based on the exploded tags $related_data = mysql_query("SELECT title, id FROM " .$db_prefix. "updates WHERE NOT " .$db_prefix. "updates.id = ".$self." AND " .$db_prefix. "updates.tags LIKE '%".$tags_explode[0]."%' (OR " .$db_prefix. "updates.tags LIKE '%".$tags_explode[1]."%' OR " .$db_prefix. "updates.tags LIKE '%".$tags_explode[2]."%' OR " .$db_prefix. "updates.tags LIKE '%".$tags_explode[3]."%' OR " .$db_prefix. "updates.tags LIKE '%".$tags_explode[4]."%') ORDER BY id ASC LIMIT 5" ); // Run while loop to output all found data while($related = mysql_fetch_array($related_data)) { echo " <p style='margin-bottom:5px;'><a href='view.php?action=update&updateid=" .$related['id']. "'>" .$related['title']. "</a></p> "; } echo " </div> </div>"; } } As you can see i explode() the tags in the db at the space and then line each of the 5 tags up to find matching results.. If you have any further questions about my code.. please let me know And thanks in advance