Rob Hecker2 wrote: My workflow is to export from the remote and import to the local when it is a whole database. That's because there are financial transactions and website content changes happening on the remote database. Good point. I think I may have usually done that in the past and encountered no isuues with importing locally but I can't really remember, I'll try exporting the remote database as a whole. Strange, I've been working with mysql for quite a few years and this exporting one table 'bug' has only just come to light, maybe I've just never exported one table on it's own before from the remote server. Rob Hecker2 wrote: In a situation where I create a new table locally, there are never issues importing it to the remote database since it is new to the remote. That's what I find too. Local to remote is always good for me. Rob Hecker2 wrote: MySQL workbench is a nice (free) tool. Very different from PHPmySQL. Provides more info about the data and more tools for working with it, including access to remote databases. I like being able to store and quickly run stored scripts. I could not even imagine working with stored procedures with PHPmyAdmin alone (well, it can be done). I'll look into workbench. Thanks Rob. ... View more

Niknab0417 wrote: I am using Cycle 2. I can't figure out what I'm doing wrong. This isn't cycle2 js? $('#start').click(function () {         var allppl = $.post('gest-slideshow.php');         if ($('input[name=ppl]:checked').val() == 30) {             $('#pics').show(function () {                 $(allppl).cycle({                     fx: 'fade',                     next: '#pics',                     timeout: 30000,                     random: 1                 });             }); All you need to do is literally copy the code below and change the directory for the images (shown in red) then insert the 'cycle-slideshow' <div> in the page where you want the slideshow and change the path to the images src (shown in red) <script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script> <script src="http://malsup.github.com/jquery.cycle2.js"></script> <?php $images = array(); $directory = 'images'; if ($handle = opendir($directory)) { while (false !== ($file = readdir($handle))) { if (preg_match("/\.png$/", $file)) $images[] = $file; elseif (preg_match("/\.jpg$/", $file)) $images[] = $file; elseif (preg_match("/\.jpeg$/", $file)) $images[] = $file; elseif (preg_match("/\.gif$/", $file)) $images[] = $file; } shuffle($images); closedir($handle); } ?> <div class="cycle-slideshow"> <?php for($i= 0; $i < 11; $i++) { echo '<img src="images/'.$images[$i].'" alt="" >'; } ?> </div> ... View more

the_shocker wrote: Can you ssh into your server? You should be able to run mysqldump command from the server through the shell using ssh. If your host suggested that you use mysqldump then mysql client might already be installed on your server. If mysql client isn't installed on the server then when you try to run mysqldump command from the shell you'll get an error message like: mysqldump command not found If that happens then you should install the mysql client on the server first by running. sudo apt-get install mysql-client-5.1 best, Shocker Hi Shocker, Thanks for the information. I think the easiest way, for me, might just be to amend the exported .sql file, that seems to work. I'm just a bit miffed that a bug of that magnitude escaped unnoticed. To be honest I'd never encountered it before although it seems to have been around since 2013. Maybe the host should have updated their mysql version by now but maybe that's too problematical for them <shrug> I'll look into the 'dump' method as you describe for peace of mind, it's something that I should probably know anyhow. Cheers Os ... View more

I dont know what slideshow youre using - why not just use Cycle2: Cycle2 <script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script> <script src="http://malsup.github.com/jquery.cycle2.js"></script> <div class="cycle-slideshow"> <?php for($i= 0; $i < 11; $i++) { echo '<img src="images/'.$images[$i].'" alt="" >'; } ?> </div> ... View more

Niknab0417 wrote: This prevents the page from crashing since it only loads 10 images, but it's still loading all 10 at once. I can't seem to get the images to work with the sldieshow. Not sure exactly what you need? You say you want a 'slideshow' - so how many images do you need for the slideshow? Obviously for a slideshow you need a set quantity of images to load to the page. The code I provided will give you a slideshow which cycles through 10 images - one at a time. What is happening in your case? ... View more

