OGBugsy
-
Posts
8 -
Joined
-
Last visited
OGBugsy's Achievements
Newbie (1/5)
0
Reputation
-
Is there a way to format the date output of a function?
OGBugsy replied to OGBugsy's topic in PHP Coding Help
Your answer worked perfectly TYVM! -
Hi all, I have a form that submits data to a mysql db. It's working fine. What I am trying to do is output an html page (or possibly 2) that is propagated with the data that I just sent to the db. example: when I submit a new workorder, a page comes up with all the data i just submitted. so that can be printed as a "customer copy". and in a perfect world, another page comes up that is a material order form. That can be faxed to my vendor to order the materials for that job. Not looking to auto print or fax anything. I am just having trouble getting the data into my html page. Here is what I have, but sadly is not working. <?php $link = mysqli_connect("xxxx", "xxxx", "xxxx", "xxxx"); $sql = "SELECT customer FROM jobs WHERE id=6487"; echo $sql; mysqli_close($link); ?> I would like to use the data from the last id submitted and have tried several things like: WHERE id=mysqli::$insert_id and WHERE id=$insert_id with no luck. Here is a pic of the html form and the output i'm getting. Any help would be greatly appreciated. Thanks in advance. OGBugsy
-
Is there a way to format the date output of a function?
OGBugsy replied to OGBugsy's topic in PHP Coding Help
I am just using a MySQL db field named date with an auto timestamp. it displays like - 2015-04-15 11:07:03 not quite sure on how to use your code, still learning. Do you mean I should format the date the way I want it before it's sent to the db? Like with the rest of the form data and not use the timestamp? -
I have a function i'm building and I would rather not have it return the year or the seconds. Is there a way to format the date output when I echo this function? function estOptions($db) { $opts = "'<option value=''>- New Estimates -</option>\n"; $sql = "SELECT id, customer, salesman, status, location_address, date FROM jobs ORDER BY status"; $res = $db->query($sql); while (list($id, $customer, $salesman, $status, $location_address, $date) = $res->fetch_row()) { $opts .= "<option value='$id, $customer, $salesman, $status, $location_address, $date'>$id, $customer, $salesman, $status, $location_address, $date </option>\n"; } return $opts; } I was wanting to format it like: date("jS F h:i A") Any help would be greatly appreciated, thanks! OGBugsy
-
You sir, are a Saint !! That is exactly what I was hoping for and I understand it a lot better now to boot. Many thanks and a bunch of good karma your way! PS - I am from Texas but I visited Portsmouth Harbor in 1984 via the US Navy. Very beautiful country you have there. I always dreamed of taking my wife back. Hopefully someday. Cheers!
-
Here is another attempt at it, just trying to populate with "last_name" only. $db = new mysqli(localhost,xxxxx,xxxxx,xxxxx); function salesmenOptions($db) { $opts = "'<option value=''>- select last_name -</option>\n"; $sql = "SELECT id, last_name FROM salesmen ORDER BY last_name"; $res = $db->query($sql); while (list($id, $las) = $res->fetch_row()) { $opts .= "<option value='$id'>$las</option>\n"; } return $opts; } thanks, OGBugsy
-
Thank you for the response and the code. I decided to try the code on the simplest table I have "salesmen". I would like the selectbox to pull up the salesmen "last_name" and "first_name", did I edit the code correctly? +----------------------+------------+ | id | first_name | last_name | +----+-----------------+------------+ | 1 | dave | walker | | 2 | pete | smith | | 3 | sam | jones | +----+-----------------+------------+ $db = new mysqli(localhost,XXXXXXXX,XXXXXXXXX,XXXXXXXX); function salesmenOptions($db) { $opts = "'<option value=''>- select salesmen -</option>\n"; $sql = "SELECT last_name, first_name FROM salesmen ORDER BY last_name"; $res = $db->query($sql); while (list($last_name, $first_name) = $res->fetch_row()) { $opts .= "<option value='$last_name'>$first_name</option>\n"; } return $opts; } <html> <body> <select name='salesmen'> <?php echo salesmenOptions($db); ?> </select> </body> </html> I have put the code into my html doc with no problem. But, I am having trouble creating the "function" in phpmyadmin (I have never done this before). I tried to use the "Routines" tab to create the function but I am having no luck. I honestly tried to figure it out thru google searches but I am at the hair pulling point atm. Any help in pointing me in the right direction or tips on creating the function with phpmyadmin would be very appreciated. Thanks, OGBugsy
-
Hello, new to the forum and was hoping to find a little help. I have a database and form set that I built with MySQL, html and php. I can submit new data, search and view the db fine from all the forms. what I am trying to do is have a form select box auto fill with the contents of a table/row. like an "active" select box example: I have a workorder form and I would like the form to have a select box that can choose from a list of materials that are populated in another table. So When I add a new material, it will show up in the forms select box. is there a way to accomplish this? Many thanks in advance. OGBugsy