Prisma

image.png

Having an issue with the PrismaClient not being allowed on NextJS...

Hey <@U01HTL5ERCP> :wave:
Are you using the `PrismaClient` instance in a React component? If so, that’s not possible as Prisma can only be used on the backend. So it would only be used in `getServerSideProps` or `getStaticProps` to fetch data.

Ah okay thanks, could I have an example <@UESADRKMY>?

<@U01HTL5ERCP> here’s an example from the docs <https://www.prisma.io/nextjs>

<@UESADRKMY> Thanks a bunch I missed that.

Code
```export async function getServerSideProps() {
const allUsers = prisma.profile.findMany()
console.log(allUsers)

return {
  props : { allUsers }
}
}```

You’re missing an `await` before prisma

```export default function UserPage(allUsers){
  return (
    &lt;div key={allUsers.id}&gt;
     &lt;Head&gt;
     &lt;title&gt;{allUsers.username}&lt;/title&gt;
     &lt;/Head&gt;
     &lt;h1&gt;{allUsers.username}&lt;/h1&gt;
     &lt;/div&gt;
)
}```

I think it should be:
```export default function UserPage({ allUsers }){
  return (
    &lt;div key={allUsers.id}&gt;
     &lt;Head&gt;
     &lt;title&gt;{allUsers.username}&lt;/title&gt;
     &lt;/Head&gt;
     &lt;h1&gt;{allUsers.username}&lt;/h1&gt;
     &lt;/div&gt;
)
}```

`allUsers` is a list so you would need to `map` over it. Also make sure you have users in your db. Check the posts example in the above doc for a better idea.

You would need to add it as per this example

Ah I only want to grab one user and display it like this

localhost:3000/Username

In that case you would need to use <https://www.prisma.io/docs/concepts/components/prisma-client/crud#findfirst|findFirst> and get the `username` from Next.js via the <https://nextjs.org/docs/basic-features/data-fetching#getserversideprops-server-side-rendering|params>.

One more question, I'm getting this error?

It should be `where: { username: 'Cheese' }` to match the username.

```export async function getServerSideProps({ params }) {
const allUsers = await prisma.user.findUnique({
  where: { 
    username: params.username.toString()
  }
})

return {
  props : { allUsers }
}
}```

Not sure what's happening here, the name type is clearly in the schema

Now I'm getting this after setting name to unique

Nevermind I fixed it :slightly_smiling_face: