If you can't drill the hook directly into a stud, use a wall anchor to ensure a tight, long-lasting hold. You can then move to designing your toilet paper holder, using some lengths of rope ...

Columns are often used to hold up heavy loads ... Repeat Step 2 using the second toilet-paper tube and your new design.