TapeGun007

I'm just curious if there's a much better way to do this: I have a form and the input looks like this: <td><input name="InspectionExp" value="<?=$InspectionExp; ?>" id="date4" placeholder="mm-dd-yyyy" /></td> The id on the form is for a jquery that auto formats the input field when selected to "__-__-____". By default a new user InspectionExp is a DATE field in mySQL and is set to NULL. So when the form is initially loaded up, the INPUT field above is blank with the place holder showing. So first I check if(isset($_POST['LicenseExp']) { Then for whatever reason this seems to be the only thing that works right, but seems really sloppy to me: if(!strlen($LicenseExp) == 10){ $LicenseExp = DateTime::createFromFormat('m-d-Y', $_POST['LicenseExp'])->format('Y-m-d'); } If I don't have an IF statement, then by default it's going to UPDATE the database with a 1969-12-31 date on new users. I can't use isset because the form makes the value set (again only on new users). I mean, the code works yes, but I am pretty certain one of you gurus could show me a better way.

Yeah. At some point we'll hire only internal developers.

No. I did not say that, or at least wasn't intending to. I'm no expert, but I'm probably at least a decent coder (or at least let me think I am). I was stating that the developer created an admin page where I could select the STATE first, then see a page of 20 users at a time with numbers (like to go straight to page 8 for example) and a "next page" link. I already created a search function. Currently, it only searches one database at a time. I basically want to search through all the databases in a specific state and pull up a single user at a time to edit/update/change some of their information except of course, their ID. I was looking for advice on how to accomplish this task really, but probably didn't explain it well enough. I was trying to give the full background of how it was built so you would understand why I'm trying to accomplish that. I had no idea I was going to get this kind of a response as I do not understand what to expect on a wide scale database environment. On this I am simply ignorant, but you guys are helping me realize that more than likely (as I have long suspected) that our developer might have been greedy and is charging us for development that didn't necessarily need to be done. @Jacques1, we have both an Android and iPhone application in beta testing that are nearly complete. When I said "version 1.0" I meant those applications. The application accesses the database every time a user opens the application to verify their credentials. Each time they use the application, there is database activity taking place. We have a fully built out website in which users can sign up etc, all of which interacts with the database. Then there is admin side of the website which I am building a better version than the developer, all of which interacts with the database. I really wish I could share more information about what it is we are doing with you Psycho, however, a public forum for discussing our plans isn't the place. If you would like, I can give you my email in a PM and take it offline. Any advice, including getting rid of the developer and how to move forward would be a welcome and refreshing thought for sure. If I could just find a developer than does Android, iOS, and knows Laravel, that could understand our project and what we want to accomplish.... oh man... BTW, I only have my developer that was hired. No other "experts". The developer was supposed to be the expert. Everything has been handled by the developer on the technical side. I have been the one beta testing the application, the website, and trying to steer the UI to where it's good. I am the most knowledgeable technical person in my company. The owner of this company is completely non technical to where he gets frustrated at Outlook because he doesn't know how to use it. LOL. If he had not hired me, he would've already thrown even more money away and this project would never have succeeded. I am not boasting, it's just the sad reality of our situation.

Thank you all for your input. We are a start up company, so I would imagine that nothing is too late, except that our funds are starting to get low and we just want to launch without spending a bunch more $$ on development. I've coded many mySQL and php pages, but most of what I have coded was certainly catering to a small audience and nothing this large. I do not claim to be an expert, but more of a "hack of all trades". I have, no doubt, had some serious questions about our developer for many more reasons beyond this (like complete lack of customer service). Our hope was to get to version 1.0 (which is very close), fire them and hire someone else after launch. @Psycho, this is a large scale application and will have high server demand (or so we hope). We plan on having a million users in our local city alone. We definitely want to scale, not just nation wide, but globally. Users will be downloading and user our iPhone and Android capable applications all of which connect, of course, to the database(s). I'm not certain this will change any of the opinions listed above. Of course, we have been charged for the creation of multiple databases.... But in the meantime, I still need to know how to access and pull all of this information out (like doing a query to search for a specific user or updating one field for a user). Any light shed on this (until such a time when we can fix this mess) would be greatly helpful. I've seen such examples of this on StackOverflow: SELECT * FROM database_2.table_2 JOIN database_1.table_1 ON (database_2.table_2.some_field = database_1.table_1.some_other_field) WHERE database_1.table_1.data_1 LIKE database_2.table_2.data_2 Or You can make multiple calls to mysql_connect(), but if the parameters are the same you need to pass true for the '$new_link' (fourth) parameter, otherwise the same connection is reused. For example: $dbh1 = mysql_connect($hostname, $username, $password); $dbh2 = mysql_connect($hostname, $username, $password, true); mysql_select_db('database1', $dbh1); mysql_select_db('database2', $dbh2); Then to query database 1 pass the first link identifier: mysql_query('select * from tablename', $dbh1); and for database 2 pass the second: mysql_query('select * from tablename', $dbh2); If you do not pass a link identifier then the last connection created is used (in this case the one represented by $dbh2) e.g.: mysql_query('select * from tablename');

So presume for a moment, that I have a set of databases named like the following: The developer says they created multiple databases to prevent crashes and such like our competition often has. Keep in mind, all of these databases in this example are for the State of California, USA. So each database is identical in the layout, tables, field names etc. It's just that the territory is broken up into multiple databases. All of the highly populated states (Like Texas) are broken up like this into multiple databases similar to this. I have an admin webpage with a drop down and I can select "California" and it will show me every user in all of the databases above (listing about 20 per page). Every single user across all of these databases for this state having a unique UserID. In my limited knowledge of mySQL, I am assuming that they are loading each database with a SELECT command into an array and then displaying the information? Or is there SQL that allows access to each of them to pull information at the same time? Any links that I can read up would be helpful as I don't know what terms to search for on Google or what this might be called. I hope my question makes sense to you like it does to me. lol Any help as always is greatly appreciated.

Wow. I changed this line jQuery(function($){ Now it works...

When I went to the page you just linked, the Date field works just fine once you start typing. They probably should have included placeholder="MM/DD/YYYY". I had an account on BlueHost and coded a website there about a year ago. I should have mentioned, the script is from http://digitalbush.com/projects/masked-input-plugin/

I cannot seem to get this code to work. What's interesting, is that I've used this before and had no issues, but it was on a different server. There has got to be something super simple that I am overlooking. Here is the code: <!DOCTYPE HTML> <head> <title>Untitled 3</title> </head> <body> <script type='text/javascript' src='js/jquery-3.1.1.js'></script> <script type="text/javascript" src="js/jquery.maskedinput.js"></script> <script type="text/javascript"> jQuery(function(){ $("#date").mask("99/99/9999",{placeholder:"mm/dd/yyyy"}); }); </script> <input id="date" type="text" /> </body> </html> It just doesn't format the Input field at all. Help? PS. I know the paths are correct.

It depends on what your background is. Have you coded in ANY language prior to trying to learn PHP? Have you programmed any databases like Access, or mySQL? What exactly do you want to do? Are you looking at just learning how to code just the backend of a website, or do you want to code an entire website?

Ok, then I'm good. Thanks!

I'm confused, I thought you said I cannot modify the image before upload? I was using the following code to resize the image (that I got from a google search). I have not modified it such as fixing orientation, I still have to figure out where that would go: <?php # ========================================================================# # Requires : Requires PHP5, GD library. # Usage Example: # include("resize_class.php"); # $resizeObj = new resize('images/cars/large/input.jpg'); # $resizeObj -> resizeImage(150, 100, 0); # $resizeObj -> saveImage('images/cars/large/output.jpg', 100); # ========================================================================# class resize { // *** Class variables private $image; private $width; private $height; private $imageResized; function __construct($fileName) { // *** Open up the file $this->image = $this->openImage($fileName); // *** Get width and height $this->width = imagesx($this->image); $this->height = imagesy($this->image); } ## -------------------------------------------------------- private function openImage($file) { // *** Get extension $extension = strtolower(strrchr($file, '.')); switch($extension) { case '.jpg': case '.jpeg': $img = @imagecreatefromjpeg($file); break; case '.gif': $img = @imagecreatefromgif($file); break; case '.png': $img = @imagecreatefrompng($file); break; default: $img = false; break; } return $img; } ## -------------------------------------------------------- public function resizeImage($newWidth, $newHeight, $option="auto") { // *** Get optimal width and height - based on $option $optionArray = $this->getDimensions($newWidth, $newHeight, $option); $optimalWidth = $optionArray['optimalWidth']; $optimalHeight = $optionArray['optimalHeight']; // *** Resample - create image canvas of x, y size $this->imageResized = imagecreatetruecolor($optimalWidth, $optimalHeight); imagecopyresampled($this->imageResized, $this->image, 0, 0, 0, 0, $optimalWidth, $optimalHeight, $this->width, $this->height); // *** if option is 'crop', then crop too if ($option == 'crop') { $this->crop($optimalWidth, $optimalHeight, $newWidth, $newHeight); } } ## -------------------------------------------------------- private function getDimensions($newWidth, $newHeight, $option) { switch ($option) { case 'exact': $optimalWidth = $newWidth; $optimalHeight= $newHeight; break; case 'portrait': $optimalWidth = $this->getSizeByFixedHeight($newHeight); $optimalHeight= $newHeight; break; case 'landscape': $optimalWidth = $newWidth; $optimalHeight= $this->getSizeByFixedWidth($newWidth); break; case 'auto': $optionArray = $this->getSizeByAuto($newWidth, $newHeight); $optimalWidth = $optionArray['optimalWidth']; $optimalHeight = $optionArray['optimalHeight']; break; case 'crop': $optionArray = $this->getOptimalCrop($newWidth, $newHeight); $optimalWidth = $optionArray['optimalWidth']; $optimalHeight = $optionArray['optimalHeight']; break; } return array('optimalWidth' => $optimalWidth, 'optimalHeight' => $optimalHeight); } ## -------------------------------------------------------- private function getSizeByFixedHeight($newHeight) { $ratio = $this->width / $this->height; $newWidth = $newHeight * $ratio; return $newWidth; } private function getSizeByFixedWidth($newWidth) { $ratio = $this->height / $this->width; $newHeight = $newWidth * $ratio; return $newHeight; } private function getSizeByAuto($newWidth, $newHeight) { if ($this->height < $this->width) // *** Image to be resized is wider (landscape) { $optimalWidth = $newWidth; $optimalHeight= $this->getSizeByFixedWidth($newWidth); } elseif ($this->height > $this->width) // *** Image to be resized is taller (portrait) { $optimalWidth = $this->getSizeByFixedHeight($newHeight); $optimalHeight= $newHeight; } else // *** Image to be resizerd is a square { if ($newHeight < $newWidth) { $optimalWidth = $newWidth; $optimalHeight= $this->getSizeByFixedWidth($newWidth); } else if ($newHeight > $newWidth) { $optimalWidth = $this->getSizeByFixedHeight($newHeight); $optimalHeight= $newHeight; } else { // *** Sqaure being resized to a square $optimalWidth = $newWidth; $optimalHeight= $newHeight; } } return array('optimalWidth' => $optimalWidth, 'optimalHeight' => $optimalHeight); } ## -------------------------------------------------------- private function getOptimalCrop($newWidth, $newHeight) { $heightRatio = $this->height / $newHeight; $widthRatio = $this->width / $newWidth; if ($heightRatio < $widthRatio) { $optimalRatio = $heightRatio; } else { $optimalRatio = $widthRatio; } $optimalHeight = $this->height / $optimalRatio; $optimalWidth = $this->width / $optimalRatio; return array('optimalWidth' => $optimalWidth, 'optimalHeight' => $optimalHeight); } ## -------------------------------------------------------- private function crop($optimalWidth, $optimalHeight, $newWidth, $newHeight) { // *** Find center - this will be used for the crop $cropStartX = ( $optimalWidth / 2) - ( $newWidth /2 ); $cropStartY = ( $optimalHeight/ 2) - ( $newHeight/2 ); $crop = $this->imageResized; //imagedestroy($this->imageResized); // *** Now crop from center to exact requested size $this->imageResized = imagecreatetruecolor($newWidth , $newHeight); imagecopyresampled($this->imageResized, $crop , 0, 0, $cropStartX, $cropStartY, $newWidth, $newHeight , $newWidth, $newHeight); } ## -------------------------------------------------------- public function saveImage($savePath, $imageQuality="100") { // *** Get extension $extension = strrchr($savePath, '.'); $extension = strtolower($extension); switch($extension) { case '.jpg': case '.jpeg': if (imagetypes() & IMG_JPG) { imagejpeg($this->imageResized, $savePath, $imageQuality); } break; case '.gif': if (imagetypes() & IMG_GIF) { imagegif($this->imageResized, $savePath); } break; case '.png': // *** Scale quality from 0-100 to 0-9 $scaleQuality = round(($imageQuality/100) * 9); // *** Invert quality setting as 0 is best, not 9 $invertScaleQuality = 9 - $scaleQuality; if (imagetypes() & IMG_PNG) { imagepng($this->imageResized, $savePath, $invertScaleQuality); } break; // ... etc default: // *** No extension - No save. break; } imagedestroy($this->imageResized); } ## -------------------------------------------------------- } ?> // *** 1) Initialise / load image $resizeObj = new resize('testimage.jpg'); // *** 2) Resize image (options: exact, portrait, landscape, auto, crop) $resizeObj -> resizeImage(200, 200); // *** 3) Save image $resizeObj -> saveImage('testimage.jpg', 1000);

Ok, thank you for that! It's unfortunate, but at least I know how to proceed. I can use the EXIF data after the upload. I just wanted to resize the image before upload which apparently strips the EXIF data. So I wanted to correct the image orientation first, then resize it, then upload. Now I have to simply upload the image, then correct the orientation, then resize it. I think HTTP uploads however have a limit of 2 MB by default. So I really wanted to resize the image before upload so I never crossed the 2MB limitation.

I’ve written several “test” pages to sample code from other sources. Each one of my test program works just fine but with certain assumptions like the file is already on the server. Then I’m trying to compile the code all together to accomplish what I want it to do. Here is what I want to accomplish: 1. I have form where an admin can select an image. 2. Because the image is taken on an iPhone, I want to pull the EXIF data, rotate it 90 degrees so it appears correctly on the website. 3. I want to resize the image. 4. I now want to upload that image. My first question is: Is it possible to do everything in this order? I presume when you select an image in a form, it’s a temp file not yet uploaded so you can manipulate the file first. The reason why step 2 is before step 3, is because the resizing of the image apparently wipes out the EXIF data and then there is no way to auto correct the image. I would also like to upload a much smaller file to save on upload time and also meet upload size requirements. So here is the form (yes I’m using tables for now instead of <div>): <form method="POST" action="edit.php?id=<?=$ID; ?>" enctype="multipart/form-data"> <table border='1' cellpadding='3' cellspacing='0'> <tr> <th>Select Document To Be Uploaded</th> </tr> <tr> <td> <input type="radio" name="ImageType" value="License" />Drivers License<br /> <input type="radio" name="ImageType" value="Insurance" />Vehicle Insurance<br /> <input type="radio" name="ImageType" value="Registration" />Vehicle Registration<br /> <input type="radio" name="ImageType" value="Background" />Background Check<br /> </td> </tr> <tr> <td align="center"> <input type="file" name="FileUploaded" /> </td> </tr> <tr> <td align="center"> <input value="Upload" type="submit" /> </td> </tr> </table> </form> At the beginning of this long page of code I have the following: // After a file has been submitted if(!empty($_FILES['FileUploaded']['tmp_name'])){ $Image = $_FILES['FileUploaded']['tmp_name']; exif($Image); } So I’m calling the function exif. The page stops rendering at this point and I’m not sure why. Here is the function exif (which when testing with an image on the server already it was working fine): function exif($file) { //This line reads the EXIF data and passes it into an array $exif = exif_read_data($file); //We're only interested in the orientation $exif_orient = isset($exif['Orientation'])?$exif['Orientation']:0; $rotateImage = 0; //We convert the exif rotation to degrees for further use if (6 == $exif_orient) { $rotateImage = 90; $imageOrientation = 1; } elseif (3 == $exif_orient) { $rotateImage = 180; $imageOrientation = 1; } elseif (8 == $exif_orient) { $rotateImage = 270; $imageOrientation = 1; } //if the image is rotated if ($rotateImage) { //WordPress 3.5+ have started using Imagick, if it is available since there is a noticeable difference in quality //Why spoil beautiful images by rotating them with GD, if the user has Imagick if (class_exists('Imagick')) { $imagick = new Imagick(); $imagick->readImage($file); $imagick->rotateImage(new ImagickPixel(), $rotateImage); $imagick->setImageOrientation($imageOrientation); $imagick->writeImage($file); $imagick->clear(); $imagick->destroy(); } } // The image orientation is fixed, pass it back for further processing return $file; } Previously I did a exif(“testfile.jpg”) which testfile.jpg already existed on the server and it worked fine. But I’m missing something (probably obvious) when trying to upload a file here from the form. Any help here would be greatly appreciated.

Yes, I took it in portrait. The original image shows just fine. I wish you could remember! ;-) I just read this article that has nothing to do with php coding per se...

So I have an Iphone 7. I was testing some php code, which works just fine, I'll include that at the end, but for whatever reason, when I load up the website with that newly resized image, it's been rotated 90 degrees to the left. It's driving me crazy. Any ideas? <?php /** * Resize image class will allow you to resize an image * * Can resize to exact size * Max width size while keep aspect ratio * Max height size while keep aspect ratio * Automatic while keep aspect ratio */ class ResizeImage { private $ext; private $image; private $newImage; private $origWidth; private $origHeight; private $resizeWidth; private $resizeHeight; /** * Class constructor requires to send through the image filename * * @param string $filename - Filename of the image you want to resize */ public function __construct( $filename ) { if(file_exists($filename)) { $this->setImage( $filename ); } else { throw new Exception('Image ' . $filename . ' can not be found, try another image.'); } } /** * Set the image variable by using image create * * @param string $filename - The image filename */ private function setImage( $filename ) { $size = getimagesize($filename); $this->ext = $size['mime']; switch($this->ext) { // Image is a JPG case 'image/jpg': case 'image/jpeg': // create a jpeg extension $this->image = imagecreatefromjpeg($filename); break; // Image is a GIF case 'image/gif': $this->image = @imagecreatefromgif($filename); break; // Image is a PNG case 'image/png': $this->image = @imagecreatefrompng($filename); break; // Mime type not found default: throw new Exception("File is not an image, please use another file type.", 1); } $this->origWidth = imagesx($this->image); $this->origHeight = imagesy($this->image); } /** * Save the image as the image type the original image was * * @param String[type] $savePath - The path to store the new image * @param string $imageQuality - The qulaity level of image to create * * @return Saves the image */ public function saveImage($savePath, $imageQuality="100", $download = false) { switch($this->ext) { case 'image/jpg': case 'image/jpeg': // Check PHP supports this file type if (imagetypes() & IMG_JPG) { imagejpeg($this->newImage, $savePath, $imageQuality); } break; case 'image/gif': // Check PHP supports this file type if (imagetypes() & IMG_GIF) { imagegif($this->newImage, $savePath); } break; case 'image/png': $invertScaleQuality = 9 - round(($imageQuality/100) * 9); // Check PHP supports this file type if (imagetypes() & IMG_PNG) { imagepng($this->newImage, $savePath, $invertScaleQuality); } break; } if($download) { header('Content-Description: File Transfer'); header("Content-type: application/octet-stream"); header("Content-disposition: attachment; filename= ".$savePath.""); readfile($savePath); } imagedestroy($this->newImage); } /** * Resize the image to these set dimensions * * @param int $width - Max width of the image * @param int $height - Max height of the image * @param string $resizeOption - Scale option for the image * * @return Save new image */ public function resizeTo( $width, $height, $resizeOption = 'default' ) { switch(strtolower($resizeOption)) { case 'exact': $this->resizeWidth = $width; $this->resizeHeight = $height; break; case 'maxwidth': $this->resizeWidth = $width; $this->resizeHeight = $this->resizeHeightByWidth($width); break; case 'maxheight': $this->resizeWidth = $this->resizeWidthByHeight($height); $this->resizeHeight = $height; break; default: if($this->origWidth > $width || $this->origHeight > $height) { if ( $this->origWidth > $this->origHeight ) { $this->resizeHeight = $this->resizeHeightByWidth($width); $this->resizeWidth = $width; } else if( $this->origWidth < $this->origHeight ) { $this->resizeWidth = $this->resizeWidthByHeight($height); $this->resizeHeight = $height; } else { $this->resizeWidth = $width; $this->resizeHeight = $height; } } else { $this->resizeWidth = $width; $this->resizeHeight = $height; } break; } $this->newImage = imagecreatetruecolor($this->resizeWidth, $this->resizeHeight); imagecopyresampled($this->newImage, $this->image, 0, 0, 0, 0, $this->resizeWidth, $this->resizeHeight, $this->origWidth, $this->origHeight); } /** * Get the resized height from the width keeping the aspect ratio * * @param int $width - Max image width * * @return Height keeping aspect ratio */ private function resizeHeightByWidth($width) { return floor(($this->origHeight/$this->origWidth)*$width); } /** * Get the resized width from the height keeping the aspect ratio * * @param int $height - Max image height * * @return Width keeping aspect ratio */ private function resizeWidthByHeight($height) { return floor(($this->origWidth/$this->origHeight)*$height); } } $resize = new ResizeImage('testimage.jpg'); $resize->resizeTo(100, 100, 'maxWidth'); $resize->saveImage('testimage.jpg'); ?>

So I have mySQL Workbench that connects to my host and they require an SSH Connection. I have that option set in mySQL workbench. I am able to connect just fine and look at the database that my developer has coded. Now I actually want to use PHP to connect to the database and pull some information out to utilize on another domain name. Can anyone give me a link or help me understand, how can I connect to a mySQL db using SSH in a PHP script?

Bwahaha. Ok ok ok. I KNEW it was something very stupid. Thanks man. Something I think I just stare too hard and need another set of eyeballs.

Here is my code: <form method="post" action="state.php"> <select name="state" id="state" onchange="this.form.submit()"> <option></option> <?php $sql = "SELECT * FROM States"; $rs=$con->query($sql); $rs->data_seek(0); $row = $rs->fetch_assoc(); while($row = $rs->fetch_assoc()){ $StateID = $row[StateID]; // Check to see which state was selected so it stays in drop down box. if($StateID==$StateSelected){ $selected = " selected"; }else{ $selected = ""; } echo "<option value='".$StateID."'".$selected.">".$row['StateName']."</option>"; } ?> </select> </form> I am befuddled as to why when pulling the state from the db, that the first state Alaska does not show up in the drop down. I double checked that Alaska is in fact in the db as the first entry. I know this has to be one of those stupid things that I am not seeing for some reason.

Thank you for the link btw, that explains a LOT more. I was so confused by the "app" directory because they have coded a iOS and Android application for us as well. I couldn't not, for the life of me, understand why they had our website in that "app" folder.

Yes Sir. I just wanted to implement our users being able to send a URL like mywebsite.com?id=12345 so that each time a business signs up using their referral code it automatically fills that id # on the form for them and makes that field uneditable. Pretty basic php, but looking at Laravel has me a bit confused since I don't fully understand how it's setup. It appears initially anyway, that a simple page has many files (or I guess they call them blades) to compile it (assuming I'm understanding this from the little bit that I have read). I'll take a look at the link you provided and maybe see if I can find a YouTube video which explains it more.

I looked into the index.php file and still could not figure it out. Turns out they were using Laravel. I barely know anything other than it's a template driven way of coding php faster. Are you familiar with Laravel and/or have an opinion on it?

Hrmm... ok. This developer of ours... I just wish I could convince the owner to fire them, I think he's getting there. So... help me understand. I physically typed in domain.com/index.php just to see where it would go when I clicked on a link. When I saw the "index.php/contact-us" I flipped. So is the "contact-us" portion of that URL a directory with a file in it? I'm logged in via FTP, and I cannot find a folder or file called "contact-us" anyway is why I'm asking.

Simple question, how do they get the website to show like this: www.website.com/index.php/contact-us The site displays the contact-us page just fine. Shouldn't there be a "contact-us.php" file or something? I wasn't sure how to Google this because I don't know what it's called. But if you could just give me the keywords to search on, I'll be more than happy to do my own homework and read up on it.

mac_gyver, that was it. In the index.php page, once a person logged in and everything checked out, I redirected to crm.php instead of http://www.mysite.com/crm.php. Once I changed to the full URL, everything now works fine. I had also put in the exit; command before testing to see if that was part of the issue or not, but whatever the case it does work.

I don't think so. The login page is completely separate from all other pages. Once you login, it redirects to a page called crm.php and you can go to ANY of the pages just fine (calendar, leads, whatever), but once you click on the Admin page, it redirects to the login page again. After logging in again... then there are no issues with any of the admin pages. Is there some sort of error checking code I can insert to see what is going on?