Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This seems like a perfect time to use try/catch block to control flow execution. It also appears that you are missing a big part of the puzzle, which is to save the image path created during the image save to the user, within the user table.</p> <p>Following code is untested, but should put you on the right track:</p> <pre><code>Class User{ static public function insert($name, $image, $ext) { $conn = DB_config::get(); // This will force any PDO errors to throw an exception, so our following t/c block will work as expected // Note: This should be done in the DB_config::get method so all api calls to get will benefit from this attribute $conn-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); try { $conn-&gt;beginTransaction(); $sth = $conn-&gt;prepare(" INSERT INTO users (name) values(:name);" ); $sth-&gt;execute(array(":name" =&gt; $name)); $imagePath = Image::saveImage($image, IMAGE_PATH . $conn-&gt;lastInsertId(). $ext)); // Image path is an key component of saving a user, so if not saved lets throw an exception so we don't commit the transaction if (false === $imagePath) { throw new Exception(sprintf('Invalid $imagePath: %s', $imagePath)); } $sth = $conn-&gt;prepare("UPDATE users SET image_path = :imagePath WHERE id = :userId LIMIT 1"); $sth-&gt;bindValue(':imagePath', $imagePath, PDO::PARAM_STR); $sth-&gt;bindValue(':userId', $conn-&gt;lastInsertId(), PDO::PARAM_INT); $sth-&gt;execute(); // If we made this far and no exception has been thrown, we can commit our transaction $conn-&gt;commit(); return $conn-&gt;lastInsertId(); } catch (Exception $e) { error_log(sprintf('Error saving user: %s', $e-&gt;getMessage())); $conn-&gt;rollback(); } return 0; } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POBest practice database transactions and storing files onto filesystem in PHP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USMike Purcell
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI don't think an update is necessary to save the imagepath. For example if the user is added and has ID "24" the image would be path/24.jpg.
      singulars
      1. PO
      1. UScooxie
    2. COsorry, it is necessary to store the path, in my application I store the extension instead.
      singulars
      1. PO
      1. UScooxie
    3. CO@cooxie: I see. I added that update statement to give you an idea of how the try/catch will help with flow execution if you need to store the data required to link a user to an image within the database. Feel free to change it to satisfy your reqs.
      singulars
      1. PO
      1. USMike Purcell
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload