pdf generation in php

Check out this: 

https://www.etutorialspoint.com/index.php/260-how-to-fetch-data-from-database-in-php-and-display-in-pdf

I want the code in Php between. also onclick button it has to generate pdf file for each user with data from Ms SQL database 

Check the example, modify it to your specific requirements.

import pyodbc
from reportlab.pdfgen import canvas

# Connect to MS SQL database
conn = pyodbc.connect("Driver={SQL Server};Server=myServerAddress;Database=myDatabase;Uid=myUsername;Pwd=myPassword;")

# Fetch user details from database
cursor = conn.cursor()
cursor.execute("SELECT * FROM users WHERE condition='value'")
users = cursor.fetchall()

# Generate declaration form for each user
for user in users:
    # Create PDF document
    pdf_file_name = f"{user['name']}_declaration.pdf"  # Unique file name for each user
    pdf = canvas.Canvas(pdf_file_name)
    
    # Generate declaration form
    pdf.drawString(100, 750, f"Name: {user['name']}")
    pdf.drawString(100, 700, f"Address: {user['address']}")
    # Add more details as needed
    
    # Save PDF document
    pdf.save()
    
# Close database connection
conn.close()

To dynamically generate a declaration form with user details and fetch the details from a Microsoft SQL Server database, you can follow the steps below:

1. Establish a connection to the Microsoft SQL Server database using a suitable database driver or ORM (Object-Relational Mapping) library in your programming language of choice.
2. Write a SQL query to fetch the required user details from the database. This query will depend on the specific table structure and data model of your application.
3. Execute the SQL query and fetch the results into your application.
4. Use a suitable library or tool to generate a PDF document dynamically from a template that includes the user details. There are many libraries available for this purpose in various programming languages, such as Python's ReportLab, Java's iText, or .NET's iTextSharp.
5. Populate the PDF template with the user details fetched from the database and generate the PDF document for each user.
6. Save the generated PDF document to a suitable location, such as a server directory or cloud storage.

Note that the specifics of implementing this solution will depend on your application's architecture and requirements, as well as your programming language and tool choices. However, the above steps should provide a general framework for achieving your goal of dynamically generating declaration forms with user details from a Microsoft SQL Server database.