Jump to content
Larry Ullman's Book Forums

Database Restore Using Pdo

Recommended Posts

Hi Larry,


As mentioned elsewhere, I am upgrading all my database actions to PDO.


I use the PHP scripts for database backup and restore which you have provided - they are very useful and have served me well.


I have upgraded the database backup to PDO no worries but now I'm coming to the restore.


The PDO "inserts" will need to handle a variable number of fields of varying/unknown data types. Are there any 'best practices' for this type of PDO INSERT / field binding?


Looking forward to your advice and thank you in anticipation,



Link to comment
Share on other sites

Hi Larry,


I experimented a bit and the following process worked for me:


Loop through the row returned from the .doc file for the table in question and create the query inserting an un-named placeholder (?) for every data item - thus it will create an un-named placeholder for each data item - you don't need to know how many up front.

Then loop through the row again binding each data item to a numerical count of the placeholder - I found that all the data items are strings so I used the PDO::PARAM_STR constant in every bind.

The second foreach loop needs to declare the data_item with a preceding & pass by reference otherwise the binds don't work properly.


There may be better ways but this worked for me (after numerous trials and errors)!



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...