PHP Code::find_by_sql 예제들

예제 #1

파일: index.php 프로젝트: amsakib/SimpleShare

                            <option value="0">Private</option>
                        </select>
                    </div>
                    <?php 
}
?>
                    <div class="form-group right">
                        <button type="submit" class="btn btn-primary btn-lgk">Share It!</button>
                    </div>
                </div>
            </form>

        </div>
        <div class="col-md-4">
            <h3>Recent Shares</h3>
            <ul>
                <?php 
$sql = "SELECT * FROM codes WHERE privacy = 1 ORDER by id DESC LIMIT 10";
$codes = Code::find_by_sql($sql);
foreach ($codes as $code) {
    echo "<li><a href=\"./code.php?id={$code->id}\">{$code->title}</a></li>";
}
?>
            </ul>

        </div>
    </div>
</div>

<?php 
include 'includes/footer.php';