Jump to content

igorek24

Members
  • Posts

    10
  • Joined

  • Last visited

igorek24's Achievements

Newbie

Newbie (1/5)

0

Reputation

1

Community Answers

  1. Here is the result: public function odometer($carID) { $mileage = str_split($this->pullMileageLastRecord($carID)); $output = ""; foreach ($mileage as $mile) { $output .= "<img src='img/speedo-numbers/$mile.gif' alt='$mile'>"; } return $output; }
  2. str_split is what I was looking for. Thank you so much everyone!
  3. How can I display an image for a number? For example, if I have a number 185 that I pulle from DB, I would like to rendered as html as: <img src="1.jpg" alt="1"> <img src="8.jpg" alt="8"> <img src="5.jpg" alt="5"> Any help would be greatly appreciated.
  4. That seems to work just like I want it. Thank you so much
  5. Hi all, can someone help me to limit output from SELECT query to unique row only on php page. When I join a veh_services table to vehicles, and there are multiple rows in veh_services with the same veh_id, it outputs multiple rows with the same veh_id. My query: SELECT username, vehicles.veh_id, year, veh_make.make_title, veh_model.model_title, veh_registration.policy_num, cylinder_count, eng_hp, trans, int_color, ext_color, fuel_tank, date_format(veh_services.date,'%m/%d/%Y') as servdate FROM vehicles LEFT JOIN (veh_make, veh_model) ON (vehicles.model_id = veh_model.model_id) AND (vehicles.make_id = veh_make.make_id) LEFT JOIN (veh_registration) ON (vehicles.reg_id = veh_registration.reg_id) JOIN (users) on (vehicles.user_id = users.user_id) left JOIN (veh_services) ON (veh_services.veh_id = vehicles.veh_id) WHERE users.user_id = 2 I've created a temp user in my phpMyAdmin: User: help Pass: Password01 Here is my DB typology and here is my source code and the webpage
  6. Figured it out. It was my query. Thanks everyone.
  7. Here is the var_damp (which is printed twice as well): http://dev.phpmyvst.com/test.php array (size=16) 'odometer_read' => string '25000' (length=5) 'service_type' => string 'brake replacement' (length=17) 'year' => string '2011' (length=4) 'make' => string 'Audi' (length=4) 'model' => string 'Q5' (length=2) 'vin' => string 'WTP20155565626667' (length=17) 'veh_image' => string 'images/audi_q5.png' (length=18) 'ext_color' => string 'White' (length=5) 'int_color' => string 'Balck' (length=5) 'body_type' => string 'SUV' (length=3) 'cylender_count' => string '4' (length=1) 'eng_size' => string '2.0' (length=3) 'eng_hp' => null 'fuel_type' => string 'GAS' (length=3) 'fuel_tank_capacity' => string '16' (length=2) 'transmission' => string '6 Speed Automatic' (length=17)
  8. Here is the page without style: http://dev.phpmyvst.com/test.php
  9. Hi all, I'm new to this forum and jest started to learn php. I'm working on a project and when I echoing data from database, for some reason it's doubling it self on html page. Here is the source code: https://git.theigor.net/igorek24/phpMyVST/blob/master/www/index.php and page: http://dev.phpmyvst.com/ Any help would be appreciated.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.