Nancy O. wrote: Yes, I have seen this. If I EMPTY content from tables first, importing SQL works for me. Give it a try . Nancy O. I'm not following? I'm exporting the table information but when I import the table information back the error occurs.  I don't have any tables to empty, I'm trying to create a new one based on the information saved in the .sql file. I can open the .sql file and correct what needs to be corrected then import the information and it works fine but I was just wondering if there was any other way around as it seems a bit awkard to have to do keep doing that. The real annoyance is why wasnt a bug like that spotted before that particular version of mysql was released. I mean thats just crazy. Its like rolling out a new car with only 3 wheels when there is meant to be 4 and spotting the 4th wheel is missing when driving along, totally insane. I can't even begin to get my head around it to be honest. Os ... View more

This may help. I have found a simple way using php for you to get a 'quantity' of random images from an image folder and put them into a slideshow using the cycle2 slideshow. Include these 2 scripts in your page: <script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script> <script src="http://malsup.github.com/jquery.cycle2.js"></script> Include the following php and set a directory for your images: <?php $images = array(); $directory = 'images'; if ($handle = opendir($directory)) { while (false !== ($file = readdir($handle))) { if (preg_match("/\.png$/", $file)) $images[] = $file; elseif (preg_match("/\.jpg$/", $file)) $images[] = $file; elseif (preg_match("/\.jpeg$/", $file)) $images[] = $file; elseif (preg_match("/\.gif$/", $file)) $images[] = $file; } shuffle($images); closedir($handle); } ?> Include the slideshow <div> in  your page: (This cycles through 10  images - set the number to your requirement) <div class="cycle-slideshow"> <?php for($i= 0; $i < 11; $i++) { echo '<img src="images/'.$images[$i].'" alt="" >'; } ?> </div> ... View more

In the end, if I can remember that far back, I stored all the image names in a database as I had over 50 images and didn't want all loaded to the page a once. Not sure if you know much about working with databases but all I did was connect to it and query it for the images BUT limiting the query each time to just 10 images, which could then be cycled in a slideshow: <?php <?php $conn = new mysqli('localhost' , 'username , 'password' , 'database_name'); ?> $sql = "SELECT DISTINCT * FROM excursion_images ORDER BY RAND() LIMIT 10"; $ExcursionImages = $conn->query($sql) or die($conn->error); ?> Then in the slideshow container, which ever slideshow you are using, add the code to call in the 10 random images: <ul class="slides"> <?php while($row = $ExcursionImages->fetch_assoc()) { ?> <li><img src="excursion_images/<?php echo $row['excursion_image_name']; ?>" alt="<?php echo $row['excursion_image_name']; ?>"></li> <?php } ?> </ul> MInd you if you have over 7000 images that might be a lot of database entries you need to create. I guess what you might to be looking for is a script that can choose 10 images at random from a folder where the image names are already stored. ... View more

sinious wrote: If that full table creation is what you're dumping then you can't have AUTO_INCREMENT or PRIMARY KEY enabled on that row, unless you're using a really incompatible/old version of mysql and phpmyadmin. It's the only way I can get the information back into the local database. If I don't include 'primary key' on the product_id line the local version of phpMyAdmin just throws an error and the table is NOT created, If I add 'primary key' the table IS created but throws another error but that error doesnt seem to affect the data. `product_id` int(11) NOT NULL auto_increment primary key, I'm begining to think this is some kind of compatibility issue with the remote version of phpAdmin not being set up correctly to export the table or the local version not setting up teh database correctly in the first instance. What's troubling is local to remote goes smoothly so remote to local, the reverse should do as well - I've not changed any database setting on the remote server When I have time I'm going to try and dump some data from other sites and see what happens when I try and bring that back into a local environment. For now I've got the info back into the local setting and all is working locally but I've yet to export it again and put it back to the remote. ... View more

sinious wrote: I'm enjoying it so far and on some small projects I'm actually using it for the extreme speed and somewhat better code suggestions. I keep dodging back and forth between Brackets and Dreamweaver. I need to make up my mind and choose one or the other. DW has been around a long time so it feels right while Brackets still feels like it's finding it's way, even though there are more useful attributes that I would use in Brackets, somehow I'm finding it hard to prise myself away from the 'comfortable' environment of DW. ... View more

sinious wrote: Fairly common error, as I think you know you can only specify one primary key column. Are you using a typical 'id' column with AUTO_INCREMENT on it? If so, are you specifying that as primary key either in the column creation (id INT AUTO_INCREMENT primary key NOT NULL) or later on (id INT AUTO_INCREMENT NOT NULL, ..., primary key (id))? Either way just do a quick search for 'primary key' and 'AUTO_INCREMENT' and make sure there isn't 2. Hi Sinious, Yup for sure there is only one Primary Key allocated to the auto increment id column - no other primary key is allocated to the other columns. This is whats confusing me. I imported the locally exported .sql file to the remote database without any warning errors but when I came to do the reverse - that's when the errors started flagging up locally. Here's my post from the DW forum (I know a couple of the varchar columns exceed 255 but they will be truncated if more than 255 characters are inserted - I'll put those right) Weird - The below is what is saved from the remote database - note 'auto_increment' AFTER the 'product_id' - the rest is the same as saved from the local database - see below. CREATE TABLE IF NOT EXISTS `products_services` (   `product_id` int(11) NOT NULL auto_increment, This is what is saved from the 'Local' database - no 'auto_increment' after the 'product_id' CREATE TABLE `products_services` (   `product_id` int(11) NOT NULL,   `product_sector` varchar(200) NOT NULL,   `product_category` varchar(200) NOT NULL,   `product_year` varchar(50) NOT NULL,   `product_title` varchar(500) NOT NULL,   `product_sub_title` varchar(200) NOT NULL,   `product_keywords` text NOT NULL,   `product_route` varchar(50) NOT NULL,   `product_introduction` text NOT NULL,   `product_description` text NOT NULL,   `product_date` date NOT NULL,   `product_days` varchar(10) NOT NULL,   `product_hotel` text NOT NULL,   `product_includes` text NOT NULL,   `product_url` varchar(500) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=544 DEFAULT CHARSET=latin1; -- Indexes for dumped tables -- -- -- Indexes for table `products_services` -- ALTER TABLE `products_services` ADD PRIMARY KEY (`product_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `products_services` -- ALTER TABLE `products_services` MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=544; The only way I could get the local database to suck in the information is add 'primary key' after 'auto_increment' (see below) but then I get the error #1068 - Multiple primary key defined. This error doesnt seem to affect the database - all the information still works - I just dont know why its happening. `product_id` int(11) NOT NULL auto_increment primary key, There's no issue with exporting locally to importing remotely - it's the return journey exporting remotely to importing locally which is throwing up the errors. ... View more

kpmi wrote: Last question -- is there any way to keep the hands centered as the page shrinks? They disappear offscreen and only the left bars are seen. Try background-position: center, center; as below in combination with background-cover: -webkit-background-size: cover; -moz-background-size: cover; -o-background-size: cover; background-size: cover; background-position: center, center; ... View more

It must be coming from a padding or margin - insert the below css in the page in question directly before the closing </head> tag. It will determine IF it is a padding or margin on some element that is causing the issue as this bit of code should set ALL padding and magin to zero. * { padding: 0; margin; 0; } IF it is down to padding or margin can you upload the page so we can look at the code? Failing that set the <h1> and <p> tags in the jumbotron to padding: 0; margin: 0; as it is most likely one or both of those which is causing the space. Also dont use <br /><br /><br /> to create space, its ugly bloated coding, use some padding: h1 { margin: 0; padding: 100px 0 100px 0; /*top, right, bottom, left */ } ... View more

Nancy O. wrote: I mostly use varchar too. I just wondered if there is any advantage/disadvantage in using tinytext which allows a max of 255 characters as well. Nancy O. I'm not that technical - I'll leave that to sinious. I'm more 'trial and error'. If the water starts running after I turn on the tap, job done. If I understand what I've done, that's a bonus  ... View more

Nancy O. wrote: I have a product database. It contains both long_descriptions (text) and short_descriptions. I want to limit length of short_descriptions to 255 characters. Which is preferred -- varchar(255) or tinytext? Thanks, Nancy Personally I use 'varchar' for pretty much everything expect long descriptions in which case I use 'text' ... View more

Nancy O. wrote: Cool & fast.  Saved changes to the Less, / mixins / variables comes up instantly. In terms of speed, Bootstrap's code editing really is awesome.  I don't know why I haven't been using it more. Nancy O. Strangely it's now lost its ability to compile to the css file - just stopped working..... hummmmm. Was ok. I may have to completely unistall Brackets and reinstall a fresh version. I'll look at it tomorrow. Ok well that extension is obviously a bit unreliable. I've dumped the site folder in 'Prepros' which seems a bit more robust and compiles the css from within Brackets, rather than go through a re-install of Brackets. No idea what happened one minute it worked the next it didn't, maybe a js file got corrupted or something ... View more

Nancy O. wrote: I just installed this free extension for Brackets that auto compiles CSS when you save the LESS file. It contains options for compiling to a separate file, compressing CSS, supressing, etc... This is great!! jdiehl/brackets-less-autocompile · GitHub Nancy O. Yeah I been using it for a couple of weeks or more probably, time flies, as I test out brackets. Not going to use it in my mainwork flow for reasons you know but that doesnt detract from it's pretty cool for those that want to go down that route. You can access it and install it directly from within brackets - click on the second icon down on the right and then type in 'less' ... View more

Nancy O. wrote: What if the file already exists? Shouldn't there be some provision for handling duplicates? Nancy O. Sure that all needs to be handled in the 'upload' file or KCFinder will cope with that for you. As I'm sure you are aware its fairly straight forward to upload a file to a folder but you have to take other things into consideration too like eliminating the space between file names, the size, what formats you allow and how you wish those formats to be written and as you say to check the file name doesnt already exit, it's not all plain sailing as one might imagine. ... View more

rich1973 wrote: Hi I've created upload files I just need to link it to the database in dreamweaver cs6. The file go into a folder on the server I just need to know how to link the image file to the database when submit. many thanks Richard Depends what you are doing and what your workflow is. If the images are going to be available for one client to insert into their webpages then on the 'insert' page you can list all the images which are in a folder using a <select></select> list, which will be part of a form, like below: (obviously this is php so your pages need the .php extension) <select name="uploaded_images" id="uploaded_images"> <option value="">Select Image</option> <?php $a = array(); $dir = 'uploaded_images'; if ($handle = opendir($dir)) {   while (false !== ($file = readdir($handle))) {     if (preg_match("/\.png$/", $file)) $a[] = $file;     elseif (preg_match("/\.jpg$/", $file)) $a[] = $file;     elseif (preg_match("/\.jpeg$/", $file)) $a[] = $file;                 elseif (preg_match("/\.gif$/", $file)) $a[] = $file;   }   closedir($handle); } natsort($a); // sort. foreach ($a as $i) {   echo "<option value=".$i.">".$i."</option>"; } ?> </select> The above makes all the images in a folder named 'uploaded_images' available for selection to the user. Once the user submits the form the image name gets inserted into a database via a mysli query Its not visual by any means but is a useful method for a 'template' style page where images are allocated a consistant position on a 'details' page. If you want something which is more felxible and graphical then you need to use something like KCFinder web file manager - SunHater Projects and integrate that with your Content Management System. ... View more

Nancy O. wrote: I'm not marking this as a question since there are no right or wrong answers. I thought it might be helpful to see how folks work on projects. What are some of the tools you use, why do you like them? etc... Do you build all mobile-friendly projects now or only when a client requests it? Is your backend system (CMS) mobile-friendly too or just the front end? Workflows: Illustrator to wireframe? PSD to Extract? Bootstrap? Foundation? Commercial Themes/Templates? Other? SASS / LESS / SCSS? Etc... Nancy O. I still use Fireworks CS6 to create wireframing - but it doesn't support svg by default (I think there may be an extension). Will most likely eventually use Illustrator as I'm familar with that and it feels a lot more like a layout tool than does Photoshop which I think is too complex for my workflow. Pity Fireworks was abandonded as I think its a really good bare-bones no fuss bit of software that understood web-graphics whereas Illustrator and Photoshop try to encompass both print and web. I hope something else comes along to replicate Fireworks. Never used extract but found the demo using psd file and Brackets hugely interesting. Brackets is really impressive - I like it a lot. Not sure why I havent made it my main web-editor yet. I'm still using DW, old habits die hard I guess. Yikes, you know my take on Bootstrap, Foundation etc - I give those kinds of workflow a wide berth - far too uneccessary mark-up, dodgy css and general coding for my liking - obviously engineered with something other than front-end web development in mind. (It's grid system is fine though if you isolate the code needed (not that I use it) - components are total rubbish) Templates - not something that I would consider using as I've never ever found one which fits with my requirements or specifically the clients requirements. I think when you use a pre-conceived design you don't fully take into consideration the objectives of the project and see the templete as a wirefarme to feed in information, rather than than coming up with something bespoke which might best suit the clients needs. I might observe template designs and get some inspiration or even use some aspects or them. Again I have an issue with SASS/LESS etc as I don't feel a 'compiled' file fits in with my workflow as it could quickly become redundant and be rendered uselsss should the compiled css file get changed for any reason, of which there could be a few - mistakes, other companies geting involved with website updates etc. I think the attributes bought to this workflow such as mixin-in, variables, calculations are amazing and useful BUT not if it needs to be complied to a stand alone file - I'll wait until this can all be executed in one file, which surely must happen as some stage. I use php as standard in all production sites going forward - best decision I ever made. No point in NOT producing everything as mobile friendy now - its not going away so you might as well include it as part of the overall production workflow. I think clients are now becoming more aware of the need for mobile support. I don't push my clients to go that way until they need a complete redesign. I feel all the hype about Google penalising those sites that are not mobile friendy is/was as far as my findings are concerned not happening. I still have sites which are not mobile friendly ranked way above those that are. Seriously is Google reallly only going to take mobile friendly into consideration and not the content. Persoanally I don't think so as it would kill the search engine stone dead. It's not really up to Google to get involved in that kind of decision making. CMS - I don't really care if that is mobile friendly or not so I really havent made any effort to make them compatibile. I don't really know why - its just probably the least of my concerns. OK so you have other stuff like Jade - again I don't understand this workflow of compling an html file - just seems crazy to me but if it works for others well it works. I can't help thinking sometimes though developers are using things more out of being a bit lazy or wanting to feel and be looked upon as  'skillfull and clever' rather than it really being a nessesary measure or are maybe pressured to do so by the company they work for. Everyones situation is different. ... View more

sinious wrote: The OP needs an answer to keep progress moving. Let's fix the problem, all eyes on the goal, within the existing situation. I provided an answer to the OPs issue along with the pros and cons and even some positive aspects of Bootstrap too. You don't expect me to sit back and say I think what you are doing is correct surely? That would not be helping at all in my opinion. After all if you go over to the DW forum everytime Muse is mentioned you find people expressing their opinion about that - usually 'don't use it' from the very same people here using Bootstrap - hummmm why is everyone trying to pretend an ugly bloated framework with numerous coding oddities is acceptable, beats me. No-one has ever provided answers when I flag up the ridiculous mark-up and css in Bootstrap, why do you think that is? It's called turning a blind eye when it suits or simple because they are using something they have not written and have no idea why and most likely don't care. As for posting in a seperate thread as you have seen its pointless because it generates little interest and only attracts opnions from the die-hards of the forums like the  Nancies, the Bens - not really much help unless you can get some kind of interesting response going. ... View more

kpmi wrote: And I truly didn’t mean to start an argument for or against Bootstrap. It's not really an argument - just an airing of strong views, always has been when Bootstrap is mentioned although I seem to be the only one around here that dislikes it or it could be that I'm much more familar with it than some of those that are using it. I think its a shame when people turn to a framework to either save time or are forced to through company policy. I dont think frameworks are conducive to personal progress concerning coding ability myself and are quite restrictive in what they have to offer. You can eventually start becoming lazy and design to the restrictions of the framework rather than explore more interesting solutions. You should at least stick with it and see if it suits your workflow before making an abrupt decision - who knows you might eventually think its the best thing since sliced bread. ... View more

sinious wrote: osgood_: Good thing Bootstrap doesn't do that. Yes, there is a ton of tags, but when you consider the sheer amount of components that need CSS isolation, you know why the hierarchy is there. You can't write everything 1 level deep and keep maintainable CSS. Well it does - take a look at the navigation or carousel mark-up - uses about two-thirds more <divs> than is necessary - why would I want all that extra junk in my page? Thats just a non-agruement I can write a navigation or carousel using about 30% of the html mark-up that Bootstrap uses - you know that and so do I. sinious wrote: Clearly you do not need Bootstrap. That shouldn't get you to to try to convert existing invested users over to the purist angle. You can teach, and you can complain. I hope you stop choosing the latter. I think its my duty to advise the ill informed - after that it's their choice. Granted in most cases I will be wasting my time because most uses in the DW forums are 'amatuer' or 'occassional' users who will choose sloppy over correct. It's like a bottle of wine - if I can afford the best I buy the best if I can't I buy the cheapest. There are more bottles of cheap wine sold than expensive. Sorry you dont like my angle - you're not alone. ... View more

There is an issue with that which jumps out at me. Why the need for the ugly white space top and bottom of the 'dropdown-menu'. By default the padding should be set to 0. It's not a big fix for those that know but its an annoying inaccuracy for those that are just picking up Bootstrap .dropdown-menu  { margin: 0; padding: 0; } There are no navigation <dividers> which again is not a big fix unless its done by the Bootstrap engineeers <li class="divider"></li> <li class="divider"></li> <li class="divider"></li> <li class="divider"></li> This framework isnt fit for purpose - well only for those that dont care I guess.. YIKES - it doesnt look that good on mobile either. ... View more

sinious wrote: Just realize, you don't need to use it, so why complain about it? It's not useful here. It's very useful because it informs those with less knowledge exactly how badly coded and written it is, if that is not useful then I might as well jump on board and say this is good mark-up: <div> <div> <div> <div>Hello World</div> </div> </div> </div> But hey to Bootstrappers they would probably lap that kind of mark-up up - times change right? ... View more

kpmi wrote: But I have to agree with osgood that this is NOT an intuitive way to create websites. I have been using Dreamweaver since 1999, coding HTML and CSS, and this makes no sense to me. Personally I think you'd be wiser investing your time getting to know the Bootstrap grid, in your sleep, it's by far and away the most useful aspect of the framework and it is not that bad, even I could live with that if needs be - thankfully I don't have to though. What I detest most are the components - the nav, the carousel, the modal window etc - all are poorly coded and use obtuse css and bloated html which makes it problematical to re-style or re-position, even the most effiecient at coding will struggle as I have witnessed by viewing literally dozen of youtube videos about Bootstrap. For me the best workflow would be use the grid and then feed in your own html and css - that way you know exactly what does what and where to solve issues while the grid works 'silently' in the background. Of course you need to know some basic coding to do that. What you will find if you look at a lot of 'Bootstrap' sites is they are just using the grid, everything else is bespoke coding. Of course what we are seeing is something being used to design wesbsites which was never its intention in the first place, much the same as Wordpress began life as a blogging tool then suddenly took over the world - it doesn't make it  agood tool - just popular with those that know very little coding. Anyway I have left you in no doubt which camp I'm in. Whatever go with your gut instinct BUT you must know exactly what the tools do that you are using. ... View more

Nancy O. wrote: I agree.  If you're going to use Bootstrap, use it correctly.  Nancy O. haha very funny - who knows truly what its correct use is. At best its a hack solution at worst its dust. ... View more

kpmi wrote: If I just open a new site, won't that be fresh, clean Bootstrap I could copy? Yes. I think linking to a cdn option just keeps the bootstrap css/js files up-to-date and also it's less server heavy especially when you throw the final project up to your web-server. Dont' quote me but I think the ones which ship with DW are already outdated. ... View more